Python rollbackの例

コード例 #1

ファイル: model.py プロジェクト: jflores31/openwebapps

def identity_by_identifier(identifier):
    try:
        return session.query(Identity).filter(Identity.identifier == identifier).first()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select identity for identifier")

コード例 #2

def purchase(id):
  try:
    return session.query(Purchase).filter(Purchase.id == id).one()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select purchase")

コード例 #3

ファイル: model.py プロジェクト: jflores31/openwebapps

def purchase_for_user_app(userid, appid):
    try:
        return session.query(Purchase).filter(Purchase.user_id == userid).filter(Purchase.app_id == appid).first()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select purchases for user")

コード例 #4

def purchase_for_user_app(userid, appid):
  try:
    return session.query(Purchase).filter(Purchase.user_id == userid).filter(Purchase.app_id == appid).first()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select purchases for user")

コード例 #5

ファイル: model.py プロジェクト: jflores31/openwebapps

def application(id):
    try:
        return session.query(Application).filter(Application.id == int(id)).one()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select application")

コード例 #6

ファイル: model.py プロジェクト: jflores31/openwebapps

def applications():
    try:
        return session.query(Application).all()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select applications")

コード例 #7

def createApplication(manifestText, manifestSrc, manifestObj = None):
  try:
    if not manifestObj:
      manifestObj = json.loads(manifestSrc)
      
    name = manifestObj['name']
    baseURL = manifestObj['base_url']
    icon96 = None
    if 'icons' in manifestObj:
      if '96' in manifestObj['icons']:
        icon96 = manifestObj['icons']['96']
      else:
        key = manifestObj['icons'].keys()[0]
        icon96 = manifestObj['icons'][key]

    description = manifestObj['description']

    a = Application(name, manifestSrc, manifestText, baseURL, datetime.now(), icon96, description)
    session.add(a)
    session.commit()
    return a

  except sqlalchemy.exc.IntegrityError:
    session.rollback()
    raise ValueError("An application is already registered for that launch URL.")
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to create application")

コード例 #8

def applications():
  try:
    return session.query(Application).all()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select applications")

コード例 #9

def application(id):
  try:
    return session.query(Application).filter(Application.id == int(id)).one()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select application")

コード例 #10

def identity_by_identifier(identifier):
  try:
    return session.query(Identity).filter(Identity.identifier == identifier).first()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select identity for identifier")

コード例 #11

ファイル: model.py プロジェクト: jflores31/openwebapps

def createApplication(manifestText, manifestSrc, manifestObj=None):
    try:
        if not manifestObj:
            manifestObj = json.loads(manifestSrc)

        name = manifestObj["name"]
        baseURL = manifestObj["base_url"]
        icon96 = None
        if "icons" in manifestObj:
            if "96" in manifestObj["icons"]:
                icon96 = manifestObj["icons"]["96"]
            else:
                key = manifestObj["icons"].keys()[0]
                icon96 = manifestObj["icons"][key]

        description = manifestObj["description"]

        a = Application(name, manifestSrc, manifestText, baseURL, datetime.now(), icon96, description)
        session.add(a)
        session.commit()
        return a

    except sqlalchemy.exc.IntegrityError:
        session.rollback()
        raise ValueError("An application is already registered for that launch URL.")
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to create application")

コード例 #12

def user(id):
  try:
    return session.query(User).filter(User.id == id).first()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select user")

コード例 #13

ファイル: model.py プロジェクト: jflores31/openwebapps

def user(id):
    try:
        return session.query(User).filter(User.id == id).first()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select user")

コード例 #14

ファイル: model.py プロジェクト: jflores31/openwebapps

def purchase(id):
    try:
        return session.query(Purchase).filter(Purchase.id == id).one()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select purchase")

コード例 #15

def remove_purchase_for_user_app(userid, appid):
  try:
    session.query(Purchase).filter(Purchase.user_id == userid).filter(Purchase.app_id == appid).delete()
    session.commit()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to remove purchase")

コード例 #16

def save(obj):
  try:
    session.add(obj)
    session.commit()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to save object")

コード例 #17

ファイル: model.py プロジェクト: jflores31/openwebapps

def remove_purchase_for_user_app(userid, appid):
    try:
        session.query(Purchase).filter(Purchase.user_id == userid).filter(Purchase.app_id == appid).delete()
        session.commit()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to remove purchase")

コード例 #18

ファイル: model.py プロジェクト: jflores31/openwebapps

def save(obj):
    try:
        session.add(obj)
        session.commit()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to save object")

コード例 #19

def categories(parent=None):
  try:
    q = session.query(Category)
    if parent: q = q.filter(Category.parent_id == parent)
    return q.all()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select categories")

