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