Closed mkalam-alami closed 5 years ago
mkalam-alami
commented
6 years ago In the end, the ludumdare.com importer doesn't support automatically setting the publication date, because I didn't find a reliable way to get it from the site.
The best way would probably to store locally a JSON DB of the dates for all events, not worth it
Aurel300
commented
6 years ago Are the dates listed here too vague?
mkalam-alami
commented
6 years ago @Aurel300 Yes since I chose to store the publication date as an actual date rather than free-form text.
Aurel300
commented
6 years ago Well, there won't be and LD jams held on ludumdare.com as far as I can tell, so why not just collect the exact dates for the events?
mkalam-alami
commented
6 years ago I was too lazy :-x It didn't feel worth the trouble, but if you or anyone can get the data in a usable format I'll be happy to implement the feature.
mkalam-alami
commented
6 years ago Reopening this.
update entry set published_at = XXX where external_event = 'yyy' x100)mkalam-alami
commented
5 years ago Beware the monster migration query
update entry set published_at = '2010-08-23' where published_at is null and external_event = 'Ludum Dare 18';
update entry set published_at = '2010-12-20' where published_at is null and external_event = 'Ludum Dare 19';
update entry set published_at = '2011-05-02' where published_at is null and external_event = 'Ludum Dare 20';
update entry set published_at = '2011-08-22' where published_at is null and external_event = 'Ludum Dare 21';
update entry set published_at = '2011-12-19' where published_at is null and external_event = 'Ludum Dare 22';
update entry set published_at = '2012-04-23' where published_at is null and external_event = 'Ludum Dare 23';
update entry set published_at = '2012-08-27' where published_at is null and external_event = 'Ludum Dare 24';
update entry set published_at = '2012-12-17' where published_at is null and external_event = 'Ludum Dare 25';
update entry set published_at = '2013-04-29' where published_at is null and external_event = 'Ludum Dare 26';
update entry set published_at = '2013-08-26' where published_at is null and external_event = 'Ludum Dare 27';
update entry set published_at = '2013-12-16' where published_at is null and external_event = 'Ludum Dare 28';
update entry set published_at = '2014-04-28' where published_at is null and external_event = 'Ludum Dare 29';
update entry set published_at = '2014-08-25' where published_at is null and external_event = 'Ludum Dare 30';
update entry set published_at = '2014-12-08' where published_at is null and external_event = 'Ludum Dare 31';
update entry set published_at = '2015-04-20' where published_at is null and external_event = 'Ludum Dare 32';
update entry set published_at = '2015-08-24' where published_at is null and external_event = 'Ludum Dare 33';
update entry set published_at = '2015-12-14' where published_at is null and external_event = 'Ludum Dare 34';
update entry set published_at = '2016-04-18' where published_at is null and external_event = 'Ludum Dare 35';
update entry set published_at = '2016-08-29' where published_at is null and external_event = 'Ludum Dare 36';
update entry set published_at = '2013-02-29' where published_at is null and external_event = 'MiniLD 40';
update entry set published_at = '2013-03-31' where published_at is null and external_event = 'MiniLD 41';
update entry set published_at = '2013-05-31' where published_at is null and external_event = 'MiniLD 42';
update entry set published_at = '2013-06-30' where published_at is null and external_event = 'MiniLD 43';
update entry set published_at = '2013-07-31' where published_at is null and external_event = 'MiniLD 44';
update entry set published_at = '2013-09-30' where published_at is null and external_event = 'MiniLD 45';
update entry set published_at = '2013-11-30' where published_at is null and external_event = 'MiniLD 46';
update entry set published_at = '2013-12-01' where published_at is null and external_event = 'MiniLD 47';
update entry set published_at = '2014-01-31' where published_at is null and external_event = 'MiniLD 48';
update entry set published_at = '2014-02-28' where published_at is null and external_event = 'MiniLD 49';
update entry set published_at = '2014-03-31' where published_at is null and external_event = 'MiniLD 50';
update entry set published_at = '2014-05-31' where published_at is null and external_event = 'MiniLD 51';
update entry set published_at = '2014-06-30' where published_at is null and external_event = 'MiniLD 52';
update entry set published_at = '2014-07-31' where published_at is null and external_event = 'MiniLD 53';
update entry set published_at = '2014-09-30' where published_at is null and external_event = 'MiniLD 54';
update entry set published_at = '2014-11-30' where published_at is null and external_event = 'MiniLD 55';
update entry set published_at = '2015-01-31' where published_at is null and external_event = 'MiniLD 56';
update entry set published_at = '2015-02-28' where published_at is null and external_event = 'MiniLD 57';
update entry set published_at = '2015-03-31' where published_at is null and external_event = 'MiniLD 58';
update entry set published_at = '2015-05-31' where published_at is null and external_event = 'MiniLD 59';
update entry set published_at = '2015-06-30' where published_at is null and external_event = 'MiniLD 60';
update entry set published_at = '2015-07-31' where published_at is null and external_event = 'MiniLD 61';
update entry set published_at = '2015-09-30' where published_at is null and external_event = 'MiniLD 62';
update entry set published_at = '2015-11-30' where published_at is null and external_event = 'MiniLD 63';
update entry set published_at = '2016-01-31' where published_at is null and external_event = 'MiniLD 64';
update entry set published_at = '2016-02-29' where published_at is null and external_event = 'MiniLD 65';
update entry set published_at = '2016-03-31' where published_at is null and external_event = 'MiniLD 66';
update entry set published_at = '2016-05-31' where published_at is null and external_event = 'MiniLD 67';
update entry set published_at = '2016-06-30' where published_at is null and external_event = 'MiniLD 68';
update entry set published_at = '2016-07-31' where published_at is null and external_event = 'MiniLD 69';
update entry set published_at = '2016-09-30' where published_at is null and external_event = 'MiniLD 70';
update entry set published_at = '2017-01-31' where published_at is null and external_event = 'MiniLD 71';
update entry set published_at = '2017-02-28' where published_at is null and external_event = 'MiniLD 72';
update entry set published_at = '2017-03-31' where published_at is null and external_event = 'MiniLD 73';
update entry set published_at = '2017-07-31'' where published_at is null and external_event = 'MiniLD 74';Could be made more perfect:
Thrainsa
commented
5 years ago I add some MiniLD dates and I upgrade the prod database
update entry set published_at = '2013-02-25' where published_at is null and external_event = 'MiniLD 40';
update entry set published_at = '2012-09-24' where published_at is null and external_event = 'MiniLD 37';
update entry set published_at = '2012-05-20' where published_at is null and external_event = 'MiniLD 34';
update entry set published_at = '2012-02-27' where published_at is null and external_event = 'MiniLD 32';
update entry set published_at = '2012-01-22' where published_at is null and external_event = 'MiniLD 31';
update entry set published_at = '2011-11-06' where published_at is null and external_event = 'MiniLD 30';
update entry set published_at = '2011-10-25' where published_at is null and external_event = 'MiniLD 29';
update entry set published_at = '2011-03-14' where published_at is null and external_event = 'MiniLD 25';
update entry set published_at = '2011-01-23' where published_at is null and external_event = 'MiniLD 23';
update entry set published_at = '2010-11-28' where published_at is null and external_event = 'MiniLD 22';
Also let people customize it on external entries. Also update the ld.com importer for setting it correctly.