db.init.js

/**
Initialization script for database setup.

Usage:
Run this file once to create the database (and optionally the tables):
$ node ./app/config/db.init.js

By default, this script runs immediately when executed.
It does NOT export any functions since it’s meant to be a one-time setup.
If you prefer to import and call the functions manually elsewhere, 
just uncomment the last line, and paste the following script in the desired file:

  const { createDatabase, createTables } = require('./app/config/db.init');
  createDatabase();
  createTables();

*/

const { Sequelize } = require("sequelize");
const dbConfig = require("../config/db.config.js");

async function createDatabase() {
  const sequelize = new Sequelize("", dbConfig.USER, dbConfig.PASSWORD, {
    host: dbConfig.HOST,
    dialect: dbConfig.DIALECT,
  });

  try {
    await sequelize.query(`CREATE DATABASE IF NOT EXISTS \`${dbConfig.DB}\`;`);
    console.log(`Database "${dbConfig.DB}" created successfully!`);

  } catch (err) {
    console.error("Error creating database:", err);

  } finally {
    await sequelize.close();
  }
}

async function createTables() {
  const sequelize = new Sequelize(dbConfig.DB, dbConfig.USER, dbConfig.PASSWORD, {
    host: dbConfig.HOST,
    dialect: dbConfig.DIALECT,
  });

  // every table should be imported as it follows:
  const { TutorialModel } = require("../models/tutorial.model.js");
  
  // the model should be added to "modelNameList":
  const modelNameList = [TutorialModel];

  for (const modelDef of modelNameList) {
    const attributes = modelDef.getAttributes();
    sequelize.define(
      modelDef.name,
      attributes,
      {
        ...(modelDef.options || {}),
        tableName: modelDef.options?.tableName ?? modelDef.tableName
      }
    );
  }

  try {
    await sequelize.sync({ force: true });
    console.log(`All tables created/updated successfully in database "${dbConfig.DB}"!`);
  } catch (err) {
    console.error(`Failed to create tables:`, err);
  } finally {
    await sequelize.close();
  }
}

async function init() {
  await createDatabase();
  await createTables();
}

init();

// module.exports = { createDatabase, createTables }; // uncomment line to export function