Python get_local_db_session Examples

Example #1

File: submit_new.py Project: henrypig/alex-1

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()

Example #2

File: submit_new.py Project: AoJ/alex

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()

Example #3

File: new_token.py Project: henrypig/alex-1

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