var Schema = require('jugglingdb').Schema; var schema = new Schema('redis', {port: 6379}); //port number depends on your configuration // define models var Post = schema.define('Post', { title: { type: String, length: 255 }, content: { type: Schema.Text }, date: { type: Date, default: function () { return new Date;} }, timestamp: { type: Number, default: Date.now }, published: { type: Boolean, default: false, index: true } }); // simplier way to describe model var User = schema.define('User', { name: String, bio: Schema.Text, approved: Boolean, joinedAt: Date, age: Number }, { restPath: '/users' // tell WebService adapter which path use as API endpoint }); var Group = schema.define('Group', {name: String}); // define any custom method User.prototype.getNameAndAge = function () { return this.name + ', ' + this.age; }; // models also accessible in schema: schema.models.User; schema.models.Post;

// setup relationships User.hasMany(Post, {as: 'posts', foreignKey: 'userId'}); // creates instance methods: // user.posts(conds) // user.posts.build(data) // like new Post({userId: user.id}); // user.posts.create(data) // build and save Post.belongsTo(User, {as: 'author', foreignKey: 'userId'}); // creates instance methods: // post.author(callback) -- getter when called with function // post.author() -- sync getter when called without params // post.author(user) -- setter when called with object User.hasAndBelongsToMany('groups'); // user.groups(callback) - get groups of user // user.groups.create(data, callback) - create new group and connect with user // user.groups.add(group, callback) - connect existing group with user // user.groups.remove(group, callback) - remove connection between group and user schema.automigrate(); // required only for mysql and postgres NOTE: it will drop User and Post tables // work with models: var user = new User; user.save(function (err) { var post = user.posts.build({title: 'Hello world'}); post.save(console.log); }); // or just call it as function (with the same result): var user = User(); user.save(...); // Common API methods // each method returns promise, or may accept callback as last param // just instantiate model new Post({ published: 0, userId: 1 }); // save model (of course async) Post.create(); // all posts Post.all(); // all posts by user Post.all({ where: { userId: user.id }, order: 'id', limit: 10, skip: 20 }); // the same as prev user.posts(cb) // get one latest post Post.findOne({ where: { published: true }, order: 'date DESC' }); // same as new Post({userId: user.id}); user.posts.build({ published: 1 }); // save as Post.create({userId: user.id}); user.posts.create(); // find instance by id User.find(1); // find instance by id and reject promise when not found User.fetch(1) .then(user => console.log('found user', user)) .catch(err => console.error('can not fetch user with id 1:', err)); // count instances User.count([conditions]) // destroy instance user.destroy(); // destroy all instances User.destroyAll(); // update multiple instances (currently only on the sql adapters) Post.bulkUpdate({ update: { published: 0 }, where: { id: [1, 2, 3] }}); // update single instance Post.update(1, { published: 1 });

// Setup validations User.validatesPresenceOf('name', 'email') User.validatesLengthOf('password', {min: 5, message: {min: 'Password is too short'}}); User.validatesInclusionOf('gender', {in: ['male', 'female']}); User.validatesExclusionOf('domain', {in: ['www', 'billing', 'admin']}); User.validatesNumericalityOf('age', {int: true}); User.validatesUniquenessOf('email', {message: 'email is not unique'}); user.isValid(function (valid) { if (!valid) { user.errors // hash of errors {attr: [errmessage, errmessage, ...], attr: ...}  } })

var user = new User; // afterInitialize user.save(callback); // If Model.id isn't set, save will invoke Model.create() instead // beforeValidate // afterValidate // beforeSave // beforeUpdate // afterUpdate // afterSave // callback user.updateAttribute('email', 'email@example.com', callback); // beforeValidate // afterValidate // beforeSave // beforeUpdate // afterUpdate // afterSave // callback user.destroy(callback); // beforeDestroy // afterDestroy // callback User.create(data, callback); // beforeValidate // afterValidate // beforeCreate // beforeSave // afterSave // afterCreate // callback