[ https://issues.apache.org/jira/browse/NIFI-2156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15357544#comment-15357544 ]
ASF GitHub Bot commented on NIFI-2156: -------------------------------------- GitHub user mattyb149 opened a pull request: https://github.com/apache/nifi/pull/599 NIFI-2156: Add ListDatabaseTables processor You can merge this pull request into a Git repository by running: $ git pull https://github.com/mattyb149/nifi NIFI-2156 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/nifi/pull/599.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #599 ---- commit 81db08532a0939f7108cf9cd0d641f897e024d79 Author: Matt Burgess <mattyb...@apache.org> Date: 2016-06-30T17:49:41Z NIFI-2156: Add ListDatabaseTables processor ---- > Add ListDatabaseTables processor > -------------------------------- > > Key: NIFI-2156 > URL: https://issues.apache.org/jira/browse/NIFI-2156 > Project: Apache NiFi > Issue Type: Sub-task > Components: Extensions > Reporter: Matt Burgess > Assignee: Matt Burgess > Fix For: 1.0.0 > > > This processor would use a DatabaseConnectionPool controller service, call > getTables(), and if the (optional, defaulting-to-false) property "Include Row > Count" is set, then a "SELECT COUNT(1) from table" would be issued to the > database. The table catalog, schema, name, type, remarks (and its count if > specified) will be included as attributes in a zero-content flow file. > It will also use State Management to only list tables once. If new tables are > added (and the processor is running), then the new tables' flow files will be > generated. Changing any property that could affect the list of returned > tables (such as the DB Connection, catalog, schema pattern, table name > pattern, or table types) will reset the state and all tables will be fetched > using the new criteria. The state can also be manually cleared using the > standard Clear State link on the View State dialog (available on the > processor's context menu) -- This message was sent by Atlassian JIRA (v6.3.4#6332)