• EJB, Hibernate - Java
• Doctrine - PHP
  
• ADO.NET Entity Framework - .Net

• Defining as part of the model options

  var Book = sequelize.define('Book', {
      title:Sequelize.STRING  
      }
    }, 
    {
      getterMethods   : {
        title       : function()  {/* Return a value  */}
        },
      setterMethods   : {
        title       : function(v) { /*...*/ }
      }
  });
  

      is: /^[a-z]+$/i,          // RegExp
      not: ["[a-z]",'i'],       // will not allow letters
      isEmail: true,            // checks for email format (foo@bar.com)
      isUrl: true,              // checks for url format (http://foo.com)
      isAlpha: true,            // will only allow letters
      isNumeric: true           // will only allow numbers
      isInt: true,              // checks for valid integers
      isFloat: true,            // checks for valid floating point numbers
      isNull: true,             // only allows null
      len: [2,10],              // allow values with length between 2 and 10
      isDate: true,             // only allow date strings
      isAfter: "2011-11-05",    // allow date strings after a specific date
      isBefore: "2011-11-05",   // allow date strings before a specific date
      max: 23,                  // only allow values <= 23
      min: 23,                  // only allow values >= 23
      isCreditCard: true,       // check for valid credit card numbers

  isEven: function(value) {
        if(parseInt(value) % 2 != 0) {
          throw new Error('Only even values are allowed!')
        }
     }

 isInt: {
  msg: "Must be an integer number of pennies"
}

• find()
  
• returns a single entry

• findOrCreate()
  
• Check if an element exists and if not, create it

• findAndCountAll()
  
• Returns an object with two properties, the total number of records and an array of objects containing the records

  Project.findAndCountAll({
       where: ["title LIKE 'NodeJS%'"]
    })
    .success(function(result) {
      /* result.count and result.rows */
  });

• findAll()
  
• Search for multiple elements in the database

  Project.findAll().success(function(projects) {
    // returns all instances of projects
  });
  
  // Using where
  Project.findAll({
    where: {
      id: {
        gt: 6,              // id > 6  gte: 6  // id >= 6
        lt: 1,             // id < 1 lte: 1, // id <= 1
        ne: 20,             // id != 20
        between: [6, 10],   // BETWEEN 6 AND 10
        nbetween: [11, 15]  // NOT BETWEEN 11 AND 15
      }
    }
  });
  

• count()

   Project.count([where]).success(function(c) {});

• max()

   Project.max('Column', [where]).success(function(max) {});

• min()

   Project.min('Column', [where]).success(function(min) {});

• sum()

   Project.sum('Column', [where]).success(function(sum) {});

• build()
  
• Create an unsaved object

var Task = sequelize.define('Project', {
  title: Sequelize.STRING,
  rating: { type: Sequelize.STRING, defaultValue: 3 }
});
 
var task = Task.build({title: 'very important task'});

• create()
  
• create and store an instance

Task.create({ 
              title: 'Task 1', 
              description: 'A hard task', 
              deadline: new Date() })
           .success(function(task) {});

• save()
  

task.title = 'Another title';
task.save().success(function() {});

• updateAttributes()
• another way to update instance values

task.updateAttributes({
  title: 'Another title'
}, [<attributes to save>]).success(function() {});

As in save(), you can also specify which attributes to save

______________________________________________

Sequelize - A Node Js ORM library

• destroy()
• Delete an object from the database

 task.destroy().success(function() { });

• bulkCreate()
  
• Create bulks of instances

Task.bulkCreate([
  {subject: 'programming', status: 'executing'},
  {subject: 'reading', status: 'executing'},
  {subject: 'programming', status: 'finished'}
]).success(function() {});

 Task.update(
    {status: 'inactive'}, // set status = 'inactive'
    {subject: 'programming'} // where subject = 'programming'
  ).success(function(affectedRows) {});

• One-To-One
  
• One-To-Many
  
• Many-To-Many

Project.hasMany(User, { as: 'Workers' });
User.hasMany(Project);

var User = sequelize.define('User', {  username: DataTypes.STRING }, {  hooks: {
    beforeValidate: function(user, fn) {
      /*  fn(null, user); */
    }
  }
});

// another way to add a hook
User.hook('beforeValidate', function(user, fn) {
  /*  fn(null, user); */
});