add tests for sqlite backend