Skip to content

DM.js is a simple JavaScript ORM (loosely based on ActiveRecord) that supports the following sqlite browser backends: Safari/HTML5, Adobe Air, and Google Gears.

Notifications You must be signed in to change notification settings

mattmccray/dm.js

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DM.js

Requires Prototype 1.6+!

This project is still in the early phases.

What Works

  • HTML 5 and Google Gear back-ends
  • Simple models and schema generator
  • Base CRUD on models
  • Event callbacks for beforeCreate, afterCreate, beforeSave, and afterSave
  • Rudimentary Dataset class good for filtered reading of tables...

What Doesn't Work (Yet)

  • Adobe AIR back-end
  • Relationships (planned: hasMany, hasAndBelongsToMany, hasOne, belongsTo)
  • Finder WHERE clauses

Example Usage

In your application's initialization, you'll need to create the database object:

// the variable name doesn't matter...
var DB = new DM.Database({
  name:        'GraphicNovelist.db',
  displayName: 'Graphic Novelist',
  description: 'Graphic Novelist database... What?'
});

Now you can define your models:

var Script = new DM.Model('scripts', {
  
  // This is the schema builder function you'll need to fill out...
  schema: function(t){ 
    // An id field is automatically created for models
    t.text('title');
    t.text('source');
    t.text('html');
    // Creates created_on && updated_on
    t.timestamps('on');
    
    // Not implemented yet, but this is how it'll probably work...
    t.hasMany('Revision', { cascadeDelete:true });
    
    t.beforeSave(function(self){
      // use model#get and model#set to access attributes...
      var renderedSource = GraphicNovelist.render( self.get('source') );
      self.set('html', renderedSource );
    })
  }

  // Any model instance methods you'd like here...
});

After you've defined/included all of your models:

DM.Model.createModels(); // Executes CREATE TABLE IF EXISTS for each model's schema...

Creating a model instance:

var script = Script.create({ title:"A new title!" });

Typical model kinds of things to do:

script.save();

script.destroy();

Script.all(function(allScripts){
  // Since the HTML5 back-end is strictly asynchronous all
  // database access methods require callbacks to work with
  // the fetched models... 
  
  allScripts.each(function(script){
    // build DOM nodes, or whatever else you'd like...
  })
});

Script.find(1, function(script){
  // Script 1 stuff here...
});

Todo

  • Need WHERE builder so finders can actually be useful
  • Tests, tests, and more tests!

About

DM.js is a simple JavaScript ORM (loosely based on ActiveRecord) that supports the following sqlite browser backends: Safari/HTML5, Adobe Air, and Google Gears.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published