how to select data from existing tables using sequelize

Question

I already have tables in postgresql. I want to retrieve data from them using sequelize. I used several ways to do it. But still can't map the db schma to sequelize in node.js.

  const Test = Conn.define('test', {
          race_id: 
          {
           type: Sequelize.STRING,
           allowNull: false   
           },
          race_name:
          {
           type: Sequelize.STRING,
           allowNull: false
          }
   });

  Conn.sync(); 
export default Conn;

I define the schema in node.js and have a table with same schema in postgresql.

But when execute Db.models.test.findAll({ where: args });

The console will output result as following:

Executing (default): SELECT "id", "race_id", "race_name", "createdAt", "updatedAt" FROM "tests" AS "test";

And I will get another output that is

column \"id\" does not exist

I can't figure out why sequelize retrieve data from tests table and it retrieve columns that I don't have.

How could I select table from existing tables using sequelize? I need to use ORM for requirement and can't use other way to get data.

Ivan Drinchev · Accepted Answer · 2018-10-30 07:50:55Z

4

You should define your primary key :

const Test = Conn.define('test', {
      race_id: 
      {
       type: Sequelize.STRING,
       allowNull: false,
       primaryKey: true
       },
      race_name:
      {
       type: Sequelize.STRING,
       allowNull: false
      }
});

This will replace id in your query with your primary key.

Check working with legacy tables, since it might help you for future problems.

edited Oct 30, 2018 at 7:50

answered May 16, 2016 at 20:08

Ivan Drinchev

19.6k4 gold badges69 silver badges97 bronze badges

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

1 Comment

Ivan Drinchev Over a year ago

@AkshayM fixed.

Collectives™ on Stack Overflow

how to select data from existing tables using sequelize

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