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()