Re: [Gnumed-devel] Consumable substances

[Jim Busser]

> On 2011-09-04, at 3:12 PM, Karsten Hilbert 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?

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

-- Jim