#!/usr/bin/env python from shared.utils.check_imported_data import run_sql_checks, all_valid_url, assert_count_minimum, assert_count_zero sql_checks = [ ('count', "select count(*) from bb_quotum_new", assert_count_minimum(90)), ('count_col', """ select count(column_name) from information_schema.columns where table_schema = 'public' and table_name = 'bb_quotum_new' and column_name in ('wijk', 'availability_color', 'geo') """, assert_count_minimum(3)), ('geometrie', """ select count(*) from bb_quotum_new where geo is null or ST_IsValid(geo) = false or ST_GeometryType(geo) <> 'ST_MultiPolygon' """, assert_count_zero()), ('count1', "select count(*) from omzettingen_quotum_new", assert_count_minimum(90)), ('count_col1', """ select count(column_name) from information_schema.columns where table_schema = 'public' and table_name = 'omzettingen_quotum_new' and column_name in ('wijk', 'availability_color', 'geo') """, assert_count_minimum(3)), ('geometrie1', """ select count(*) from omzettingen_quotum_new where geo is null or ST_IsValid(geo) = false or ST_GeometryType(geo) <> 'ST_MultiPolygon' """, assert_count_zero()), ] if __name__ == '__main__': run_sql_checks(sql_checks)
from shared.utils.check_imported_data import ( run_sql_checks, all_valid_url, assert_count_minimum, assert_count_zero, ) sql_checks = [ ("count", "select count(*) from bb_quotum_new", assert_count_minimum(90)), ( "count", """ select count(column_name) from information_schema.columns where table_schema = 'public' and table_name = 'bb_quotum_new' and column_name in ('wijk', 'availability_color', 'geo') """, assert_count_minimum(3), ), ( "geometrie", """ select count(*) from bb_quotum_new where geo is null or ST_IsValid(geo) = false or ST_GeometryType(geo) <> 'ST_MultiPolygon' """, assert_count_zero(), ), ] if __name__ == "__main__": run_sql_checks(sql_checks)
#!/usr/bin/env python from shared.utils.check_imported_data import run_sql_checks, assert_count_zero, assert_count_minimum sql_checks = [ ('count', "select count(*) from parkeerzones_new", assert_count_minimum(100)), ('count_uitz', "select count(*) from parkeerzones_uitz_new", assert_count_minimum(60)), ('geometrie', """ select count(*) from parkeerzones_new where wkb_geometry is null or ST_GeometryType(wkb_geometry) <> 'ST_Polygon' """, assert_count_zero()), ('geometrie', """ select count(*) from parkeerzones_uitz_new where wkb_geometry is null or ST_GeometryType(wkb_geometry) <> 'ST_Polygon' """, assert_count_zero()), # ('columns', """ #select column_name from information_schema.columns where #table_schema = 'public' and table_name = 'hoofdroutes_new' # """, lambda x: x == [("ogc_fid",), ("wkb_geometry",), ("id",), ("name",), ("route",), ("type",)]), ] if __name__ == '__main__': run_sql_checks(sql_checks)