added tests for new sqlite adapter