Check Mysql Connection In Sequelize
Answer :
As of latest version of Sequelize (i.e. 3.3.2
), authenticate
can be used to check the connection:
var sequelize = new Sequelize("db", "user", "pass"); sequelize.authenticate().then(function(errors) { console.log(errors) });
authenticate
simply runs SELECT 1+1 AS result
query to check the db connection.
UPDATE:
Errors by the newest API need to be handled in catch
:
sequelize .authenticate() .then(() => { console.log('Connection has been established successfully.'); }) .catch(err => { console.error('Unable to connect to the database:', err); });
UPDATE 2:
I haven't tested this, but its only logical that the same thing can be reached with async/await
:
try { await sequelize.authenticate() } catch (err) { console.error('Unable to connect to the database:', err) }
You won't see errors, like password authentication errors, in .then
.
From the sequelize documentation here:
You can use the .authenticate() function like this to test the connection.
sequelize .authenticate() .then(function(err) { console.log('Connection has been established successfully.'); }) .catch(function (err) { console.log('Unable to connect to the database:', err); });
Comments
Post a Comment