README.md

Configurando sequelize

const models = require('./models/'); const { User } = models;

npm install express sequelize pg pg-hstore

npm install -D sequelize

npz sequelize init

npx sequelize-cli model:generate --name User --attributes name:string,email:string

alterar config/config.json com os dados do seu banco

Integrando com express

const express = require('express');
const app = express();
const models = require('./models/');
const { User } = models;



app.use(express.json())
app.get('/', (req, res)=>{
  User.create({ name: 'João', email: '[email protected]' });
  res.send({'status': 'created'});
})
app.listen(2000);

Vamos fazer um post

const express = require('express');
const app = express();
const models = require('./models/');
const { User } = models;

app.use(express.json());
app.post('/', async (req, res)=>{
  const {name, email} = req.body;
  await User.create({ name: name, email: email });
  res.send({'status': 'done'});
});

app.get('/users', async (req, res)=>{
  const users = await User.findAll();
  res.status(200).send({ users: users});
});
app.listen(2000);