/DBRS

Primary LanguageJavaScript

DBRS v0.0.1

Database REST Synchronise

Javascript ORM and synchronisation tool with REST API, based on WebSQL.

You just have to configure one file (DBRS/scripts/dbrs.conf.js) describing :

  • database(s)
  • model = table(s)
  • requests to your API

WARNING : work in progress (only get request on API).

##DEMO

http://k-yak.github.io/DBRS/

before do a getBy don't forget to create model

##TODO

###DBRS SCOPE

  • var db = dbrs.openDB(name) ✔
  • var dbs = dbrs.openDBs() ✔
  • var db = dbrs.createDB(name) ✔
  • var dbs = dbrs.createDBs() ✔

###DB SCOPE

  • db.updateAll() ... : change simple binding to two-way binding
  • db.clearAll() ✔
  • db.ping() ✔
  • db.dropTable(tableName) ✔
  • db.dropTables() ✔
  • var model = db.createModel() ✔
  • db.sql('SELECT * FROM table', onSuccess, on Error) ✔

###CLASS SCOPE

  • var obj = model.MyClass.getOneBy(fieldName, value, callback) ✔
  • var objs = model.MyClass.getManyBy(fieldName, value, callback) ✔
  • var objs = model.MyClass.getAll(callback) ✔
  • var obj = new model.MyClass() ✔
  • model.MyClass.update() ...

###OBJECT SCOPE

  • obj.save() ✔
  • obj.remove() ✔
  • obj.update() ✔/...
  • var obj2 = obj.clone() ✔
  • foreign key : 1 - 1 + 1 - N + N - N ...
  • var obj2 = obj.relation //1 - 1 ...
  • var objTabl = obj.relations //X - N ...