Examples with Row org.openforis.collect.relational.data.Row used on opensource projects

Example 6 with Row

use of org.openforis.collect.relational.data.Row in project collect by openforis.

the class DataTableDataExtractor method extractRow.

private Row extractRow(Node<?> source) {
    List<Column<?>> columns = table.getColumns();
    Row row = new Row(table);
    for (int i = 0; i < columns.size(); i++) {
        Column<?> col = columns.get(i);
        Object val = extractColumnValue(source, col);
        row.setValue(i, val);
    }
    return row;
}

Example 7 with Row

use of org.openforis.collect.relational.data.Row in project collect by openforis.

the class RDBPrintTask method writeBatchInsert.

protected void writeBatchInsert(Table<?> table, DataExtractor extractor) throws IOException {
    if (extractor.hasNext()) {
        writer.write("INSERT INTO ");
        writer.write(getQualifiedName(table));
        writer.write('(');
        writer.write(StringUtils.join(doubleQuote(getColumnNames(table)), ", "));
        writer.write(')');
        writer.write(" VALUES ");
        writer.write('\n');
        while (extractor.hasNext()) {
            if (!isRunning()) {
                return;
            }
            Row row = extractor.next();
            writer.write('\t');
            writer.write('(');
            List<String> stringValues = getStringValues(row);
            writer.write(StringUtils.join(stringValues, ", "));
            writer.write(')');
            if (extractor.hasNext()) {
                writer.write(',');
                writer.write('\n');
            }
        }
        writer.write(';');
        writer.write('\n');
    }
}

Example 8 with Row

use of org.openforis.collect.relational.data.Row in project collect by openforis.

the class SqlWriter method writeBatchInsert.

protected void writeBatchInsert(Table<?> table, DataExtractor extractor) throws IOException {
    if (extractor.hasNext()) {
        writer.write("INSERT INTO ");
        writer.write(getQualifiedName(table));
        writer.write('(');
        writer.write(StringUtils.join(doubleQuote(getColumnNames(table)), ", "));
        writer.write(')');
        writer.write(" VALUES ");
        writer.write('\n');
        while (extractor.hasNext()) {
            Row row = extractor.next();
            writer.write('\t');
            writer.write('(');
            List<String> stringValues = getStringValues(row);
            writer.write(StringUtils.join(stringValues, ", "));
            writer.write(')');
            if (extractor.hasNext()) {
                writer.write(',');
                writer.write('\n');
            }
        }
        writer.write(';');
        writer.write('\n');
    }
}