#!/bin/bash
# Script completo para popular roles na VPS
# Execute na VPS: bash popular-roles-completo.sh

cd /var/www/maktubia-backend

echo "🔧 Populando tabela roles com todos os roles necessários..."
echo ""

sudo -u postgres psql -d maktubia_points << 'SQL'
-- Popular roles padrão
INSERT INTO roles (role_name, role_description, permissions)
VALUES 
    ('user', 'Cliente padrão', '{"purchases": ["read", "create"], "transfers": ["read", "create"], "friends": ["read", "create", "accept", "reject"], "rewards": ["read", "redeem"], "profile": ["read", "update"]}'::jsonb),
    ('admin', 'Administrador', '{"*": ["*"]}'::jsonb),
    ('manager', 'Gerente', '{"users": ["read", "update"], "customers": ["read", "create", "update"], "establishments": ["read", "create", "update", "delete"], "purchases": ["read", "confirm", "reject"], "campaigns": ["read", "create", "update", "delete"], "reports": ["read", "export"], "dashboard": ["read"]}'::jsonb),
    ('employee', 'Funcionário', '{"customers": ["read", "create"], "purchases": ["read", "confirm"], "establishments": ["read"], "campaigns": ["read"]}'::jsonb),
    ('cashier', 'Caixa', '{"purchases": ["read", "create", "confirm"], "customers": ["read"], "establishments": ["read"]}'::jsonb),
    ('supervisor', 'Supervisor', '{"users": ["read"], "customers": ["read", "create", "update"], "establishments": ["read", "update"], "purchases": ["read", "confirm", "reject"], "campaigns": ["read", "create", "update"], "reports": ["read"], "dashboard": ["read"]}'::jsonb)
ON CONFLICT (role_name) DO UPDATE SET
    role_description = EXCLUDED.role_description,
    permissions = EXCLUDED.permissions;

-- Verificar roles criados
SELECT role_id, role_name, role_description FROM roles ORDER BY role_id;
SQL

echo ""
echo "✅ Tabela roles populada!"
echo ""
echo "🔄 Reiniciando aplicação..."
pm2 restart maktubia-backend

echo ""
echo "✅ Concluído!"