# 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;`

### More accurate SQL to test all data at this stage:
`select datamap.name, datamap_line.key, datamap_line.sheet, return.name,
return_data.filename, return_data.value from datamap, datamap_line, return,
return_data where datamap_line.dm_id=datamap.id;`

### Simple output to spreadsheet from sqlite3:
`.excel`
`select return.name, datamap_line.key, return_data.filename,
datamap_line.sheet, datamap_line.cellref, return_data.value from datamap_line,
return, return_data where (return_data.dml_id=datamap_line.id AND
datamap_line.key like '%MM6%');`