Data query API - Githubissues

Frozenfire92 / Sobeys-IBM-Hackathon

1 stars 0 forks source link

Data query API #3

Closed Glavin001 closed 8 years ago

Glavin001 commented 8 years ago

Blocked by #2.

Models:

[x] DayStat
[x] Store
[x] Item
[x] Sale

API for Queries of DayStat:

[ ] by store
[ ] by product
[ ] by store & product
[ ] by day
[ ] by week
[ ] by month
[ ] by custom

Glavin001 commented 8 years ago

Done the API for all of the models.

Now to implement the custom queries on the DayStat model.

Glavin001 commented 8 years ago

So we have a problem: the CALENDAR_DT field is in the format DAMONYEAR such as 01AUG2015, which is not the format for a date type field in MySQL.

Glavin001 commented 8 years ago

Get records with max value for each group of grouped SQL results: http://stackoverflow.com/a/12102288/2578205

Glavin001 commented 8 years ago

We are using fixture data that is pre-computed by @rainbee2214 , see #12. Thus this issue can be closed as we do not need any more custom API queries for DayStats.