| 1 |
|
| 2 | const sqlite3 = require('sqlite3').verbose();
|
| 3 | const path = require('path')
|
| 4 |
|
| 5 | const dbFile = path.resolve(__dirname, 'iswa2010.db')
|
| 6 | const db = new sqlite3.Database(dbFile)
|
| 7 |
|
| 8 | db.query = function (sql, params) {
|
| 9 | var that = this;
|
| 10 | return new Promise(function (resolve, reject) {
|
| 11 | that.all(sql, params, function (error, rows) {
|
| 12 | if (error)
|
| 13 | reject(error);
|
| 14 | else
|
| 15 | resolve( rows );
|
| 16 | });
|
| 17 | });
|
| 18 | };
|
| 19 |
|
| 20 | module.exports = { db };
|