Fetch data from Table using sequelizejs in Node.js

Question

I am new in node.js, i want to fetch the data from table of the postgresql using sequelize ORM in node.js. I am using below code but its not working.

  const apisListModel = sequelize.define('apisList', {});
  apisListModel.findAll().then((data)=>{
              JSON.stringify(data,undefined,2);
            },(e)=>{
                console.log(e);

             });

Its give me error

        Executing (default): SELECT "id", "createdAt", "updatedAt" FROM 
           "apisLists" AS "apisList";
      { SequelizeDatabaseError: relation "apisLists" does not exist

But apiList table exist in my DATABASE

eseom · Accepted Answer · 2018-03-21 12:55:05Z

0

Sequelize changes the tableName to plural implicitly. You can define options as

const apisListModel = sequelize.define('apisList', {}, {
  tableName: 'apisList'
})

answered Mar 21, 2018 at 12:55

eseom

862 bronze badges

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

Comments

Shahzeb Khan · Accepted Answer · 2018-03-21 12:56:52Z

0

The query trying to fetch data from apisLists but your table name is apiList. Note the "s" in table name.

If this is the case, you can specify the table name using the option

tableName: 'apiList'

Here is the Documentation link

answered Mar 21, 2018 at 12:56

Shahzeb Khan

3,6428 gold badges47 silver badges82 bronze badges

Collectives™ on Stack Overflow

Fetch data from Table using sequelizejs in Node.js

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related