com.hfg.sql.table

Class DatabaseTable<T extends DatabaseRow>

java.lang.Object

com.hfg.sql.table.DatabaseTable<T>

All Implemented Interfaces:

java.lang.Cloneable, java.lang.Comparable<DatabaseTable<T>>

public class DatabaseTable<T extends DatabaseRow>
extends java.lang.Object
implements java.lang.Cloneable, java.lang.Comparable<DatabaseTable<T>>

Database table object.

Constructor Summary

Constructors

Constructor and Description
DatabaseTable(java.lang.String inName, java.util.function.Function<java.sql.ResultSet,T> inResultSetConstructorFn)

Method Summary

Modifier and Type	Method and Description
void	addCol(DatabaseCol inCol)
DatabaseTable<T>	clone()
int	compareTo(DatabaseTable<T> inObj2)
void	drop(java.sql.Connection inConn)
boolean	equals(java.lang.Object inObj2)
boolean	exists(java.sql.Connection inConn)
java.lang.String	getAlias()
SQLQuery	getBaseQuery()
DatabaseCol	getCol(java.lang.String inColName)
java.util.List<DatabaseCol>	getCols()
static RDBMS	getDefaultRDBMS()
DatabaseCol	getIdCol()
java.lang.String	getQualifiedName()
RDBMS	getRDBMS()
T	getRow(java.sql.Connection inConn, java.util.List<SQLClause> inSQLClauses)
T	getRow(java.sql.Connection inConn, SQLClause inClause)
T	getRow(java.sql.Connection inConn, SQLQuery inQuery)
T	getRowById(java.sql.Connection inConn, java.lang.Integer inId)
T	getRowById(java.sql.Connection inConn, java.lang.Long inId)
java.util.List<T>	getRows(java.sql.Connection inConn)
java.util.List<T>	getRows(java.sql.Connection inConn, java.util.List<SQLClause> inSQLClauses)
java.util.List<T>	getRows(java.sql.Connection inConn, SQLClause... inClauses)
java.util.List<T>	getRows(java.sql.Connection inConn, SQLClause inClause)
java.util.List<T>	getRows(java.sql.Connection inConn, SQLQuery inQuery)
java.util.List<T>	getRows(java.sql.Connection inConn, SQLQuery inQuery, SQLStatementOptions inOptions)
Schema	getSchema()
java.util.Collection<DatabaseCol>	getTaggedCols(java.lang.String inTag)
int	hashCode()
java.lang.String	name()
void	renameTo(java.sql.Connection inConn, java.lang.String inNewName)
DatabaseTable	setAlias(java.lang.String inValue)
static void	setDefaultRDBMS(RDBMS inValue)
DatabaseTable<T>	setName(java.lang.String inValue)
DatabaseTable<T>	setRDBMS(RDBMS inValue)
DatabaseTable	setSchema(Schema inValue)
java.lang.String	toString()
void	truncate(java.sql.Connection inConn)

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

DatabaseTable

public DatabaseTable(java.lang.String inName,
                     java.util.function.Function<java.sql.ResultSet,T> inResultSetConstructorFn)

Method Detail

setDefaultRDBMS

public static void setDefaultRDBMS(RDBMS inValue)

getDefaultRDBMS

public static RDBMS getDefaultRDBMS()

setRDBMS

public DatabaseTable<T> setRDBMS(RDBMS inValue)

getRDBMS

public RDBMS getRDBMS()

compareTo

public int compareTo(DatabaseTable<T> inObj2)

Specified by:

compareTo in interface java.lang.Comparable<DatabaseTable<T extends DatabaseRow>>

equals

public boolean equals(java.lang.Object inObj2)

Overrides:

equals in class java.lang.Object

hashCode

public int hashCode()

Overrides:

hashCode in class java.lang.Object

setName

public DatabaseTable<T> setName(java.lang.String inValue)

name

public java.lang.String name()

getQualifiedName

public java.lang.String getQualifiedName()

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

clone

public DatabaseTable<T> clone()

Overrides:

clone in class java.lang.Object

setAlias

public DatabaseTable setAlias(java.lang.String inValue)

getAlias

public java.lang.String getAlias()

setSchema

public DatabaseTable setSchema(Schema inValue)

getSchema

public Schema getSchema()

getCols

public java.util.List<DatabaseCol> getCols()

getCol

public DatabaseCol getCol(java.lang.String inColName)

getTaggedCols

public java.util.Collection<DatabaseCol> getTaggedCols(java.lang.String inTag)

addCol

public void addCol(DatabaseCol inCol)

getIdCol

public DatabaseCol getIdCol()

getRow

public T getRow(java.sql.Connection inConn,
                SQLQuery inQuery)
         throws JDBCException

Throws:

JDBCException

getRow

public T getRow(java.sql.Connection inConn,
                java.util.List<SQLClause> inSQLClauses)
         throws JDBCException

Throws:

JDBCException

getRow

public T getRow(java.sql.Connection inConn,
                SQLClause inClause)
         throws JDBCException

Throws:

JDBCException

getRowById

public T getRowById(java.sql.Connection inConn,
                    java.lang.Long inId)
             throws JDBCException

Throws:

JDBCException

getRowById

public T getRowById(java.sql.Connection inConn,
                    java.lang.Integer inId)
             throws JDBCException

Throws:

JDBCException

getRows

public java.util.List<T> getRows(java.sql.Connection inConn)
                          throws JDBCException

Throws:

JDBCException

getRows

public java.util.List<T> getRows(java.sql.Connection inConn,
                                 java.util.List<SQLClause> inSQLClauses)
                          throws JDBCException

Throws:

JDBCException

getRows

public java.util.List<T> getRows(java.sql.Connection inConn,
                                 SQLClause inClause)
                          throws JDBCException

Throws:

JDBCException

getRows

public java.util.List<T> getRows(java.sql.Connection inConn,
                                 SQLClause... inClauses)
                          throws JDBCException

Throws:

JDBCException

getRows

public java.util.List<T> getRows(java.sql.Connection inConn,
                                 SQLQuery inQuery)
                          throws JDBCException

Throws:

JDBCException

getRows

public java.util.List<T> getRows(java.sql.Connection inConn,
                                 SQLQuery inQuery,
                                 SQLStatementOptions inOptions)
                          throws JDBCException

Throws:

JDBCException

getBaseQuery

public SQLQuery getBaseQuery()

exists

public boolean exists(java.sql.Connection inConn)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

drop

public void drop(java.sql.Connection inConn)
          throws java.sql.SQLException

Throws:

java.sql.SQLException

truncate

public void truncate(java.sql.Connection inConn)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

renameTo

public void renameTo(java.sql.Connection inConn,
                     java.lang.String inNewName)
              throws java.sql.SQLException

Throws:

java.sql.SQLException