remote/datasette
1
0
Fork 0
mirror of https://github.com/simonw/datasette.git synced 2026-07-14 03:24:42 +02:00
Code Issues Projects Releases Packages Wiki Activity
datasette/datasette
History
Exact
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
..
static Hide sort select on larger screens, closes #300 2018-05-31 07:43:06 -07:00
templates Basic CSV export, refs #266 2018-06-14 23:51:23 -07:00
views ?_labels= and ?_label=COL to expand foreign keys in JSON/CSV 2018-06-16 15:08:11 -07:00
__init__.py Move version info back to separate module 2018-05-22 12:35:21 -07:00
_version.py Add version number support with Versioneer 2018-05-22 12:35:21 -07:00
app.py Cleaned up view_definition/table_definition code in table view 2018-06-16 15:08:11 -07:00
cli.py Extract string-to-bool logic into utils.py 2018-06-16 09:45:35 -07:00
hookspecs.py New plugin hooks: extra_css_urls() and extra_js_urls() 2018-04-17 20:12:21 -07:00
inspect.py Refactor inspect logic 2018-05-22 07:03:06 -07:00
utils.py Switch back from python:3.6-slim-stretch to python:3.6 2018-06-16 15:07:01 -07:00
version.py Move version info back to separate module 2018-05-22 12:35:21 -07:00