bartender/bin/setup

#!/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 status (status_status) VALUES ('Livre');

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

INSERT OR IGNORE INTO user (user_name, user_email, user_password, user_flag, company_id, role_id) VALUES ('admin', 'admin@example.com', 'admin', 'a', 1, 1);


EOF

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