On Sat, May 31, 2008 at 8:30 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote:
> An example of how to do this with the shell would be helpful.
>
> Oddly enough I can do it with applescript; but I can't do it with some other
> shell tools I'm trying to use.
>
> My problem has to do with how to pass multiple lines to a single command.
> I'm sure it's quite simple but I keep poking around not getting anywhere.
>
> This is the applescript version:
>
> set this to "echo '
> .read /a.sql
> .o stdout
> .dump
> .q
> '|sqlite3 "
> set this to paragraphs of this
> set applescript's text item delimiters to "\n"
> do shell script (this as text)
> -- result:
> "BEGIN TRANSACTION;
> CREATE TABLE Responses (GFUP_ID TEXT,FullQNum TEXT,ResponseNumber
> TEXT,SurveyVersion TEXT,RecordID TEXT);
> INSERT INTO \"Responses\" VALUES('36780001', '00.1.01', '1', '2000', '1');
> INSERT INTO \"Responses\" VALUES('36780001', '02.1.01', '1', '2000', '2');
> INSERT INTO \"Responses\" VALUES('36780001', '02.1.02', '', '2000', '3');Are you trying to dump one database into another, new database? I played around at the command line and came up with this. Not sure it fits your needs. (I create a database test.db and then dump into a new database test2.db.) $ sqlite3 test.db SQLite version 3.5.7 Enter ".help" for instructions sqlite> create table test (one integer, two integer); sqlite> insert into test values (1,2); sqlite> select * from test; 1|2 $ $ echo '.dump' | sqlite3 test.db | sqlite3 test2.db $ sqlite3 test2.db SQLite version 3.5.7 Enter ".help" for instructions sqlite> select * from test; 1|2 sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
