Duplicate keys

[John Currey]

Hi, 

I noticed that in 2004, I have 3 games on the same day for several teams vs. their opponent. In investigating, I see that double header=2 has 2 records in the database for the same date, t:team and o:team. I'm wondering how the database would allow a duplicate key. I suspect a space or other invisible character is in there somewhere. This shows that the string fields match in length.

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cdouble+header%2Clen%28team%29%2Clen%28o%3Ateam%29%40team%3D%27Red+Sox%27+and+date%3D20040429&submit=++S+D+Q+L+%21++

https://s3.sportsdatabase.com/MLB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Cdouble+header%40team%3D%27Red+Sox%27+and+date%3D20040429&submit=++S+D+Q+L+%21++

Thanks.

[Joe Meyer]

John and SDQL API Friends,

I see that there is a data file saved for date=20040429 team=Red Sox double header=0.

My best guess is that you first saved this game with DH=0 and then updated to DH=2.

The problem is that the file is still here (along with the ones for DH=1 and DH=2).

To fix issue, just use the API to remove the game for: date=20040429 team=Red Sox double header=0

Best regards,

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/5ca6e83a-4c25-4417-ada1-8779bfb45774n%40googlegroups.com.

[John Currey]

Joe, 

So I'm confused by the terminology. I'm unsure what you mean by "data file". I think you're referring to a record in the database, but want to be sure. 

I don't see anything where date=20040429, team=Red Sox, double header=0. I see this, which has two games with the same date, t:team, o:team and both show double header=2. To me, that's a duplicate record. What am I missing?

[Joe Meyer]

John and SDQL API Friends,

when you upload a game to the server, it is saved in a datafile named by that game's key.

For MLB the key is: date, home team, double header.

For GimmeTheDog is see these three datafiles: 

20040429_Red Sox_0

20040429_Red Sox_1

20040429_Red Sox_2

To fix this issue, use the API to remove the game for: date=20040429 team=Red Sox double header=0 

Best regards,

Joe  Meyer
Sports Database LLC

 

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/bea7a7c8-8bca-4fa8-9891-56d71ac2ccbbn%40googlegroups.com.

[John Currey]

OK, I don't fully understand it. I am confused as to why the UI showed 2 games with double header=2. Nonetheless, I followed your instructions and it's fixed. Thanks, Joe!

[John Currey]

Here's another example of a duplicate key. There are 2 games with identical date,t:team, and o:team values. I'm not sure what I'm doing to cause this. In my brain, the database should not write a new record when a matching key exists. 

I can remove one of the games. If the answer is to simply remove the unwanted game, I accept that. I'm reporting it in case this is a real issue. 

https://s3.sportsdatabase.com/NCAAFB/query.html?sdql=date%2Cteam%2Co%3Ateam%2Clen%28team%29%2Clen%28o%3Ateam%29%40date%3D20210904+and+team%3D%27USC%27+&submit=++S+D+Q+L+%21++

Thanks. 

[Joe Meyer]

John,

I see you have two data files for that game:

20210904_SJST

20210904_USC

I think this SDQL will help you figure out the problem and solution:

team,o:team,site@date=20210904 and team='USC'

Best regard,

Joe Meyer

Sports Database LLC

To view this discussion on the web visit https://groups.google.com/d/msgid/sdqlapi/8394f5a6-4883-490f-b954-6bd5b5554144n%40googlegroups.com.