Re: [Gnumed-devel] Creating gnumed with sqls alone

[Karsten Hilbert]

On Tue, Jan 10, 2006 at 09:12:11PM +0800, Syan Tan wrote:

> it is possible.
Thanks :-)

> there is a line that executes a sql script within a sql script in
> gmDemographics-GIS-data.sql
> \i gmCountryZones.sql  , 
The reason for it being there had to do with some sort of
complexity while upgrading a v1 to a v2 database. That
reason wasn't very good, though. It's definitely not the
place it *should* be in, I agree.

> which implies one is running the sql script in the same directory as 
> execution,
I didn't think of that. A good counter-argument.

> and I moved that to the monolithic-core.conf  because  it means scripts which
> aren't configured
> with the relative path to the sql scripts will still run.
OK.

> I debugged
> 
>     test-area/cygwin/install_schema.sh 
...
> what the script does is basically parses server/boostrap/
> boostrap-monolithic-core.conf for the basic setup
> information under $service ...$service  [database ..] [server..] [service
> SERVICENAME]  $schema ..$schema
> orders it and puts the order in "filelist", and dumps the sql in that order  
> to
> a file called "all'  , does some  setup
> using  the command line  createdb, createlang, createuser,  and then runs  
> psql
> -f  "all"  -U "gm-dbo" gnumed.
Sounds very reasonable.

> So it sort of proves what Karsten asserts. 
:-)

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346