[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Data packs
From: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Data packs |
Date: |
Mon, 05 Sep 2011 22:09:04 -0700 |
On 2011-09-02, at 11:53 AM, Jim Busser wrote:
> I am working on refactoring the freely-available HC DPD (Canadian) data into
> GNUmed.
Can gmPsql.py support a variation of direct SQL in which gmPsql.py is pointed
to 'install-data-pack.sql' which could then itself references one or more sql
files in the same top level of the .zip archive (since extracted) for example
install-data-pack.sql --> references the following
prepare-staging.sql
insert-or-update-values-1.sql
insert-or-update-values-2.sql
insert-or-update-values-3.sql
complete-job.sql
This could somewhat simply the work of the data pack providers when it is only
the data that changes. New data would simply need them to dump data --data-only
into one or more suitable
insert-or-update-values.sql
and avoid their having to splice it at potentially multiple places into a
single file.
??
-- Jim
[Gnumed-devel] Data packs, Jim Busser, 2011/09/24