def syncAssignment(gradesourceId, taId):
conn = MySQLdb.connect(host = "localhost", user = "******", passwd = "root", db = "ta")
cursor = conn.cursor()
sql = """SELECT sc.*, st.gs_name
FROM scores sc
LEFT JOIN students st ON st.id = sc.student_id
WHERE assignment_id = '%s'
AND st.dropped = 0
""" % taId
cursor.execute(sql)
scores = {}
while True:
row = fetchOneAssoc(cursor)
if row == None:
break
print colored(row['score'], 'green'), row['gs_name']
scores[row['gs_name']] = row['score']
g = Gradesource('qpleple', getpass())
g.importScores(scores, gradesourceId, gradesourceName = True)
cursor.close()
conn.commit()
conn.close()
