public void testTimescaleDropColumnsGeneration()

in timescaledb-connector/src/integration-test/java/com/epam/deltix/timebase/connector/service/timescale/TimescaleSqlGeneratorTest.java [158:186]

• 24 lines of code
• 1 McCabe index (conditional complexity)

    public void testTimescaleDropColumnsGeneration() {
        String schemaName = "orders-123";
        TimescaleSchema schema = getValidSchema();

        TimescaleColumn dropColumn1 = TimescaleColumn.builder()
                .dataType(TimescaleColumn.TimescaleDataType.DECIMAL64)
                .name("balance")
                .build();

        TimescaleColumn dropColumn2 = TimescaleColumn.builder()
                .dataType(TimescaleColumn.TimescaleDataType.VARCHAR)
                .name("somename")
                .build();
        Set<TimescaleColumn> columns = new HashSet<>();
        columns.add(dropColumn1);
        columns.add(dropColumn2);

        String createTableStatement = sqlGenerator.generateCreateTableStatement(schema);
        String createHypertableStatement = sqlGenerator.generateHypertableStatement(schema);
        String dropColumnStatement = sqlGenerator.generateDropColumnStatement(schemaName, columns);

        dataService.executeQuery(createTableStatement);
        dataService.executeQuery(createHypertableStatement);
        dataService.executeQuery(dropColumnStatement);

        assertThat(dropColumnStatement, is(Matchers.oneOf(
                "ALTER TABLE \"orders-123\" DROP COLUMN somename, DROP COLUMN balance",
                "ALTER TABLE \"orders-123\" DROP COLUMN balance, DROP COLUMN somename")));
    }