Python fetchall Beispiele

Beispiel #1

Datei: db.py Projekt: always19/clutch

def get_variations_for_app(app_id):
    SQL = """
    SELECT V.*
    FROM ab_variation V
    WHERE V.experiment_id IN (
        SELECT E.id FROM ab_experiment E WHERE E.app_id = %s
    )
    """
    return db.fetchall(SQL, [app_id])

Beispiel #2

def get_variations_for_app(app_id):
    SQL = """
    SELECT V.*
    FROM ab_variation V
    WHERE V.experiment_id IN (
        SELECT E.id FROM ab_experiment E WHERE E.app_id = %s
    )
    """
    return db.fetchall(SQL, [app_id])

Beispiel #3

Datei: db.py Projekt: always19/clutch

def get_experiments_for_app(app_id):
    SQL = """SELECT E.* FROM ab_experiment E WHERE E.app_id = %s"""
    return db.fetchall(SQL, [app_id])

Beispiel #4

def get_experiments_for_app(app_id):
    SQL = """SELECT E.* FROM ab_experiment E WHERE E.app_id = %s"""
    return db.fetchall(SQL, [app_id])