Do sqlite commands via bash

Question

I don't want to run these commands manually. How can I automate that in bash script?

sqlite3 /var/lib/pve-cluster/config.db
sqlite> select * from tree where name = 'corosync.conf';
sqlite> delete from tree where name = 'corosync.conf';
sqlite> select * from tree where name = 'corosync.conf';
sqlite> .quit

Shawn · Accepted Answer · 2020-05-28 10:01:18Z

2

I use heredocs:

sqlite3 /var/lib/pve-cluster/config.db <<EOF
select * from tree where name = 'corosync.conf';
delete from tree where name = 'corosync.conf';
select * from tree where name = 'corosync.conf';
EOF

answered May 28, 2020 at 10:01

Shawn

53.9k3 gold badges29 silver badges74 bronze badges

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

Comments

mtnezm · Accepted Answer · 2020-05-28 09:59:25Z

2

Just do:

sqlite3 /path/to/file.db "$command"

From your command prompt.

For example:

sqlite3 /var/lib/pve-cluster/config.db "select * from tree where name = 'corosync.conf';"

answered May 28, 2020 at 9:59

mtnezm

1,0271 gold badge9 silver badges20 bronze badges

Collectives™ on Stack Overflow

Do sqlite commands via bash

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related