def register(cursor, sess_id, plain_password): hashed_pw = util.hash_password(plain_password) st = util.get_submission_time() cursor.execute( """ INSERT INTO sessions VALUES (%(id)s, %(register_time)s, 0, %(h_pw)s); """, { 'id': sess_id, 'register_time': st, 'h_pw': hashed_pw })
def editing_comment(cursor, id, comment): st = util.get_submission_time() cursor.execute( """ update comment set message = %(mess)s, edited_count = edited_count + 1 where id = %(c_id)s; """, { 'mess': comment, 'c_id': id }) return cursor
def new_q_comment(cursor, comment, question_id, user): st = util.get_submission_time() cursor.execute( """ insert into comment (submission_time, question_id, message, edited_count, session_id) values (%(submission_time)s, %(question_id)s, %(message)s, %(edited_count)s, %(user)s);""", { 'submission_time': st, 'question_id': question_id, 'message': comment, 'edited_count': 0, 'user': user }) return cursor
def add_new_user(cursor, new_name, new_password): submission_time = util.get_submission_time() new_password = util.hash_password(new_password) try: cursor.execute( """ insert into regduser(id, hashed_password, submission_time) values (%(id)s, %(hashed_password)s, %(submission_time)s); """, { 'id': new_name, 'hashed_password': new_password, 'submission_time': submission_time }) except: return 1
def new_question(cursor, title, message, session_id): st = util.get_submission_time() cursor.execute( ''' INSERT INTO question (submission_time, view_number, vote_number, title, message, session_id) VALUES (%(submission_time)s, %(view_number)s, %(vote_number)s, %(title)s, %(message)s, %(session_id)s);''', { 'submission_time': st, 'view_number': 0, 'vote_number': 0, 'title': title, 'message': message, 'session_id': session_id }) return cursor
def new_answer(cursor, question_id, message, image, name): submission_time = util.get_submission_time() cursor.execute( ''' INSERT INTO answer (question_id, vote_number, message, image, submission_time, session_id) VALUES (%(question_id)s, %(vote_number)s, %(message)s, %(image)s, %(submission_time)s, %(s_id)s);''', { 'question_id': question_id, 'vote_number': 0, 'message': message, 'image': image, 'submission_time': submission_time, 's_id': name }) return cursor
def new_comment(cursor, id, new_a_comment, user): st = util.get_submission_time() edited_count = 0 cursor.execute( """ select id, question_id from answer where id = %(a_id)s; """, {'a_id': id}) qid_and_aid = cursor.fetchall() ids = qid_and_aid[0] cursor.execute( """ insert into comment(question_id, answer_id, message, submission_time, edited_count, session_id) values (null, %(ans_id)s, %(message)s, %(submission_t)s, %(edited_c)s); """, { 'ans_id': ids['id'], 'message': new_a_comment, 'submission_t': st, 'edited_c': edited_count, 'user': user }) return cursor