Sequelize Run Script File

user_1394922 0
Viewed 4179

I have a project which is using Sequelize to manage a set of MySQL databases. Thus far I've been able to run simple queries to create new databases, insert parameters into a table, and select data... however, I have a very long .sql file (+1,700 lines) which when executed will set up a database with a specific schema (ie. tables, views, etc.). The problem is that I can not figure out how to execute a script like this using sequelize. I know the script works on a new database because I can execute the sql file from MySQL Workbench, however I do not know how to execute the script from javascript file using sequelize. I've searched forums but can't seem to find any resources either. Can this be done?

sequelize.js node.js mysql
1 Answers

You can run raw query by Sequelize using sequelize.query(sql_string) and you can use fs or fs-extra to read the sql file;

Just mind that you need to set the multiline statement option true in order to run this sql text:

var sql_string = fs.readFileSync('path to file', 'utf8');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: /* one of 'mysql' | 'mariadb' | 'postgres' | 'mssql' */,
  dialectOptions: {
    multipleStatements: true
  }
});

sequelize.query(sql_string);

Edit 1:

To better understanding of Sequelize class take a look at this

user_97585620
Related