Sails.js attribute type array in waterline mongoDB

Question

I want to create a model like below. users model having attribute agreements of type array.I was not able to find a example in waterline where attributes type is an array of object. Please advise `

module.exports = {

  attributes: {
    userName: {
      type: "string",
      unique: true,
      required: true
    },
    Name: {
      type: "string",
      required: true,
      minLength: 2
    },
    phone: {
      type: "string",
      required: true
    },
    password: {
      type: "string",
      minLength: 6

    },
    roles: {
      type: "array",
      required: true,
      enum: ['Admin', 'User']

    },
    agreements: {
       type : "array",
      agreement :{
        version : "string",
        dateSigned :"date",


      }

    },

`

Andi N. Dirgantara · Accepted Answer · 2015-07-08 15:05:13Z

1

Use one to many association.

Assume that your model is Model.js

agreements: { collection: 'Agreement', via : 'model' }

Create Agreement.js in models

module.exports: {
  attributes: {
    model      : { model: 'Model' },
    version    : { type: 'string' },
    dateSigned : { type: 'datetime' }
  }
}

See this documentation.

answered Jul 8, 2015 at 15:05

Andi N. Dirgantara

2,05114 silver badges20 bronze badges

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

3 Comments

batwadi Over a year ago

Its many to many relationship. Users must sign all agreements. and apart from agreement model i need to store some extra fields which are specific to particular user and agreement. Like (dateSigned , IP address and User agent of client machine) .

Alexis N-o Over a year ago

You could create a model (maybe named UserAgreement or AgreementSignature) that has a OneToMany relation to User, a OneToMany relation to Agreement and the attributes that you want.

Andi N. Dirgantara Over a year ago

It's true, all that you need is fixing your database structure and associations, because agreement : { version : "string", dateSigned :"date" } is not a valid configuration.

Collectives™ on Stack Overflow

Sails.js attribute type array in waterline mongoDB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related