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])
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])