blob: 54ad59f88a383e105e209484a0dbbd047a2c00db (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
Program to translate from YAML to SQLite and back.
$ yaqlite insert --db database.db 'table_name' records.yml
# records.yml
- column: value
column2: 2
- column: value2
column2: 4
translates to:
INSERT INTO "table_name"
(column, column2)
VALUES
('value', 2),
('value2', 4);
$ yaqlite select --db database.db 'table_name' <ID> > records.yml
# records.yml
- column: value
column2: value
column3: >
Multiline value.
|