SailsJS Cheat Sheet by ProLoser

after: {Date object}

alph­ada­shed: {bool­ean}

alph­anu­mer­icd­ash­ed: {bool­ean}

befo­re: {Date object}

cont­ains: {stri­ng?­Reg­Ex?}

date: {bool­ean}

deci­mal: {bool­ean}

empty: {bool­ean}

fals­ey: {bool­ean}

float: {bool­ean}

hexC­olor: {bool­ean}

int: {bool­ean}

alias for integer

ip: {bool­ean}

IPv4 or IPv6

ipv6: {bool­ean}

json: {bool­ean}

lowe­rca­se: {bool­ean}

minL­eng­th: {int}

notC­ont­ains: {stri­ng?­Reg­Ex?}

notIn: {stri­ng|­array}

notR­egex: {bool­ean?}

numb­er: {bool­ean}

NaN is considered a number

obje­ct: {bool­ean}

prot­ect­ed: {bool­ean}

remove attribute when toJSON is called on instance

stri­ng: {bool­ean}

trut­hy: {bool­ean}

uniq­ue: {bool­ean}

url: {bool­ean}

uuid: {bool­ean}

UUID v3, v4 or v5

uuid­v4: {bool­ean}

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 publ­ish­Cre­ate­(). Works for socket requests only.

befo­reV­ali­date: {fn(v­alues, next)}

create and update

befo­reC­rea­te: {fn(v­alues, next)}

befo­reU­pda­te: {fn(v­alu­esT­oUp­date, next)}

befo­reD­est­roy: {fn(c­rit­eria, next)}

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

Only works with PostgreSQL and mySQL

coun­t­([c­rit­eria], [callb­ack]) {query}

find­One­(­cri­teria, [callb­ack]) {query}

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

upda­te­(c­rit­eria, 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.

auto­Cre­ate­dAt: {bool­ean}

tabl­eNa­me: {string}

table or collection to be used

type: {string}

 ­ text

 ­ ­float

 ­ ­dat­etime

 ­ ­boolean

 ­ ­array

 ­ ­email

auto­Inc­rem­ent: {bool­ean}

requires type: 'integer'

prim­ary­Key: {bool­ean}

size: {inte­ger}

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

 ­ { property: { 'comp­ari­son': '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' cont­ains: '%sea­rch%' star­tsW­ith: 'sear­ch%' ends­With: '%sea­rch'

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

Value not in array

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

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

 ­ { sort: 'property DESC' }

 ­ ­v­ia: 'forei­gnP­rop­ert­yName'