MCPcopy Create free account
hub / github.com/GoogleChrome/samples / dropAllTables

Function dropAllTables

web-sql-to-sqlite-wasm/script.js:94–117  ·  view source on GitHub ↗
()

Source from the content-addressed store, hash-verified

92};
93
94const dropAllTables = () => {
95 try {
96 db.transaction(function (tx) {
97 tx.executeSql(
98 "SELECT name FROM sqlite_master WHERE type='table' and name !='__WebKitDatabaseInfoTable__'",
99 [],
100 function (tx, result) {
101 const len = result.rows.length;
102 const tableNames = [];
103 for (let i = 0; i < len; i++) {
104 const tableName = result.rows.item(i).name;
105 tableNames.push(`'${tableName}'`);
106 db.transaction(function (tx) {
107 tx.executeSql('DROP TABLE ' + tableName);
108 });
109 }
110 pre.textContent = `Dropped table${tableNames.length > 1 ? 's' : ''}: ${tableNames.join(', ')}.`;
111 }
112 );
113 });
114 } catch (err) {
115 console.error(err.name, err.message);
116 }
117};
118
119webSQLCreateButton.addEventListener('click', () => createWebSQLDatabase());
120

Callers 1

script.jsFile · 0.85

Calls 1

errorMethod · 0.45

Tested by

no test coverage detected