Re: [sqlite] Automating the build of a sqlite database
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 typo, my executable is "sqlite3", not "sqlite3.exe". To answer your question: no, I haven't had tried that on plain cmd at the time I wrote the message. Being intrigued by your question, I discovered it actually works... (I normally use MSYS when I need something done in command-line on Windows) -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Automating the build of a sqlite database
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 default.db3 I use something like the following to create a sqlite database as part of a larger build system: sqlite3.exe output.sqlite ".read output.sql" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Automating the build of a sqlite database
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 on Windows cmd? /Roger ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Automating the build of a sqlite database
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 dos command prompt after executing build.bat > > C:\Work\X\Database>sqlite3.exe -init schema.sql default.db3 Rather than use '-init', which is intended for what you describe -- initial commands -- you should be able to pipe those commands into the shell tool. Try something like sqlite3 default.db3 < schema.sql Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Automating the build of a sqlite database
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 worked. But quit can (should?) be appended to each batch command as an argument for sqlite3.exe: sqlite3.exe -init schema.sql default.db3 ".quit" 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? -- Mihai Militaru ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Automating the build of a sqlite database
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 command shell automatically? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Automating the build of a sqlite database
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, the database is created as expected, however, the > sqlite shell doesn't automatically terminate. Put ".exit" (without quotes, and with a period in front) as the last line of the script. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Automating the build of a sqlite database
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, 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 dos command prompt after executing build.bat C:\Work\X\Database>sqlite3.exe -init schema.sql default.db3 -- Loading resources from schema.sql SQLite version 3.7.4 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users