Sequelize internal error server in request

Viewed 16

I followed the official documentation of sequelize and sequelize cli, using sequelize cli I was successful and managed to perform my migrations to the database, but now when creating user and testing in postman, I can only get internal error server 500 without being able to succeed in the request.

CustomerController

const Customer = require('../../models/customer');

module.exports = {
    async store (req, res) {
        try {
            const { name, email, password, country, city, state, address, postalCode } = req.body;

            const createdCustomer = await Customer.create({ name, email, password, country, city, state, address, postalCode })
            
            return res.status(200).json(createdCustomer);
        } catch (err) {
            return res.status(500).json(err);
        }
    }

}

route

const router = require('express').Router();

const CreateCustomer = require('../controllers/CustomerController/CreateCustomer');

router.post('/', CreateCustomer.store);

module.exports = router;

databaseConfig

const { Sequelize } = require('sequelize');

const sequelize = new Sequelize('purchasedata', process.env.NAME, proccess.env.PASSWORD, {
    host: 'localhost',
    dialect: 'postgres', 
});

module.exports = sequelize;

customer Model

'use strict';
const {
  Model
} = require('sequelize');
module.exports = (sequelize, DataTypes) => {
  class Customer extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate(models) {
      // define association here
    }
  }
  Customer.init({
    name: DataTypes.STRING,
    email: DataTypes.STRING,
    password: DataTypes.STRING,
    country: DataTypes.STRING,
    city: DataTypes.STRING,
    state: DataTypes.STRING,
    address: DataTypes.STRING,
    postalCode: DataTypes.STRING
  }, {
    sequelize,
    modelName: 'Customer',
  });
  return Customer;
};

app.js

const app = require('./app');

const sequelize  = require('./database/config');

async function connection() {
    const port = process.env.PORT;
    try {
        await sequelize.authenticate();
        console.log('Connection has been established successfully.');
        app.listen(port);
        console.log(`Listening on port ${port}`)
    } catch (error) {
        console.log(error);
    }
}

connection();

server.js

const app = require('./app');

const sequelize  = require('./database/config');

async function connection() {
    const port = process.env.PORT;
    try {
        await sequelize.authenticate();
        console.log('Connection has been established successfully.');
        app.listen(port);
        console.log(`Listening on port ${port}`)
    } catch (error) {
        console.log(error);
    }
}

connection();

But my console returns that the database has been successfully connected, and when the request fails at status 500 I don't get any error in the console. Thanks

0 Answers
Related