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()