Skip to content
 
 

Latest commit

 

History

12 Commits

Folders and files

NameName
Last commit message
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]'

About

A very simple javascript layer for a browser based SQLite database.

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages