def test_refresh_runs(engine): viewname = 'viewname' + str(random.randint(1, 10000000)) run_command(['add-view', '--name', viewname, '1', 'Note']) run_command(['refresh-views', viewname, '--remove']) run_command(['refresh-views', viewname]) with engine.connect() as conn: results = conn.execute(CURRENT_TABLES_QUERY.format(viewname)) db_tables = {result['table_name'] for result in results} assert db_tables.issuperset(VIEWS_TABLES) with engine.connect() as conn: results = conn.execute(NO_COMMENTS_QUERY, 'view_data_' + viewname) missing_comments = [result for result in results] assert missing_comments == [] run_command(['refresh-views', viewname, '--remove']) with engine.connect() as conn: results = conn.execute(CURRENT_TABLES_QUERY.format(viewname)) db_tables = {result['table_name'] for result in results} assert db_tables.isdisjoint(VIEWS_TABLES)
def test_refresh_runs(engine): run_command(['refresh-views', '--remove']) run_command(['refresh-views']) get_current_tables_query = "select table_name from information_schema.tables where table_schema = 'views'" with engine.connect() as conn: results = conn.execute(get_current_tables_query) db_tables = {result['table_name'] for result in results} assert db_tables.issuperset(VIEWS_TABLES) run_command(['refresh-views', '--remove']) with engine.connect() as conn: results = conn.execute(get_current_tables_query) db_tables = {result['table_name'] for result in results} assert db_tables.isdisjoint(VIEWS_TABLES)
def test_refresh_runs_tables_only(engine): viewname = 'viewname' + str(random.randint(1, 10000000)) run_command(['add-view', '--name', viewname, '1', 'Note', '--tables-only']) with engine.connect() as conn: results = conn.execute(CURRENT_TABLES_QUERY.format(viewname)) db_tables = {result['table_name'] for result in results} assert db_tables.issuperset(VIEWS_TABLES) run_command(['refresh-views', viewname, '--tables-only']) with engine.connect() as conn: results = conn.execute(CURRENT_TABLES_QUERY.format(viewname)) db_tables = {result['table_name'] for result in results} assert db_tables.issuperset(VIEWS_TABLES) run_command(['refresh-views', viewname, '--remove', '--tables-only']) with engine.connect() as conn: results = conn.execute(CURRENT_TABLES_QUERY.format(viewname)) db_tables = {result['table_name'] for result in results} print(db_tables) assert db_tables.isdisjoint(VIEWS_TABLES) run_command(['delete-view', viewname])
def test_field_count_runs(engine): run_command(['refresh-views', '--remove']) run_command(['field-counts', '--remove']) run_command(['refresh-views']) run_command(['field-counts']) get_current_tables_query = "select table_name from information_schema.tables where table_schema = 'views'" with engine.connect() as conn: results = conn.execute(get_current_tables_query) db_tables = {result['table_name'] for result in results} assert 'field_counts' in db_tables run_command(['refresh-views', '--remove']) run_command(['field-counts', '--remove']) with engine.connect() as conn: results = conn.execute(get_current_tables_query) db_tables = {result['table_name'] for result in results} assert 'field_counts' not in db_tables
def test_field_count_runs(engine): viewname = 'viewname' + str(random.randint(1, 10000000)) run_command(['add-view', '--name', viewname, '1', 'Note']) run_command(['refresh-views', viewname, '--remove']) run_command(['field-counts', viewname, '--remove']) run_command(['refresh-views', viewname]) run_command(['field-counts', viewname]) get_current_tables_query = "select table_name from information_schema.tables " + \ "where table_schema = 'view_data_" + viewname + "'" with engine.connect() as conn: results = conn.execute(get_current_tables_query) db_tables = {result['table_name'] for result in results} assert 'field_counts' in db_tables run_command(['refresh-views', viewname, '--remove']) run_command(['field-counts', viewname, '--remove']) with engine.connect() as conn: results = conn.execute(get_current_tables_query) db_tables = {result['table_name'] for result in results} assert 'field_counts' not in db_tables run_command(['delete-view', viewname])