github

This data as json, CSV

sha	message	author_date	committer_date	raw_author	raw_committer	repo	author	committer
0c22fa8f09e9fce7434d5fc83bcfb73c25795205	Cleaned up view_definition/table_definition code in table view Also moved those out of standard JSON into just the HTML template context	2018-06-16T17:33:17Z	2018-06-16T17:33:17Z	13ae486343ea6454a93114c6f558ffea2f2c6874	13ae486343ea6454a93114c6f558ffea2f2c6874	107914493	9599	9599
7e0caa1e62607c6579101cc0e62bec8899013715	Extract string-to-bool logic into utils.py	2018-06-16T16:44:31Z	2018-06-16T16:44:31Z	13ae486343ea6454a93114c6f558ffea2f2c6874	13ae486343ea6454a93114c6f558ffea2f2c6874	107914493	9599	9599
d0a578c0fc07b9d9208cd9de981bdf7385a26c49	Switch back from python:3.6-slim-stretch to python:3.6 Turns out slim-stretch doesn't include gcc which means it can't build various Sanic dependencies. So `datasette publish now ...` was broken. Fixes #310	2018-06-16T16:28:55Z	2018-06-16T16:28:55Z	13ae486343ea6454a93114c6f558ffea2f2c6874	13ae486343ea6454a93114c6f558ffea2f2c6874	107914493	9599	9599
ed631e690b81e34fcaeaba1f16c9166f1c505990	?_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=qLegalStatus` { "rowid": 233, "TreeID": 121240, "qLegalStatus": { "value" 2, "label": "Private" } "qSpecies": { "value": 16, "label": "Sycamore" } "qAddress": "91 Commonwealth Ave", ... } 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-16T22:18:57Z	2018-06-16T22:18:57Z	13ae486343ea6454a93114c6f558ffea2f2c6874	13ae486343ea6454a93114c6f558ffea2f2c6874	107914493	9599	9599