#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