How to manipulate a table with postgres without define a Sequelize Model

Question

I have created a 'user' table directly in postgres shell, and all i need is to manipulate (CRUD) the data without have to create a model like this:

const User = sequelize.define('user', {
  firstName: {
    type: Sequelize.STRING,
  },
  lastName: {
    type: Sequelize.STRING,
  },
});

I've searched a lot in the documentation, but what I've seen so far, I must create a Model. Is there a way I can work without creating the Model?

Don't name a table user. That wull cause trouble, since user is a reserved SQL keyword. — Laurenz Albe
– Laurenz Albe, Commented Oct 1, 2020 at 14:49

Lin Du · Accepted Answer · 2020-10-14 07:13:48Z

2

You can use Raw queries to manipulate the data without having to create a model.

For example:

We have User table in the database:

node-sequelize-examples=# select * from "User";
 UserId |          UserEmail           |                             UserAvatar                              
--------+------------------------------+---------------------------------------------------------------------
      1 | [email protected]          | https://s3.amazonaws.com/uifaces/faces/twitter/markretzloff/128.jpg
      2 | [email protected] | https://s3.amazonaws.com/uifaces/faces/twitter/faisalabid/128.jpg
      3 | [email protected]             | https://s3.amazonaws.com/uifaces/faces/twitter/sur4dye/128.jpg
(3 rows)

Use raw query to get all users:

import { sequelize } from '../../db';
import { QueryTypes } from 'sequelize';

sequelize.query('select * from "User"', { type: QueryTypes.SELECT }).then(console.log);

Logs:

Executing (default): select * from "User"
[ { UserId: 1,
    UserEmail: '[email protected]',
    UserAvatar:
     'https://s3.amazonaws.com/uifaces/faces/twitter/markretzloff/128.jpg' },
  { UserId: 2,
    UserEmail: '[email protected]',
    UserAvatar:
     'https://s3.amazonaws.com/uifaces/faces/twitter/faisalabid/128.jpg' },
  { UserId: 3,
    UserEmail: '[email protected]',
    UserAvatar:
     'https://s3.amazonaws.com/uifaces/faces/twitter/sur4dye/128.jpg' } ]

answered Oct 14, 2020 at 7:13

Lin Du

104k139 gold badges341 silver badges575 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joao Jorge Over a year ago

Thank you very much @slideshowp2, this is what I was looking for.

Collectives™ on Stack Overflow

How to manipulate a table with postgres without define a Sequelize Model

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related