def view_relations(request):
dbsession = DBSession()
parents = get_parents(dbsession)
add_child(dbsession, parents)
parents = get_parents(dbsession)
#print "\n 3. Check if parent has children"
parents = dbsession.query(Parent).all()
info = {}
ret_info = []
for parent in parents:
if is_has_child(parent):
#print "\n Parent %s has children" % parent.name
info['children'] = "yes"
#for child in parent.children:
# print "\tchild.id = %s, child.name = %s" % (str(child.id), str(child.name))
else:
#print "\n Parent %s hasn't children" % parent.name
info['children'] = "no"
info['parent'] = parent.name
ret_info.append(info)
info = {}
return ret_info
def view_all_parents(request):
dbsession = DBSession()
#parents_and_childs = dbsession.query(Parent).filter_by(name == 'Alexander', id == 1).all()
parents_and_childs = dbsession.query(Parent).filter(Parent.id == 1).filter(Parent.name == 'Alexander').scalar()
print parents_and_childs.__dict__
#return OK_RESPONSE
return parents_and_childs if parents_and_childs is not None else "NONE"
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"
def my_view(request):
dbsession = DBSession()
root = dbsession.query(Parent).filter(Parent.name == u'Alexander').first()
return {'root': root.name, 'project':'ORM'}