3bf5f2de89807642dcd1e030e45226ff3944779b,database_manager.py,DatabaseManager,get_everyone_elses_recent_submssions,#DatabaseManager#Any#Any#Any#,342

Before Change

        submissions = []

        for submission in self.db.submissions.aggregate(pipeline):
            if submission["username"] == username:
                continue
            submissions.append(submission)
        return submissions

    def get_filename(self, submission_id):
        Get the filename that is used by S3 based on submission_id

After Change

        
        if end_time is None:
            end_time = datetime.datetime.utcnow()
        cursor = self.postgres_db.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
        query = "SELECT id FROM submissions WHERE round_id = "{}" AND user_id != "{}" AND inserted_at < "{}" ORDER BY inserted_at DESC".format(round_id, user_id, end_time)
        cursor.execute(query)
        results = cursor.fetchall()
        cursor.close()

Instances