def main(): print "Content-type: text/html\n\n" cgitb.enable() # process input form = cgi.FieldStorage() xml_feedback = form.getfirst('xmlFeedback', 'None') token_number = form.getfirst('token', 'None') # open database session = get_local_db_session() try: token = session.query(Token).filter_by(number=token_number).one() except NoResultFound: print "KO" return # insert the retrived dialogueID into the xmlFeedback xml_feedback = xml_feedback.replace( "<dialogueId></dialogueId>", "<dialogueId>" + token.submission.dialogue_id + "</dialogueId>") worker_id = get_worker_id(xml_feedback) phone = token.submission.dialogue_id.rsplit("-", 1)[1] try: curr_worker = session.query(Worker).filter_by( worker_id=worker_id).one() except NoResultFound: curr_worker = Worker(worker_id=worker_id, phone_number=phone) session.add(curr_worker) # save submitted data submission = token.submission submission.data = xml_feedback submission.worker = curr_worker submission.timestamp = datetime.datetime.now() # free token token.submission = None session.commit()
def main(): print "Content-type: text/html\n\n" cgitb.enable() # process input form = cgi.FieldStorage() xml_feedback = form.getfirst('xmlFeedback', 'None') token_number = form.getfirst('token', 'None') # open database session = get_local_db_session() try: token = session.query(Token).filter_by(number=token_number).one() except NoResultFound: print "KO" return # insert the retrived dialogueID into the xmlFeedback xml_feedback = xml_feedback.replace("<dialogueId></dialogueId>", "<dialogueId>" + token.submission.dialogue_id + "</dialogueId>") worker_id = get_worker_id(xml_feedback) phone = token.submission.dialogue_id.rsplit("-", 1)[1] try: curr_worker = session.query(Worker).filter_by(worker_id=worker_id).one() except NoResultFound: curr_worker = Worker(worker_id=worker_id, phone_number=phone) session.add(curr_worker) # save submitted data submission = token.submission submission.data = xml_feedback submission.worker = curr_worker submission.timestamp = datetime.datetime.now() # free token token.submission = None session.commit()
import cgi import cgitb import sys import os sys.path.insert(0, '') from local_cfg import cfg token_file = cfg['token_file'] from model import Token from dbutils import get_local_db_session if __name__ == "__main__": print "Content-type: text/html\n\n" form = cgi.FieldStorage() data = str(form.getfirst('data', 'None')) session = get_local_db_session() cgitb.enable() token, submission = Token.get_new(session) if token is None: Token.generate_tokens(session) token, submission = Token.get_new(session) submission.dialogue_id = data session.commit() print token.number