public class GenericDatabaseAdapter extends Object implements DatabaseAdapter
Constructor and Description |
---|
GenericDatabaseAdapter() |
Modifier and Type | Method and Description |
---|---|
String |
getDescription() |
String |
getName() |
String |
getSelectStatement(String tableName,
String columnNames,
String whereClause,
String orderByClause,
Long limit,
Long offset)
Returns a SQL SELECT statement with the given clauses applied.
|
String |
getSelectStatement(String tableName,
String columnNames,
String whereClause,
String orderByClause,
Long limit,
Long offset,
String columnForPartitioning)
Returns a SQL SELECT statement with the given clauses applied.
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getTableAliasClause, getUpsertStatement, supportsUpsert, unwrapIdentifier
public String getName()
getName
in interface DatabaseAdapter
public String getDescription()
getDescription
in interface DatabaseAdapter
public String getSelectStatement(String tableName, String columnNames, String whereClause, String orderByClause, Long limit, Long offset)
DatabaseAdapter
getSelectStatement
in interface DatabaseAdapter
tableName
- The name of the table to fetch rows fromcolumnNames
- The names of the columns to fetch from the tablewhereClause
- The filter to apply to the statement. This should not include the WHERE keywordorderByClause
- The columns/clause used for ordering the result rows. This should not include the ORDER BY keywordslimit
- The value for the LIMIT clause (i.e. the number of rows to return)offset
- The value for the OFFSET clause (i.e. the number of rows to skip)public String getSelectStatement(String tableName, String columnNames, String whereClause, String orderByClause, Long limit, Long offset, String columnForPartitioning)
DatabaseAdapter
getSelectStatement
in interface DatabaseAdapter
tableName
- The name of the table to fetch rows fromcolumnNames
- The names of the columns to fetch from the tablewhereClause
- The filter to apply to the statement. This should not include the WHERE keywordorderByClause
- The columns/clause used for ordering the result rows. This should not include the ORDER BY keywordslimit
- The value for the LIMIT clause (i.e. the number of rows to return)offset
- The value for the OFFSET clause (i.e. the number of rows to skip)columnForPartitioning
- The (optional) column name that, if provided, the limit and offset values are based on values from the column itself (rather than the row number)Copyright © 2020 Apache NiFi Project. All rights reserved.