search

adicu / data.adicu.com

API for Columbia data
http://data.adicu.com
13 stars 14 forks source link

order the data being returned #65

Open natebrennand opened 10 years ago

natebrennand commented 10 years ago

dynamically add an ORDER BY statement to queries

In query.py we build a SQL query for each API call. Currently these requests will return the data in whatever order it was found, it would be nice if we ordered it.

This is an easy task for the /*/options/* queries because there is only 1 column of data. However, for the queries that return all columns, we will need to choose a column to order the data on by default. This could also be another querystring parameter to allow API consumers to determine what to order the data on.

natebrennand commented 10 years ago

this probably will involve restructuring the config dictionary to add a default column to order by.