How to fetch all fields of table using sequelize in nodejs?

Question

I want to fetch all fields without to write all fields name of table. How to use * to fetch all the fields from the table ?

This is UserController function to fetch all the rows with all fields of table.

user.findAll({
        attributes: ['name','email','mobile','dob','address','image','is_active'],
        where:{
            is_active:'1',
            name:{$like:'%%'}
        },
        limit:10
    }).then(function(users,fields){
        console.log(users);
        res.send({error:false,message:'users list',data:users});
    }).catch(function(err){
        console.log('Oops! something went wrong, : ', err);
    });

This is model code and define some property of model.

var sequalize = require('../../config/db_config');

const User = sequalize.define('user',{},{
    timestamps: false,
    paranoid: true,
    underscored: true,
    freezeTableName: true,
    tableName: 'user',
    createdAt:'created_on',
    updatedAt:'updated_on'
});

User.sync({force:false}).then(() => {
    console.log('Table is created!');    
}).catch(err => {
    console.log('An error occur when table is created!');
});
module.exports = User;

Please help me that how to fetch all fields with write to attribute in controller.

yBrodsky · Accepted Answer · 2017-07-22 16:22:10Z

4

Simply ommit the attributes key in your query and all the fields will return.

user.findAll({
  where:{
    is_active:'1',
    name:{$like:'%%'}
  },
  limit:10
}).then(function(users){
  console.log(users);
  res.send({error:false,message:'users list',data:users});
}).catch(function(err){
  console.log('Oops! something went wrong, : ', err);
});

EDIT: In your model definition is best if you specify the fields your table has. Like so: http://docs.sequelizejs.com/manual/tutorial/models-definition.html

Otherwise you will have to specify the attributes key in every find operation.

edited Jul 22, 2017 at 16:22

answered Jul 21, 2017 at 18:35

yBrodsky

5,0614 gold badges24 silver badges35 bronze badges

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

4 Comments

Rajeev Varshney Over a year ago

thanks for reply. I am begginer in nodejs. How to ommit the attribute key, give an example ?

Rajeev Varshney Over a year ago

when i am ommit the attribute then it return only id attribute.

yBrodsky Over a year ago

Update your question and show us your model definition

yBrodsky Over a year ago

Check my edited answer. You need to specify the fields in your model definition

Himanshu sharma · Accepted Answer · 2017-07-22 18:04:50Z

@yBrodsky is right . Also you should make model like this.so that it can know the field to select when no attribute.

const User = sequalize.define('user',{},{
    timestamps: false,
    paranoid: true,
    underscored: true,
    freezeTableName: true,
    tableName: 'user',
    createdAt:'created_on',
    updatedAt:'updated_on'
});

to this

var sequalize = require('../../config/db_config');

const User = sequalize.define('user',{
 name: {type: Sequelize.STRING},
  email: {type: Sequelize.STRING},
  mobile: {type: Sequelize.INTEGER},
  dob: {type: Sequelize.DATE}
address: {type: Sequelize.STRING},
  image: {type: Sequelize.INTEGER},
  is_active: {type: Sequelize.BOOLEAN }


},{
    timestamps: false,
    paranoid: true,
    underscored: true,
    freezeTableName: true,
    tableName: 'user',
    createdAt:'created_on',
    updatedAt:'updated_on'
});

for dtatype see here http://docs.sequelizejs.com/manual/tutorial/models-definition.html#data-types

Piyush Biswal · Accepted Answer · 2019-09-12 19:20:29Z

0

Simply remove attributes from model , you will be able fetch all columns

answered Sep 12, 2019 at 19:20

Piyush Biswal

1572 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to fetch all fields of table using sequelize in nodejs?

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related