def
access_data():
root5
=
Toplevel()
root5.title(main
+
"Restaurant_Database"
)
label
=
Label(root5, text
=
"RESTAURANT REVIEW ANALYSIS SYSTEM"
,
bd
=
2
, font
=
(
'Arial'
,
47
,
'bold'
,
'underline'
))
title1
=
Label(root5, text
=
"S.NO"
, font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
title2
=
Label(root5, text
=
"FOOD ITEM"
, font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
title3
=
Label(root5, text
=
"NO.OF CUSTOMERS"
,
font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
title4
=
Label(root5, text
=
"NO.OF POSITIVE REVIEWS"
,
font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
title5
=
Label(root5, text
=
"NO.OF NEGATIVE REVIEWS"
,
font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
title6
=
Label(root5, text
=
"POSITIVE RATE"
,
font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
title7
=
Label(root5, text
=
"NEGATIVE RATE"
,
font
=
(
'Arial'
,
10
,
'bold'
,
'underline'
))
label.grid(row
=
0
, column
=
0
, columnspan
=
7
)
title1.grid(row
=
1
, column
=
0
)
title2.grid(row
=
1
, column
=
1
)
title3.grid(row
=
1
, column
=
2
)
title4.grid(row
=
1
, column
=
3
)
title5.grid(row
=
1
, column
=
4
)
title6.grid(row
=
1
, column
=
5
)
title7.grid(row
=
1
, column
=
6
)
conn
=
sqlite3.connect(
'Restaurant_food_data.db'
)
c
=
conn.cursor()
c.execute(
"SELECT *,oid from item"
)
records
=
c.fetchall()
pos_rates
=
[]
for
record
in
records:
record
=
list
(record)
pos_rates.append(
float
(record[
-
3
][:
-
1
]))
max_pos
=
max
(pos_rates)
min_pos
=
min
(pos_rates)
for
i
in
range
(
len
(records)):
rec_list
=
list
(records[i])
if
str
(max_pos)
+
"%"
=
=
rec_list[
-
3
]:
rec_lab
=
[Label(root5, text
=
str
(rec_list[
-
1
]), fg
=
"green"
)]
for
item
in
rec_list[:
-
1
]:
lab
=
Label(root5, text
=
item, fg
=
"green"
)
rec_lab.append(lab)
elif
str
(min_pos)
+
"%"
=
=
rec_list[
-
3
]:
rec_lab
=
[Label(root5, text
=
str
(rec_list[
-
1
]), fg
=
"red"
)]
for
item
in
rec_list[:
-
1
]:
lab
=
Label(root5, text
=
item, fg
=
"red"
)
rec_lab.append(lab)
else
:
rec_lab
=
[Label(root5, text
=
str
(rec_list[
-
1
]))]
for
item
in
rec_list[:
-
1
]:
lab
=
Label(root5, text
=
item)
rec_lab.append(lab)
for
j
in
range
(
len
(rec_lab)):
rec_lab[j].grid(row
=
i
+
2
, column
=
j)
exit_btn
=
Button(root5, text
=
"Exit"
, command
=
root5.destroy)
exit_btn.grid(row
=
len
(records)
+
5
, column
=
3
)
conn.commit()
conn.close()
root5.attributes(
"-zoomed"
,
True
)