@Test
public void getCountOfDistinctKeys(){

    Connection connection = null;
    try {
        ConnectionManager connectionManager = temporaryFileDatabase.getConnectionManager(true);
        initWithTestData(connectionManager);
        connection = connectionManager.getConnection(null, noQueryOptions());
        int countOfDistinctKeys = DBQueries.getCountOfDistinctKeys(NAME, connection);
        assertEquals(3, countOfDistinctKeys);
    }finally {
        DBUtils.closeQuietly(connection);
    }
}