node.js – insert a new record in nodejs using sequelize POST method

node.js – insert a new record in nodejs using sequelize POST method

You should use body-pareser

https://www.npmjs.com/package/body-parser

Example use body-parser:

var express = require(express)
var bodyParser = require(body-parser)

var app = express()

// parse application/x-www-form-urlencoded
app.use(bodyParser.urlencoded({ extended: false }))

// parse application/json
app.use(bodyParser.json())

app.use(function (req, res) {
  res.setHeader(Content-Type, text/plain)
  res.write(you posted:n)
  res.end(JSON.stringify(req.body, null, 2))
})

Example:

const Sequelize = require(sequelize);
const express = require(express);
const bodyParser = require(body-parser);

const app = express();

app.use(bodyParser.json({ limit: 100mb }));
app.use(bodyParser.urlencoded({ extended: true, limit: 100mb, parameterLimit: 1000000 }));

const sequelize = new Sequelize(test_01, root, root, {
    host: localhost,
    port: 3306,
    dialect: mysql
});

const users = sequelize.define(users, {
    id: {
        primaryKey: true,
        type: Sequelize.INTEGER,
    },
    name: Sequelize.STRING,
    role: Sequelize.STRING,
    email: Sequelize.STRING
});

app.post(/test, function (request, response) {
    return users.create({
        id: request.body.id,
        name: request.body.name,
        role: request.body.role,
        email: request.body.email
    }).then(function (users) {
        if (users) {
            response.send(users);
        } else {
            response.status(400).send(Error in insert new record);
        }
    });
});

app.listen(3001, function () {
    console.log(Express server is listening on port 3000);
});

node.js – insert a new record in nodejs using sequelize POST method

Leave a Reply

Your email address will not be published.