コード例 #20

ファイル: model.py プロジェクト: jflores31/openwebapps

def categories(parent=None):
    try:
        q = session.query(Category)
        if parent:
            q = q.filter(Category.parent_id == parent)
        return q.all()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select categories")

コード例 #21

def createPurchaseForUserApp(uid, appid):
  try:
    p = Purchase(uid, appid, datetime.now())
    session.add(p)
    session.commit()
    return p

  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to create purchase")

コード例 #22

ファイル: model.py プロジェクト: jflores31/openwebapps

def createCategory(name, parent=None):
    try:
        if parent and (len(parent) == 0 or parent == 0):
            parent = None
        c = Category(name, parent=parent)
        session.add(c)
        session.commit()
        return c
    except Exception, e:
        session.rollback()
        raise ValueError("Error while creating category: %s" % e)

コード例 #23

def addIdentity(uid, identifier, displayName, email):
  try:
    id = Identity(uid, identifier, displayName, email, datetime.now())
    session.add(id)
    session.commit()
    return id

  except sqlalchemy.exc.IntegrityError, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to create identity")

コード例 #24

def createCategory(name, parent=None):
  try:
    if parent and (len(parent) == 0 or parent == 0):
        parent = None
    c = Category(name, parent=parent)
    session.add(c)
    session.commit()
    return c
  except Exception, e:
    session.rollback()
    raise ValueError("Error while creating category: %s" % e)

コード例 #25

ファイル: model.py プロジェクト: jflores31/openwebapps

def createPurchaseForUserApp(uid, appid):
    try:
        p = Purchase(uid, appid, datetime.now())
        session.add(p)
        session.commit()
        return p

    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to create purchase")

コード例 #26

ファイル: model.py プロジェクト: jflores31/openwebapps

def addIdentity(uid, identifier, displayName, email):
    try:
        id = Identity(uid, identifier, displayName, email, datetime.now())
        session.add(id)
        session.commit()
        return id

    except sqlalchemy.exc.IntegrityError, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to create identity")

コード例 #27

def createUser():
  try:
    u = User()
    session.add(u)
    session.commit()
    return u

  except sqlalchemy.exc.IntegrityError, e:
    logging.exception(e)  
    session.rollback()
    raise ValueError("Unable to create user")

コード例 #28

ファイル: model.py プロジェクト: jflores31/openwebapps

def createUser():
    try:
        u = User()
        session.add(u)
        session.commit()
        return u

    except sqlalchemy.exc.IntegrityError, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to create user")

コード例 #29

ファイル: hooks.py プロジェクト: szheross/SummitExam

def bing_user():
    try:
        # 判断是否登陆，登陆了session中包含ADMIN_EMAIL键
        if config.ADMIN_UUID in session:
            admin_email = session.get(config.ADMIN_UUID)
            admin_user = db_session.query(Admin).filter(
                Admin.admin_email == admin_email).first()
            # 如果从数据库中查询到了user用户（以防存在假的cookie, 概率几乎没有）
            if admin_user:
                g.admin_user = admin_user
    except Exception as err:
        db_session.rollback()

コード例 #30

def delete_user(id):
    try:
        user = session.query(Employee).get(id)
        user2 = session.query(Skills).filter_by(emp_id=id).first()
        #if user user2  !=None:
        session.delete(user)
        session.delete(user2)
        session.commit()
        final = {"firstname": user.firstname, "lastname": user.lastname}
        return final
    except Exception as e:
        return e
        session.rollback()

コード例 #31

ファイル: model.py プロジェクト: jflores31/openwebapps

def createUser():
    try:
        u = User()
        session.add(u)
        session.commit()
        return u

    except sqlalchemy.exc.IntegrityError, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to create user")
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to create application")


def user(id):
    try:
        return session.query(User).filter(User.id == id).first()
    except Exception, e:
        logging.exception(e)
        session.rollback()
        raise ValueError("Unable to select user")


def addIdentity(uid, identifier, displayName, email):
    try:
        id = Identity(uid, identifier, displayName, email, datetime.now())

コード例 #32

    
    
def createUser():
  try:
    u = User()
    session.add(u)
    session.commit()
    return u

  except sqlalchemy.exc.IntegrityError, e:
    logging.exception(e)  
    session.rollback()
    raise ValueError("Unable to create user")
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to create application")

def user(id):
  try:
    return session.query(User).filter(User.id == id).first()
  except Exception, e:
    logging.exception(e)
    session.rollback()
    raise ValueError("Unable to select user")
    

def addIdentity(uid, identifier, displayName, email):
  try:
    id = Identity(uid, identifier, displayName, email, datetime.now())
    session.add(id)