def ziggurat_row_inferior_to(c, depth):
return query_first_def(c, 0,
'''SELECT id FROM ziggurats
WHERE deepest <= %s
ORDER BY zig_time LIMIT 1''', depth)
def is_known_cthing(c, table, key, value):
return query_first_def(c, False,
"SELECT " + key + " FROM " + table +
" WHERE " + key + " = %s",
value)
def player_ziggurat_deepest(c, player):
return query_first_def(c, 0,
'''SELECT deepest FROM ziggurats
WHERE player = %s''',
player)
def top_score_for_cthing(c, col, table, thing): q = "SELECT sc FROM %s WHERE %s = %s" % (table, col, '%s') return query_first_def(c, 0, q, thing)
def ckiller_record_exists(c, ckiller):
return query_first_def(c, False,
'''SELECT id FROM killer_recent_kills
WHERE ckiller = %s''',
ckiller)
def player_streak_is_active(c, player):
return query_first_def(c, False,
'''SELECT active FROM streaks
WHERE player = %s AND active = 1''',
player)
def player_won_last_game(c, player):
return query_first_def(c, False,
'''SELECT id FROM player_last_games
WHERE name = %s
AND ktyp='winning' ''',
player)
def player_ziggurat_deepest(c, player):
return query_first_def(
c, 0, '''SELECT deepest FROM ziggurats
WHERE player = %s''', player)
def player_first_game_exists(c, player):
return query_first_def(c, False,
'''SELECT id FROM player_first_games
WHERE name = %s''', player)
def ckiller_record_exists(c, ckiller):
return query_first_def(
c, False, '''SELECT id FROM killer_recent_kills
WHERE ckiller = %s''', ckiller)
def is_known_cthing(c, table, key, value):
return query_first_def(
c, False,
"SELECT " + key + " FROM " + table + " WHERE " + key + " = %s", value)
def top_score_for_cthing(c, col, table, thing):
q = "SELECT sc FROM %s WHERE %s = %s" % (table, col, '%s')
return query_first_def(c, 0, q, thing)
def player_won_last_game(c, player):
return query_first_def(
c, False, '''SELECT id FROM player_last_games
WHERE name = %s
AND ktyp='winning' ''', player)
def player_streak_is_active(c, player):
return query_first_def(
c, False, '''SELECT active FROM streaks
WHERE player = %s AND active = 1''',
player)
def player_first_game_exists(c, player):
return query_first_def(
c, False, '''SELECT id FROM player_first_games
WHERE name = %s''', player)
def ziggurat_row_inferior_to(c, depth):
return query_first_def(
c, 0, '''SELECT id FROM ziggurats
WHERE deepest <= %s
ORDER BY zig_time LIMIT 1''', depth)
