Exemplo n.º 1
0
Arquivo: views.py Projeto: cvacubo/ORM
def view_balance(request):

    dbsession = DBSession()

    user_id = 1
    #user = dbsession.query(AppUserBalance).filter(AppUserBalance.id == user_id).scalar()
    #print user.app_user.__dict__

    user = dbsession.query(AppUserBalance).options(joinedload(AppUserBalance.app_user)).filter(AppUserBalance.app_user_id == user_id).scalar()

    if not user:
        app_user = AppUser(1, 'artem.com')
        user = AppUserBalance(app_user, 0)
        dbsession.add(user)
        dbsession.flush()

    vbalance = user.balance + 1000

    if vbalance < 0:
        print "ZERO"

    user.balance = vbalance
    #print user.name
    #print user.balance

    print user.__dict__
    print vbalance

    return "YES"