Class SqlServerHistorySupport

    • 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.
      • 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