9 commits

Author	SHA1	Message	Date
Simon Willison	40287b1ba0	?_labels= and ?_label=COL to expand foreign keys in JSON/CSV ... These new querystring arguments can be used to request expanded foreign keys in both JSON and CSV formats. ?_labels=on turns on expansions for ALL foreign key columns ?_label=COLUMN1&_label=COLUMN2 can be used to pick specific columns to expand e.g. `Street_Tree_List.json?_label=qSpecies&_label=PlantType&_shape=array` [ { "rowid": 1, "TreeID": 141565, "qLegalStatus": 1, "qSpecies": { "value": 1, "label": "Myoporum laetum :: Myoporum" }, "qAddress": "501X Baker St", "SiteOrder": 1, "qSiteInfo": 1, "PlantType": { "value": 1, "label": "Tree" }, "qCaretaker": 1, "qCareAssistant": null, "PlantDate": "07/21/1988 12:00:00 AM", "DBH": 21, "PlotSize": "Width 0ft", "PermitNotes": "Permit Number 25401", "XCoord": 6000609, "YCoord": 2110829, "Latitude": 37.7759676911831, "Longitude": -122.441396661871, "Location": "(37.7759676911831, -122.441396661871)" }, { "rowid": 2, "TreeID": 232565, "qLegalStatus": 2, "qSpecies": { "value": 2, "label": "Metrosideros excelsa :: New Zealand Xmas Tree" }, "qAddress": "940 Elizabeth St", "SiteOrder": 1, "qSiteInfo": 2, "PlantType": { "value": 1, "label": "Tree" }, "qCaretaker": 1, "qCareAssistant": null, "PlantDate": "03/20/2017 12:00:00 AM", "DBH": 3, "PlotSize": "Width 4ft", "PermitNotes": "Permit Number 779625", "XCoord": 6000396.48544, "YCoord": 2101998.8644, "Latitude": 37.7517102172731, "Longitude": -122.441498017841, "Location": "(37.7517102172731, -122.441498017841)" } ] The labels option also works for the HTML and CSV views. HTML defaults to `?_labels=on`, so if you pass `?_labels=off` you can disable foreign key expansion entirely - or you can use `?_label=COLUMN` to request just specific columns. If you expand labels on CSV you get additional columns in the output: `/Street_Tree_List.csv?_label=qLegalStatus` rowid,TreeID,qLegalStatus,qLegalStatus_label... 1,141565,1,Permitted Site... 2,232565,2,Undocumented... I also refactored the existing foreign key expansion code. Closes #233. Refs #266.	2018-06-16 15:08:11 -07:00
Simon Willison	eaaa3ea149	Initial implementation of facets, plus tests and docs ... Refs #255	2018-05-12 19:29:41 -03:00
Simon Willison	02ee31c8b4	New hidden: True option for table metadat, closes #239	2018-04-25 20:42:57 -07:00
Simon Willison	f27cabbaf3	label_column option in metadata.json - closes #234	2018-04-22 10:53:16 -07:00
Russ Garrett	7d5f25dfb3	Add link to pint custom units page to docs	2018-04-14 15:08:20 +01:00
Russ Garrett	3c985ec271	Allow custom units to be registered with Pint	2018-04-14 12:27:06 +01:00
Russ Garrett	8bfeb98478	Tidy up units support ... * Add units to exported JSON * Units key in metadata skeleton * Docs	2018-04-14 11:43:34 +01:00
Simon Willison	b13f0986f2	New sortable_columns option in metadata.json to control sort options ... You can now explicitly set which columns in a table can be used for sorting using the _sort and _sort_desc arguments using metadata.json: { "databases": { "database1": { "tables": { "example_table": { "sortable_columns": [ "height", "weight" ] } } } } } Refs #189	2018-04-08 22:10:22 -07:00
Simon Willison	9af2964f6f	Documentation for metadata.json and "datasette skeleton" command ... http://datasette.readthedocs.io/en/latest/metadata.html Closes #166	2017-12-07 09:19:35 -08:00