Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Mihai Militaru
On Sat, 23 Apr 2011 19:06:02 +0200 Roger Andersson wrote: > > On Unices I use: "sqlite3.exe default.db3< schema.sql" as exemplified by > > DRH (IIRC), but I guess > > there's no way to do something similar on Windows cmd? > > > Have you tried exactly the same on Windows cmd? I'm sorry for the

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Random Coder
On Fri, Apr 22, 2011 at 8:18 AM, Maurice Marinus wrote: > On a windows platform I have the following: > schema.sql (contains the sql scripts) > sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) > build.bat : A batch file containing the line : sqlite3.exe -init > schema.sql defau

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Roger Andersson
On 04/23/11 06:50 PM, Mihai Militaru wrote: > On Sat, 23 Apr 2011 12:17:54 -0400 > Tom Holden wrote: > > On Unices I use: "sqlite3.exe default.db3< schema.sql" as exemplified by DRH > (IIRC), but I guess > there's no way to do something similar on Windows cmd? > Have you tried exactly the same

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Simon Slavin
On 22 Apr 2011, at 4:18pm, Maurice Marinus wrote: > When I run build.bat, the database is created as expected, however, the > sqlite shell doesn't automatically terminate. So how would I get the > batch file to run and terminate the sqlite command shell automatically? > > Output shown on the d

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Mihai Militaru
On Sat, 23 Apr 2011 12:17:54 -0400 Tom Holden wrote: > Perhaps by adding > .quit > to your schema.sql I tried this and it does not work, no error but it enters interactive mode once more. Also, the necessity to add sqlite shell commands to the file would pervert the pure SQL schema if it worke

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Tom Holden
Perhaps by adding .quit to your schema.sql Tom -Original Message- From: Maurice Marinus Sent: Friday, April 22, 2011 11:18 AM To: sqlite-users@sqlite.org Subject: [sqlite] Automating the build of a sqlite database So how would I get the batch file to run and terminate the sqlite

Re: [sqlite] Automating the build of a sqlite database

2011-04-23 Thread Igor Tandetnik
Maurice Marinus wrote: > On a windows platform I have the following: > schema.sql (contains the sql scripts) > sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) > build.bat : A batch file containing the line : sqlite3.exe -init > schema.sql default.db3 > > When I run build.bat,

[sqlite] Automating the build of a sqlite database

2011-04-23 Thread Maurice Marinus
On a windows platform I have the following: schema.sql (contains the sql scripts) sqlite3.exe (command shell for sqlite -> downloaded from sqlite.org) build.bat : A batch file containing the line : sqlite3.exe -init schema.sql default.db3 When I run build.bat, the database is created as expected,