#!/bin/bash

# Nome do arquivo do banco de dados
DB_FILE="test.db"

cat migrations/migrations_v1.sql | sqlite3 "$DB_FILE"

# Executa comandos SQL no SQLite
sqlite3 "$DB_FILE" <<EOF

INSERT OR IGNORE INTO company (company_name, company_flag) VALUES ('Ferlin', 'a');

INSERT OR IGNORE INTO role (role_name, role_permission, role_flag, company_id) VALUES ('admin', 'all', 'a', 1);

INSERT OR IGNORE INTO role (role_name, role_permission, role_flag, company_id) VALUES ('waiter', 'waiter', 'a', 1);

INSERT OR IGNORE INTO role (role_name, role_permission, role_flag, company_id) VALUES ('kitchen', 'kitchen', 'a', 1);

INSERT OR IGNORE INTO role (role_name, role_permission, role_flag, company_id) VALUES ('cashier', 'cashier', 'a', 1);

INSERT OR IGNORE INTO status (status_status) VALUES ('Livre');

INSERT OR IGNORE INTO status (status_status) VALUES ('Ocupado');

INSERT OR IGNORE INTO status (status_status) VALUES ('Aberta');

INSERT OR IGNORE INTO status (status_status) VALUES ('Finalizada');

INSERT OR IGNORE INTO status (status_status) VALUES ('Cancelada');

EOF

echo "Banco de dados '$DB_FILE' criado e populado com sucesso! Senhas estão hasheadas."