search

datagovuk / apiserver

Prototype "NII Data->API" Service
15 stars 3 forks source link

Clarify table schema for sql tab #70

Closed rossjones closed 8 years ago

rossjones commented 8 years ago

It would be useful to users to be able to see where the indices are on tables, so they can plan their queries accordingly. This info is already in the manifests so it should just be a matter of fixing up https://github.com/datagovuk/apiserver/blob/master/web/templates/page/advanced.html.eex#L28-L34

rossjones commented 8 years ago

Although the indices are marked in the etl for table creation, they're not present in the manifests for the services :( We need to add them so that they can be loaded at runtime.

rossjones commented 8 years ago

These will now mark the indexed fields in the SQL schema view (on next deploy) from 3ac513027109006bc0b217911a9bfaccf207a6d7