aboutsummaryrefslogtreecommitdiffstats
path: root/Idea.txt
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.