tests for connection setting repository