butler.ext.temporal
Class TemporalTable

java.lang.Object
  butler.util.BaseGroovyObjectSupport
      butler.sql.metadata.Table
          butler.sql.metadata.GeneratedTable
              butler.ext.temporal.TemporalTable

All Implemented Interfaces:

groovy.lang.GroovyObject

public class TemporalTable
extends GeneratedTable

Author:

Fredrik Bertilsson

Field Summary

Fields inherited from class butler.sql.metadata.Table

_fks, _name, DUMMY

Constructor Summary

TemporalTable(java.lang.String name, Schema schema, boolean trans, boolean valid)

Method Summary

Record	findLast(butler.util.Tuple pk)
Record	findValid(butler.util.Tuple pk, java.sql.Date fromDate, java.sql.Date toDate)
Column	fromdate()
Column	transid()

Methods inherited from class butler.sql.metadata.GeneratedTable

load, loadAll, loadFKs

Methods inherited from class butler.sql.metadata.Table

addForeignKey, addIndex, addRecord, addRecordListener, addRelation, copy, create, createColumn, createColumn, createColumn, createColumn, createColumn, createColumn, createDeleteQuery, createQuery, createRecord, drop, equals, equals, exists, findAll, findByPK, findByPK, findByPK0, findByPKIfExists, findByPKIfExists, getAuthorizator, getCaption, getColumn, getColumns, getDatabase, getDataColumns, getExportedForeignKeys, getForeignKey, getForeignKey, getForeignKeyNames, getForeignKeys, getImportedForeignKeys, getIndex, getIndexes, getLocalizedCaption, getLogicalColumns, getName, getPath, getPhysicalColumns, getPhysicalName, getPrimaryKeyColumns, getProperty, getQualifiedName, getQuery, getRecordComparator, getRecordListeners, getRelation, getSchema, getTable, getTable, getValidator, hashCode, invokeMethod, isDummy, newRecord, registerColumn, registerQuery, setAuthorizator, setRecordComparator, setSchema, setValidator, toXML, unload, upgrade

Methods inherited from class butler.util.BaseGroovyObjectSupport

getMetaClass, setMetaClass, setProperty

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TemporalTable

public TemporalTable(java.lang.String name,
                     Schema schema,
                     boolean trans,
                     boolean valid)
              throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

transid

public Column transid()
               throws java.lang.Exception

Throws:

java.lang.Exception

fromdate

public Column fromdate()
                throws java.lang.Exception

Throws:

java.lang.Exception

findLast

public Record findLast(butler.util.Tuple pk)
                throws java.lang.Exception

Throws:

java.lang.Exception

findValid

public Record findValid(butler.util.Tuple pk,
                        java.sql.Date fromDate,
                        java.sql.Date toDate)
                 throws java.lang.Exception

Throws:

java.lang.Exception