On Sun, Jan 20, 2008 at 05:30:41PM +0100, RKI Andreas wrote: >> Does your script turn the data into SQL statements ? That >> would be *most* useful, much more than a mysql database as >> such. > > Sounds very reasonable. I could imagine scripts > > create_act-ddd_drug_db > update_act-ddd_drug_db > > featuring a command line options for instance -m for MySQL and > -p for PostgreSQL. > > Our task in Debian-Med would be to turn this script into an > easily installable Debian package.
It is easy to convert $dbh->do(insert ..) to print(insert ..), but it is not so easy to write fully portable sql. In my script I use create table if not exists .. insert ignore into .. and these constructs are mysql-specific. I have tried (with postgresql and sqlite3) to rewrite it in portable sql, but that is not yet ready. Maybe someone else can give it a try. I have put my scripts online at http://home.orange.nl/pbvandenberg/medicindata.html Regards, Paul
