# HG changeset patch # User Sascha Wilde # Date 1553190952 -3600 # Node ID 41f5ac76d642ede42c8ee7472fcef67ea65e1810 # Parent f0846d200ce4d0488702d0f05c745431742b3078 BT import: allow for rb and lb to be null. As rb_lb is optional according to drc this is the right thing to do. diff -r f0846d200ce4 -r 41f5ac76d642 pkg/imports/bn.go --- a/pkg/imports/bn.go Thu Mar 21 18:21:18 2019 +0100 +++ b/pkg/imports/bn.go Thu Mar 21 18:55:52 2019 +0100 @@ -126,12 +126,12 @@ var rblbRe = regexp.MustCompile(`(..)_(..)`) -func splitRBLB(s string) (string, string) { +func splitRBLB(s string) (*string, *string) { m := rblbRe.FindStringSubmatch(s) if len(m) == 0 { - return "", "" + return nil, nil } - return m[1], m[2] + return &m[1], &m[2] } func revisitingTime(s string) int { diff -r f0846d200ce4 -r 41f5ac76d642 schema/gemma.sql --- a/schema/gemma.sql Thu Mar 21 18:21:18 2019 +0100 +++ b/schema/gemma.sql Thu Mar 21 18:55:52 2019 +0100 @@ -467,8 +467,8 @@ stretch isrsrange NOT NULL, area geography(MULTIPOLYGON, 4326) NOT NULL CHECK(ST_IsValid(CAST(area AS geometry))), - rb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface - lb char(2) NOT NULL REFERENCES countries, -- from rb_lb in interface + rb char(2) REFERENCES countries, -- from rb_lb in interface + lb char(2) REFERENCES countries, -- from rb_lb in interface responsible_country char(2) NOT NULL REFERENCES countries, revisiting_time smallint NOT NULL, limiting varchar NOT NULL REFERENCES limiting_factors,