1
|
#!/bin/bash
|
2
|
# :mode=transact-sql:
|
3
|
cd "$(dirname "$0")"
|
4
|
. ../../../lib/import.sh
|
5
|
|
6
|
map_table
|
7
|
psql <<'EOF'
|
8
|
-- Remove 56 duplicate symbols of type 'Old' (these are ambiguous)
|
9
|
DELETE FROM "REF_PLANT_DICTIONARY"
|
10
|
WHERE "PLANT_SYMBOL" IN (
|
11
|
SELECT "PLANT_SYMBOL"
|
12
|
FROM "REF_PLANT_DICTIONARY"
|
13
|
WHERE "PLANT_SYMBOL_TYPE" = 'Old'
|
14
|
GROUP BY "PLANT_SYMBOL"
|
15
|
HAVING count(*) > 1
|
16
|
);
|
17
|
|
18
|
SELECT create_if_not_exists($$ALTER TABLE "REF_PLANT_DICTIONARY" ADD CONSTRAINT "REF_PLANT_DICTIONARY.unique" UNIQUE ("PLANT_SYMBOL_TYPE", "PLANT_SYMBOL")$$);
|
19
|
EOF
|
20
|
mk_derived
|