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

Function createSQLiteDatabase

web-sql-to-sqlite-wasm/worker.js:6–40  ·  view source on GitHub ↗
(sqlite3, database, sql)

Source from the content-addressed store, hash-verified

4const error = (...messages) => console.error(...messages);
5
6const createSQLiteDatabase = (sqlite3, database, sql) => {
7 log(
8 'SQLite3 version',
9 sqlite3.capi.sqlite3_libversion(),
10 sqlite3.capi.sqlite3_sourceid()
11 );
12 let db;
13 const fileName = `/${database}.db`;
14 if (sqlite3.opfs) {
15 db = new sqlite3.oo1.OpfsDb(fileName);
16 log('The OPFS is available.');
17 } else {
18 db = new sqlite3.oo1.DB(fileName, 'ct');
19 log('The OPFS is not available.');
20 }
21 log('Transient db =', db.filename);
22
23 try {
24 sql.split(';').forEach((sqlStatement) => {
25 sqlStatement += ';';
26 db.exec(sqlStatement);
27 });
28 } catch (err) {
29 db.close();
30 console.error(err.name, err.message);
31 self.postMessage({
32 message: 'errorSQLiteDatabase',
33 error: `${err.name}: ${err.message}`,
34 });
35 return;
36 }
37 self.postMessage({
38 message: 'createdSQLiteDatabase'
39 });
40};
41
42self.sqlite3InitModule().then(function (sqlite3) {
43 try {

Callers 1

worker.jsFile · 0.70

Calls 3

logFunction · 0.70
closeMethod · 0.45
errorMethod · 0.45

Tested by

no test coverage detected