#gradelog = codecs.open("apprej.log", encoding='utf-8', mode='w+', errors='replace')
appr = 0
rej = 0
for row in rows:
assign_id = row[0]
hit_id = row[2]
worker_id = row[3]
sql = "SELECT worker_id from esl_workers WHERE id=%s;"
cur.execute(sql, (worker_id, ))
worker = cur.fetchone()[0]
# logging.info("Grading assignment %s in hit %s by worker %s" % (assign_id, hit_id, worker))
result = qc.grade_controls(hit_id, assign_id, worker) #, log=gradelog)
if(result == 0):
rej += 1
else:
appr += 1
cur.execute(sql, (assign_id, ))
conn.commit()
#gradelog.close()
#sql = "SELECT * from esl_appr_buffer WHERE status='APPROVE'"
#cur.execute(sql)
#appr = cur.rowcount
#sql = "SELECT * from esl_appr_buffer WHERE status='REJECT'"
#cur.execute(sql)
#rej = cur.rowcount
cur2.execute(sql2,(assignment_id, edit_num, esl_snt, span_start, span_end, old_word, new_word, edit_type, annotation))
#result_id = cur2.fetchone()[0]
conn.commit()
cp5=datetime.datetime.now()
ip=results.get("ip","")
city=results.get("city","")
region=results.get("region","")
country=results.get("country","")
zipcode=results.get("zipcode","")
lat=results.get("lat","")
lng=results.get("lng","")
timestamp=submit_time
qc.grade_controls(hit_id, assignment_id, mturk_worker_id)
qc.appall(assignment_id, mturk_worker_id)
##--- TODO ADD BACK IN BEFORE UPLOADING TO NON-SANDBOX SITE --
#sql2="SELECT add_esl_location(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s);"
#cur2.execute(sql2,(assignment_id, db_worker_id, ip, city, region, country, zipcode, lat, lng, timestamp))
#sql="SELECT add_foreignenglishspeakingsurvey(%s, %s, %s, %s, %s);"
#cur.execute(sql,(db_worker_id, timestamp, native_speaker, years_speaking_foreign, native_english_speaker, years_speaking_english, country, born_country, language, language_id))
conn.commit()
cp6=datetime.datetime.now()
#disabled performance stats
