SailsJS - How to specify string attribute length without getting error when creating record?

Question

I'm using Sails 0.9.8 paired with MySQL and wanting to do something like this

localhost:1337/player/view/<username of player>

instead of

localhost:1337/player/view/<id of player>

So I put something like this in the model:

'username' : {
        type: 'string',
        unique: true,
        minLength: 4,
        maxLength: 32,
        required: true
    },

But I've got an error whenever I run sails lift:

{ [Error: ER_TOO_LONG_KEY: Specified key was too long; max key length is 767 bytes] code: 'ER_TOO_LONG_KEY', index: 0 }

So after I run through the modules, I discovered that it was because by default Sails give string-type attribute a length of 255 in the database. The given length can be overridden with 'size', but it causes another error when creating a record.

'username' : {
        type: 'string',
        unique: true,
        minLength: 4,
        maxLength: 32,
        size: 32,
        required: true
    },

The error caused when creating a record:

Error: Unknown rule: size
at Object.match (<deleted>npm\node_modules\sails\node_modules\waterline\node_modules\anchor\lib\match.js:50:9)
at Anchor.to (<deleted>\npm\node_modules\sails\node_modules\waterline\node_modules\anchor\index.js:76:45)
at <deleted>\npm\node_modules\sails\node_modules\waterline\lib\waterline\core\validations.js:137:33

The question is, how do I specify the size of the string column (so that I can use the unique key) without getting an error when creating a record?

Im just guessing, but it looks like the problem is anchor doesn't have a rule defined. balderdashy/anchor can you submit an issue on the anchor repo? — NDBoost
– NDBoost, Commented Jan 26, 2014 at 17:20

marionebl · Accepted Answer · 2014-02-11 16:02:21Z

8

You could work around this by defining custom validation rules via the types object. Specifically the given problem could be solved by defining a custom size validator that always returns true.

// api/models/player.js
module.exports = {
  types: {
    size: function() {
       return true;
    }
  },

  attributes: {
    username: {
      type: 'string',
      unique: true,
      minLength: 4,
      maxLength: 32,
      size: 32,
      required: true
    }
  }
}

answered Feb 11, 2014 at 16:02

marionebl

3,40222 silver badges34 bronze badges

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

1 Comment

Febiyan Over a year ago

SOMEBODY GIVE THIS GUY A MEDAL!

rahulserver · Accepted Answer · 2018-05-11 01:18:56Z

2

The marked answer is quiet old. As per the latest sails version (1.0.2 as of the date of writing this answer),

I used the columnType attribute like this:

attributes: {

  longDescription: {
    type: 'string',
    columnType: 'text'
  }
}

answered May 11, 2018 at 1:18

rahulserver

11.3k28 gold badges96 silver badges177 bronze badges

1 Comment

Daniel Azamar Over a year ago

Man you rules!! That worked out for me!!! stackoverflow.com/a/50428226/3089077

Collectives™ on Stack Overflow

SailsJS - How to specify string attribute length without getting error when creating record?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related