Beispiel #1
0
def prepare_sql_query(context):
    sample_data = _get_sample_data()
    table_data_set = SQLTableDataSet(table_name=TABLE_C,
                                     credentials=dict(con=_get_test_sql_con()))

    table_data_set.save(sample_data)
    sql = "SELECT * FROM C WHERE name='me'"
    context.query_data_set = SQLQueryDataSet(
        sql=sql, credentials=dict(con=_get_test_sql_con()))
Beispiel #2
0
def _prepare_read_samples():
    _clear_db_()
    data_set = SQLTableDataSet(table_name=TABLE_A,
                               credentials=dict(con=_get_test_sql_con()))
    data_set.save(_get_sample_data())