index.js

const express = require('express');
const { sequelize } = require('./config/db');
const app = express();
const port = process.env.PORT || 3000;
const quizzRoute = require('./routes/quizz.route');
const Quiz = require('./models/quizz.model');
const QuizMl = require('./models/quizzMl.model');

app.use(express.json());

app.use('/api/quizz', quizzRoute);

app.get('/', (req, res) => {
    res.send('Hello World!');
});


app.listen(port, () => {
    console.log(`Server is running on port ${port}`);
});


sequelize.authenticate()
    .then(async () => {

      
        // 1. Sync physical tables first
        // await sequelize.sync(); 
        await Quiz.sync();
        await QuizMl.sync();

        // 2. Define the Raw SQL for the View
        // This joins the main Quiz settings with the Multi-language (Ml) details
        const createViewSql = `
            CREATE OR REPLACE VIEW quizzes_view AS
            SELECT 
                m.id AS id,
                q.id AS quiz_id,
                m.language_id,
                m.name,
                m.description,
                q.image,
                q.isFeatured,
                q.isPopular
            FROM quizzes q
            JOIN quizzes_ml m ON q.id = m.quiz_id;
        `;

        await sequelize.query(createViewSql);

        console.log('Connection has been established successfully.');
    })
    .catch(err => {
        console.error('Unable to connect to the database:', err);
    });