Re: [Gnumed-devel] Consumable substances

[Karsten Hilbert]

On Sun, Sep 04, 2011 at 08:33:01PM -0700, Jim Busser wrote:

> >> No. They would go to the menu item "install data pack",
> >> select the "Canadian drugs 2011" and hit install.
> 
> Would this menu option (and data pack item), if selected
> 
> - prompt for gnumed-dbo password and then
> - wget and unzip the zip file
> - change directory into the unzipped directory
>       depends on the zip archive keeping the same name as the directory plus 
> .zip
>       ??
> - query if did not already know the current version vXX of the database
> - launch
> 
>       psql -d gnumed_vXX -U gm-dbo
> 
>       (providing the password fed in by the user)
> 
> - pass the file reference of the sql file to be run which, by convention, 
> will be
> 
>        install-data-pack.sql
> 
> - delete the zip and extracted archive?
>
> - return something to the user, maybe in the status line?

Yes.

> Also, to limit database bloat, is it advisable that the script should, before 
> exiting, delete the staging records?

Yes.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346