Parse sqlite query line by line

Question

i have a problem which i cant figure out myself, i have a SQLite database which contains data to retrieve the data i use a bash script and the command sqlite3 db "SELECT prkey FROM printers"

the output is something like this:

1

3

4

5

6

7

i need to parse each line and use it for my next command. and with out the use of a > file

regards Marco

Answer 1

The for loops work, but they are not very robust: they break if a line in the output has a space, and the shell must store the whole output of the query in memory before it starts running the loop. These two issues are easily dealt with:

sqlite3 db "SELECT ..." | while read prkey; do
   echo "do stuff with $prkey"
done