I am developing a [sails.js][1] app with [sequelize][2] ORM. I am a little confused as to when BelongsTo and HasOne need to be used.

The documentation states that : 

&gt; **BelongsTo** associations are associations where the foreign key for the
&gt; one-to-one relation exists on the source model.
&gt;
&gt; **HasOne** associations are associations where the foreign key for the
&gt; one-to-one relation exists on the target model.

Is there any other difference apart from the the place where these are specified? Does the behavior still continue to be the same in either cases?


  [1]: http://sailsjs.org/
  [2]: http://docs.sequelizejs.com/

Difference between HasOne and BelongsTo in Sequelize ORM

Am I required to handwrite the model definitions for Sequelize even if I&#39;m working off of an existing database.

If it&#39;s not required, then how does one go about using Sequelize with an existing database?

I&#39;ve already defined the database&#39;s schema in Doctrine, so I&#39;d rather not have to write another set of model definitions again.

Sequelize: how to import definitions from an existing database

My Node app is running fine locally, but has run into an error when deploying to Heroku. The app uses Sequelize in a `/models` folder, which contains `index.js`, `Company.js` and `Users.js`. Locally, I am able to import the models using the following code in `/models/index.js`:

    // load models
    var models = [
      &#39;Company&#39;,
      &#39;User&#39;
    ];
    models.forEach(function(model) {
      module.exports[model] = sequelize.import(__dirname + &#39;/&#39; + model);
    });

This works fine, however, when I deploy to Heroku the app crashes with the following error:

    Error: Cannot find module &#39;/app/models/Company&#39;
       at Function.Module._resolveFilename (module.js:338:15)
       at Function.Module._load (module.js:280:25)
       at Module.require (module.js:364:17)
       at require (module.js:380:17)
       at module.exports.Sequelize.import (/app/node_modules/sequelize/lib/sequelize.js:219:24)
       at module.exports.sequelize (/app/models/index.js:60:43)
       at Array.forEach (native)
       at Object.&lt;anonymous&gt; (/app/models/index.js:59:8)
       at Module._compile (module.js:456:26)
       at Object.Module._extensions..js (module.js:474:10)
    Process exited with status 8


Initially I thought it was due to case sensitivity (local mac vs heroku linux), but I moved the file, made a git commit, and then moved back and committed again to ensure `Company.js` is capitalized in the git repository. This didn&#39;t solve the problem and I&#39;m not sure what the issue could be.

Heroku + Node: Cannot find module error

I am looking for `group by` queries through Sequelize and cannot seem to find any documentation.
```sql
    SELECT column, count(column)  
    FROM table 
    GROUP BY column
```

How does group by works in sequelize?

I am getting a very strange problem with sequelize, When I try to call the function findAll it works fine (same for create and destroy), but when I try to call function &quot;findById&quot;, it throws &quot;findById is not a function&quot; (same for &quot;FindOne&quot;).

    //works fine
    var gammes = models.gamme.findAll().then(function(gammes) {
            res.render(&#39;admin/gammes/gestion_gamme&#39;,{
                layout: &#39;admin/layouts/structure&#39; ,
                gammes : gammes,
                js: &quot;gammes&quot;
            });
        });

    // throws models.gamme.findById is not a function
    models.gamme.findById(req.params.id).then(function(gamme) {
            gamme.update({
                nom: req.body.nom
            }).then(function () {
                res.redirect(&quot;/gammes&quot;);
            })
        });

Gamme.js model

    module.exports = function (sequelize, DataTypes) {
        &quot;use strict&quot;;
        var gamme = sequelize.define(&#39;gamme&#39;, {
            id_gamme: {
                type: DataTypes.INTEGER.UNSIGNED,
                autoIncrement: true,
                primaryKey: true
            },
            nom: {
                type: DataTypes.STRING,
                allowNull: false
            }
        }, {
            classMethods: {},
            timestamps: false
        });
        return gamme;
    };



sequelize &quot;findbyid&quot; is not a function but apparently &quot;findAll&quot; is

I am using Mocha for Unit tests.

When testing begins, I would like to delete all the previous records in a table.  

What I have tried:

    db.User.destroy({ force: true }).then(() =&gt; {
    }).then(() =&gt; done());


    db.User.destroy(
        {where: undefined},
        {truncate: false}
    ).then(() =&gt; {
        return 
    }).then(() =&gt; done());


    db.User.destroy({}).then(() =&gt; {
        return db.User.bulkCreate(users)
    }).then(() =&gt; done());


