Method initializeDatabase

server/tests/helpers/testDbManager.js:194–232

({ runMigrations = true } = {})

  }

  async initializeDatabase({ runMigrations = true } = {}) {
    const dbDialect = process.env.CB_DB_DIALECT_DEV || "mysql";

    const sequelizeOptions = {
      host: "localhost",
      port: this.port,
      dialect: dbDialect,
      logging: false,
      pool: {
        max: 5,
        min: 0,
        acquire: 30000,
        idle: 10000
      },
    };

    if (dbDialect === "mysql") {
      sequelizeOptions.define = {
        charset: "utf8mb4",
        collate: "utf8mb4_general_ci",
      };
      sequelizeOptions.dialectOptions = {
        charset: "utf8mb4",
      };
    }

    this.sequelize = new Sequelize(
      this.database,
      this.username,
      this.password,
      sequelizeOptions
    );

    await this.authenticateWithRetry();
    console.log("✅ Database connection established successfully");
    if (runMigrations) {
      await this.runMigrations();
    }
  }

  async authenticateWithRetry(maxRetries = 5, delay = 1000) {
    for (let attempt = 1; attempt <= maxRetries; attempt++) {