def get_round(rid, game):
d.execute("SELECT * FROM round WHERE round={} AND game={}".format(
rid, game))
rs = d.fetchone()
if rs is None:
return new_round(rid, game)
return rs
def get_summary_data(game_id):
d.execute(
'select round.id, game, round, prompt.category, prompt.text as "real", p.text as "fake", c.text from round join prompt on prompt.id=round.regularQuestion join prompt p on round.falseQuestion=p.id join category c on prompt.category=c.id where game={}'
.format(game_id))
rs = d.fetchall()
for r in rs:
d.execute(
"select player.id, player.name, player.alien, response.response as 'response' from response join player on player.id=response.player where round={} and player.alien=0"
.format(r["id"]))
r["humans"] = d.fetchall()
d.execute(
"select player.id, player.name, player.alien, response.response as 'response' from response join player on player.id=response.player where round={} and player.alien=1"
.format(r["id"]))
r["aliens"] = d.fetchall()
return rs
def get_filled_categories():
d.execute(
"SELECT * FROM category WHERE (SELECT count(*) FROM prompt where category=category.id) >= 2"
)
return d.fetchall()
def get_categories():
d.execute("SELECT * FROM category")
return d.fetchall()
def remove_code(game_id):
d.execute("UPDATE game SET code=NULL WHERE id={}".format(game_id))
conn.commit()
def get_game(game_id):
d.execute("SELECT * FROM game WHERE code='{}'".format(game_id))
return d.fetchone()
def get_members(game_id):
d.execute("SELECT * FROM player WHERE game={}".format(game_id))
return d.fetchall()
def get_category_questions(cid=None):
if cid is None:
cid = random.choice(category.get_filled_categories())["id"]
d.execute("SELECT * FROM prompt WHERE category={}".format(cid))
return d.fetchall()
def get_all_questions():
d.execute("SELECT * FROM prompt")
return d.fetchall()
def get_question(qid):
d.execute("SELECT * FROM prompt WHERE id={}".format(qid))
return d.fetchone()
def get_responses(rid):
d.execute(
"select * from response join player on player.id=response.player where round={}"
.format(rid))
return d.fetchall()
def get_round_id(rid):
d.execute("SELECT * FROM round WHERE id={}".format(rid))
return d.fetchone()
def is_alien(pid):
d.execute("SELECT alien FROM player WHERE id={}".format(pid))
return d.fetchone()["alien"] == 1
def get_player_info(player_id):
d.execute("SELECT * FROM player WHERE id={}".format(player_id))
return d.fetchone()
def get_game_info(player_id):
d.execute(
"select * from game where id=(select game from player where id={})".
format(player_id))
return d.fetchone()