I keep getting the following error:

     Error: Missing where or truncate attribute in the options parameter of model.destroy.


How do I delete/destroy all the records in a table?


Sequelize: Destroy/Delete all records in the table

How do I define a unique index on a combination of columns in sequelize. For example I want to add a unique index on user_id, count and name. 

    var Tag = sequelize.define(&#39;Tag&#39;, {
            id: {
                type: DataTypes.INTEGER(11),
                allowNull: false,
                primaryKey: true,
                autoIncrement: true
            },
            user_id: {
                type: DataTypes.INTEGER(11),
                allowNull: false,
            },
            count: {
                type: DataTypes.INTEGER(11),
                allowNull: true
            },
            name: {
                type: DataTypes.STRING,
                allowNull: true,
            })

How to define unique index on multiple columns in sequelize

**I have a model with columns:**

    from: { type: Sequelize.DATE }
    to: { type: Sequelize.DATE }

I want to query all records whose either `from` OR `to` falls in between the date ranges : `[startDate, endDate]`

**Tried Something Like:**

    const where = {
        $or: [{
            from: {
                $lte: startDate,
                $gte: endDate,
            },
            to: {
                $lte: startDate,
                $gte: endDate,
            },
        }],
    };

**Something Like:**

    SELECT * from MyTable WHERE (startDate &lt;= from &lt;= endDate) OR (startDate &lt;= to &lt;= endDate

Sequelize Query to find all records that falls in between date range

Is there a way of doing bulk upsert in sequelize. Also, can I specify which keys to use for checking for duplicates? 

I tried following but it didn&#39;t work:

    Employee.bulkCreate(data, {
        updateOnDuplicate: true
    });

Bulk creation works fine though. Above statement always creates new entries in the DB.

Nodejs sequelize bulk upsert

How would I use Sequelize to find all people where a column in the relation satisfies a condition?

An example would be to find all Books whose author&#39;s last name is &#39;Hitchcock&#39;.  The book schema contains a hasOne relation with the Author&#39;s table.

Edit: I understand how this could be done with a raw SQL query, but looking for another approach

Sequelize find based on association

I have a function to retrieve a user&#39;s profile.

    app.get(&#39;/api/user/profile&#39;, function (request, response)
    {
      // Create the default error container
      var error = new Error();

      var User = db.User;
      User.find({
        where: { emailAddress: request.user.username}
      }).then(function(user)
      {
        if(!user)
        {
          error.status = 500; error.message = &quot;ERROR_INVALID_USER&quot;; error.code = 301;
          return next(error);
        }

        // Build the profile from the user object
        profile = {
          &quot;firstName&quot;: user.firstName,
          &quot;lastName&quot;: user.lastName,
          &quot;emailAddress&quot;: user.emailAddress
        }
        response.status(200).send(profile);
      });
    });

When the &quot;find&quot; function is called it displays the select statement on the console where the server was started. 

    Executing (default): SELECT `id`, `firstName`, `lastName`, `emailAddress`, `password`, `passwordRecoveryToken`, `passwordRecoveryTokenExpire`, `createdAt`, `updatedAt` FROM `Users` AS `User` WHERE `User`.`emailAddress` = &#39;johndoe@doe.com&#39; LIMIT 1;

Is there a way to get this not to be display?  Some flag that I set in a config file somewhere?

Prevent Sequelize from outputting SQL to the console on execution of query?

I&#39;m creating a RESTful API with NodeJS, express, express-resource, and Sequelize that is used to manage datasets stored in a MySQL database.

I&#39;m trying to figure out how to properly update a record using Sequelize.

I create a model:

    module.exports = function (sequelize, DataTypes) {
      return sequelize.define(&#39;Locale&#39;, {
        id: {
          type: DataTypes.INTEGER,
          autoIncrement: true,
          primaryKey: true
        },
        locale: {
          type: DataTypes.STRING,
          allowNull: false,
          unique: true,
          validate: {
            len: 2
          }
        },
        visible: {
          type: DataTypes.BOOLEAN,
          defaultValue: 1
        }
      })
    }

Then, in my resource controller, I define an update action.

In here I want to be able to update the record where the id matches a `req.params` variable.

