public class MSSQLDatabaseAdapter extends Object implements DatabaseAdapter
Constructor and Description |
---|
MSSQLDatabaseAdapter() |
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.
|
String |
unwrapIdentifier(String identifier)
Returns a bare identifier string by removing wrapping escape characters
from identifier strings such as table and column names.
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getTableAliasClause, getUpsertStatement, supportsUpsert
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)public String unwrapIdentifier(String identifier)
DatabaseAdapter
Returns a bare identifier string by removing wrapping escape characters from identifier strings such as table and column names.
The default implementation of this method removes double quotes. If the target database engine supports different escape characters, then its DatabaseAdapter implementation should override this method so that such escape characters can be removed properly.
unwrapIdentifier
in interface DatabaseAdapter
identifier
- An identifier which may be wrapped with escape charactersCopyright © 2020 Apache NiFi Project. All rights reserved.