making multiple sqlite3 calls in a shell script

Question

i am looking to execute the following commands within a shell script:

$ sqlite3 /Users/riceje7/bin/places.sqlite
sqlite > .output places.txt;
sqlite > SELECT url FROM moz_places;
sqlite > .quit;
$ lpr /Users/riceje7/bin/places.txt

however the script stops after the initial sqlite3 command call and only executes the other commands after i manually quit sqlite. does anyone know how i can force the script to execute these commands in this order without having to manually enter them?

ocodo · Accepted Answer · 2010-11-18 03:00:50Z

3

You should be doing..

sqlite3 [OPTIONS] FILENAME [SQL]

so...

sqlite3 /Users/riceje7/bin/places.sqlite  "SELECT url FROM moz_places" > places.txt
lpr /Users/riceje7/bin/places.txt

Or better yet (unless you need to keep places.txt for some reason)...

sqlite3 /Users/riceje7/bin/places.sqlite  "SELECT url FROM moz_places" | lpr

edited Nov 18, 2010 at 3:00

answered Nov 18, 2010 at 2:53

ocodo

30.5k19 gold badges111 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

cababunga Over a year ago

lpr will be fine reading your data from stdin, so: sqlite3 /Users/riceje7/bin/places.sqlite "SELECT url FROM moz_places" | lpr

Collectives™ on Stack Overflow

making multiple sqlite3 calls in a shell script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest