Python query_first Exemples

Exemple #1

Fichier : banner.py Projet : Chrishoney/dcss_tourney

def count_recipients(c, banner, prestige):
  return query_first(c, '''SELECT COUNT(*) FROM player_banners
                         WHERE banner = %s AND prestige >= %s''', banner, prestige)

Exemple #2

Fichier : banner.py Projet : crawl/dcss_tourney

def count_recipients(c, banner, prestige):
    return query_first(
        c, '''SELECT COUNT(*) FROM player_banners
                         WHERE banner = %s AND prestige >= %s''', banner,
        prestige)

Exemple #3

def count_clan_nemelex_wins(c, char):
    return query_first(
        c, '''SELECT COUNT(*) FROM clan_nemelex_wins
                             WHERE clan_finish = 1 AND charabbrev = %s''',
        char)

Exemple #4

def count_nemelex_wins(c, char):
    return query_first(
        c, '''SELECT COUNT(*) FROM player_nemelex_wins
                             WHERE charabbrev = %s''', char)

Exemple #5

def player_has_nemelex_win(c, player, char):
    return (query_first(
        c, '''SELECT COUNT(*) FROM player_nemelex_wins
                              WHERE player = %s AND charabbrev = %s''', player,
        char) > 0)