Python query_rowの例

コード例 #1

ファイル: query.py プロジェクト: elliptic/dcss_scoring

def overall_player_stats(c, player):
  row = query_row(c, '''SELECT name, games_played, games_won,
                                 total_score, best_xl, best_score,
                                 first_game_start, last_game_end
                          FROM players
                         WHERE name = %s''', player)
  return fixup_player_stats(c, list(row))

コード例 #2

def overall_player_stats(c, player):
    row = query_row(
        c, '''SELECT name, games_played, games_won,
                                 total_score, best_xl, best_score,
                                 first_game_start, last_game_end
                          FROM players
                         WHERE name = %s''', player)
    return fixup_player_stats(c, list(row))

コード例 #3

ファイル: query.py プロジェクト: Gittourarmy/scoring

def overall_player_stats(c, player):
    row = query_row(
        c, '''SELECT name, games_played, games_won,
                                 total_score, best_xl, best_score,
                                 first_game_start, last_game_end
                          FROM players
                         WHERE name = %s''', player)
    if row is None:
        raise crawl_utils.ScoringException(
            "Non-existent player '%s': interrupt during bulk import?" % player)
    else:
        return fixup_player_stats(c, list(row))

コード例 #4

ファイル: stats.py プロジェクト: crawl/scoring

def worst_xl_rune_find(c):
  row = query_row(c, '''SELECT xl, rune_time FROM low_xl_rune_finds
                        ORDER BY xl DESC, rune_time DESC LIMIT 1''')
  return (row[0], row[1])

コード例 #5

ファイル: query.py プロジェクト: elliptic/dcss_scoring

def canonicalize_player_name(c, player):
  row = query_row(c, '''SELECT name FROM players WHERE name = %s''',
                  player)
  if row:
    return row[0]
  return None

コード例 #6

ファイル: query.py プロジェクト: elliptic/dcss_scoring

def find_streak_breaker(c, sid):
  return row_to_xdict(
    query_row(c, game_select_from('streak_breakers') + " WHERE streak_id = %s",
              sid))

コード例 #7

ファイル: query.py プロジェクト: elliptic/dcss_scoring

def player_last_game(c, player):
  return (row_to_xdict(
      query_row(c, 'SELECT ' + scload.LOG_DB_SCOLUMNS
                + ''' FROM player_last_games WHERE name = %s''',
                player)))

コード例 #8

ファイル: query.py プロジェクト: elliptic/dcss_scoring

def player_best_game(c, player):
  return (row_to_xdict(
      query_row(c, 'SELECT ' + scload.LOG_DB_SCOLUMNS
                + ''' FROM player_best_games WHERE name = %s
                     ORDER BY sc DESC LIMIT 1''',
                player)))

コード例 #9

def canonicalize_player_name(c, player):
    row = query_row(c, '''SELECT name FROM players WHERE name = %s''', player)
    if row:
        return row[0]
    return None

コード例 #10

def find_streak_breaker(c, sid):
    return row_to_xdict(
        query_row(
            c,
            game_select_from('streak_breakers') + " WHERE streak_id = %s",
            sid))

コード例 #11

def player_last_game(c, player):
    return (row_to_xdict(
        query_row(
            c, 'SELECT ' + scload.LOG_DB_SCOLUMNS +
            ''' FROM player_last_games WHERE name = %s''', player)))

コード例 #12

def player_best_game(c, player):
    return (row_to_xdict(
        query_row(
            c, 'SELECT ' + scload.LOG_DB_SCOLUMNS +
            ''' FROM player_best_games WHERE name = %s
                     ORDER BY sc DESC LIMIT 1''', player)))

コード例 #13

ファイル: stats.py プロジェクト: floraline/scoring

def worst_xl_rune_find(c):
    row = query_row(
        c, '''SELECT xl, rune_time FROM low_xl_rune_finds
                        ORDER BY xl DESC, rune_time DESC LIMIT 1''')
    return (row[0], row[1])