Package org.teichert.databaseexplorer.sqlitems

Class SQLTable

java.lang.Object

org.teichert.databaseexplorer.sqlitems.SQLTable

All Implemented Interfaces:

Serializable, Comparable<ISQLItem<SQLDatabase,SQLTable>>, IFilteredTreeItem, ISQLItem<SQLDatabase,SQLTable>

public class SQLTable
extends Object
implements IFilteredTreeItem, ISQLItem<SQLDatabase,SQLTable>

Represents a table of a SQLDatabase.
It contains information like its children, name, catalog, schema, indexes/primarykey-fields and foreign-keys
It also contains a list of SQLRow, which will hold the data per line if this SQLTable loaded content of an sql.

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor	Description
SQLTable(String name, TableType type)
SQLTable(String name, TableType type, List<SQLIndex> copyIndexes)
SQLTable(SQLTable table)	COPY CONSTRUCTOR

Method Summary

Modifier and Type	Method	Description
SQLTable	addChild(SQLTableColumn child)
SQLTable	addForeign(SQLForeignInfo child)
void	addIndex(SQLIndex index)
void	addPrimarykey(SQLTableColumn primaryKey)
void	addRow(SQLRow row)
SQLTable	addTrigger(SQLTrigger trigger)
void	clear()
void	clearCols()
void	clearIndexes()
void	clearRows()
int	compareTo(ISQLItem<SQLDatabase,SQLTable> o)
void	copyFrom(SQLTable table)
void	copyFrom(SQLTable table, boolean fullyLoad)
void	copyFrom(SQLTable table, boolean fullyLoad, boolean clearBeforeLoad)
boolean	equals(Object obj)
String	getCatalog()
SQLTableColumn	getColumnByName(String name)
int	getColumnCount()
List<SQLTableColumn>	getColumns()
SQLTableColumn[]	getColumnsAsArray()
String	getDisplayText()
int	getForeignCount()
List<SQLForeignInfo>	getForeigns()
SQLForeignInfo[]	getForeignsAsArray()
String	getIcon()
SQLIndex	getIndexByName(String name)
List<SQLIndex>	getIndexes()
String	getName()
SQLDatabase	getParent()
List<SQLTableColumn>	getPrimarys()
SQLTableColumn[]	getPrimarysAsArray()
List<SQLRow>	getRows()
String	getSchema()
List<SQLTrigger>	getTriggers()
TableType	getType()
boolean	hasChildren()
SQLTable	removeChild(SQLTableColumn child)
SQLTable	removeForeign(SQLForeignInfo child)
void	removeIndex(SQLIndex index)
void	removeRow(SQLRow row)
SQLTable	removeTrigger(SQLTrigger trigger)
SQLTable	setCatalog(String catalog)
void	setForeigns(List<SQLForeignInfo> foreigns)
SQLTable	setIcon(String icon)
void	setIndexes(List<SQLIndex> index)
SQLTable	setName(String name)
SQLTable	setParent(SQLDatabase parent)
void	setRows(List<SQLRow> rows)
SQLTable	setSchema(String schema)
SQLTable	setTriggers(List<SQLTrigger> triggers)
SQLTable	setType(TableType type)
String	toString()

Methods inherited from class java.lang.Object

clone, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SQLTable

public SQLTable(SQLTable table)

COPY CONSTRUCTOR

SQLTable

public SQLTable(String name,
                TableType type,
                List<SQLIndex> copyIndexes)

SQLTable

public SQLTable(String name,
                TableType type)

Method Detail

getName

public String getName()

Specified by:

getName in interface ISQLItem<SQLDatabase,SQLTable>

copyFrom

public void copyFrom(SQLTable table)

Specified by:

copyFrom in interface ISQLItem<SQLDatabase,SQLTable>

copyFrom

public void copyFrom(SQLTable table,
                     boolean fullyLoad)

copyFrom

public void copyFrom(SQLTable table,
                     boolean fullyLoad,
                     boolean clearBeforeLoad)

addChild

public SQLTable addChild(SQLTableColumn child)

removeChild

public SQLTable removeChild(SQLTableColumn child)

getColumnCount

public int getColumnCount()

addForeign

public SQLTable addForeign(SQLForeignInfo child)

removeForeign

public SQLTable removeForeign(SQLForeignInfo child)

getForeignCount

public int getForeignCount()

getTriggers

public List<SQLTrigger> getTriggers()

setTriggers

public SQLTable setTriggers(List<SQLTrigger> triggers)

addTrigger

public SQLTable addTrigger(SQLTrigger trigger)

removeTrigger

public SQLTable removeTrigger(SQLTrigger trigger)

getParent

public SQLDatabase getParent()

Specified by:

getParent in interface ISQLItem<SQLDatabase,SQLTable>

hasChildren

public boolean hasChildren()

getColumnByName

public SQLTableColumn getColumnByName(String name)

getCatalog

public String getCatalog()

getSchema

public String getSchema()

getIcon

public String getIcon()

getIndexByName

public SQLIndex getIndexByName(String name)

setIcon

public SQLTable setIcon(String icon)

setType

public SQLTable setType(TableType type)

getType

public TableType getType()

setParent

public SQLTable setParent(SQLDatabase parent)

Specified by:

setParent in interface ISQLItem<SQLDatabase,SQLTable>

setName

public SQLTable setName(String name)

setCatalog

public SQLTable setCatalog(String catalog)

setSchema

public SQLTable setSchema(String schema)

addRow

public void addRow(SQLRow row)

removeRow

public void removeRow(SQLRow row)

getRows

public List<SQLRow> getRows()

setRows

public void setRows(List<SQLRow> rows)

clearRows

public void clearRows()

addIndex

public void addIndex(SQLIndex index)

removeIndex

public void removeIndex(SQLIndex index)

getIndexes

public List<SQLIndex> getIndexes()

setIndexes

public void setIndexes(List<SQLIndex> index)

clearIndexes

public void clearIndexes()

clearCols

public void clearCols()

getPrimarys

public List<SQLTableColumn> getPrimarys()

getColumns

public List<SQLTableColumn> getColumns()

getForeigns

public List<SQLForeignInfo> getForeigns()

setForeigns

public void setForeigns(List<SQLForeignInfo> foreigns)

getPrimarysAsArray

public SQLTableColumn[] getPrimarysAsArray()

getColumnsAsArray

public SQLTableColumn[] getColumnsAsArray()

getForeignsAsArray

public SQLForeignInfo[] getForeignsAsArray()

getDisplayText

public String getDisplayText()

Specified by:

getDisplayText in interface IFilteredTreeItem

addPrimarykey

public void addPrimarykey(SQLTableColumn primaryKey)

toString

public String toString()

Overrides:

toString in class Object

equals

public boolean equals(Object obj)

Overrides:

equals in class Object

clear

public void clear()

Specified by:

clear in interface ISQLItem<SQLDatabase,SQLTable>

compareTo

public int compareTo(ISQLItem<SQLDatabase,SQLTable> o)

Specified by:

compareTo in interface Comparable<ISQLItem<SQLDatabase,SQLTable>>