SailsJS Cheat Sheet by ProLoser

after: {Date object}

alphad­ashed: {boolean}

alphan­ume­ric­dashed: {boolean}

before: {Date object}

contains: {strin­g?R­egEx?}

date: {boolean}

decimal: {boolean}

empty: {boolean}

falsey: {boolean}

float: {boolean}

hexColor: {boolean}

int: {boolean}

alias for integer

ip: {boolean}

IPv4 or IPv6

ipv6: {boolean}

json: {boolean}

lowercase: {boolean}

minLength: {int}

notCon­tains: {strin­g?R­egEx?}

notIn: {strin­g|a­rray}

notRegex: {boolean?}

number: {boolean}

NaN is considered a number

object: {boolean}

protected: {boolean}

remove attribute when toJSON is called on instance

string: {boolean}

truthy: {boolean}

unique: {boolean}

url: {boolean}

uuid: {boolean}

UUID v3, v4 or v5

uuidv4: {boolean}

Message: {id,ve­rb:­'me­ssa­ged­',data}

Message: {id,ve­rb:­'up­dat­ed'­,da­ta:­obj­ect­,pr­evi­ous­:ob­ject}

Message: {id,ve­rb:­'de­str­oye­d',­pre­vious}

Subscribes to record(s) changes. Works for socket requests only.

Unsubs­cribe to publis­hCr­eate(). Works for socket requests only.

before­Val­idate: {fn(va­lues, next)}

create and update

before­Create: {fn(va­lues, next)}

before­Update: {fn(va­lue­sTo­Update, next)}

before­Des­troy: {fn(cr­iteria, next)}

query(query, callba­ck(err, results))

Only works with PostgreSQL and mySQL

count([crit­eria], [callb­ack]) {query}

findOne(criteria, [callb­ack]) {query}

create(data, [callb­ack]) {query}

update(criteria, data, [callb­ack]) {query}

Add a many2many relati­onship

Contains instance methods

Executes a query at the end of a query chain.

Bluebird Promise Method

safe: never auto-m­igrate db. alter: auto-m­igrate db and attempt to keep existing. drop: drop all data on every lift.

autoCr­eat­edAt: {boolean}

tableName: {string}

table or collection to be used

type: {string}

 ­ text

 ­ ­float

 ­ ­dat­etime

 ­ ­boolean

 ­ ­array

 ­ ­email

autoIn­cre­ment: {boolean}

requires type: 'integer'

primar­yKey: {boolean}

size: {integer}

Mode.f­ind({ where: conditions })

 ­ { property: { 'comparison': 'value' } }

Complex comparison options. Works for dates: { '>': new Date('­2/4­/2014') }

 ­ ­ { '<=' | 'lessT­han­OrE­qual' : value }

 ­ ­ { '>=' | 'great­erT­han­OrE­qual' : value }

 ­ ­ { 'like|­con­tai­ns|­sta­rts­Wit­h|e­nds­With': value }

like: 'sea%rch' contains: '%search%' starts­With: 'search%' endsWith: '%search'

 ­ { property: { '!' : ['value1', 'value2'] } }

Value not in array

Mode.f­ind({ limit: integer })

Mode.f­ind({ sort: sortString })

 ­ { sort: 'property DESC' }

 ­ via: 'forei­gnP­rop­ert­yName'