Mercurial > gemma
comparison schema/isrs_tests.sql @ 578:61af85a432bf
Fix extraction of object reference code
Use something more distinguishing in test to make it more likely
to catch similar errors.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Thu, 06 Sep 2018 13:19:51 +0200 |
parents | ad07846b09d1 |
children | 6590208e3ee1 |
comparison
equal
deleted
inserted
replaced
577:e6c9d2da2e20 | 578:61af85a432bf |
---|---|
1 -- | 1 -- |
2 -- pgTAP test script for ISRS location code types and functions | 2 -- pgTAP test script for ISRS location code types and functions |
3 -- | 3 -- |
4 | 4 |
5 SELECT results_eq($$ | 5 SELECT results_eq($$ |
6 SELECT isrs_fromText('DEXXX039000000005023') | 6 SELECT isrs_fromText('DEBON03901G007906548') |
7 $$, | 7 $$, |
8 $$ | 8 $$ |
9 SELECT CAST(('DE', 'XXX', '03900', '00000', 5023) AS isrs) | 9 SELECT CAST(('DE', 'BON', '03901', 'G0079', 6548) AS isrs) |
10 $$, | 10 $$, |
11 'Correct ISRS text input gives respective ISRS location code'); | 11 'Correct ISRS text input gives respective ISRS location code'); |
12 | 12 |
13 SELECT throws_ok($$ | 13 SELECT throws_ok($$ |
14 SELECT isrs_fromText('DEUXXX039000000005023') | 14 SELECT isrs_fromText('DEUXXX039000000005023') |