com.hfg.sql.table

Class DatabaseTable<T extends DatabaseRow>

java.lang.Object

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

All Implemented Interfaces:

Cloneable, Comparable<DatabaseTable<T>>

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

Database table object.

Constructor Summary

Constructors

Constructor and Description
DatabaseTable(String inName, Function<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(Connection inConn)
boolean	equals(Object inObj2)
boolean	exists(Connection inConn)
String	getAlias()
SQLQuery	getBaseQuery()
DatabaseCol	getCol(String inColName)
List<DatabaseCol>	getCols()
static RDBMS	getDefaultRDBMS()
DatabaseCol	getIdCol()
String	getQualifiedName()
RDBMS	getRDBMS()
T	getRow(Connection inConn, List<SQLClause> inSQLClauses)
T	getRow(Connection inConn, SQLClause inClause)
T	getRow(Connection inConn, SQLQuery inQuery)
T	getRowById(Connection inConn, Integer inId)
T	getRowById(Connection inConn, Long inId)
int	getRowCount(Connection inConn)
int	getRowCount(Connection inConn, Collection<SQLClause> inSQLClauses)
int	getRowCount(Connection inConn, SQLClause inClause)
List<T>	getRows(Connection inConn)
List<T>	getRows(Connection inConn, List<SQLClause> inSQLClauses)
List<T>	getRows(Connection inConn, SQLClause... inClauses)
List<T>	getRows(Connection inConn, SQLClause inClause)
List<T>	getRows(Connection inConn, SQLQuery inQuery)
List<T>	getRows(Connection inConn, SQLQuery inQuery, SQLStatementOptions inOptions)
Schema	getSchema()
Collection<DatabaseCol>	getTaggedCols(String inTag)
int	hashCode()
String	name()
void	renameTo(Connection inConn, String inNewName)
DatabaseTable	setAlias(String inValue)
static void	setDefaultRDBMS(RDBMS inValue)
DatabaseTable<T>	setName(String inValue)
DatabaseTable<T>	setRDBMS(RDBMS inValue)
DatabaseTable	setSchema(Schema inValue)
String	toString()
void	truncate(Connection inConn)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseTable

public DatabaseTable(String inName,
                     Function<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 Comparable<DatabaseTable<T extends DatabaseRow>>

equals

public boolean equals(Object inObj2)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object

setName

public DatabaseTable<T> setName(String inValue)

name

public String name()

getQualifiedName

public String getQualifiedName()

toString

public String toString()

Overrides:

toString in class Object

clone

public DatabaseTable<T> clone()

Overrides:

clone in class Object

setAlias

public DatabaseTable setAlias(String inValue)

getAlias

public String getAlias()

setSchema

public DatabaseTable setSchema(Schema inValue)

getSchema

public Schema getSchema()

getCols

public List<DatabaseCol> getCols()

getCol

public DatabaseCol getCol(String inColName)

getTaggedCols

public Collection<DatabaseCol> getTaggedCols(String inTag)

addCol

public void addCol(DatabaseCol inCol)

getIdCol

public DatabaseCol getIdCol()

getRow

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

Throws:

JDBCException

getRow

public T getRow(Connection inConn,
                List<SQLClause> inSQLClauses)
         throws JDBCException

Throws:

JDBCException

getRow

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

Throws:

JDBCException

getRowById

public T getRowById(Connection inConn,
                    Long inId)
             throws JDBCException

Throws:

JDBCException

getRowById

public T getRowById(Connection inConn,
                    Integer inId)
             throws JDBCException

Throws:

JDBCException

getRows

public List<T> getRows(Connection inConn)
                throws JDBCException

Throws:

JDBCException

getRows

public List<T> getRows(Connection inConn,
                       List<SQLClause> inSQLClauses)
                throws JDBCException

Throws:

JDBCException

getRows

public List<T> getRows(Connection inConn,
                       SQLClause inClause)
                throws JDBCException

Throws:

JDBCException

getRows

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

Throws:

JDBCException

getRows

public List<T> getRows(Connection inConn,
                       SQLQuery inQuery)
                throws JDBCException

Throws:

JDBCException

getRows

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

Throws:

JDBCException

getRowCount

public int getRowCount(Connection inConn)
                throws SQLException

Throws:

SQLException

getRowCount

public int getRowCount(Connection inConn,
                       SQLClause inClause)
                throws SQLException

Throws:

SQLException

getRowCount

public int getRowCount(Connection inConn,
                       Collection<SQLClause> inSQLClauses)
                throws SQLException

Throws:

SQLException

getBaseQuery

public SQLQuery getBaseQuery()

exists

public boolean exists(Connection inConn)
               throws SQLException

Throws:

SQLException

drop

public void drop(Connection inConn)
          throws SQLException

Throws:

SQLException

truncate

public void truncate(Connection inConn)
              throws SQLException

Throws:

SQLException

renameTo

public void renameTo(Connection inConn,
                     String inNewName)
              throws SQLException

Throws:

SQLException