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)