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