node 创建mysql,如何在nodejs中创建mysql模式

I am using nodejs, express framework and mysql for my database.

I would like to know how can I replicate this mongoose code using mysql. I cannot find a way to write my sql schema in a nodejs file. Do I have to use workbench for this? Thanks!

var mongoose = require('mongoose');

var userSchema = mongoose.Schema({

local: {

username: String,

password: String

}

});

module.exports = mongoose.model('User', userSchema);

解决方案

you can use any of:

bookshelf

knex

objection

orm

sequelize

see compare between that: