Added Test coverage for basic functionality using in-memory SQLite database