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.
  |