[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Re: GNUmed and FreeDiams

From: Jim Busser
Subject: Re: [Gnumed-devel] Re: GNUmed and FreeDiams
Date: Sat, 01 Jan 2011 11:29:23 -0800

On 2011-01-01, at 3:32 AM, Karsten Hilbert wrote:

> No. Users would run the script as needed and generate the
> text file.
>>      (needs the string "table" to be replaced with "ref.branded_drug")
> How about applying sed to the resulting text file ?

This will do it

        sed -e 's:table:ref.branded_drug:' fd2gm_brands_raw.txt 

However… FreeDiams has columns


lacking in GNUmed ref.branded_drug. We should add them, yes? They can remain 
empty for sources that do not use them but at least these would give a way to 
distinguish among multiple values for a branded drug that (in GNUmed) are 
identical except for the source UID

Once we would have resolved the above question, setting aside that postgres 
will auto-assign values in pk_audit, what do I need for the import file (or 
script) to address the GNUmed columns

        serial (is this auto-assigned?)
        fk_data_source (integer)

For the foreign key to data_source, I would propose one data_source record per 
distinct drug database within (e.g.) FreeDiams

        name_long = FreeMedForms FreeDiams DRUGS table
        name_short = FreeDiams
        version = CA_HCDPD
        description = BSD license (Health Canada DPD source is no-charge, 
royalty-free, non-exclusive, annually renewable)
        source =
        lang = (leave blank)

and then the value for will have to feed the insertion, like 

        INSERT INTO … but does one need the "ref." part, or just "branded_drug" 

         (quoted column names, assuming we will not in this case be specifying 

        SELECT pk FROM WHERE name_short = "FreeDiams" and 
version = "CA_HCDPD"

which, if yes, would need to be pre-inserted (maybe via sed) into every record 
in the source text file. Or, is it better that this pk is manually looked up, 
and inserted, as part of creating the output from FreeDIams?

-- Jim

reply via email to

[Prev in Thread] Current Thread [Next in Thread]