private StringBuilder getMainSql()

in src/main/java/com/epam/digital/data/platform/liquibase/extension/sqlgenerator/core/DdmCreateMany2ManyGenerator.java [55:79]


    private StringBuilder getMainSql(DdmCreateMany2ManyStatement statement) {
        StringBuilder buffer = new StringBuilder();

        buffer.append("SELECT ");
        buffer.append(statement.getMainTableName())
            .append(".")
            .append(statement.getMainTableKeyField());
        buffer.append(", UNNEST(")
            .append(statement.getMainTableName())
            .append(".")
            .append(statement.getReferenceKeysArray())
            .append(")");
        buffer.append(" AS ");
        buffer.append(statement.getReferenceColumnName());

        if (!statement.getMainTableColumns().isEmpty()) {
            buffer.append(", ");
            buffer.append(getListOfColumns(statement.getMainTableName(), statement.getMainTableColumns()));
        }

        buffer.append(" FROM ");
        buffer.append(statement.getMainTableName());

        return buffer;
    }