-
Notifications
You must be signed in to change notification settings - Fork 7
Storage APIs
Rob Parham edited this page Sep 25, 2017
·
2 revisions
jSQL databases are stored on the user's hard drive but are loaded into memory when jSQL is loaded. For query speed, all database operations are made in memory and are not saved to the user's hard drive until jSQL.commit() is called.
Register a callback to be fired when the database has been loaded into memory and is ready to be queried.
- onLoadCallback: A function to be called when the database has been loaded.
jSQL.load(function(){
jSQL.createTable('Users', ['Name', `Age`]).ifNotExists().execute();
var allUsers = jSQL.select('*').from('Users').execute().fetchAll('ASSOC');
});
jSQLTable.namejSQLTable.columnsjSQLTable.datajSQLTable.colmapjSQLTable.renameColumnjSQLTable.addColumnjSQLTable.loadDatajSQLTable.insertRow
jSQLQuery.ifNotExistsjSQLQuery.ignorejSQLQuery.executejSQLQuery.fetchjSQLQuery.fetchAlljSQLQuery.valuesjSQLQuery.setjSQLQuery.wherejSQLQuery.fromjSQLQuery.limitjSQLQuery.orderByjSQLQuery.ascjSQLQuery.descjSQLQuery.distinct
jSQLWhereClause.wherejSQLWhereClause.equalsjSQLWhereClause.preparedLikejSQLWhereClause.doesNotEqualjSQLWhereClause.lessThanjSQLWhereClause.containsjSQLWhereClause.endsWithjSQLWhereClause.beginsWithjSQLWhereClause.andjSQLWhereClause.orjSQLWhereClause.limitjSQLWhereClause.orderByjSQLWhereClause.ascjSQLWhereClause.descjSQLWhereClause.execute