def new_round(rid, game):
p = question.get_question_pair()
c.execute(
"INSERT INTO round (game, round, regularQuestion, falseQuestion) VALUES ({}, {}, {}, {})"
.format(game, rid, p[0]["id"], p[1]["id"]))
conn.commit()
return get_round_id(c.lastrowid)
def join_game(player_name: str, game_id):
player_name = player_name.replace('"', "'")
c.execute("INSERT INTO player (game, name) VALUES ('{}', \"{}\")".format(
game_id, player_name))
conn.commit()
return c.lastrowid
def add_category(text):
text = text.replace('"', "'")
c.execute("INSERT INTO category (text) VALUES ('{}')".format(text))
conn.commit()
def is_game_running(game_id):
c.execute("SELECT COUNT(*) FROM game WHERE id={}".format(game_id))
return bool(c.fetchone()[0] > 0)
def delete_game(game_id):
c.execute("DELETE FROM game WHERE id={}".format(game_id))
conn.commit()
def new_game():
c.execute("INSERT INTO game (code) VALUES ('{}')".format(get_game_code()))
conn.commit()
return c.lastrowid
def delete_question(qid):
c.execute("DELETE FROM prompt WHERE id={}".format(qid))
conn.commit()
def edit_question(qid, cat, text):
text = text.replace('"', "'")
c.execute("UPDATE prompt SET category={}, text=\"{}\" WHERE id={}".format(
cat, text, qid))
conn.commit()
def add_question(cid, text):
text = text.replace('"', "'")
c.execute("INSERT INTO prompt (category, text) VALUES ({}, \"{}\")".format(
cid, text))
conn.commit()
def set_alien_status(pid, status):
c.execute("UPDATE player SET alien={} WHERE id={}".format(status, pid))
conn.commit()
def set_response(rid, player, text):
text = text.replace('"', "'")
c.execute(
"INSERT INTO response (round, player, response) VALUES ({}, {}, \"{}\")"
.format(rid, player, text))
conn.commit()