Class DbViewHistorySupport

    • Method Detail

      • isStandardsBased

        public boolean isStandardsBased()
        Description copied from interface: DbHistorySupport
        Return true if the implementation is SQL2011 standards based.

        Non standards based means we need to add additional predicates into the JOIN ON clause and add an additional predicate for the base table.

        Specified by:
        isStandardsBased in interface DbHistorySupport
      • getAsOfViewSuffix

        public String getAsOfViewSuffix​(String asOfViewSuffix)
        Returns the configured view suffix.
        Specified by:
        getAsOfViewSuffix in interface DbHistorySupport
        asOfViewSuffix - the configured view suffix (typically "_with_history").
        The suffix appended after the base table name in the from and join clauses.
      • getBindCount

        public int getBindCount()
        Return 2 if we have effective start and effective end as 2 columns. Note that for postgres we can use a single range type so that returns 1.
        Specified by:
        getBindCount in interface DbHistorySupport
      • getAsOfPredicate

        public String getAsOfPredicate​(String asOfTableAlias,
                                       String asOfSysPeriod)
        Return the 'as of' predicate clause appended to the end of the normal query predicates.
        Specified by:
        getAsOfPredicate in interface DbHistorySupport
        asOfTableAlias - The table alias this predicate is added for
        asOfSysPeriod - The name of the 'sys_period' column used for effective date time range.
        The predicate containing a single ? bind parameter which will be bound to the 'as at' timestamp value