First I build a model and then I use the `updateAttributes` method to update the record.

    const Sequelize = require(&#39;sequelize&#39;)
    const { dbconfig } = require(&#39;../config.js&#39;)
    
    // Initialize database connection
    const sequelize = new Sequelize(dbconfig.database, dbconfig.username, dbconfig.password)
    
    // Locale model
    const Locales = sequelize.import(__dirname + &#39;./models/Locale&#39;)
    
    // Create schema if necessary
    Locales.sync()
    

    /**
     * PUT /locale/:id
     */
    
    exports.update = function (req, res) {
      if (req.body.name) {
        const loc = Locales.build()
    
        loc.updateAttributes({
          locale: req.body.name
        })
          .on(&#39;success&#39;, id =&gt; {
            res.json({
              success: true
            }, 200)
          })
          .on(&#39;failure&#39;, error =&gt; {
            throw new Error(error)
          })
      }
      else
        throw new Error(&#39;Data not provided&#39;)
    }

Now, this does not actually produce an update query as I would expect.

Instead, an insert query is executed:

    INSERT INTO `Locales`(`id`, `locale`, `createdAt`, `updatedAt`, `visible`)
    VALUES (&#39;1&#39;, &#39;us&#39;, &#39;2011-11-16 05:26:09&#39;, &#39;2011-11-16 05:26:15&#39;, 1)

So my question is: What is the proper way to update a record using Sequelize ORM?

How to update a record using sequelize for node?

I&#39;m close to having my project ready to launch. I have big plans for after launch and the database structure is going to change -- new columns in existing tables as well as new tables, and new associations to existing and new models.

I haven&#39;t touched migrations in Sequelize yet, since I&#39;ve only had testing data which I don&#39;t mind wiping out every time the database changes.

To that end, at present I&#39;m running `sync force: true` when my app starts up, if I have changed the model definitions. This deletes all the tables and makes them from scratch. I could omit the `force` option to have it only create new tables. But if existing ones have changed this is not useful.

So once I add in migrations how do things work? Obviously I don&#39;t want existing tables (with data in them) to be wiped out, so `sync force: true` is out of the question. On other apps I&#39;ve helped develop (Laravel and other frameworks) as part of the app&#39;s deployment procedure we run the migrate command to run any pending migrations. But in these apps the very first migration has a skeleton database, with the database in the state where it was some time early in development -- the first alpha release or whatever. So even an instance of the app late to the party can get up to speed in one go, by running all migrations in sequence.

How do I generate such a &quot;first migration&quot; in Sequelize? If I don&#39;t have one, a new instance of the app some way down the line will either have no skeleton database to run the migrations on, or it will run sync at the start and will make the database in the new state with all the new tables etc, but then when it tries to run the migrations they won&#39;t make sense, since they were written with the original database and each successive iteration in mind.

My thought process: at every stage, the initial database plus each migration in sequence should equal (plus or minus data) the database generated when `sync force: true` is run. This is because the model descriptions in the code describe the database structure. So maybe if there is no migration table we just run sync and mark all the migrations as done, even though they weren&#39;t run. Is this what I need to do (how?), or is Sequelize supposed to do this itself, or am I barking up the wrong tree? And if I&#39;m in the right area, surely there should be a nice way to auto generate most of a migration, given the old models (by commit hash? or even could each migration be tied to a commit? I concede I am thinking in a non-portable git-centric universe) and the new models. It can diff the structure and generate the commands needed to transform the database from old to new, and back, and then the developer can go in and make any necessary tweaks (deleting/transitioning particular data etc).

When I run the sequelize binary with the `--init` command it gives me an empty migrations directory. When I then run `sequelize --migrate` it makes me a SequelizeMeta table with nothing in it, no other tables. Obviously not, because that binary doesn&#39;t know how to bootstrap my app and load the models.

I must be missing something.

TLDR: how do I set up my app and its migrations so various instances of the live app can be brought up to date, as well as a brand new app with no legacy starting database?

Sequelize.js: how to use migrations and sync

I am using sequelize ORM; everything is great and clean, but I had a problem when I use it with `join` queries.
I have two models: users and posts.

    var User = db.seq.define(&#39;User&#39;,{
    	username: { type: db.Sequelize.STRING},
    	email: { type: db.Sequelize.STRING},
    	password: { type: db.Sequelize.STRING},
    	sex : { type: db.Sequelize.INTEGER},
    	day_birth: { type: db.Sequelize.INTEGER},
    	month_birth: { type: db.Sequelize.INTEGER},
    	year_birth: { type: db.Sequelize.INTEGER}
    
    });
    
    User.sync().success(function(){
    	console.log(&quot;table created&quot;)
    }).error(function(error){
    	console.log(err);
    })
    
    
    var Post = db.seq.define(&quot;Post&quot;,{
    	body: { type: db.Sequelize.TEXT },
    	user_id: { type: db.Sequelize.INTEGER},
    	likes: { type: db.Sequelize.INTEGER, defaultValue: 0 },
    
    });
    
    Post.sync().success(function(){
    	console.log(&quot;table created&quot;)
    }).error(function(error){
    	console.log(err);
    })

I want a query that respond with a post with the info of user that made it. In the raw query, I get this:

    db.seq.query(&#39;SELECT * FROM posts, users WHERE posts.user_id = users.id &#39;).success(function(rows){
    			res.json(rows);
    		});

My question is how can I change the code to use the ORM style instead of the SQL query?

How to make join queries using Sequelize on Node.js

I want to see the SQL commands that are sent to the PostgreSQL server because I need to check if they are correct. In particular, I am interested in the table creation commands.

For instance, ActiveRecord (Ruby) prints its SQL statements to standard output. Is this possible with Node.js/ActionHero.js and Sequelize.js as well?

How can I see the SQL generated by Sequelize.js?

I am looking for an example nodejs app that uses the sequelize ORM.

My main concern is that it seems next to impossible to define your models in separate js files if those models have complex relationships to one another because of require() dependency loops. Maybe people define all their models in one file that is very very long?

I am mainly interested in how the models are defined and use through out the app. I would like to have some validation that what i am doing on my own is the &quot;good&quot; way to do things.



How to organize a node app that uses sequelize?

I have an model called User but Sequelize looks for the table USERS whenever I am trying to save in the DB. Does anyone know how to set Sequelize to use singular table names? Thanks. 

How to make Sequelize use singular table names

Is there a way to write a delete/deleteAll query like findAll?

For example I want to do something like this (assuming MyModel is a Sequelize model...):

    MyModel.deleteAll({ where: [&#39;some_field != ?&#39;, something] })
        .on(&#39;success&#39;, function() { /* ... */ });


Sequelize.js delete query?

I&#39;m not very familiar with javascript, and stunning, because i can&#39;t add new property, to object, that fetched from database using ORM names Sequelize.js.

To avoid this, i use this hack:

    db.Sensors.findAll({
        where: {
            nodeid: node.nodeid
        }
    }).success(function (sensors) {
            var nodedata = JSON.parse(JSON.stringify(node)); // this is my trick
            nodedata.sensors = sensors;
            nodesensors.push(nodedata);
            response.json(nodesensors);
    });

So, what normally way to add new properties to object.

If it can help, i use sequelize-postgres version 2.0.x.

**upd. console.log(node):**

    { dataValues: 
       { nodeid: &#39;NodeId&#39;,
         name: &#39;NameHere&#39;,
         altname: &#39;Test9&#39;,
         longname: &#39;&#39;,
         latitude: 30,
         longitude: -10,
         networkid: &#39;NetworkId&#39;,
         farmid: &#39;5&#39;,
         lastheard: Mon Dec 09 2013 04:04:40 GMT+0300 (FET),
         id: 9,
         createdAt: Tue Dec 03 2013 01:29:09 GMT+0300 (FET),
         updatedAt: Sun Feb 23 2014 01:07:14 GMT+0300 (FET) },
      __options: 
       { timestamps: true,
         createdAt: &#39;createdAt&#39;,
         updatedAt: &#39;updatedAt&#39;,
         deletedAt: &#39;deletedAt&#39;,
         touchedAt: &#39;touchedAt&#39;,
         instanceMethods: {},
         classMethods: {},
         validate: {},
         freezeTableName: false,
         underscored: false,
         syncOnAssociation: true,
         paranoid: false,
         whereCollection: { farmid: 5, networkid: &#39;NetworkId&#39; },
         schema: null,
         schemaDelimiter: &#39;&#39;,
         language: &#39;en&#39;,
         defaultScope: null,
         scopes: null,
         hooks: { beforeCreate: [], afterCreate: [] },
         omitNull: false,
         hasPrimaryKeys: false },
      hasPrimaryKeys: false,
      selectedValues: 
       { nodeid: &#39;NodeId&#39;,
         name: &#39;NameHere&#39;,
         longname: &#39;&#39;,
         latitude: 30,
         longitude: -110,
         networkid: &#39;NetworkId&#39;,
         farmid: &#39;5&#39;,
         lastheard: Mon Dec 09 2013 04:04:40 GMT+0300 (FET),
         id: 9,
         createdAt: Tue Dec 03 2013 01:29:09 GMT+0300 (FET),
         updatedAt: Sun Feb 23 2014 01:07:14 GMT+0300 (FET),
         altname: &#39;Test9&#39; },
      __eagerlyLoadedAssociations: [],
      isDirty: false,
      isNewRecord: false,
      daoFactoryName: &#39;Nodes&#39;,
      daoFactory: 
       { options: 
          { timestamps: true,
            createdAt: &#39;createdAt&#39;,
            updatedAt: &#39;updatedAt&#39;,
            deletedAt: &#39;deletedAt&#39;,
            touchedAt: &#39;touchedAt&#39;,
            instanceMethods: {},
            classMethods: {},
            validate: {},
            freezeTableName: false,
            underscored: false,
            syncOnAssociation: true,
            paranoid: false,
            whereCollection: [Object],
            schema: null,
            schemaDelimiter: &#39;&#39;,
            language: &#39;en&#39;,
            defaultScope: null,
            scopes: null,
            hooks: [Object],
            omitNull: false,
            hasPrimaryKeys: false },
         name: &#39;Nodes&#39;,
         tableName: &#39;Nodes&#39;,
         rawAttributes: 
          { nodeid: [Object],
            name: [Object],
            altname: [Object],
            longname: [Object],
            latitude: [Object],
            longitude: [Object],
            networkid: [Object],
            farmid: [Object],
            lastheard: [Object],
            id: [Object],
            createdAt: [Object],
            updatedAt: [Object] },
         daoFactoryManager: { daos: [Object], sequelize: [Object] },
         associations: {},
         scopeObj: {},
         primaryKeys: {},
         primaryKeyCount: 0,
         hasPrimaryKeys: false,
         autoIncrementField: &#39;id&#39;,
         DAO: { [Function] super_: [Function] } } }

I think next, what you think will be: &quot;Ok, that is easy, just add your property to dataValues.&quot;

    node.selectedValues.sensors = sensors;
    node.dataValues.sensors = sensors;

I add this lines, and this don&#39;t work

Sequelize, convert entity to plain object

I&#39;m getting a Unknown column &#39;userDetails.createdAt&#39; in &#39;field list&#39;
When trying to fetch with association.

Using `findAll` without association works fine.

My code is as follows:

&lt;!-- language: lang-js --&gt;

    var userDetails = sequelize.define(&#39;userDetails&#39;, {
        userId :Sequelize.INTEGER,
        firstName : Sequelize.STRING,
        lastName : Sequelize.STRING,
        birthday : Sequelize.DATE
    });
    
    var user = sequelize.define(&#39;user&#39;, {
        email: Sequelize.STRING,
        password: Sequelize.STRING
    });
    
    user.hasOne(userDetails, {foreignKey: &#39;userId&#39;});
    
    user.findAll({include: [userDetails] }).success(function(user) {
        console.log(user)
    });

&lt;!-- end snippet --&gt;


Sequelize Unknown column &#39;*.createdAt&#39; in &#39;field list&#39;

I&#39;m trying to output all object list from database with sequelize as follow and want to get data are sorted out as I added id in where clause.

    exports.getStaticCompanies = function () {
        return Company.findAll({
            where: {
                id: [46128, 2865, 49569,  1488,   45600,   61991,  1418,  61919,   53326,   61680]
            },
            attributes: [&#39;id&#39;, &#39;logo_version&#39;, &#39;logo_content_type&#39;, &#39;name&#39;, &#39;updated_at&#39;]
        });
    };

But the problem is after rendering, all data are sorted out as follow.

    46128, 53326, 2865, 1488, 45600, 61680, 49569, 1418, ....

As I found, it&#39;s neither sorted by id nor name. Please help me how to solve it.

sequelize findAll sort order in nodejs

I have a set of Sequelize models. I want to use migrations, not DB Sync.

[Sequelize CLI][1] seems to be able to do this, according to [this article][2]:
&quot;When you use the CLI for the model generation, you will gain the migration scripts for free as well.&quot;

How to auto generate the migrations with Sequelize CLI from existing Sequelize models?


  [1]: https://github.com/sequelize/cli
  [2]: http://sequelizejs.com/articles/express

How to auto generate migrations with Sequelize CLI from Sequelize models?

By creating object like this

    var condition=
    {
      where:
      {
         LastName:&quot;Doe&quot;，
         FirstName:[&quot;John&quot;,&quot;Jane&quot;],
         Age:{
           gt:18
         }
      }    
    }

and pass it in

    Student.findAll(condition)
    .success(function(students){
        
    })

It could beautifully generate SQL like this

    &quot;SELECT * FROM Student WHERE LastName=&#39;Doe&#39; AND FirstName in (&quot;John&quot;,&quot;Jane&quot;) AND Age&gt;18&quot;

However, It is all &#39;AND&#39; condition, how could I generate &#39;OR&#39; condition by creating a condition object?

Sequelize OR condition object

I have the following sequelize definition of a table:

    AcademyModule = sequelize.define(&#39;academy_module&#39;, {
            academy_id: DataTypes.INTEGER,
            module_id: DataTypes.INTEGER,
            module_module_type_id: DataTypes.INTEGER,
            sort_number: DataTypes.INTEGER,
            requirements_id: DataTypes.INTEGER
        }, {
            freezeTableName: true
    });

As you can see there is not an `id` column in this table. However when I try to insert it still tries the following sql:

     INSERT INTO `academy_module` (`id`,`academy_id`,`module_id`,`sort_number`) VALUES (DEFAULT,&#39;3&#39;,5,1);

How can I disable the `id` function it clearly has?

sequelize table without column &#39;id&#39;

I am using sequelize with MySQL. For example if I do:

    models.People.update({OwnerId: peopleInfo.newuser},
            {where: {id: peopleInfo.scenario.id}})
            .then(function (result) {
                response(result).code(200);
                
            }).catch(function (err) {
            request.server.log([&#39;error&#39;], err.stack);
           ).code(200);
        });
I am not getting information back if the people model was succesfully updated or not. Variable result is just an array with one element, 0=1

How can I know for certain that the record was updated or not.


Sequelize - update record, and return result

Any idea how to use an include with attributes (when you need to include only specific fields of the included table) with sequelize?

Currently I have this (but it doesn&#39;t work as expected):

    var attributes = [&#39;id&#39;, &#39;name&#39;, &#39;bar.version&#39;, [&#39;bar.last_modified&#39;, &#39;changed&#39;]];
    foo.findAll({
        where      : where,
        attributes : attributes,
        include    : [bar]
    }).success(function (result) { ...

How to use an include with attributes with sequelize?

I am using Sequelize as my backend ORM. Now I wish to do some `WHERE` operations on a Date. 

More specifically, I want to get all data where a date is between now and 7 days ago.

The problem is that the documentation does not specify which operations you can do on `Datatypes.DATE`

Can anyone point me in the right direction?

Sequelize Where statement with date

What does the force option on sequelize.sync() do?

    sequelize.sync({
        force: true
    });

Specifically, I am interested in knowing what force: false does? Will it not sync the schema with the database?

Are there any formal docs for sequelize? I could only find examples inside the docs.

How does sequelize.sync() work, specifically the force option?

I&#39;m building an app running on NodeJS using postgresql.
I&#39;m using SequelizeJS as ORM.
To avoid using real postgres daemon and having nodejs on my own device, i&#39;m using containers with docker-compose.

when I run ```docker-compose up```
it starts the pg database

    database system is ready to accept connections

and the nodejs server.
but the server can&#39;t connect to database.

    Error: connect ECONNREFUSED 127.0.01:5432

If I try to run the server without using containers (with real nodejs and postgresd on my machine) it works.

But I want it to work correctly with containers. I don&#39;t understand what i&#39;m doing wrong.

here is the `docker-compose.yml` file

    web:
      image: node
      command: npm start
      ports:
        - &quot;8000:4242&quot;
      links:
        - db
      working_dir: /src
      environment:
        SEQ_DB: mydatabase
        SEQ_USER: username
        SEQ_PW: pgpassword
        PORT: 4242
        DATABASE_URL: postgres://username:pgpassword@127.0.0.1:5432/mydatabase
      volumes:
        - ./:/src
    db:
      image: postgres
      ports:
      - &quot;5432:5432&quot;
      environment:
        POSTGRES_USER: username
        POSTGRES_PASSWORD: pgpassword

Could someone help me please?

(someone who likes docker :) )


ECONNREFUSED for Postgres on nodeJS with dockers

Alright so I have a project in NodeJS where I&#39;m utilizing Sequelize for a MySQL ORM. The thing works fantastically however I&#39;m trying to figure out if there is a way to specify what fields are being returned on a query basis or if there&#39;s even a way just to do a .query() somewhere. 

For example in our user database there can be ridiculous amounts of records and columns. In this case I need to return three columns only so it would be faster to get just those columns. However, Sequelize just queries the table for everything &quot;*&quot; to fulfill the full object model as much as possible. This is the functionality I&#39;d like to bypass in this particular area of the application.

Specifying specific fields with Sequelize (NodeJS) instead of *

Node.js 7 and up already support async/await syntax. How should I use async/await with sequelize transactions?

Node.js 7 how to use sequelize transaction with async / await?

I need to find the latest entry in a table. What is the best way to do this? The table has Sequelize&#39;s default `createdAt` field.

Sequelize findOne latest entry

I&#39;ve just started using Sequelize and Sequelize CLI

Since it&#39;s a development time, there are a frequent addition and deletion of columns. What the best the method to add a new column to an existing model?

For example, I want to a new column &#39;**completed**&#39; to **Todo** model. I&#39;ll add this column to models/todo.js. Whats the next step?

I tried `sequelize db:migrate`

not working: *&quot;No&#160;migrations&#160;were&#160;executed,&#160;database&#160;schema&#160;was&#160;already&#160;up&#160;to&#160;date.&quot;*


How to Add, Delete new Columns in Sequelize CLI

I&#39;m using the sequelize ORM to fetch data from a PSQL DB. However, when I retrieve something, a whole bunch of data is given. The only data I want is inside &#39;dataValues&#39;. Of course, I can use object.dataValues. But, is there any other good solutions?

I&#39;m using Sequelize 4.10

Get only dataValues from Sequelize ORM

This is my model definition:

    var Tag = sequelize.define(&#39;Tag&#39;, {
        name: Sequelize.STRING
    });
    
    var Event = sequelize.define(&#39;Event&#39;, {
        name: Sequelize.STRING,
    });
    
    Event.hasMany(Tag, {as: &#39;tags&#39;, through: &#39;event_tags&#39;, foreignKey: &#39;eventId&#39;});
    Tag.hasMany(Event, {as: &#39;events&#39;, through: &#39;event_tags&#39;, foreignKey: &#39;tagId&#39;});

In words this is: there are events and tags. Events are tagged with many tags.

I&#39;m trying to run this query:

    Event
    .findAndCountAll({
        include: [{model: Tag, as: &#39;tags&#39;}],
        where: {&#39;tags.id&#39;: {in: [1,2,3,4]}},
        order: order,
        limit: pageSize,
        offset: pageSize * (page - 1),
    })
    .success(function(result) {
    
        ...
    });

But I&#39;m getting this error:

       \node_modules\sequelize\lib\dialects\abstract\query-generator.js:1134
              var logicResult = Utils.getWhereLogic(logic, hash[key][logic]);
                                                                    ^
       TypeError: Cannot read property &#39;in&#39; of undefined

What am I doing wrong?

I&#39;ve used before the &quot;in&quot; expression, for example here:

     Tag
     .find({
          where: {id: {in: [1,2,3,4]}}
     }).success(...)

And it worked just fine.&lt;br&gt;

I&#39;ve never used the in expression with a sub-array though, as in this case. So I don&#39;t know if thats the correct way to do it.

Sequelize error when using &quot;where&quot; and &quot;in&quot; on a subarray

I&#39;m using Sequelize in my Nodejs project and I found a problem that I&#39;m having a hard time to solve.
Basically I have a cron that gets an array of objects from a server than inserts it on my database as a object ( for this case, cartoons ). But if I already have one of the objects, I have to update it.

Basically I have a array of objects and a could use the BulkCreate() method. But as the Cron starts again, it doesn&#39;t solve it so I was needing some sort of update with an upsert true flag. And the main issue: I must have a callback that fires just once after all these creates or updates. Does anyone have an idea of how can I do that? Iterate over an array of object.. creating or updating it and then getting a single callback after?

Thanks for the attention 

Create or Update Sequelize

I have a multiple contentIds.

    Mode.findAll({
        where: {
         id: contentIds
       }
      })

After finding all how can I Delete multiple rows from a table.

Or tell me other options to delete multiple records with a single query.

Is multiple delete available in sequelize?

What&#39;s the difference between `B.belongsTo(A)` and `A.hasMany(B)`

    Artist = sequelize.define(&#39;Artist&#39;, {});
    Album = sequelize.define(&#39;Albums&#39;, {});

    Album.belongsTo(Artist, foreignKey: &#39;album_belongsl_artist&#39;);
    Artist.hasMany(Album, foreignKey: &#39;artist_hasmany_albums&#39;);

if it in both cases creates the depended tables in `Album`?

belongsTo vs hasMany in Sequelize.js

I have a complex set of associated models. The models are associated using join tables, each with an attribute called &#39;order&#39;. I need to be able to query the parent model &#39;Page&#39; and include the associated models, and sort those associations by the field &#39;order&#39;.

The following is having no effect on the results&#39; sort order:

    db.Page.findAll({
      include: [{
        model: db.Gallery,
        order: [&#39;order&#39;, &#39;DESC&#39;],
        include: [{
          model: db.Artwork,
          order: [&#39;order&#39;, &#39;DESC&#39;]
        }]
      }],
    })

Ordering results of eager-loaded nested models in Node Sequelize

I want to get query like this with sequelize ORM: 

    SELECT &quot;A&quot;.*,      
    FROM &quot;A&quot; 
    LEFT OUTER JOIN &quot;B&quot; ON &quot;A&quot;.&quot;bId&quot; = &quot;B&quot;.&quot;id&quot;
    LEFT OUTER JOIN &quot;C&quot; ON &quot;A&quot;.&quot;cId&quot; = &quot;C&quot;.&quot;id&quot;
    WHERE (&quot;B&quot;.&quot;userId&quot; = &#39;100&#39;
           OR &quot;C&quot;.&quot;userId&quot; = &#39;100&#39;)
The problem is that sequelise not letting me to reference &quot;B&quot; or &quot;C&quot; table in where clause. Following code

    A.findAll({
        include: [{
    		model: B,
    		where: {
    			userId: 100
    		},
    		required: false
    
    	}, {
    		model: C,
    		where: {
    			userId: 100
    		},
    		required: false
    	}]
    ] 
gives me

    SELECT &quot;A&quot;.*,      
    FROM &quot;A&quot; 
    LEFT OUTER JOIN &quot;B&quot; ON &quot;A&quot;.&quot;bId&quot; = &quot;B&quot;.&quot;id&quot; AND &quot;B&quot;.&quot;userId&quot; = 100
    LEFT OUTER JOIN &quot;C&quot; ON &quot;A&quot;.&quot;cId&quot; = &quot;C&quot;.&quot;id&quot; AND &quot;C&quot;.&quot;userId&quot; = 100
which is completely different query, and result of

    A.findAll({
        where: {
    	    $or: [
    		    {&#39;&quot;B&quot;.&quot;userId&quot;&#39; : 100},
    		    {&#39;&quot;C&quot;.&quot;userId&quot;&#39; : 100}
    	    ]
        },
        include: [{
    		model: B,
    		required: false
    
    	}, {
    		model: C,
    		required: false
    	}]
    ] 
is no even a valid query:

    SELECT &quot;A&quot;.*,      
    FROM &quot;A&quot; 
    LEFT OUTER JOIN &quot;B&quot; ON &quot;A&quot;.&quot;bId&quot; = &quot;B&quot;.&quot;id&quot;
    LEFT OUTER JOIN &quot;C&quot; ON &quot;A&quot;.&quot;cId&quot; = &quot;C&quot;.&quot;id&quot;
    WHERE (&quot;A&quot;.&quot;B.userId&quot; = &#39;100&#39;
           OR &quot;A&quot;.&quot;C.userId&quot; = &#39;100&#39;)

Is first query even possible with sequelize, or I should just stick to raw queries? 


Where condition for joined table in Sequelize ORM

Using NodeJS and Sequelize 2.0, I&#39;m writing a migration to create a new table. In addition to the primary key, I want to mark a second column to be enforced as unique. I can&#39;t find anything about this in the documentation.

    migration.createTable(&#39;data&#39;, {
        id: {
            type: DataTypes.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        key: {
            // needs to be unique
            type: DataTypes.UUID,
            allowNull: false
        }
    })
        .then(function () {
            done();
        });

All sequelize.js Solutions on Gang of Coders

Total of 41 sequelize.js Solutions