Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
Repository files navigation
A very simple Javascript statement builder for the SQLite databases.
example usage:
var smtBuild = new StatementBuilder();
smtBuild.createTable('people', 'name TEXT, age INTEGER');
smtBuild.insert('people', { name: 'Jeremy', age: 29 });
smtBuild.update('people', { age: 30 }, { name: 'Jeremy' });
smtBuild.select('people', '*', { age: 30 }, null);
smtBuild.destroy('people', { age: 30 });
Conditions can be:
* a number: defaults to 'WHERE id=number'
* a string: generates 'WHERE string'
* an array: generates 'WHERE val1 AND val2'
* a hash: generates 'WHERE key=hash[key] AND key2=hash[key2]'