–1 vote
Hi,

Will the daily cards be ready 3 days before race day?

Thanks
in Horseracing by jgrn88 Plater (110 points)

1 Answer

0 votes
Hi - thanks for the question; we should have these loaded on Friday evening, but we will update again tomorrow.
by colin Frankel (19.7k points)
Great, thanks for the update.
The cards have arrived so should be fetchable from 7:30 pm tonight
Thank you. When using the automated scripts to update the database, how would I know if the updates have been successful from the command terminal? I'm updating on my Mac and all I get is 'loading updates from 'http:...'
I always run a query at command line if wanting to check the data is loaded, eg:
>smartform (alias to starting mysql with username/ password)
>select scheduled_time, course from daily_races where meeting_date >= CURDATE();

This returns:
+---------------------+-----------+
| scheduled_time      | course    |
+---------------------+-----------+
| 2020-06-01 13:00:00 | Newcastle |
| 2020-06-01 13:35:00 | Newcastle |
| 2020-06-01 14:10:00 | Newcastle |
| 2020-06-01 14:45:00 | Newcastle |
| 2020-06-01 15:20:00 | Newcastle |
| 2020-06-01 15:55:00 | Newcastle |
| 2020-06-01 16:30:00 | Newcastle |
| 2020-06-01 17:05:00 | Newcastle |
| 2020-06-01 17:40:00 | Newcastle |
| 2020-06-01 18:15:00 | Newcastle |
+---------------------+-----------+
10 rows in set (0.11 sec)
Great, thank you. Do the Betfair daily mappings not update until the morning of the Raceday?
Yes, always morning of raceday - usually by 9 am.
...