Re: [Gnumed-devel] Data packs

[Jim Busser]

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