fmgprog's picture
Update app.py
e3b54d0 verified
Raw History Blame Contribute Delete
6.03 kB
from flask import Flask, request, jsonify, abort
from flask_cors import CORS
from supabase_client import supabase
import uuid
import secrets
from datetime import datetime, timedelta
import pytz
import os
from jose import jwt
import requests
from functools import wraps
SUPABASE_URL = os.environ["SUPABASE_URL"]
app = Flask(__name__)
CORS(app)
def require_role(role):
def decorator(f):
@wraps(f)
def decorated(*args, **kwargs):
if not hasattr(request, "user"):
return jsonify({"error": "Usuário não autenticado"}), 401
user_role = request.user.get("role")
if user_role != role:
return jsonify({"error": "Permissão negada"}), 403
return f(*args, **kwargs)
return decorated
return decorator
def login_required(f):
@wraps(f)
def decorated(*args, **kwargs):
auth_header = request.headers.get("Authorization")
if not auth_header:
return jsonify({"error": "Token de usuário ausente"}), 401
try:
token = auth_header.split(" ")[1]
# valida JWT
user = supabase.auth.get_user(token)
user_id = user.user.id
# busca dados do usuário na tabela users
result = supabase.table("users") \
.select("id, nome, role") \
.eq("id", user_id) \
.single() \
.execute()
if not result.data:
return jsonify({"error": "Usuário não registrado"}), 403
# anexamos ao request
request.user = result.data
except Exception as e:
print("Erro auth:", e)
return jsonify({"error": "Token inválido"}), 401
return f(*args, **kwargs)
return decorated
def auditoria(processo_id,result,reason):
ip = request.headers.get("X-Forwarded-For", request.remote_addr)
user_agent = request.headers.get("User-Agent")
supabase.table("acessos").insert({
"processo_id": processo_id,
"ip": ip,
"user_agent": user_agent,
"success": result,
"reason": reason
}).execute()
@app.route("/api/processo", methods=["POST"])
@login_required
def criar_processo():
tz = pytz.timezone("America/Sao_Paulo")
payload = request.get_json()
tipo = payload.get("viewType")
data = payload.get("data")
nome_arquivo = payload.get("nome_arquivo")
token = secrets.token_urlsafe(16)
expires_at = datetime.now(tz) + timedelta(hours=48) # Expira em 48 horas
if not payload:
abort(400, "JSON inválido")
if tipo not in ["homologacao", "classificacao"]:
abort(400, "Tipo inválido")
if not isinstance(data, list):
abort(400, "Payload inválido")
result = supabase.table("processos").insert({
"tipo": tipo,
"edital": nome_arquivo,
"payload": data,
"token": token,
"expires_at": expires_at.isoformat()
}).execute()
processo_id = result.data[0]["id"]
return jsonify({
"id": processo_id,
"token": token
})
@app.route("/api/processo/<processo_id>", methods=["GET"])
def obter_processo(processo_id):
result = supabase.table("processos") \
.select("tipo, edital, payload, decisions, token, created_at, expires_at, last_mod") \
.eq("id", processo_id) \
.single() \
.execute()
processo = result.data
now = datetime.now(pytz.timezone("America/Sao_Paulo"))
token = request.args.get("t")
if not token:
msg = "Token ausente"
auditoria(processo_id,False,msg)
abort(403, msg)
if not result.data:
msg = "Dados Inválidos"
auditoria(processo_id,False,msg)
abort(404, msg)
if processo["token"] != token:
msg = "Token inválido"
auditoria(processo_id,False,msg)
abort(403, msg)
if processo["expires_at"] and now > datetime.fromisoformat(processo["expires_at"]):
msg = "Link expirado"
auditoria(processo_id,False,msg)
abort(410, msg)
msg = "Dados do processo carregados com sucesso"
auditoria(processo_id,True,msg)
return jsonify({
"tipo": processo["tipo"],
"edital": processo["edital"],
"payload": processo["payload"],
"decisions": processo["decisions"],
})
@app.route("/api/admin/processos", methods=["GET"])
@login_required
@require_role("admin")
def listar_processos():
result = supabase.table("processos") \
.select("""
id,
tipo,
edital,
token,
created_at,
expires_at,
last_mod,
acessos:acessos(count)
""") \
.order("created_at", desc=True) \
.execute()
return jsonify(result.data)
@app.route("/api/admin/revogar/<processo_id>", methods=["POST"])
@login_required
@require_role("admin")
def revogar_processo(processo_id):
token = request.headers.get("X-Admin-Token")
if token != os.environ.get("ADMIN_TOKEN"):
abort(403)
supabase.table("processos") \
.update({"expires_at": datetime.now(pytz.timezone("America/Sao_Paulo")).isoformat()}) \
.eq("id", processo_id) \
.execute()
return jsonify({"ok": True})
@app.route("/api/me", methods=["GET"])
def me():
auth_header = request.headers.get("Authorization")
if not auth_header:
return jsonify({"error": "Sem token"}), 401
token = auth_header.split(" ")[1]
try:
user = supabase.auth.get_user(token)
except Exception as e:
print("Erro token:", e)
return jsonify({"error": "Token inválido"}), 401
user_id = user.user.id
result = supabase.table("users") \
.select("id, nome, role") \
.eq("id", user_id) \
.single() \
.execute()
return jsonify(result.data)
if __name__ == "__main__":
app.run(host="0.0.0.0", port=7860)