| 4 | const error = (...messages) => console.error(...messages); |
| 5 | |
| 6 | const 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 | |
| 42 | self.sqlite3InitModule().then(function (sqlite3) { |
| 43 | try { |