Package org.teichert.databaseexplorer.sqlitems

Class SQLTableColumn

java.lang.Object

org.teichert.databaseexplorer.sqlitems.SQLTableColumn

All Implemented Interfaces:

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

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

Represents a Column of an SQLTable.
It contains information like its parent, its datatype, name, aliasname, constraintName and more..
It also provide a list of its foreignColumns of other tables.

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor	Description
SQLTableColumn(String name, String label, ColumnType type, SQLDataType dataType, long size)
SQLTableColumn(SQLTableColumn columnToCopy)

Method Summary

Modifier and Type	Method	Description
void	addForeignColumn(SQLForeignColumn foreignColumn)
void	addForeignColumn(SQLForeignColumn foreignColumn, boolean forceAdding)
void	addForeignColumn(SQLTableColumn column, boolean isManual)
void	clear()
int	compareTo(ISQLItem<SQLTable,SQLTableColumn> o)
void	copyFrom(SQLTableColumn t)
boolean	equals(Object obj)
String	getAdditionalType()
String	getAdditionDisplayText()
List<SQLForeignColumn>	getAllocatedColumns()
String	getConstraintName()
SQLDataType	getDatatype()
Serializable	getDefaultValue()
String	getDisplayText()
List<SQLForeignColumn>	getForeignColumns()	List of Foreign-Columns for this Column
String	getIcon()
String	getLabel()
String	getName()
SQLTable	getParent()
int	getPrecision()
long	getSize()
ColumnType	getType()
boolean	isAutoincrement()
boolean	isCombinedKey()
boolean	isNotNull()
boolean	isPrimaryKey()
boolean	removeForeignColumn(SQLForeignColumn foreignColumn)
SQLTableColumn	setAdditionalType(String additionalType)
void	setAllocatedColumns(List<SQLForeignColumn> allocatedColumns)
SQLTableColumn	setAutoincrement(boolean isAutoincrement)
static void	setColumnIcons(List<SQLTableColumn> columns)	Setzt nach dem ermitteln der primary_keys usw. die Icons fuer die entsprechenden Columns.
SQLTableColumn	setCombinedKey(boolean isCombinedKey)
void	setConstraintName(String constraintName)
SQLTableColumn	setDatatype(SQLDataType datatype)
SQLTableColumn	setDefaultValue(Serializable defaultValue)
SQLTableColumn	setIcon(String icon)
SQLTableColumn	setIsPrimaryKey(boolean isprimaryKey)
SQLTableColumn	setLabel(String label)
SQLTableColumn	setName(String name)
SQLTableColumn	setNotNull(boolean isNotNull)
SQLTableColumn	setParent(SQLTable parent)
SQLTableColumn	setPrecision(int precision)
static void	setPrimaryKeyStatus(List<SQLTableColumn> columns, List<SQLTableColumn> primarys)	Setzt die entsprechenden columns als primary-Feld, falls diese eines sind!
SQLTableColumn	setSize(long size)
SQLTableColumn	setType(ColumnType type)
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLTableColumn

public SQLTableColumn(String name,
                      String label,
                      ColumnType type,
                      SQLDataType dataType,
                      long size)

Parameters:

name - = Name of the column

label - = display name of the column

type - = column-type (normal, primary etc. see ColumnType)

dataType - = SQLDataType

SQLTableColumn

public SQLTableColumn(SQLTableColumn columnToCopy)

Method Detail

getName

public String getName()

Specified by:

getName in interface ISQLItem<SQLTable,SQLTableColumn>

getLabel

public String getLabel()

getType

public ColumnType getType()

getSize

public long getSize()

isAutoincrement

public boolean isAutoincrement()

getParent

public SQLTable getParent()

Specified by:

getParent in interface ISQLItem<SQLTable,SQLTableColumn>

getDatatype

public SQLDataType getDatatype()

getIcon

public String getIcon()

getAdditionalType

public String getAdditionalType()

getDefaultValue

public Serializable getDefaultValue()

getForeignColumns

public List<SQLForeignColumn> getForeignColumns()

List of Foreign-Columns for this Column

Returns:

addForeignColumn

public void addForeignColumn(SQLTableColumn column,
                             boolean isManual)

addForeignColumn

public void addForeignColumn(SQLForeignColumn foreignColumn)

addForeignColumn

public void addForeignColumn(SQLForeignColumn foreignColumn,
                             boolean forceAdding)

removeForeignColumn

public boolean removeForeignColumn(SQLForeignColumn foreignColumn)

isPrimaryKey

public boolean isPrimaryKey()

isCombinedKey

public boolean isCombinedKey()

isNotNull

public boolean isNotNull()

setName

public SQLTableColumn setName(String name)

setLabel

public SQLTableColumn setLabel(String label)

setCombinedKey

public SQLTableColumn setCombinedKey(boolean isCombinedKey)

setIsPrimaryKey

public SQLTableColumn setIsPrimaryKey(boolean isprimaryKey)

setIcon

public SQLTableColumn setIcon(String icon)

setDatatype

public SQLTableColumn setDatatype(SQLDataType datatype)

setParent

public SQLTableColumn setParent(SQLTable parent)

Specified by:

setParent in interface ISQLItem<SQLTable,SQLTableColumn>

setNotNull

public SQLTableColumn setNotNull(boolean isNotNull)

setAdditionalType

public SQLTableColumn setAdditionalType(String additionalType)

setPrecision

public SQLTableColumn setPrecision(int precision)

setDefaultValue

public SQLTableColumn setDefaultValue(Serializable defaultValue)

getPrecision

public int getPrecision()

setSize

public SQLTableColumn setSize(long size)

setType

public SQLTableColumn setType(ColumnType type)

setAutoincrement

public SQLTableColumn setAutoincrement(boolean isAutoincrement)

getConstraintName

public String getConstraintName()

setConstraintName

public void setConstraintName(String constraintName)

setAllocatedColumns

public void setAllocatedColumns(List<SQLForeignColumn> allocatedColumns)

getAllocatedColumns

public List<SQLForeignColumn> getAllocatedColumns()

copyFrom

public void copyFrom(SQLTableColumn t)

Specified by:

copyFrom in interface ISQLItem<SQLTable,SQLTableColumn>

setPrimaryKeyStatus

public static void setPrimaryKeyStatus(List<SQLTableColumn> columns,
                                       List<SQLTableColumn> primarys)

Setzt die entsprechenden columns als primary-Feld, falls diese eines sind!

Parameters:

columns -

primarys -

setColumnIcons

public static void setColumnIcons(List<SQLTableColumn> columns)

Setzt nach dem ermitteln der primary_keys usw. die Icons fuer die entsprechenden Columns.
Wenn diese Methode aufgerufen wird, MueSSEN die kompletten Columns mit allen Werten gef�llt und konfiguriert sein!

Parameters:

columns -

getAdditionDisplayText

public String getAdditionDisplayText()

getDisplayText

public String getDisplayText()

Specified by:

getDisplayText in interface IFilteredTreeItem

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<SQLTable,SQLTableColumn>

compareTo

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

Specified by:

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