Quick start

Quick start

Ok! Let's go!

We create a repository and fill it

    mkdir $HOME/myrepo
    cd  $HOME/myrepo
    dsql -r repository.sqlite db add --code DBONE --uri $HOME/myrepo/db1.sqlite --engine sqlite3
    dsql -r repository.sqlite db add --code DBTWO --uri $HOME/myrepo/db2.sqlite --engine sqlite3

Check it

dsql db list

List of databases

Id On Code Engine URI Tags
1 + DBONE sqlite3 /home/inf/myrepo/db1.sqlite
2 + DBTWO sqlite3 /home/inf/myrepo/db2.sqlite

Create databases DBONE and DBTWO

You can use existing databases, modify the connection string uri in the previous step.

    dsql exec --sql="CREATE TABLE ORDER(ID NUMERIC,OrdNo numeric)"

see output :
DBONE: Success. Elapsed time:53 msec. Rows count:0  Rows affected: 0
DBTWO: Success. Elapsed time:53 msec. Rows count:0  Rows affected: 0
Executed: 2    Success:2   (100.00%) Failed:0   
Completed: 54 msec

    dsql exec --sql="insert into ORDERS(ID,OrdNo) values(1,1000)"
    dsql exec --sql="insert into ORDERS(ID,OrdNo) values(2,2000)" -d DBONE
    dsql exec --sql="insert into ORDERS(ID,OrdNo) values(2,2001)" -d DBTWO

Execute sql select the database

    dsql select --sql "select * from ORDERS" --format=table
┌────────────────┬────────────┬────────────────────────────┐
│$CODE$          │ID          │OrdNo                       │
├────────────────┼────────────┼────────────────────────────┤
│DBTWO           │1           │1000                        │
│DBTWO           │2           │2001                        │
│DBONE           │1           │1000                        │
│DBONE           │2           │2000                        │
└────────────────┴────────────┴────────────────────────────┘