def get_user_by_id(self, user_id):
result = DBSession.query(UsersTable).filter(UsersTable.uid == user_id)
try:
user = build_user(result.one())
except:
user = None
return user
def update_by_id(self, user_id, user_info):
try:
user = DBSession.query(UsersTable).filter(UsersTable.uid ==
user_id).update({'username':user_info['username']})
transaction.commit()
except:
return {'status': '1', 'data': 'Username Exists'}
return {'status': '0', 'data': 'Update User Successful'}
def delete(self, user_id):
try:
user = DBSession.query(UsersTable).filter(UsersTable.uid ==
user_id).one()
except:
return {'status': '2', 'data': 'No User Found'}
try:
status = DBSession.delete(user)
transaction.commit()
except:
transaction.abort() # This seems necessary for the functional tests
# to run
return {'status': '1', 'data': 'Something Went Wrong'}
return {'status': '0', 'data': 'Create User Successful'}
def get_all(self):
users = DBSession.query(UsersTable).all()
return [build_user(u) for u in users]