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]