public abstract class DbViewHistorySupport extends Object implements DbHistorySupport
These implementations have explicit history tables, a view to union the base table and history table and triggers to maintain the history.
Constructor and Description |
---|
DbViewHistorySupport() |
Modifier and Type | Method and Description |
---|---|
String |
getAsOfPredicate(String asOfTableAlias,
String asOfSysPeriod)
Return the 'as of' predicate clause appended to the end of the normal query predicates.
|
String |
getAsOfViewSuffix(String asOfViewSuffix)
Returns the configured view suffix.
|
int |
getBindCount()
Return 2 if we have effective start and effective end as 2 columns.
|
String |
getSysPeriodLower(String tableAlias,
String sysPeriod)
Return the lower bound column prepended with the table alias.
|
String |
getSysPeriodUpper(String tableAlias,
String sysPeriod)
Return the upper bound column prepended with the table alias.
|
String |
getVersionsBetweenSuffix(String asOfViewSuffix)
Returns the configured view suffix (same as getAsOfViewSuffix()).
|
boolean |
isStandardsBased()
Return true if the implementation is SQL2011 standards based.
|
public DbViewHistorySupport()
public boolean isStandardsBased()
DbHistorySupport
Non standards based means we need to add additional predicates into the JOIN ON clause and add an additional predicate for the base table.
isStandardsBased
in interface DbHistorySupport
public String getAsOfViewSuffix(String asOfViewSuffix)
getAsOfViewSuffix
in interface DbHistorySupport
asOfViewSuffix
- the configured view suffix (typically "_with_history").public String getVersionsBetweenSuffix(String asOfViewSuffix)
getVersionsBetweenSuffix
in interface DbHistorySupport
asOfViewSuffix
- the configured view suffix (typically "_with_history").public int getBindCount()
getBindCount
in interface DbHistorySupport
public String getAsOfPredicate(String asOfTableAlias, String asOfSysPeriod)
getAsOfPredicate
in interface DbHistorySupport
asOfTableAlias
- The table alias this predicate is added forasOfSysPeriod
- The name of the 'sys_period' column used for effective date time range.public String getSysPeriodLower(String tableAlias, String sysPeriod)
getSysPeriodLower
in interface DbHistorySupport
tableAlias
- the table aliassysPeriod
- the name of the sys_period columnpublic String getSysPeriodUpper(String tableAlias, String sysPeriod)
getSysPeriodUpper
in interface DbHistorySupport
tableAlias
- the table aliassysPeriod
- the name of the sys_period columnCopyright © 2019. All rights reserved.