def __update_given_submissions(self, submissions):
for submission in submissions:
submission_id = base36decode(submission.id)
if not self.db_manager.row_exists(submission_id):
s = Submission.from_reddit_api(submission)
self.db_manager.insert_submission(s)
else:
# if submission does exist, update its score
new_submission = Submission.from_reddit_api(submission)
# existing_submission =
query = 'SELECT * FROM submissions WHERE id = %d;' % submission_id
existing_submissions = [Submission(x) for x in self.db_manager.query(query)]
assert(len(existing_submissions) == 1)
existing_submission = existing_submissions[0]
#print "existing score: ", existing_submission.score
#print "new score: ", new_submission.score
if existing_submission.score != new_submission.score:
#print "going to replace old submission!"
#print "NEW_SUBMISSION: ", new_submission.to_tuple()
#print "BEFORE: ", existing_submission.to_tuple()
existing_submission.score = new_submission.score
#print "AFTER: ", existing_submission.to_tuple()
#time.sleep(5)
self.db_manager.replace_submission(existing_submission)
# Debug printing:
if self.db_manager.new_rows_written % 100 == 0 and self.db_manager.new_rows_written != 0:
print "Entries written so far: ", self.db_manager.new_rows_written, " [", self.db_manager.rows_written, " total]"
def __update_given_submission(self, submission):
submission_id = base36decode(submission.id)
if not self.db_manager.row_exists(submission_id):
s = Submission.from_reddit_api(submission)
self.db_manager.insert_submission(s)
else:
new_submission = Submission.from_reddit_api(submission)
query = 'SELECT * FROM submissions WHERE id = %d;' % submission_id
existing_submissions = [Submission(x) for x in self.db_manager.query(query)]
assert(len(existing_submissions) == 1)
existing_submission = existing_submissions[0]
if existing_submission.score != new_submission.score:
existing_submission.score = new_submission.score
self.db_manager.replace_submission(existing_submission)
def __update_given_submissions(self, submissions):
for submission in submissions:
if not self.image_manager.row_exists(submission.id):
s = Submission.from_reddit_api(submission)
self.image_manager.insert_submission(s)
else:
# if submission does exist, update its score
new_submission = Submission.from_reddit_api(submission)
# existing_submission =
query = 'SELECT * FROM submissions WHERE id = "%s";' % submission.id
existing_submissions = [Submission(x) for x in m.query(query)]
assert (len(existing_submissions) == 1)
existing_submission = existing_submissions[0]
if existing_submission.score != new_submission.score:
#print "NEW_SUBMISSION: ", new_submission.to_tuple()
#print "BEFORE: ", existing_submission.to_tuple()
existing_submission.score = new_submission.score
#print "AFTER: ", existing_submission.to_tuple()
#time.sleep(5)
m.replace_submission(existing_submission)
