Examples with PageReader org.embulk.spi.PageReader used on opensource projects

Example 1 with PageReader

use of org.embulk.spi.PageReader in project MiscellaneousStudy by mikoto2000.

the class MyPageOutput method add.

@Override
public void add(Page page) {
    System.out.println("start MyPageOutput#add!");
    try (PageReader pageReader = new PageReader(inputSchema)) {
        pageReader.setPage(page);
        System.out.println("record count: " + PageReader.getRecordCount(page));
        int columnCount = inputSchema.getColumnCount();
        while (pageReader.nextRecord()) {
            // 行番号カラム
            pageBuilder.setLong(0, lineNumber);
            // 入力カラムたち
            pageBuilder.setLong(1, pageReader.getLong(0));
            pageBuilder.setLong(2, pageReader.getLong(1));
            pageBuilder.setTimestamp(3, pageReader.getTimestamp(2));
            pageBuilder.setTimestamp(4, pageReader.getTimestamp(3));
            pageBuilder.setString(5, pageReader.getString(4));
            // 追加文字列カラム
            pageBuilder.setString(6, "Additional String" + lineNumber++ + "!");
            // 編集したレコードを追加
            pageBuilder.addRecord();
        }
    }
}

Example 2 with PageReader

use of org.embulk.spi.PageReader in project embulk by embulk.

the class Pages method toObjects.

// TODO use streaming and return Iterable
public static List<Object[]> toObjects(Schema schema, Iterable<Page> pages) {
    ImmutableList.Builder<Object[]> builder = ImmutableList.builder();
    Iterator<Page> ite = pages.iterator();
    try (PageReader reader = new PageReader(schema)) {
        while (ite.hasNext()) {
            reader.setPage(ite.next());
            while (reader.nextRecord()) {
                builder.add(toObjects(reader));
            }
        }
    }
    return builder.build();
}

Example 3 with PageReader

use of org.embulk.spi.PageReader in project embulk by embulk.

the class RemoveColumnsFilterPlugin method open.

@Override
public PageOutput open(TaskSource taskSource, Schema inputSchema, Schema outputSchema, PageOutput output) {
    PluginTask task = taskSource.loadTask(PluginTask.class);
    PageReader pageReader = new PageReader(inputSchema);
    PageBuilder pageBuilder = new PageBuilder(getBufferAllocator(), outputSchema, output);
    return new PageConverter(pageReader, pageBuilder, task.getIndexMapping());
}

Example 4 with PageReader

use of org.embulk.spi.PageReader in project embulk by embulk.

the class CsvFormatterPlugin method open.

@Override
public PageOutput open(TaskSource taskSource, final Schema schema, FileOutput output) {
    final PluginTask task = taskSource.loadTask(PluginTask.class);
    final LineEncoder encoder = new LineEncoder(output, task);
    final TimestampFormatter[] timestampFormatters = Timestamps.newTimestampColumnFormatters(task, schema, task.getColumnOptions());
    final char delimiter = task.getDelimiterChar();
    final QuotePolicy quotePolicy = task.getQuotePolicy();
    final char quote = task.getQuoteChar() != '\0' ? task.getQuoteChar() : '"';
    final char escape = task.getEscapeChar().or(quotePolicy == QuotePolicy.NONE ? '\\' : quote);
    final String newlineInField = task.getNewlineInField().getString();
    final String nullString = task.getNullString();
    // create a file
    encoder.nextFile();
    // write header
    if (task.getHeaderLine()) {
        writeHeader(schema, encoder, delimiter, quotePolicy, quote, escape, newlineInField, nullString);
    }
    return new PageOutput() {

        private final PageReader pageReader = new PageReader(schema);

        private final String delimiterString = String.valueOf(delimiter);

        public void add(Page page) {
            pageReader.setPage(page);
            while (pageReader.nextRecord()) {
                schema.visitColumns(new ColumnVisitor() {

                    public void booleanColumn(Column column) {
                        addDelimiter(column);
                        if (!pageReader.isNull(column)) {
                            addValue(Boolean.toString(pageReader.getBoolean(column)));
                        } else {
                            addNullString();
                        }
                    }

                    public void longColumn(Column column) {
                        addDelimiter(column);
                        if (!pageReader.isNull(column)) {
                            addValue(Long.toString(pageReader.getLong(column)));
                        } else {
                            addNullString();
                        }
                    }

                    public void doubleColumn(Column column) {
                        addDelimiter(column);
                        if (!pageReader.isNull(column)) {
                            addValue(Double.toString(pageReader.getDouble(column)));
                        } else {
                            addNullString();
                        }
                    }

                    public void stringColumn(Column column) {
                        addDelimiter(column);
                        if (!pageReader.isNull(column)) {
                            addValue(pageReader.getString(column));
                        } else {
                            addNullString();
                        }
                    }

                    public void timestampColumn(Column column) {
                        addDelimiter(column);
                        if (!pageReader.isNull(column)) {
                            Timestamp value = pageReader.getTimestamp(column);
                            addValue(timestampFormatters[column.getIndex()].format(value));
                        } else {
                            addNullString();
                        }
                    }

                    public void jsonColumn(Column column) {
                        addDelimiter(column);
                        if (!pageReader.isNull(column)) {
                            Value value = pageReader.getJson(column);
                            addValue(value.toJson());
                        } else {
                            addNullString();
                        }
                    }

                    private void addDelimiter(Column column) {
                        if (column.getIndex() != 0) {
                            encoder.addText(delimiterString);
                        }
                    }

                    private void addValue(String v) {
                        encoder.addText(setEscapeAndQuoteValue(v, delimiter, quotePolicy, quote, escape, newlineInField, nullString));
                    }

                    private void addNullString() {
                        encoder.addText(nullString);
                    }
                });
                encoder.addNewLine();
            }
        }

        public void finish() {
            encoder.finish();
        }

        public void close() {
            encoder.close();
        }
    };
}