butler.ext.temporal
Class TemporalTable

java.lang.Object
  extended by butler.util.BaseGroovyObjectSupport
      extended by butler.sql.metadata.Table
          extended by butler.sql.metadata.GeneratedTable
              extended by 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