Package io.ebean.config.dbplatform.sqlserver

Class SqlServerHistorySupport

java.lang.Object

io.ebean.config.dbplatform.DbStandardHistorySupport

io.ebean.config.dbplatform.sqlserver.SqlServerHistorySupport

All Implemented Interfaces:

DbHistorySupport

public class SqlServerHistorySupport
extends DbStandardHistorySupport

History support only valid on SqlServer 2016 or later.

Author:

Vilmos Nagy

Constructor Summary

Constructors

Constructor	Description
SqlServerHistorySupport()

Method Summary

Modifier and Type	Method	Description
String	getAsOfViewSuffix(String asOfViewSuffix)	Return the ' as of timestamp ?' clause appended after the table name.
String	getSysPeriodLower(String tableAlias, String sysPeriod)	Returns the SQL Server specific effective start column.
String	getSysPeriodUpper(String tableAlias, String sysPeriod)	Returns the SQL Server specific effective end column.
String	getVersionsBetweenSuffix(String asOfViewSuffix)	Return the 'versions between timestamp' suffix.

Methods inherited from class io.ebean.config.dbplatform.DbStandardHistorySupport

getAsOfPredicate, getBindCount, isStandardsBased

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SqlServerHistorySupport

public SqlServerHistorySupport()

Method Details

getAsOfViewSuffix

public String getAsOfViewSuffix(String asOfViewSuffix)

Return the ' as of timestamp ?' clause appended after the table name.

Parameters:

asOfViewSuffix - the configured view suffix (typically "_with_history").

Returns:

The suffix appended after the base table name in the from and join clauses.

getVersionsBetweenSuffix

public String getVersionsBetweenSuffix(String asOfViewSuffix)

Description copied from interface: DbHistorySupport

Return the 'versions between timestamp' suffix.

getSysPeriodLower

public String getSysPeriodLower(String tableAlias,
String sysPeriod)

Returns the SQL Server specific effective start column.

Parameters:

tableAlias - the table alias which will typically be 't0'

sysPeriod - the name of the sys_period column

getSysPeriodUpper

public String getSysPeriodUpper(String tableAlias,
String sysPeriod)

Returns the SQL Server specific effective end column.

Parameters:

tableAlias - the table alias which will typically be 't0'

sysPeriod - the name of the sys_period column