def delete(user_id: str, ver: str): session.rollback() old_data = query_helper.find_by_params(session, User, [{ "id": { "$eq": user_id } }, { "ver": { "$eq": ver } }], json_result=True) result = query_helper.delete_by_params( session, User, [{ "id": { "$eq": user_id } }, { "ver": { "$eq": ver } }], {'deleted_by_id': request.user['id']}, json_result=True) log_helper.log_update(session, User, request.user["id"], result, old_data) session.commit() return json_dumps(model_helper.insert_field_objects(session, result))
def update(board_user_id: str, ver: str): session.rollback() data = deepcopy(request.data) data.update({"updated_by_id": request.user["id"]}) old_data = query_helper.find_by_params(session, BoardUser, [{ "id": { "$eq": board_user_id } }, { "ver": { "$eq": ver } }], json_result=True) result = query_helper.update_by_params(session, BoardUser, [{ "id": { "$eq": board_user_id } }, { "ver": { "$eq": ver } }], data, json_result=True) log_helper.log_update(session, BoardUser, request.user["id"], result, old_data) session.commit() return json_dumps(model_helper.insert_field_objects(session, result))
def find(board_user_id: str): session.rollback() result = query_helper.find_by_id(session, BoardUser, board_user_id, json_result=True) return json_dumps(model_helper.insert_field_objects(session, result))
def find(card_list_id: str): session.rollback() result = query_helper.find_by_id(session, CardList, card_list_id, json_result=True) return json_dumps(model_helper.insert_field_objects(session, result))
def create(): session.rollback() data = deepcopy(request.data) data.update({"created_by_id": request.user["id"]}) result = query_helper.save(session, BoardUser, data, json_result=True) log_helper.log_insert(session, BoardUser, request.user["id"], result) session.commit() return json_dumps(model_helper.insert_field_objects(session, result))
def index(): session.rollback() results = query_helper.list_query(session, BoardUser, request.pagination.get("filters", []), request.pagination, json_result=True) return json_dumps( [model_helper.insert_field_objects(session, row) for row in results])
def create(): session.rollback() result = query_helper.save(session, CardList, request.data, json_result=True) log_helper.log_insert(session, CardList, request.user["id"], result) session.commit() return json_dumps(model_helper.insert_field_objects(session, result))
def signup(): session.rollback() data = deepcopy(request.data) data.update({ "created_at": datetime.utcnow(), "created_by_id": request.user["id"] }) if 'password' in data: data['password'] = password_helper.encrypt_password( str(data['password']).strip()) result = query_helper.save(session, User, data, json_result=True) log_helper.log_insert(session, User, request.user["id"], result) session.commit() return json_dumps(model_helper.insert_field_objects(session, result))
def login(): session.rollback() params = request.data token = None find_args = [] if 'username' in params: find_args.append( {'username': { "$eq": str(params['username']).strip() }}) elif 'email' in params: find_args.append({'email': {"$eq": str(params['email']).strip()}}) if 'password' in params: find_args.append({ 'password': { "$eq": password_helper.encrypt_password( str(params['password']).strip()) } }) result = query_helper.find_by_params(session, User, find_args, json_result=True) if result: if 'password' in result: del result['password'] token = jwt_helper.encode_token(result) if token: result.update({'token': token}) return json_dumps(model_helper.insert_field_objects(session, result))
def update(user_id: str, ver: str): session.rollback() data = deepcopy(request.data) data.update({ "updated_by_id": request.user["id"], "updated_at": datetime.now() }) if 'password' in data: del data['password'] old_data = query_helper.find_by_params(session, User, [{ "id": { "$eq": user_id } }, { "ver": { "$eq": ver } }], json_result=True) result = query_helper.update_by_params(session, User, [{ "id": { "$eq": user_id } }, { "ver": { "$eq": ver } }], data, json_result=True) log_helper.log_update(session, User, request.user["id"], result, old_data) session.commit() return json_dumps(model_helper.insert_field_objects(session, result))
def find(user_id): result = query_helper.find_by_id(session, User, user_id, json_result=True) return json_dumps(model_helper.insert_field_objects(session, result))