def update():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
arguments_to_update = request.json['arguments_to_update']
primary_keys = request.json['primary_keys']
arguments_to_update["date_last_update"] = str(date.today())
if "password" in arguments_to_update:
arguments_to_update["pwd_salt"] = uuid.uuid4().hex
arguments_to_update["pwd_hash"] = hashlib.sha512(
(arguments_to_update["password"] +
arguments_to_update["pwd_salt"]).encode('utf-8')).hexdigest()
if arguments_to_update["check_pass_hash"] != hashlib.sha512(
(arguments_to_update["old_password"] +
arguments_to_update["check_salt_hash"]
).encode('utf-8')).hexdigest():
return jsonify({"msg": "invalid old password"}), 406
del arguments_to_update["password"]
del arguments_to_update["old_password"]
del arguments_to_update["confirm_password"]
del arguments_to_update["check_pass_hash"]
del arguments_to_update["check_salt_hash"]
try:
users_model.update(arguments_to_update, primary_keys)
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "usages of register was updated"}), 201
def get_for_utilizer():
if roles_required(["utilizer"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
num = request.json['num']
series = request.json['series']
try:
returned_data = blank_model.read({"num": num, "series": series})
from models.usages_register import UsagesRegisterModel
usages_register_model = UsagesRegisterModel(
PostgresConnection().get_connection())
usages_register = usages_register_model.custom_query(
"SELECT * FROM usages_register "
"WHERE num_blank = %s "
"AND series_blank = \'%s\'" % (num, series))
from models.code_usages_blank import CodeUsagesBlankModel
code_usages_blank_model = CodeUsagesBlankModel(
PostgresConnection().get_connection())
code_usages_blank = code_usages_blank_model.custom_query(
"SELECT * FROM code_usages_blank "
"WHERE code = %s" % (usages_register['code_usage']))
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({
"statusCode": usages_register['code_usage'],
"statusPhrase": code_usages_blank['text_representation'],
"dateUsing": usages_register['date_usage']
}), 200
def generate():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
try:
num = request.json['number']
users_model = UsersModel(PostgresConnection().get_connection())
notarius_model = NotariusModel(PostgresConnection().get_connection())
blank_model = BlankModel(PostgresConnection().get_connection())
usages_register_model = UsagesRegisterModel(
PostgresConnection().get_connection())
journal_actions_model = JournalActionsModel(
PostgresConnection().get_connection())
verifications_register_model = VerificationsRegisterModel(
PostgresConnection().get_connection())
code_usages_blank_model = CodeUsagesBlankModel(
PostgresConnection().get_connection())
users_model.generate_data(num)
notarius_model.generate_data(num)
blank_model.generate_data(num)
usages_register_model.generate_data(num)
journal_actions_model.generate_data(num)
verifications_register_model.generate_data(num)
code_usages_blank_model.generate_data(num)
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "data generated"}), 200
def delete():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
id = request.json['id']
try:
journal_actions_model.delete({
"id": id
})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "journal action was deleted"}), 201
def amount():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
try:
returned_data = verifications_register_model.amount()
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"verifications_register_amount": returned_data}), 200
def get_all():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
try:
returned_data = journal_actions_model.read_all()
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"journals_actions": returned_data}), 200
def delete_all():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
try:
journal_actions_model.delete_all()
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "journal actions was deleted"}), 201
def amount():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
try:
returned_data = blank_model.amount()
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"blanks_amount": returned_data}), 200
def generate():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
try:
num = request.json['number']
returned_data = journal_actions_model.generate_data(num)
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "journal_actions added"}), 200
def get():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
id = request.json['id']
try:
returned_data = notarius_model.read({"id": id})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"notarius": returned_data}), 200
def get():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
username = request.json['username']
try:
returned_data = users_model.read({"username": username})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"code_usages_blank": returned_data}), 200
def update():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
arguments_to_update = request.json['arguments_to_update']
primary_keys = request.json['primary_keys']
try:
journal_actions_model.update(arguments_to_update, primary_keys)
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "journal action was updated"}), 201
def delete():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
num = request.json['num']
series = request.json['series']
try:
blank_model.delete({"num": num, "series": series})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "Blank was deleted"}), 201
def get():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
num = request.json['num']
series = request.json['series']
try:
returned_data = blank_model.read({"num": num, "series": series})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"blank": returned_data}), 200
def create():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
request_json = request.json
try:
returned_data = verifications_register_model.create({
"num_blank": request_json['num_blank'],
"series_blank": request_json['series_blank'],
"user_id": request_json['user_id'],
"date_verification": date.today()
})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "verification was added"}), 201
def create():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
request_json = request.json
try:
returned_data = journal_actions_model.create({
"user_id": request_json['user_id'],
"action_date": request_json['action_date'],
"action_type": request_json['action_type'],
"row_affected": request_json['row_affected'],
"old_value": request_json['old_value'],
"new_value": request_json['new_value']
})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "journal action was added"}), 201
def create():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
request_json = request.json
try:
returned_data = notarius_model.create({
"type":
request_json['type'],
"status":
request_json['status'],
"date_status_update":
date.today(),
"num_certificate":
request_json['num_certificate'],
"num_card":
request_json['num_card'],
"name":
request_json['name'],
"name_organization":
request_json['name_organization'],
"region":
request_json['region'],
"contacts":
request_json['contacts'],
"notarius_region":
request_json['notarius_region'],
"additional_info":
request_json['additional_info'],
"date_issue_certificate":
request_json['date_issue_certificate'],
"date_issue_card":
request_json['date_issue_card'],
"date_reg_region":
date.today(),
"location":
request_json['location']
})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "Notarius was added"}), 201
def create():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
request_json = request.json
try:
returned_data = users_model.create({
"name": request_json["name"],
"role": request_json["role"],
"date_registration": date.today(),
"username": request_json["username"],
"pwd_hash": request_json["pwd_hash"],
"pwd_salt": uuid.uuid4().hex,
"date_last_update": date.today(),
"status": True
})
except Exception as e:
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "user was added"}), 201
def create():
if roles_required(["admin", "registrar"]) == 400:
return jsonify({"msg": "no access"}), 400
if not request.is_json:
return jsonify({"msg": "Missing JSON in request"}), 400
request_json = request.json
try:
returned_data = blank_model.create({
"num":
request_json["num"],
"series":
request_json["series"],
"notarius_id":
request_json["notarius_id"],
"date_receiving":
date.today(),
"user_id":
request_json.get("user_id", None)
})
except Exception as e:
print(str(e))
return jsonify({"msg": str(e)}), 400
return jsonify({"msg": "Blank was added"}), 201
def protected():
if roles_required(["admin"]) == 400:
return jsonify({"msg": "no access"}), 400
current_user = get_jwt_identity()
return jsonify(logged_in_as=current_user), 200
