dates

[John Currey]

Hi,

I think I made a mistake storing dates as integers.  Doing so is causing date math to fail.

Notice in the image, 20211213-20121205 works, but when the math has to cross over to a different month (20211213-20121121), it's not working the way I would like it to work. 

Can dates be stored in a date format to accommodate date math?

Here's the query:

https://s3.sportsdatabase.com/NFL/query.html?sdql=date%2Cp%3Adate%2Cp2%3Adate%2Cdate-p%3Adate%2Cdate-p2%3Adate%2Ctype%28date%29%2Cteam%2Co%3Ateam%40date%3Dtoday&submit=++S+D+Q+L+%21++

Thanks.

[Joe Meyer]

John and SDQL API Friends,

That looks like a bug: thanks for the good report and link.

The intent is indeed for you to upload `date` as an integer and for the backend code to then convert this to the proper date object.

I've got my best Python programmer working on this and expect a solution soon.

C'est moi,

Joe Meyer

Sports Database LLC

--

---
You received this message because you are subscribed to the Google Groups "SDQL API" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdqlapi+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/d1c29bcf-f627-4dd3-903a-7a0bd713af6an%40googlegroups.com.

[Joe Meyer]

John and SDQL API Friends,

I believe that date is now being cast correctly as per the SDQL:

date,team,date-p:date-1 as 'rest',date-30@date-today=0 

https://sportsdatabase.com/NBA/query.html?sdql=date%2Cteam%2Cdate-p%3Adate-1+as+%27rest%27%2Cdate-30%40date-today%3D0&submit=++S+D+Q+L+%21++

best regards,

Joe Meyer

Sports Database LLC.

[John Currey]

Thank Joe, I'm glad you found the right man for the job! 😉

[John Currey]

So the plot thickens a little. I discovered I could not query my NHL games by date. Upon investigation, there seems to be a problem with importing dates as integers for the NHL. Here's an example:

Here's the URL:

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Ctype%28date%29%2Co%3Ateam%40team%3DCanucks+and+o%3Ateam%3DHurricanes+and+season%3D2021&submit=++S+D+Q+L+%21++

Here's how my dictionary looks:

Thanks.

[Joe Meyer]

John and SDQL API Friends,

I do not see an error here.

I see that you upload the date as an integer, and that the backend converts this to a customized 'Date8' object.

If you still see an error, please send a link to that error.

Best regards,

Joe Meyer

Sports Database LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/cd169105-7733-439e-98f3-24d9339f7ffcn%40googlegroups.com.

[John Currey]

My mistake. I noticed that type(date) for the NFL, NCAAFB, and NBA used to show <class 'int>, and the NHL showed 
<class 'PyQL.py_tools.Date8'> and that caused me to believe that was the issue. The real problem was I spelled Kraken wrong. Sorry for the false alarm.

I see all sports now have Date8. 

Thanks. 

[John Currey]

Hi,

I'm still struggling with this in the NHL. This shows the data that the Devils recent games:

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Co%3Ateam%2Ctype%28date%29%2Cgoals%2Co%3Agoals%40team%3D%27Devils%27+and+season%3D2021+and+date%3E20211205&submit=++S+D+Q+L+%21++

Using this data statement, the API returns no results (i.e. {'headers': [], 'groups': []}):

d={"sdql": "date,team,o:team@team=Capitals and date=20211214"}

If I change the date to 20211211 or before, it works fine. For any date after 20211214, no results are returned via the API. The same happens for other teams. 

[Joe Meyer]

John and SDQL API Friends,

I do not see an error there. 

This SDQL works as expected:

date,team,o:team@team=Capitals and date=20211217

https://s3.sportsdatabase.com/NHL/query.html?sdql=date%2Cteam%2Co%3Ateam%40team%3DCapitals+and+date%3D20211217&submit=++S+D+Q+L+%21++

best regards,

Joe Meyer

Sports  Database LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/6e412cf1-d212-42a9-bfdb-cb2ec80da605n%40googlegroups.com.

[John Currey]

I believe my issue was that I was seeing other people's data in the UI thinking it was mine. My code was not finding it, and I was tricked. 

Thanks.