public interface DbHistorySupport
Modifier and Type | Method and Description |
---|---|
String |
getAsOfPredicate(String tableAlias,
String sysPeriod)
Return the 'as of' predicate added for the given table alias.
|
String |
getAsOfViewSuffix(String asOfViewSuffix)
For sql2011 style this ignores the passed in view suffix and returns something
like the ' as of timestamp ?' clause to be appended after the base table name.
|
int |
getBindCount()
Return the number of columns bound in a 'As Of' predicate.
|
String |
getSysPeriodLower(String tableAlias,
String sysPeriod)
Return the column for the system period lower bound that will be included in findVersions() queries.
|
String |
getSysPeriodUpper(String tableAlias,
String sysPeriod)
Return the column for the system period upper bound that will be included in findVersions() queries.
|
String |
getVersionsBetweenSuffix(String asOfViewSuffix)
Return the 'versions between timestamp' suffix.
|
boolean |
isStandardsBased()
Return true if the implementation is SQL2011 standards based.
|
boolean isStandardsBased()
Non standards based means we need to add additional predicates into the JOIN ON clause and add an additional predicate for the base table.
int getBindCount()
This is 1 for more standard sql2011 style and Postgres which has the special range type and 2 for view based solutions with 2 columns such as MySql.
String getAsOfViewSuffix(String asOfViewSuffix)
asOfViewSuffix
- the configured view suffix (typically "_with_history").String getVersionsBetweenSuffix(String asOfViewSuffix)
String getAsOfPredicate(String tableAlias, String sysPeriod)
tableAlias
- The table alias this predicate is added forsysPeriod
- The name of the 'sys_period' column used for effective date time range.String getSysPeriodLower(String tableAlias, String sysPeriod)
tableAlias
- the table alias which will typically be 't0'sysPeriod
- the name of the sys_period columnString getSysPeriodUpper(String tableAlias, String sysPeriod)
tableAlias
- the table alias which will typically be 't0'sysPeriod
- the name of the sys_period columnCopyright © 2019. All rights reserved.