constructor(config) { super(); this.config = { database: process.env.CUBEJS_DB_NAME, ...config }; if (!this.config.db) { this.config.db = new sqlite3.Database(this.config.database); } }
open(fileName) { return new Promise((resolve, reject) => { this.db = new sqlite3.Database(fileName, sqlite3.OPEN_READWRITE, (error) => { if (error === null) { resolve(); } else { reject(`SQLite::open ${error.message} while trying to open the following file: ${fileName}`); } }); }); }
// just open the DB... function openDatabase(cb) { console.log('openDatabase...'); var db = new sqlite3.Database(__dirname+'/sqlite-thing.db', function (err) { if (err) return cb(err); // strongly recommended for debugging SQLITE db.on('trace', function (item) { console.log('TRACE: ', item); }); cb(null, db); }); }
// LIBRARY describe('puresql.adapters.sqlite', () => { // create a connection the adapter will use const connection = new sqlite.Database(':memory:') const adapter = puresql.adapters.sqlite(connection) it('should escape a string correctly', () => { expect(adapter.escape('john')).to.equal("'john'") expect(adapter.escape(1)).to.equal(1) expect(adapter.escape("john' OR 'michael'")).to.equal("'john'' OR ''michael'''") }) it('should process a query correctly', (done) => { adapter.query('SELECT 1 AS foo') .then((rows) => { expect(rows[0]['foo']).to.equal(1) done() }) }) it('should throw a query error correctly', () => { expect(adapter.query('SELECT 1 A foo')).to.be.rejected }) it('should escape an identifier correctly', () => { expect(adapter.escapeIdentifier('id')).to.equal('id') }) })
test.before.cb(t => { fs.unlink(DB_PATH, err => { if (err && err.code !== `ENOENT`) { t.end(err); return; } db = new sqlite3.cached.Database(DB_PATH); controllerMock = { spawn: sinon.stub().returnsThis(), startRTM: sinon.stub().returnsThis(), hears: sinon.stub().returnsThis(), on: sinon.stub().returnsThis(), }; botkitMock = { slackbot: sinon.stub().returns(controllerMock), }; botMock = { reply: sinon.stub(), }; program = proxyquire(`../demo_bot`, { botkit: botkitMock, }); db.run(program.TABLE_SQL, t.end); }); });
this.engine.database = new sqlite3.Database('/var/defiant/sqlite.db'); break; // pre-enable
app = require('./../app').create(); server = app.listen(process.env.PORT || 4730); db = new sqlite3.Database(config.test.db.file, sqlite3.OPEN_READONLY);; done(); });
app = require('./../app').create(); server = app.listen(process.env.PORT || 4730); db = new sqlite3.Database(config.test.db.file, sqlite3.OPEN_READONLY);; done(); });
global.db = new sqlite3.Database
app = require('./../app').create(); server = app.listen(process.env.PORT || 4730); db = new sqlite3.Database(config.test.db.file, sqlite3.OPEN_READONLY);; done(); });
app = require('./../app').create(); server = app.listen(process.env.PORT || 4730); db = new sqlite3.Database(config.test.db.file, sqlite3.OPEN_READONLY);; done(); });
app = require('./../app').create(); server = app.listen(process.env.PORT || 4730); db = new sqlite3.Database(config.test.db.file, sqlite3.OPEN_READONLY);; done(); });
test.before.cb((t) => { fs.unlink(DB_PATH, (err) => { if (err && err.code !== `ENOENT`) { t.end(err); return; } db = new sqlite3.cached.Database(DB_PATH); controllerMock = { spawn: sinon.stub().returnsThis(), startRTM: sinon.stub().returnsThis(), hears: sinon.stub().returnsThis(), on: sinon.stub().returnsThis() }; botkitMock = { slackbot: sinon.stub().returns(controllerMock) }; botMock = { reply: sinon.stub() }; program = proxyquire(`../demo_bot`, { botkit: botkitMock }); db.run(program.TABLE_SQL, t.end); }); });
app = require('./../app').create(); server = app.listen(process.env.PORT || 4730); db = new sqlite3.Database(config.test.db.file, sqlite3.OPEN_READONLY);; done(); });