Python execute_queries Examples

Example #1

File: compute_load_evolving_user_status_changed.py Project: jonathan-marsan/active-users-sample-code

def load_evolving_user_status_changed(conn):
    execute_queries(
        conn=conn,
        queries=[query_drop_tbl, query_create_tbl, query_insert_tbl])
    print('Upload complete: {}'.format(TABLE_NAME))

Example #2

def load_derived_user_became_inactive(conn):
    execute_queries(conn=conn, queries=[query_drop_tbl, query_create_tbl,
                                        query_insert_tbl])
    print('Upload complete: {}'.format(TABLE_NAME))

Example #3

File: compute_load_snapshot_user_churn_rate_daily.py Project: jonathan-marsan/active-users-sample-code

def load_snapshot_user_churn_rate_daily(conn):
    execute_queries(
        conn=conn,
        queries=[query_drop_tbl, query_create_tbl, query_insert_tbl])
    print('Upload complete: {}'.format(TABLE_NAME))

Example #4

def load_user_tasks_with_active_period(conn):
    execute_queries(conn=conn, queries=[query_drop_view, query_create_view])
    print('Created view: {}'.format(VIEW_NAME))

Example #5

File: compute_load_lookup_dates.py Project: jonathan-marsan/active-users-sample-code

def load_lookup_dates(conn):
    execute_queries(
        conn=conn,
        queries=[query_drop_tbl, query_create_tbl, query_insert_tbl])
    print('Upload complete: {}'.format(TABLE_NAME))

Example #6

def load_snapshot_active_users_monthly(conn):
    execute_queries(
        conn=conn,
        queries=[query_drop_tbl, query_create_tbl, query_insert_tbl])
    print('Upload complete: {}'.format(TABLE_NAME))

Example #7

File: compute_load_number.py Project: jonathan-marsan/active-users-sample-code

def load_number(conn):
    execute_queries(conn=conn, queries=[query_drop_tbl, query_A, query_B,
                                        query_C, query_D, query_E, query_F,
                                        query_G, query_H, query_I])
    print('Upload complete: {}'.format(TABLE_NAME))