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))
