Skip to content

Instantly share code, notes, and snippets.

@mike-luabase
Created June 13, 2022 11:51
Show Gist options
  • Save mike-luabase/e09ea0fd40e41833246834fc76c2aacb to your computer and use it in GitHub Desktop.
Save mike-luabase/e09ea0fd40e41833246834fc76c2aacb to your computer and use it in GitHub Desktop.
var supdb = openDatabase('mike@luabase.com', '262', 'blah', 2 * 1024 * 1024);
function successHandler(tx, results) {
var arr = []
console.log('found: ', results.rows.length)
for (let i = 0; i < results.rows.length; i++) {
let row = results.rows.item([i]);
arr.push(row)
}
console.log(arr)
}
function errorHandler(transaction, error) {
console.log(`Error : ${error.message}`);
}
function execSql(db, sql, q, successHandler) {
db.transaction(function (tx) {
tx.executeSql(sql, [], successHandler, errorHandler);
})
}
var sql = `
select *
from messages
limit 20
`
execSql(supdb, sql, '', successHandler)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment