Skip to content

Instantly share code, notes, and snippets.

@bahkostya
Forked from partageit/reset-websql-database.js
Created March 11, 2021 14:15
Show Gist options
  • Save bahkostya/3fcf01df409a5cd26b95f3b579c642c6 to your computer and use it in GitHub Desktop.
Save bahkostya/3fcf01df409a5cd26b95f3b579c642c6 to your computer and use it in GitHub Desktop.
Reset WebSQL database dropping every tables
var db = openDatabase('myDatabase', '', 'My database description', 5 * 1024 * 1024);
if (reinitDb) {
db.changeVersion(db.version, '', function(t) {
t.executeSql("SELECT name FROM sqlite_master WHERE type='table' and name not like '__Webkit%'", [], function(sqlTransaction, sqlResultSet) {
var table, tablesNumber = sqlResultSet.rows.length;
console.log('DATABASE RESET MODE ENABLED');
for (var i = 0; i < tablesNumber; i++) {
table = sqlResultSet.rows.item(i);
console.log('Removing table: ' + table.name);
sqlTransaction.executeSql('DROP TABLE ' + table.name);
}
});
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment