gears-dblib


A simple abstraction on top of the Database object in Gears

Allow db users to use objects as much as possible, and simplify the API where possible.

``` var db = new GearsDB('gears-test');

var bob = {id: 3, name: 'Bob', url: 'http://bob.com', description: 'whee'};
db.insertRow('person', bob);
db.insertRow('person', bob, 'name = ?', ['Bob']);

db.selectAll('select * from person', null, function(person) {
   document.getElementById('selectAll').innerHTML += ' ' + person.name;
});

db.selectRows('person', 'name like ?', ['%'], function(person) {
   document.getElementById('selectRows').innerHTML += ' ' + person.name;
});

var person = db.selectRow('person', 'id = 1');
document.getElementById('selectRow').innerHTML = person.name;  

// update
person.name = 'Harry';
db.updateRow('person', person);
person = db.selectRow('person', 'id = 1');
document.getElementById('updateRow').innerHTML = person.name;

// force
person.name = 'Sally';
db.forceRow('person', person);
person = db.selectRow('person', 'id = 1');
document.getElementById('forceRow').innerHTML = person.name;

var adam = {name: 'Adam', url: 'http://adam.com', description: 'long hair'};
db.forceRow('person', adam);
person = db.selectRow('person', 'id = 4');
document.getElementById('forceRow2').innerHTML = person.name;

db.deleteRow('person', bob);

```

Project Information

Labels:
gears javascript sql sqlite ajax offline