Looping over rows in an SQLite database using Bash

README.md

• Description

This is a code sample showing how to query an SQLite database using Bash and loop through query results.

To run this sample:

make gen_data
make build_db
make query

• Contact

If you need help with SQLite, my company provides a variety of database-related services.

Makefile

gen_data:
	echo "1 2 3" > data.tsv
	echo "4 5 6" >> data.tsv
	echo "7 8 9" >> data.tsv

build_db:
	sqlite3 data.db < schema.sql

query:
	./query.sh

query.sh

#!/bin/bash

for row_str in $(sqlite3 data.db 'select * from t1;'); do
    IFS='|' read -r -a COLS <<< "$row_str"
    echo "${COLS[2]}"
done

schema.sql

drop table if exists t1;

create table t1 (
    a int,
    b int,
    c int
);

.mode ascii
.separator " " "\n"
.import data.tsv t1