Error Query Today.

39 views
Skip to first unread message

Secret Smokestack LLC

unread,
Feb 6, 2024, 4:09:49 PMFeb 6
to SportsDataBase
Greetings all. I just signed up and am interested in this database. 
I hit the URL 

with the following query. 
team=RedSox and p:M6=0 and p:L

and this was the result 
Traceback (most recent call last): File "/usr/lib/python3/dist-packages/S3/sdb_lol.py", line 823, in query result = self.pyql(pyql=sdql,**kwargs) File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 745, in pyql self._q = self.build_mc(pyql) File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 788, in build_mc return self.build_mc("%s@%s" % (df,pyql)) File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 796, in build_mc conditions = self.init_conditions(self.qob.conditions) File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 707, in init_conditions for cond in itertools.product(*cout)] File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 707, in for cond in itertools.product(*cout)] File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 215, in __init__ self.add_metacode() File "/usr/lib/python3/dist-packages/PyQL/lol.py", line 295, in add_metacode self.cmc = compile(self.mc, 'metacode', 'eval') File "metacode", line 1 ((r"""team=RedSox""", """team=RedSox""","""team=RedSox"""),(r""" and """, """ and """,""" and """),(r"""p:M6=0""", """p:M6=0""","""p:M6=0"""),(r""" and """, """ and """,""" and """),(r"""p:L""", """(p:Games:runs sup...@SportsDatabase.com          eyeball communications llc


Joe Meyer

unread,
Feb 6, 2024, 4:48:38 PMFeb 6
to sportsd...@googlegroups.com
SDQL Friends,

there is not a parameter called 'M6' at sportsdatabase.com.

Sportsdatabase.com is a barebones site for API users.

This SDQL is equivalent to your query:
team='Red Sox' and p:L and sum(p:inning runs[:6]) = sum(po:inning runs[:6])


Best regards,

Joe Meyer
SDQL.com
SportsDatabase.com
Eyeball Communications LLC
 




--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/b95dbf17-4cab-497a-9c2f-60d5c90f7542n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages