@Override
    public Collection<LocalDataQueryResultRow> getRows(final ShowStorageUnitsStatement sqlStatement, final ContextManager contextManager) {
        Collection<LocalDataQueryResultRow> result = new LinkedList<>();
        for (Entry<String, StorageUnit> entry : getToBeShownStorageUnits(sqlStatement).entrySet()) {
            ConnectionProperties connectionProps = entry.getValue().getConnectionProperties();
            DataSourcePoolProperties dataSourcePoolProps = getDataSourcePoolProperties(entry.getValue());
            Map<String, Object> poolProps = dataSourcePoolProps.getPoolPropertySynonyms().getStandardProperties();
            Map<String, Object> customProps = getCustomProperties(dataSourcePoolProps.getCustomProperties().getProperties(), connectionProps.getQueryProperties());
            result.add(new LocalDataQueryResultRow(entry.getKey(),
                    entry.getValue().getStorageType().getType(),
                    connectionProps.getHostname(),
                    connectionProps.getPort(),
                    connectionProps.getCatalog(),
                    getStandardProperty(poolProps, "connectionTimeoutMilliseconds"),
                    getStandardProperty(poolProps, "idleTimeoutMilliseconds"),
                    getStandardProperty(poolProps, "maxLifetimeMilliseconds"),
                    getStandardProperty(poolProps, "maxPoolSize"),
                    getStandardProperty(poolProps, "minPoolSize"),
                    getStandardProperty(poolProps, "readOnly"),
                    customProps));
        }
        return result;
    }
@Test
    void assertGetRowsWithLikePattern() {
        Collection<LocalDataQueryResultRow> actual = executor.getRows(new ShowStorageUnitsStatement(mock(DatabaseSegment.class), "_0", null), mock(ContextManager.class));
        assertThat(actual.size(), is(1));
        LocalDataQueryResultRow row = actual.iterator().next();
        assertThat(row.getCell(1), is("ds_0"));
        assertThat(row.getCell(2), is("MySQL"));
        assertThat(row.getCell(3), is("localhost"));
        assertThat(row.getCell(4), is("3307"));
        assertThat(row.getCell(5), is("ds_0"));
        assertThat(row.getCell(6), is(""));
        assertThat(row.getCell(7), is(""));
        assertThat(row.getCell(8), is(""));
        assertThat(row.getCell(9), is("100"));
        assertThat(row.getCell(10), is("10"));
        assertThat(row.getCell(11), is(""));
        assertThat(row.getCell(12), is("{\"openedConnections\":[],\"closed\":false}"));
    }