Populate URLs for reference systems

[g1itch]

Can you add a new column ref_system_url (text) to reference_system table and populate it from reference.config?

[binf]

On Thu, Sep 12, 2013 at 10:13 AM, Dmitri notifications@github.com wrote:

Can you add a new column ref_system_url (text) to reference_system table
and populate it from reference.config?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/104
.

Hi Dimitri,

CREATE TABLE reference ( ref_id SERIAL,
ref_system_id INT4 NOT NULL,
ref_tag TEXT NOT NULL,
PRIMARY KEY (ref_id));
You already have the integer of system inserted in the reference table.
Why you would want to have the text literal?
Also, the old database schema is not going to change.
-elz

[g1itch]

No, I want URL in reference_system from reference.config, OK with reference:

CREATE TABLE reference_system ( ref_system_id SERIAL,
                                ref_system_name TEXT,
                                ref_system_url TEXT,
                                PRIMARY KEY (ref_system_id));

INSERT INTO schema  (vseq, ctime) VALUES ('108', now());

Еhen, if someone wants to get the reference URL, she appends reference.ref_tag to reference_system.ref_system_url. No need to maintain own lists of URLs in code or parse from config every time.