def on_connect(self, connection):
log_file.write("connection received\n")
log_file.flush()
if not hasattr(self, "db_conn"):
self.db_conn = None
if self.db_conn is None:
self.db_conn = connect_db()
elif self.db_conn.closed != 0:
self.db_conn = connect_db()
def get_first_q_counts():
connection = connect_db()
cursor = connection.cursor()
cursor.execute("select count(id), count(kolo) from first_quadrant")
counts = cursor.fetchall()
connection.close()
return counts
def count_q_1(total):
total_fq_1 = fq_1_query
connection = connect_db()
cursor = connection.cursor()
qr = cursor.execute(fq_1_query)
number = cursor.fetchone()
connection.commit()
connection.close()
for fq_1_total in number:
return fq_1_total
def count_tq_27(total):
total_tq_27 = tq_27_query
connection = connect_db()
cursor = connection.cursor()
qr = cursor.execute(tq_27_query)
number = cursor.fetchone()
connection.commit()
connection.close()
for tq_27_total in number:
return tq_27_total
def count_sq_18(total):
total_sq_18 = sq_18_query
connection = connect_db()
cursor = connection.cursor()
qr = cursor.execute(sq_18_query)
number = cursor.fetchone()
connection.commit()
connection.close()
for sq_18_total in number:
return sq_18_total
def fourth_q_update():
"""update the fourth quadrant by inserting automaticly current drow data into third quadrant"""
ftq_list = fourth_quadrant()
connection = connect_db()
cursor = connection.cursor()
fourth_q_query = (""" INSERT INTO forth_quadrant(ftq_28, ftq_29, ftq_30, ftq_31, ftq_32, ftq_33, ftq_34, ftq_35, ftq_36, ftq_37, ftq_38, ftq_39, kolo, ftq_freq) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s, %s, %s, %s, %s, %s)""")
fourth_q_query_list = ftq_list
cursor.execute(fourth_q_query, fourth_q_query_list)
connection.commit()
connection.close()
def third_q_update():
"""update the third quadrant by inserting automaticly current drow data into third quadrant"""
tq_list = third_quadrant()
connection = connect_db()
cursor = connection.cursor()
third_q_query = (""" INSERT INTO third_quadrant(tq_19, tq_20, tq_21, tq_22, tq_23, tq_24, tq_25, tq_26, tq_27, kolo, tq_freq) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s, %s, %s)""")
third_q_query_list = tq_list
cursor.execute(third_q_query, third_q_query_list)
connection.commit()
connection.close()
def second_q_update():
"""update the second quadrant by inserting automaticly current drow data into second quadrant"""
sq_list = second_quadrant()
connection = connect_db()
cursor = connection.cursor()
second_q_query = (""" INSERT INTO second_quadrant(sq_10, sq_11, sq_12, sq_13, sq_14, sq_15, sq_16, sq_17, sq_18, kolo, sq_freq) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s, %s, %s)""")
second_q_query_list = sq_list
cursor.execute(second_q_query, second_q_query_list)
connection.commit()
connection.close()
def first_q_update():
"""update the first quadrant by inserting automaticly current drow data into first quadrant"""
fq_list = first_quadrant()
connection = connect_db()
cursor = connection.cursor()
first_q_query = (""" INSERT INTO first_quadrant(fq_1, fq_2, fq_3, fq_4, fq_5, fq_6, fq_7, fq_8, fq_9, kolo, fq_freq) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s, %s, %s)""")
first_q_query_list = fq_list
cursor.execute(first_q_query, fq_list)
connection.commit()
connection.close()
def get_fisrt_quadrant_data():
connection = connect_db()
cursor = connection.cursor()
#cursor.execute("select fq_1, fq_2, fq_3, fq_4, fq_5, fq_6, fq_7, fq_8, fq_9, fq_freq, id, count(id), count(kolo) from first_quadrant")
cursor.execute(
"select fq_1, fq_2, fq_3, fq_4, fq_5, fq_6, fq_7, fq_8, fq_9, fq_freq from first_quadrant"
)
numbers = cursor.fetchall()
connection.close()
#print numbers
return numbers
def get_exam_uuid(exam_id):
conn = connections.connect_db()
cur = conn.cursor()
cur.execute("select directory from public.exam where exam_id = %s",
[exam_id])
rows = cur.fetchone()
if len(rows) == 0:
return None
return rows[0]
def get_user_row(column, email):
conn = connections.connect_db()
cur = conn.cursor()
cur.execute("SELECT * FROM public.people WHERE email = %s;", [email])
rows = cur.fetchall()
colnames = [desc[0] for desc in cur.description]
indexes = []
for colname in column:
try:
indexes.append(colnames.index(colname))
except Exception:
pass
response = []
for row in rows:
temp = []
for i in indexes:
temp.append(row[i])
response.append(temp)
return response
def third_Q_main_update():
connection = connect_db()
cursor = connection.cursor()
total_no_of_occurance = [
count_tq_19(tq_19_query),
count_tq_20(tq_20_query),
count_tq_21(tq_21_query),
count_tq_22(tq_22_query),
count_tq_23(tq_23_query),
count_tq_24(tq_24_query),
count_tq_25(tq_25_query),
count_tq_26(tq_26_query),
count_tq_27(tq_27_query)
]
positive_weight = [(count_tq_19(tq_19_query) / float(19)) * 100,
(count_tq_20(tq_20_query) / float(19)) * 100,
(count_tq_21(tq_21_query) / float(19)) * 100,
(count_tq_22(tq_22_query) / float(19)) * 100,
(count_tq_23(tq_23_query) / float(19)) * 100,
(count_tq_24(tq_24_query) / float(19)) * 100,
(count_tq_25(tq_25_query) / float(19)) * 100,
(count_tq_26(tq_26_query) / float(19)) * 100,
(count_tq_27(tq_27_query) / float(19)) * 100]
negative_weight = [(100 - (count_tq_19(tq_19_query) / float(19)) * 100),
(100 - (count_tq_20(tq_20_query) / float(19)) * 100),
(100 - (count_tq_21(tq_21_query) / float(19)) * 100),
(100 - (count_tq_22(tq_22_query) / float(19)) * 100),
(100 - (count_tq_23(tq_23_query) / float(19)) * 100),
(100 - (count_tq_24(tq_24_query) / float(19)) * 100),
(100 - (count_tq_25(tq_25_query) / float(19)) * 100),
(100 - (count_tq_26(tq_26_query) / float(19)) * 100),
(100 - (count_tq_27(tq_27_query) / float(19)) * 100)]
id = [19, 20, 21, 22, 23, 24, 25, 26, 27]
for i in range(0, len(id), 1):
a = '(' + str(id[i]) + ',' + str(total_no_of_occurance[i]) + ',' + str(
positive_weight[i]) + ',' + str(negative_weight[i]) + ')'
b = ''
c = ''
d = ''
if i < (len(id) - 1):
c = c + a + b + d
#print c
else:
c += a + b
print c
update_cell = (
"INSERT INTO main (id, total_no_of_occurance, positive_weight, negative_weight)"
"VALUES %s" % c + "ON DUPLICATE KEY UPDATE "
"total_no_of_occurance=VALUES(total_no_of_occurance), "
"positive_weight=VALUES(positive_weight),"
"negative_weight=VALUES(negative_weight)"
";")
cursor.execute(update_cell)
connection.commit()
connection.close()
def second_Q_main_update():
connection = connect_db()
cursor = connection.cursor()
total_no_of_occurance = [
count_sq_10(sq_10_query),
count_sq_11(sq_11_query),
count_sq_12(sq_12_query),
count_sq_13(sq_13_query),
count_sq_14(sq_14_query),
count_sq_15(sq_15_query),
count_sq_16(sq_16_query),
count_sq_17(sq_17_query),
count_sq_18(sq_18_query)
]
positive_weight = [(count_sq_10(sq_10_query) / float(19)) * 100,
(count_sq_11(sq_11_query) / float(19)) * 100,
(count_sq_12(sq_12_query) / float(19)) * 100,
(count_sq_13(sq_13_query) / float(19)) * 100,
(count_sq_14(sq_14_query) / float(19)) * 100,
(count_sq_15(sq_15_query) / float(19)) * 100,
(count_sq_16(sq_16_query) / float(19)) * 100,
(count_sq_17(sq_17_query) / float(19)) * 100,
(count_sq_18(sq_18_query) / float(19)) * 100]
negative_weight = [(100 - (count_sq_10(sq_10_query) / float(19)) * 100),
(100 - (count_sq_11(sq_11_query) / float(19)) * 100),
(100 - (count_sq_12(sq_12_query) / float(19)) * 100),
(100 - (count_sq_13(sq_13_query) / float(19)) * 100),
(100 - (count_sq_14(sq_14_query) / float(19)) * 100),
(100 - (count_sq_15(sq_15_query) / float(19)) * 100),
(100 - (count_sq_16(sq_16_query) / float(19)) * 100),
(100 - (count_sq_17(sq_17_query) / float(19)) * 100),
(100 - (count_sq_18(sq_18_query) / float(19)) * 100)]
id = [10, 11, 12, 13, 14, 15, 16, 17, 18]
for i in range(0, len(id), 1):
a = '(' + str(id[i]) + ',' + str(total_no_of_occurance[i]) + ',' + str(
positive_weight[i]) + ',' + str(negative_weight[i]) + ')'
b = ''
c = ''
d = ''
if i < (len(id) - 1):
c = c + a + b + d
#print c
else:
c += a + b
print c
update_cell = (
"INSERT INTO main (id, total_no_of_occurance, positive_weight, negative_weight)"
"VALUES %s" % c + "ON DUPLICATE KEY UPDATE "
"total_no_of_occurance=VALUES(total_no_of_occurance), "
"positive_weight=VALUES(positive_weight),"
"negative_weight=VALUES(negative_weight)"
";")
cursor.execute(update_cell)
connection.commit()
connection.close()
def first_Q_main_update():
connection = connect_db()
cursor = connection.cursor()
total_no_of_occurance = [
count_q_1(fq_1_query),
count_q_2(fq_2_query),
count_q_3(fq_3_query),
count_q_4(fq_4_query),
count_q_5(fq_5_query),
count_q_6(fq_6_query),
count_q_7(fq_7_query),
count_q_8(fq_8_query),
count_q_9(fq_9_query)
]
positive_weight = [(count_q_1(fq_1_query) / float(19)) * 100,
(count_q_2(fq_2_query) / float(19)) * 100,
(count_q_3(fq_3_query) / float(19)) * 100,
(count_q_4(fq_4_query) / float(19)) * 100,
(count_q_5(fq_5_query) / float(19)) * 100,
(count_q_6(fq_6_query) / float(19)) * 100,
(count_q_7(fq_7_query) / float(19)) * 100,
(count_q_8(fq_8_query) / float(19)) * 100,
(count_q_9(fq_9_query) / float(19)) * 100]
negative_weight = [(100 - (count_q_1(fq_1_query) / float(19)) * 100),
(100 - (count_q_2(fq_2_query) / float(19)) * 100),
(100 - (count_q_3(fq_3_query) / float(19)) * 100),
(100 - (count_q_4(fq_4_query) / float(19)) * 100),
(100 - (count_q_5(fq_5_query) / float(19)) * 100),
(100 - (count_q_6(fq_6_query) / float(19)) * 100),
(100 - (count_q_7(fq_7_query) / float(19)) * 100),
(100 - (count_q_8(fq_8_query) / float(19)) * 100),
(100 - (count_q_9(fq_9_query) / float(19)) * 100)]
id = [1, 2, 3, 4, 5, 6, 7, 8, 9]
for i in range(0, len(id), 1):
a = '(' + str(id[i]) + ',' + str(total_no_of_occurance[i]) + ',' + str(
positive_weight[i]) + ',' + str(negative_weight[i]) + ')'
b = ''
c = ''
d = ''
if i < (len(id) - 1):
c = c + a + b + d
#print c
else:
c += a + b
print c
update_cell = (
"INSERT INTO main (id, total_no_of_occurance, positive_weight, negative_weight)"
"VALUES %s" % c + "ON DUPLICATE KEY UPDATE "
"total_no_of_occurance=VALUES(total_no_of_occurance), "
"positive_weight=VALUES(positive_weight),"
"negative_weight=VALUES(negative_weight)"
";")
cursor.execute(update_cell)
connection.commit()
connection.close()
