From 43a6c1535c4d06abeb4f56b676e1bf403ae13822 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Sun, 1 Dec 2019 00:30:35 +0100 Subject: grid_checks.py: add is_superseded info in output --- scripts/grid_checks.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'scripts') diff --git a/scripts/grid_checks.py b/scripts/grid_checks.py index e70f3a15..b789b1e9 100755 --- a/scripts/grid_checks.py +++ b/scripts/grid_checks.py @@ -55,9 +55,9 @@ proj_datumgrid = args.path_to_proj_datumgrid if args.not_in_grid_alternatives: conn = sqlite3.connect(dbname) - print('Authority, code, name, grid_name') + print('Authority, code, name, grid_name, is_superseded') res = conn.execute(""" - SELECT auth_name, code, name, grid_name FROM grid_transformation + SELECT auth_name, code, name, grid_name, EXISTS (SELECT 1 FROM supersession WHERE superseded_table_name = 'grid_transformation' AND superseded_auth_name = auth_name AND superseded_code = code) AS superseded FROM grid_transformation WHERE deprecated = 0 AND NOT EXISTS (SELECT 1 FROM grid_alternatives WHERE original_grid_name = grid_name)""") for row in res: -- cgit v1.2.3