Examples with FlowFileTable org.apache.nifi.queryrecord.FlowFileTable used on opensource projects

Example 1 with FlowFileTable

use of org.apache.nifi.queryrecord.FlowFileTable in project nifi by apache.

the class QueryRecord method query.

protected QueryResult query(final ProcessSession session, final FlowFile flowFile, final String sql, final ProcessContext context, final RecordReaderFactory recordParserFactory) throws SQLException {
    final Properties properties = new Properties();
    properties.put(CalciteConnectionProperty.LEX.camelName(), Lex.MYSQL_ANSI.name());
    Connection connection = null;
    ResultSet resultSet = null;
    Statement statement = null;
    try {
        connection = DriverManager.getConnection("jdbc:calcite:", properties);
        final CalciteConnection calciteConnection = connection.unwrap(CalciteConnection.class);
        final SchemaPlus rootSchema = calciteConnection.getRootSchema();
        final FlowFileTable<?, ?> flowFileTable = new FlowFileTable<>(session, flowFile, recordParserFactory, getLogger());
        rootSchema.add("FLOWFILE", flowFileTable);
        rootSchema.setCacheEnabled(false);
        statement = connection.createStatement();
        resultSet = statement.executeQuery(sql);
        final ResultSet rs = resultSet;
        final Statement stmt = statement;
        final Connection conn = connection;
        return new QueryResult() {

            @Override
            public void close() throws IOException {
                closeQuietly(rs, stmt, conn);
            }

            @Override
            public ResultSet getResultSet() {
                return rs;
            }

            @Override
            public int getRecordsRead() {
                return flowFileTable.getRecordsRead();
            }
        };
    } catch (final Exception e) {
        closeQuietly(resultSet, statement, connection);
        throw e;
    }
}

Example 2 with FlowFileTable

use of org.apache.nifi.queryrecord.FlowFileTable in project nifi by apache.

the class QueryRecord method buildCachedStatement.

private CachedStatement buildCachedStatement(final String sql, final Supplier<CalciteConnection> connectionSupplier, final ProcessSession session, final FlowFile flowFile, final RecordReaderFactory recordReaderFactory) throws SQLException {
    final CalciteConnection connection = connectionSupplier.get();
    final SchemaPlus rootSchema = connection.getRootSchema();
    final FlowFileTable<?, ?> flowFileTable = new FlowFileTable<>(session, flowFile, recordReaderFactory, getLogger());
    rootSchema.add("FLOWFILE", flowFileTable);
    rootSchema.setCacheEnabled(false);
    final PreparedStatement stmt = connection.prepareStatement(sql);
    return new CachedStatement(stmt, flowFileTable, connection);
}