DAOism

When you face the need to persist your application model entities, you inevitably end up with persistence routines for the common Create, Read, Update and Delete (CRUD) type of operations. And before long you will realize that these are actually quite similar between different entities, i.e. they are very generic in nature if you start thinking in a little higher level abstractions such as types and identifiers, instead of concrete entities and properties. JavaScript happens to be very good at realizing this into application model. So, instead of copying the same routine for each entity, it's natural to abstract into a framework that can handle entities persistence into data records and back to entities in a generic way. That's what DAOism is about.

In a nutshell, DAOism knows how to handle the CRUD operations on an entity, plus some extras, based on a minimal configuration that you feed it to specify, which are the persistent entity properties and how they map to data records. You can also customize it on different levels to get your favorite style of DAOs. Read the longer story on the project wikis

Example:

//Get a DAO instance with ORM configuration
var dao = require('daoism/dao').get({
	dbName: "TBL_A",
	properties: [
		{
			name: "id",
			dbName: "A_ID",
			id: true,
			required: true,
			type: "Long"
		},{
			name: "text",
			dbName: "A_TEXT",
			type: "String"
		}
	]
);

//Invoke CRUD ops on the DAO instance
var id = dao.insert({
              shortText: "aaa"
            });

var entity = dao.find(id);
console.info('Entity with id['+id+']: '+ JSON.stringify(entity, null,2));

console.info(dao.count() + ' entities counted');

var entities = dao.list();
console.info('Entities list: '+ JSON.stringify(entities, null,2));

dao.update({
      shortText: "bbb"
    });
console.info('Updated entity with id['+id+']: '+ JSON.stringify(dao.find(id), null,2));

dao.remove(id);
console.info(dao.count() + ' entities counted after remove');