Minor issue with spaces and math in NBA

26 views
Skip to first unread message

John Currey

unread,
Jan 8, 2022, 9:59:21 AMJan 8
to SDQL API
In the NFL, this works fine.
  • date,line,total,total-line @team=Jets and date>20211114
Notice the space between "total-line" and "@".

In the NBA, this works fine:
  • date,line,total,total-line@team=Jets and date>20211114
However, adding a space before the "@" causes the math to fail and return "None".
  • date,line,total,total-line @team=Nets and date=20211105
Here's the link that shows the failure:


Thanks. 

John Currey

unread,
Jan 8, 2022, 10:28:47 AMJan 8
to SDQL API

Joe Meyer

unread,
Jan 8, 2022, 11:23:17 AMJan 8
to sdq...@googlegroups.com
John,

I see that another user has a parameter called 'line ' (with an inadvertent space at the end).

I consider it a bug in the code to allow parameters with leading or trailing whitespace - I will get my best Python programmer right on that!

If you are only making use of the data that you upload, you can either explicitly use:
jcurrey.total - jcurrey.line @ jcurrey.team=Nets and jcurrey.date=20211105

or, use the settings API to set follow to  ['jcurrey']

Thanks for finding, and clearly reporting, strange looking errors!

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/3b6e4ce5-e3ed-490c-9247-9a9581efef08n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages