I've been working on creating a model using Sequelize with a MySQL database. When trying to post to '/students/register', I keep encountering an error stating that findOne is not a function. I attempted requiring mysql without success and also tried using a different function like findAll, which also didn't work. Can anyone help identify what the issue might be? Thanks
models/Students.js
const Sequelize = require('sequelize');
const sequelize = require('../database/db')
module.exports = (sequelize, Sequelize) => {
const Student = sequelize.define(
'student', {
id: {
type: Sequelize.INTEGER,
primaryKey: true,
autoIncrement: true
},
name: {
type: Sequelize.STRING
},
email: {
type: Sequelize.STRING
},
password: {
type: Sequelize.STRING
},
created: {
type: Sequelize.DATE,
defaultValue: Sequelize.NOW
}
}, {
timestamps: false
});
module.exports = Student;
};
database/db.js
const Sequelize = require('sequelize')
const sequelize = new Sequelize('canavs', 'root', 'root', {
host: 'localhost',
port: 8889,
dialect: 'mysql',
operatorAliases: false,
pool: {
max: 5,
min: 0,
acquire: 3000,
idle: 10000
}
})
// sequelize.import('./models/Students')
module.exports = sequelize;
index.js
const Student_Info = require('./models/Students')
const db = require('./database/db')
// app.use('/students', Student)
app.get('/getName', (req, res) => {
Student_Info.findOne({
where: {
id: 1
}
})
.then((student) => {
res.json(student.name);
})
.catch((err) => {
res.send('error' + err)
}
)
})