zenhack / iron-blogger2

GNU General Public License v3.0
3 stars 3 forks source link

Rounds being assigned to posts out-of-order #19

Closed zenhack closed 9 years ago

zenhack commented 9 years ago

At the time of writing, a chunk of the test instance's database looks as follows:

ironblogger=# select post.title, post.timestamp, post.counts_for from post, blog, blogger where blog.blogger_id = blogger.id and post.blog_id = blog.id and blogger.name = 'mindstalk' order by counts_for;
                      title                       |      timestamp      |     counts_for      
--------------------------------------------------+---------------------+---------------------
 Why are books sold for fixed prices?             | 2015-02-06 02:32:48 | 2015-01-05 00:00:00
 Anime I am watching                              | 2015-02-07 08:50:58 | 2015-01-12 00:00:00
 US stagnation                                    | 2015-02-11 03:23:28 | 2015-01-19 00:00:00
 some fanfic (Suzumiya, Lucifer, Madoka, Firefly) | 2015-02-24 06:05:42 | 2015-01-26 00:00:00
 Trader Joe's salt, and bacon jerky               | 2015-01-31 03:31:11 | 2015-02-02 00:00:00
 Geography fun                                    | 2015-03-08 19:17:04 | 2015-02-09 00:00:00
 random stuff                                     | 2015-03-15 04:51:52 | 2015-02-16 00:00:00
 St. Patrick's food articles                      | 2015-03-18 04:55:13 | 2015-02-23 00:00:00
 how many western TV shows have I seen?           | 2015-03-19 20:18:12 | 2015-03-02 00:00:00
 American social psychosis                        | 2015-03-20 17:36:08 | 2015-03-09 00:00:00
 Some thoughts on #BoycottIndiana                 | 2015-03-29 17:42:45 | 2015-03-16 00:00:00
 Phoenician circumnavigation of Africa            | 2015-04-16 06:49:47 | 2015-03-23 00:00:00
 Hillary the liberal                              | 2015-04-19 21:00:59 | 2015-03-30 00:00:00
 Urban streets and other links                    | 2015-04-19 21:25:50 | 2015-04-06 00:00:00
 Politicians keep their promises                  | 2015-04-23 22:28:37 | 2015-04-13 00:00:00
 funny images                                     | 2015-05-07 07:02:15 | 2015-04-20 00:00:00
 oh god the heat                                  | 2015-05-10 23:23:18 | 2015-04-27 00:00:00
 Tsarnaev death sentence                          | 2015-05-18 15:55:06 | 2015-05-04 00:00:00
 hippos                                           | 2015-05-26 14:55:58 | 2015-05-11 00:00:00
 Vox Future of Commuting series                   | 2015-05-27 05:41:13 | 2015-05-18 00:00:00
 Charter school scams                             | 2015-05-27 06:42:09 | 2015-05-25 00:00:00
 Alert alert                                      | 2015-05-31 23:17:06 | 2015-06-01 00:00:00
 The fall of American democracy?                  | 2015-03-04 11:04:40 | 
 some women in Roman history                      | 2015-02-24 05:55:06 | 
 Costs of sprawl                                  | 2015-03-06 18:29:13 | 
(25 rows)

Some of these are incorrectly assigned. For example, "hippos" is recorded as counting for the week ending 5/11, but there's an on-time post for that round which should take precedence ("oh god the heat").

I'm looking at ironblogger.tasks.assign_rounds, and it isn't actually sorting the posts before assigning things to them --- this would indeed cause the problem.