Esempi in Python per fetchall

Esempio n. 1

File: db.py Progetto: 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])

Esempio n. 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])

Esempio n. 3

File: db.py Progetto: 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])

Esempio n. 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])