Class SqlServerHistorySupport

  • All Implemented Interfaces:
    io.ebean.config.dbplatform.DbHistorySupport

    public class SqlServerHistorySupport
    extends io.ebean.config.dbplatform.DbStandardHistorySupport
    History support only valid on SqlServer 2016 or later.
    Author:
    Vilmos Nagy
    • Method Detail

      • 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: io.ebean.config.dbplatform.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