mrded / waterline-nested

A simple helper, allows you to do nested creates and updates with Waterline 0.13 (Sails v1.0).

Waterline Nested

A simple helper, allows you to do nested creates and updates with Waterline 0.13 (Sails v1.0).

Installation

• Latest release
• npm install waterline-nested

Avaliable methods

• Nested.create(model, record)
• Nested.createEach(model, records)

	Argument	Type	Details
1	model	String	A model name.
2	record	Object	An Object that is to be created.
2	records	Array	A list of Objects to be created.

Returns: Promise

Usage

// ./api/models/User.js
// A user may have many pets
module.exports = {
  attributes: {
    firstName: { type: 'string' },
    lastName: { type: 'string' },

    // Add a reference to Pets
    pets: {
      collection: 'pet',
      via: 'owner'
    }
  }
};

// ./api/models/Pet.js
// A pet may only belong to a single user
module.exports = {
  attributes: {
    breed: { type: 'string' },
    type: { type: 'string' },
    name: { type: 'string' },

    // Add a reference to User
    owner: {
      model: 'user'
    }
  }
};

Now that the pets and users know about each other, they can be associated. To do this we can create or update a pet with the user's object inside.

var Nested = require('waterline-nested');

Nested.create('pet', {
  breed: 'labrador',
  type: 'dog',
  name: 'fido',
  owner: { // is User model.
    firstName: {
      type: 'Dmitry'
    },
    lastName: {
      type: 'Demenchuk'
    },
  }
}).exec(function(err) {});

It will automativaly create new user and create a pet associated with that user.

TODOs

• Add tests.
• Find a better way to integrate waterline-nested with waterline.

waterline-nested's Issues

Problem on creating nested array

When the nested association is an array, i get this error:

Could not use the provided where clause. Could not filter by translations: Cannot filter by translations because it is a plural association (which wouldn't make sense).

I think the problem is in that part

49: var output = mainModel.findOrCreate(_.clone(values), _.clone(values)).meta({fetch: true});

i guess it is because he wants to match the criteria with the array.

Hope you can solve that,

And nice, exactly what i needed... after sails omitting the nested update and create....

BR,
Kevin

Combine our efforts

Hi there!

Great work on this. We recently published a module that does something similar, although ours takes it a bit further to providing sails controller methods. We implemented this before we found your repo, but I think our library is a full superset of the functionality provided here. It's also intended to expand in scope to include nested updates, etc. I'd love to get your feedback on our version and see how we can combine our efforts!

https://github.com/smartprocure/sails-nested-blueprint