Demonstration for SQLite3 lock case

sqlite-transaction-test-passing.js

it('should be able to run normal queries inside transaction blocks', function() {

  return knex('accounts')
    .returning('id')
    .insert({
      first_name: 'Transacting',
      last_name: 'User',
      email:'transaction-test3@example.com',
      logins: 1,
      about: 'Lorem ipsum Dolore labore incididunt enim.',
      created_at: new Date(),
      updated_at: new Date()
    })
    .then(function(resp) {
      var id = resp[0];

      return knex.transaction(function(t) {
        var transactionless = knex('accounts').where('id', id).select('first_name')
          .then(function(resp) {
            expect(resp).to.have.length(1);
          });

        var Promise = require('bluebird');

        return Promise.all([
          transactionless,
          Promise.delay(100).then(t.commit)
        ]);
          
      });
    });
    
});

sqlite3-transaction-test-failing.js

it('should be able to run normal queries inside transaction blocks', function() {

  return knex('accounts')
    .returning('id')
    .insert({
      first_name: 'Transacting',
      last_name: 'User',
      email:'transaction-test3@example.com',
      logins: 1,
      about: 'Lorem ipsum Dolore labore incididunt enim.',
      created_at: new Date(),
      updated_at: new Date()
    })
    .then(function(resp) {
      var id = resp[0];

      return knex.transaction(function(t) {
        return knex('accounts').where('id', id).select('first_name')
          .then(function(resp) {
            expect(resp).to.have.length(1);
          })
          .finally(t.commit);
      });
    });
    
});