blob: f0c37ba423c7ce8c2ef1e9e15b6d4f6015967f34 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# Datamaps in Go
Some useful queries:
### Joining and pattern matching
`select name, key, cellref from datamap_line join datamap on (datamap.id
= datamap_line.dm_id) where key like 'Total RDEL%';`
### Create return and return_data tables
`CREATE TABLE return(id INTEGER PRIMARY KEY, name TEXT, date_created TEXT);
CREATE TABLE return_data(id INTEGER PRIMARY KEY, dml_id INTEGER, value TEXT, FOREIGN KEY (dml_id) REFERENCES datamap_line(id) ON DELETE CASCADE);
`
### This crazy join works
`select dm.name, dml.key, dml.sheet, return.name, return_data.value from
datamap as dm inner join datamap_line as dml on dml.dm_id=dm.id inner join
return on return_data.ret_id=return.id inner join return_data on
return_data.ret_id=return.id;`
|
