How to exit sqlite3 from bash script after initializing database

Question

I have a folder with multiple .sql files, each creating their own database. I'm trying the below bash script to loop through each file and initialize the database with sqlite3.

for filepath in $(find ~/sql/ -name '*.sql'); do
        sqlite3 "${file}.db" -init "$filepath"
done

My issue is I have to manually type .quit in the terminal to exit sqlite3 before the bash loop continues.

I tried adding .quit but the terminal doesn't recognize the sqlite command. Do I need to add an exit command in the .sql files to exit sqlite from bash's terminal or something else?

EDIT: from the comments, I got the script to run automatically with sqlite3 "${file}.db" < "$filepath".

I just tried sqlite3 -batch "${file}.db" -init "$filepath" and it's still needing manual .quit. Is that right? I also tried adding .quit to each .sql file and got the same issue. — Phuong H Nguyen
– Phuong H Nguyen, Commented May 5, 2022 at 21:57
Also, see sqlite.org/cli.html#using_sqlite3_in_a_shell_script — Shawn
– Shawn, Commented May 5, 2022 at 22:30

user117529 · Accepted Answer · 2024-01-23 02:39:57Z

0

Where you can't/don't want to pass the commands in via standard input, a workaround is to misspell .quit (e.g., .quoot) as the last statement in the -init file, and pass the -bail option on the command-line.

sqlite3 will execute commands in the -init file until reaching one that produces an error (hopefully the intentionally misspelled one), and then terminate with a nonzero status. To exit solely at the end, you can insert .bail on into the file just prior to the misspelled command. In either case, the bash script can then continue.

edited Jan 23, 2024 at 2:39

answered Jan 22, 2024 at 18:55

user117529

6731 gold badge8 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to exit sqlite3 from bash script after initializing database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related