seeding vote count for questions

edit

Can't a user only vote up a question once?

Yes, you're right! I'll see what else I can suggest.

Brilliant. I think that will work. I'll give it a shot. Thanks!

Couple of issues: 1) When I run post.points = n, post.save(), the question list doesn't show the votes. However if I click into the Question, the votes are displayed and then the next time I go to the question list, I see the votes listed. Even setting the post.vote_up_count = n as well doesn't display the vote count in the question list. 2) Once I have clicked into the question and navigate back to the question list, the sorting by vote count doesn't seem to work.

I can probably figure this all out, but can you explain the relationship between Vote, and Post.points/vote_up_count/vote_down_count?

It's because of the cache. Just delete all cache after the import:

python manage.py shell
from django.core.cache import cache
cache.clear()

There is cache for the question summary snippet for the front page.

Points is 10*(vote_up_count - vote_down_count), sorry I should have explained before.

Thanks for the clarification. However, clearing the cache doesn't seem to have any effect on the previous behavior. Here's the complete example of what I'm doing to try and seed a vote count of 10 on a particular Post:

post.vote_up_count = 10
post.points = 100
post.save()
Vote(user=PHANTOM_VOTER_USER, voted_post=post, vote=100).save()
cache.clear()

I was going to look into the query that is generated for the question summary front page to investigate further, but I'm not sure where it's being generated.

Okay so it looks like I also need to set the Thread.points value as well to get this to work completely. Also, I don't see the points value computed the way you describe above. If I up-vote a post, the database shows the point value as +1 as well.

Oh, sorry missed that. Btw the vote value of Vote should be either Vote.VOTE_UP or Vote.VOTE_DOWN (which are +1 and -1). You will need the Vote records if you ever decide to recalculate the votes for some reason.

No worries. As for the Vote.VOTE_UP and Vote.VOTE_DOWN, this won't work for seeding a Vote count of more than one when we do the import since we're still limited by a unique constraint on (user_id, voted_post_id). For us it's not a huge issue. In the importer, I'll make a note about this if Votes need to be recalculated.

I don't see any management command for recalculating votes currently, is there one? Not sure what exactly would go wrong though, would it just count that as a single vote up or down? Or would it barf?