Is there a way to create the database if it doesn`t exist with sequelize?

Question

I have a sequelize connection.

Then I create every table I need if they don't already exist. However, before I do that, I want to create the schema itself if it doesn`t exist, so I can run this script anywhere that has mysql installed and not worry. Is there a way to do so with sequelize? Or with any other tool if not.

try a combination of [this](https://stackoverflow.com/a/52915491/62282) and [sync](https://sequelize.org/master/class/lib/sequelize.js~Sequelize.html#instance-method-sync) — Samuel Goldenbaum, Aug 18 '20 at 20:17

score 6 · Accepted Answer · answered Aug 18 '20 at 23:26

6

Following this answer as proposed by Samuel G:

const mysql = require('mysql2/promise');

await mysql.createConnection({
    user     : user,
    password : pwd
}).then((connection: Sequelize) => {
    connection.query(`CREATE DATABASE IF NOT EXISTS ${name};`);
});

answered Aug 18 '20 at 23:26

Icaro Mota

912
1
12
20

2

This works for non-sequelize sessions too, thanks for the answer. – elpideus Dec 01 '22 at 00:16

Is there a way to create the database if it doesn`t exist with sequelize?

1 Answers1