def execute(self, sql, args=None):
BaseModel.logger.info(self.mogrify(sql, args))
try:
RealDictCursor.execute(self, sql, args)
except Exception, e:
BaseModel.logger.error("%s: %s" % (e.__class__.__name__, e))
raise
def write_comment_to_question(cursor: RealDictCursor, q_id, s_time, ct):
query = """
INSERT INTO comment(question_id, submission_time, message)
VALUES (%(q_id)s, %(s_time)s, %(ct)s);"""
cursor.execute(query, {'q_id': q_id, 's_time': s_time, 'ct': ct})
def delete_answer(cursor: RealDictCursor, question_id: int):
query = """
DELETE FROM answer WHERE question_id = %(q_id)s;"""
cursor.execute(query, {'q_id': question_id})
return
def add_data(cursor: RealDictCursor, full_name, email, password):
query = """
INSERT INTO users (full_name, email, password)
VALUES (%s, %s, %s);
"""
cursor.execute(query, (full_name, email, password,))
def get_comments_q(cursor: RealDictCursor):
command_comment = """
SELECT * from comment_q
"""
cursor.execute(command_comment)
return cursor.fetchall()
def delete_question_image_by_name(cursor: RealDictCursor, asd: dict):
query = f"""
DELETE FROM question_image
WHERE question_id = {asd['question_id']} and image LIKE '%{asd['filename']}'
"""
cursor.execute(query)
def delete_question_image(cursor: RealDictCursor, question_id: int):
query = f"""
DELETE FROM question_image
WHERE question_id = {question_id}
"""
cursor.execute(query)
def add_new_user(cursor: RealDictCursor, new_user: dict):
query = """
INSERT INTO forum_user (mail, submission_time, hash_pass)
VALUES (%(email)s, %(submission_time)s, crypt(%(password)s, gen_salt('bf', 8)))
"""
cursor.execute(query, new_user)
def get_all_tags(cursor: RealDictCursor):
query = """
SELECT * FROM tag
"""
cursor.execute(query)
return cursor.fetchall()
def get_cards_by_boardId(cursor: RealDictCursor, boardId) -> list:
query = sql.SQL("""SELECT *
FROM cards
WHERE board_id = {}""").format(sql.Literal(boardId))
cursor.execute(query)
return cursor.fetchall()
def add_new_status(cursor: RealDictCursor, board_id, status_name) -> list:
query = sql.SQL("""
INSERT INTO statuses (board_id, title)
VALUES ({},{})""").format(sql.Literal(board_id),
sql.Literal(status_name))
cursor.execute(query)
def get_boards(cursor: RealDictCursor) -> list:
query = """SELECT *
FROM boards
ORDER BY id ASC"""
cursor.execute(query)
return cursor.fetchall()
def get_last_board_id(cursor: RealDictCursor) -> list:
query = """SELECT MAX(id)
FROM boards"""
cursor.execute(query)
return cursor.fetchone()
def insert_new_board(cursor: RealDictCursor, title) -> list:
query = sql.SQL("""
INSERT INTO boards (title)
VALUES ({})""").format(sql.Literal(title))
cursor.execute(query)
def get_statuses(cursor: RealDictCursor) -> list:
query = """SELECT *
FROM statuses
ORDER BY id"""
cursor.execute(query)
return cursor.fetchall()
def delete_tag(cursor: RealDictCursor, tag_id, question_id: int):
query = f"""
DELETE FROM question_tag
WHERE tag_id = {tag_id} AND question_id = {question_id} """
cursor.execute(query)
return
def get_tags_for_question(cursor: RealDictCursor, question_id: int):
query = """
SELECT * FROM tag JOIN question_tag ON tag.id = question_tag.tag_id WHERE question_id=%(question_id)s
"""
cursor.execute(query, {'question_id': question_id})
return cursor.fetchall()
def add_answer_image(cursor: RealDictCursor, new_image: dict) -> dict:
query = f"""
INSERT INTO answer_image (answer_id, image)
VALUES (%(answer_id)s, %(image)s)
"""
cursor.execute(query, new_image)
def delete_answers_for_question(cursor: RealDictCursor, question_id: int):
query = f"""
DELETE from answer
WHERE question_id = {question_id}"""
cursor.execute(query)
return
def delete_answer_image(cursor: RealDictCursor, answer_id: int):
query = f"""
DELETE FROM answer_image
WHERE answer_id = {answer_id}
"""
cursor.execute(query)
def delete_comment_for_question(cursor: RealDictCursor, question_id: int):
query = f"""
DELETE from comment
WHERE question_id = {question_id}"""
cursor.execute(query)
return
def delete_answer_image_by_name_s(cursor: RealDictCursor, asd: dict):
query = f"""
DELETE FROM answer_image
WHERE answer_id = {asd['answer_id']} and image LIKE '%{asd['filename']}'
"""
cursor.execute(query)
def delete_comment_for_answer(cursor: RealDictCursor, answer_id: int):
query = f"""
DELETE from comment
WHERE answer_id = {answer_id}"""
cursor.execute(query)
def get_user(cursor: RealDictCursor, email):
user = "******".format(email)
cursor.execute(user)
return cursor.fetchone()
def delete_question(cursor: RealDictCursor, question_id: int):
query = f"""
DELETE from question
WHERE id = {question_id}"""
cursor.execute(query)
return
def add_vote(cursor: RealDictCursor, planet_name, user_id, submission_time, vote_numbers, planet_id):
query = """
INSERT INTO planet_votes (planet_name, user_id, submission_time, vote_numbers, planet_id)
VALUES (%s, %s, %s, %s, %s);
"""
cursor.execute(query, (planet_name, user_id, submission_time, vote_numbers, planet_id,))
def get_comment_by_id(cursor: RealDictCursor, comment_id: int):
query = f"""
SELECT * from comment
WHERE id = {comment_id}"""
cursor.execute(query)
return cursor.fetchone()
def delete_answer_by_id(cursor: RealDictCursor, answer_id: int):
query = """
DELETE FROM answer WHERE id = %(aid)s;"""
cursor.execute(query, {'aid': answer_id})
return
def delete_comment(cursor: RealDictCursor, comment_id: int):
query = f"""
DELETE FROM comment
WHERE id = {comment_id} """
cursor.execute(query)
return
def write_comment_to_answer(cursor: RealDictCursor, a_id, s_time, ct):
query = """
INSERT INTO comment(answer_id, submission_time, message)
VALUES (%(a_id)s, %(s_time)s, %(ct)s);"""
cursor.execute(query, {'a_id': a_id, 's_time': s_time, 'ct': ct})
def add_answer_comment(cursor: RealDictCursor, details: dict):
query = f"""
INSERT INTO comment (answer_id, message, submission_time, user_id)
VALUES (%(answer_id)s, %(comment_message)s, %(submission_time)s, %(user_id)s) """
cursor.execute(query, details)
return
