Merging sqlite databases through a bash script

Question

Thanks to previous SO posts I can now merge sqlite databases.

But I want to run this merging in an automatic way using a bash script,

I have tried various ways and here is my latest and most complete fail:

## DB to merge
I1=d1.db
I2=d2.db

## Command to run
CMD='attach \'d2.db\' as toMerge; BEGIN; insert into sae select * from toMerge.sae; COMMIT; detach toMerge;'
echo $CMD

## Pass to sqlite
sqlite3 $I1 $CMD

Two issues meet here:

1- passing a bash variable (here d2.db). I had tried with the quote function as well:

CMD='attach quote('$I2') as toMerge; BEGIN; insert into sae select * from toMerge.sae; COMMIT; detach toMerge;'

2- the * in the select command that is interpreted in the bash way, hence the single quotes.

Diego Torres Milano · Accepted Answer · 2018-04-03 19:02:12Z

3

This works

d1=d1.db
d2=d2.db
sqlite3 "$d1" <<!
attach database "$d2" as m;
insert into sae select * from m.sae;
detach m;
!

using a heredoc

answered Apr 3, 2018 at 19:02

Diego Torres Milano

69.9k9 gold badges116 silver badges145 bronze badges

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

1 Comment

Diego Torres Milano Over a year ago

it's a delimiter, <<EOF is also commonly used

ivan2kh · Accepted Answer · 2018-10-18 11:54:31Z

0

find . -name "*.db" -exec sqlite3 {} .dump \; | sqlite3 new_db

answered Oct 18, 2018 at 11:54

ivan2kh

362 bronze badges

Collectives™ on Stack Overflow

Merging sqlite databases through a bash script

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related