3bf5f2de89807642dcd1e030e45226ff3944779b,common.py,,get_filename,#Any#Any#,20

Before Change

def get_filename(db, submission_id):
    submission = db.submissions.find_one({"_id": ObjectId(submission_id)})
    fname = submission.get("filename", None)
    user = submission.get("username", None)
    if fname and user:
        return "{}/{}".format(user, fname), fname

After Change

def get_filename(postgres_db, submission_id):
    query = "SELECT filename, user_id FROM submissions WHERE id = "{}"".format(submission_id)
    cursor = postgres_db.cursor()
    cursor.execute(query)
    results = cursor.fetchone()
    filename = results[0]
    user_id = results[1]
    query = "SELECT username FROM users WHERE id = "{}"".format(user_id)
    cursor.execute(query)
    username = cursor.fetchone()[0]
    cursor.close()
    return "{}/{}".format(username, filename), filename


def download_submission(postgres_db, submission_id):

Instances