def add_question(cursor, title, message, image, username):
timestamp = generate_timestamp()
cursor.execute("""
INSERT INTO question (submission_time, view_number, vote_number, title, message, image, username)
VALUES (%(timestamp)s, 0, 0, %(title)s, %(message)s, %(image)s, %(username)s)
""", {'timestamp': timestamp, 'title': title, 'message': message, 'image': image,
'username': username})
def add_answer(cursor, question_id, message, image, username):
timestamp = generate_timestamp()
cursor.execute("""
INSERT INTO answer (submission_time, vote_number, question_id, message, image, username)
VALUES (%(timestamp)s, 0, %(question_id)s, %(message)s, %(image)s, %(username)s)
""", {'timestamp': timestamp, 'question_id': question_id, 'message': message, 'image': image,
'username': username})
def register_user(cursor, username, hash_password):
date = generate_timestamp()
cursor.execute(
"""
INSERT INTO users
VALUES (%(username)s,%(hash_password)s,%(date)s)
""", {
'username': username,
'hash_password': hash_password,
'date': date
})