#!/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)