init.sh

#!/bin/bash

echo "Setup BookSocial..."

# --- CONFIG ---
DB_NAME="booksocial"
DB_USER="booksocial_user"
DB_PASS="booksocial_pass"
PORT=8070

# --- CONTROLLI ---
if ! command -v node &> /dev/null
then
    echo "❌ Node.js non installato"
    exit 1
fi

if ! command -v mysql &> /dev/null
then
    echo "❌ MySQL/MariaDB non installato"
    exit 1
fi

# --- INSTALL DIPENDENZE ---
echo "Installo dipendenze Node..."
npm install

# --- CREA CARTELLA UPLOADS ---
echo "Creo cartella uploads..."
mkdir -p uploads

# --- SETUP DATABASE ---
echo "Configuro database..."
echo "Inserisci password MySQL root quando richiesto"

mysql -u root -p <<EOF

CREATE DATABASE IF NOT EXISTS $DB_NAME
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;

CREATE USER IF NOT EXISTS '$DB_USER'@'localhost' IDENTIFIED BY '$DB_PASS';
GRANT ALL PRIVILEGES ON $DB_NAME.* TO '$DB_USER'@'localhost';
FLUSH PRIVILEGES;

USE $DB_NAME;

-- USERS
CREATE TABLE IF NOT EXISTS users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    profile_image VARCHAR(255),
    bio TEXT,
    role ENUM('user','admin') DEFAULT 'user',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- ROOMS
CREATE TABLE IF NOT EXISTS rooms (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) UNIQUE,
    display_name VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- MESSAGES
CREATE TABLE IF NOT EXISTS messages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    room VARCHAR(100),
    username VARCHAR(50),
    message TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- POSTS
CREATE TABLE IF NOT EXISTS posts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    book_title VARCHAR(200),
    author VARCHAR(200),
    review TEXT,
    rating INT,
    cover_image VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY unique_user_book (username, book_title, author)
);

-- ADMIN DEFAULT
INSERT IGNORE INTO users (username, password, role)
VALUES ('admin', 'admin', 'admin');

-- DEFAULT ROOMS
INSERT IGNORE INTO rooms (name, display_name) VALUES
('fantasy', '🧙 Fantasy Books'),
('scifi', '🚀 Sci-Fi Books'),
('horror', '👻 Horror Books'),
('romance', '💝 Romance Books'),
('thriller', '🔎 Thriller & Mystery'),
('classics', '📜 Classic'),
('ya', '🧒 Young Adult'),
('darkfantasy', '🧙‍♂️ Dark Fantasy'),
('history', '🌍 Historical Fiction'),
('comedy', '😂 Comedy'),
('philosophy', '🧠 Philosophy'),
('manga', '📚 Manga & Light Novel');

EOF

# --- CREA FILE .ENV ---
echo "Creo file .env..."

cat <<EOT > .env
DB_HOST=localhost
DB_USER=$DB_USER
DB_PASS=$DB_PASS
DB_NAME=$DB_NAME
PORT=$PORT
EOT

echo "Setup completato!"
echo "Avvia il server con: node app.js"