?_labels=1 to expand foreign keys (in csv and json), refs #233 #311
Conversation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Output looks something like this:
{
"rowid": 233,
"TreeID": 121240,
"qLegalStatus": {
"value" 2,
"label": "Private"
}
"qSpecies": {
"value": 16,
"label": "Sycamore"
}
"qAddress": "91 Commonwealth Ave",
...
}
|
Still todo:
|
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
Also moved those out of standard JSON into just the HTML template context
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.
|
I merged this manually in ed631e6 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
Output looks something like this: