Title:
Issue with Sequelize migration – “No database selected” error
Description:
I’m currently facing an issue with Sequelize migrations. When I try to run npx sequelize-cli db:migrate, I encounter a “No database selected” error. I have checked my Sequelize configuration, and it seems correct.
This is the error I get:
Sequelize CLI [Node: 20.11.1, CLI: 6.5.2, ORM: 6.35.2]
Loaded configuration file “srcconfigconfig.cjs”.
Using environment “development”.
ERROR: (conn=33, no: 1046, SQLState: 3D000) No database selected
sql: CREATE TABLE IF NOT EXISTS SequelizeMeta (name VARCHAR(255) NOT NULL UNIQUE, PRIMARY KEY (name)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci; – parameters:[]
This is the migration code:
module.exports = {
up: async (queryInterface, Sequelize) => {
await queryInterface.createTable('Restaurants', {
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,
type: Sequelize.INTEGER
},
name: {
type: Sequelize.STRING,
allowNull: false
},
description: {
type: Sequelize.TEXT
},
address: {
type: Sequelize.STRING,
allowNull: false
},
postalCode: {
type: Sequelize.STRING,
allowNull: false
},
url: {
type: Sequelize.STRING
},
shippingCosts: {
type: Sequelize.DOUBLE,
allowNull: false
},
averageServiceTime: {
type: Sequelize.DOUBLE
},
email: {
type: Sequelize.STRING
},
phone: {
type: Sequelize.STRING
},
logo: {
type: Sequelize.STRING
},
heroImage: {
type: Sequelize.STRING
},
status: {
type: Sequelize.ENUM('online', 'offline', 'closed', 'temporarily closed'),
allowNull: false
},
restaurantCategoryId: {
type: Sequelize.INTEGER,
allowNull: false,
references: {
model: {
tableName: 'RestaurantCategories'
},
key: 'id'
}
},
userId: {
type: Sequelize.INTEGER,
allowNull: false,
references: {
model: {
tableName: 'Users'
},
key: 'id'
}
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
defaultValue: new Date()
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
defaultValue: new Date()
}
})
},
down: async (queryInterface, Sequelize) => {
await queryInterface.dropTable('Restaurants')
}
}
I haven’t tried any succesful possible solution, since I don’t have much knowledge with migrations