org.xmlBlaster.contrib.dbwriter.info
Class SqlColumn

java.lang.Object
  org.xmlBlaster.contrib.dbwriter.info.SqlColumn

public class SqlColumn
extends java.lang.Object

Field Summary

static java.lang.String	AUTO_INCREMENT_ATTR
private boolean	autoInc
static java.lang.String	CASE_SENSITIVE_ATTR
private boolean	caseSens
private java.lang.String	catalog
static java.lang.String	CATALOG_ATTR
static java.lang.String	CHAR_OCTET_LENGTH_ATTR
private int	charLength
private java.lang.String	colDefault
private java.lang.String	colName
static java.lang.String	COLNAME_TAG
private int	colSize
static java.lang.String	COLUMN_DEF_ATTR
static java.lang.String	COLUMN_SIZE_ATTR
static java.lang.String	DATA_TYPE
static java.lang.String	DATA_TYPE_ATTR
static java.lang.String	DECIMAL_DIGITS_ATTR
static java.lang.String	FK_COLUMN_NAME_ATTR
static java.lang.String	FK_DEFERRABILITY_ATTR
static java.lang.String	FK_DELETE_RULE_ATTR
static java.lang.String	FK_KEY_SEQ_ATTR
static java.lang.String	FK_TABLE_CAT_ATTR
static java.lang.String	FK_TABLE_NAME_ATTR
static java.lang.String	FK_TABLE_SCHEM_ATTR
static java.lang.String	FK_UPDATE_RULE_ATTR
private java.lang.String	fkCatalog
private java.lang.String	fkCol
private java.lang.String	fkDef
private java.lang.String	fkDelRule
private java.lang.String	fkSchema
private java.lang.String	fkSeq
private java.lang.String	fkTable
private java.lang.String	fkUpdRule
private java.lang.String	label
static java.lang.String	LABEL_ATTR
private int	nullable
static java.lang.String	NULLABLE_ATTR
static java.lang.String	NUM_PREC_RADIX_ATTR
static java.lang.String	ORDINAL_POSITION_ATTR
static java.lang.String	PK_ATTR
static java.lang.String	PK_NAME_ATTR
private java.lang.String	pkName
private int	pos
private int	precision
static java.lang.String	PRECISION_ATTR
private boolean	primaryKey
private int	radix
private boolean	readOnly
private java.lang.String	remarks
static java.lang.String	REMARKS_ATTR
static java.lang.String	RO_ATTR
private int	scale
static java.lang.String	SCALE_ATTR
private java.lang.String	schema
static java.lang.String	SCHEMA_ATTR
private boolean	searchable
static java.lang.String	SEARCHABLE_ATTR
private boolean	signed
static java.lang.String	SIGNED_ATTR
private int	sqlType
private java.lang.String	table
static java.lang.String	TABLE_ATTR
private java.lang.String	type
static java.lang.String	TYPE_ATTR
static java.lang.String	TYPE_NAME_ATTR
private java.lang.String	typeName

Constructor Summary

SqlColumn(I_Info info)

Method Summary

SqlColumn	doClone()
ClientProperty	generateRandomObject()
java.lang.String	getCatalog()
int	getCharLength()
java.lang.String	getColDefault()
java.lang.String	getColName()
int	getColSize()
static SqlColumn	getComplete()
java.lang.String	getFkCatalog()
java.lang.String	getFkCol()
java.lang.String	getFkDef()
java.lang.String	getFkDelRule()
java.lang.String	getFkSchema()
java.lang.String	getFkSeq()
java.lang.String	getFkTable()
java.lang.String	getFkUpdRule()
java.lang.String	getLabel()
int	getNullable()
java.lang.String	getPkName()
int	getPos()
int	getPrecision()
int	getRadix()
java.lang.String	getRemarks()
int	getScale()
java.lang.String	getSchema()
int	getSqlType()
static java.lang.String	getSqlTypeAsText(int sqlType)
java.lang.String	getTable()
java.lang.String	getType()
java.lang.String	getTypeName()
boolean	isAutoInc()
boolean	isCaseSens()
boolean	isFk()
boolean	isPrimaryKey()
boolean	isReadOnly()
boolean	isSame(SqlColumn col)
private static boolean	isSameString(java.lang.String str1, java.lang.String str2)
boolean	isSearchable()
boolean	isSigned()
static void	main(java.lang.String[] args)
private ClientProperty	nextChar(java.util.Random random, int numOfChars)
private ClientProperty	nextDate(java.util.Random random)
private ClientProperty	nextNumber(java.util.Random random, int max)
void	setAutoInc(boolean autoInc)
void	setCaseSens(boolean caseSens)
void	setCatalog(java.lang.String catalog)
void	setCharLength(int charLength)
void	setColDefault(java.lang.String colDefault)
void	setColName(java.lang.String colName)
void	setColSize(int colSize)
void	setFkCatalog(java.lang.String fkCatalog)
void	setFkCol(java.lang.String fkCol)
void	setFkDef(java.lang.String fkDef)
void	setFkDelRule(java.lang.String fkDelRule)
void	setFkSchema(java.lang.String fkSchema)
void	setFkSeq(java.lang.String fkSeq)
void	setFkTable(java.lang.String fkTable)
void	setFkUpdRule(java.lang.String fkUpdRule)
void	setLabel(java.lang.String label)
void	setNullable(int nullable)
void	setPkName(java.lang.String pkName)
void	setPos(int pos)
void	setPrecision(int precision)
void	setPrimaryKey(boolean primaryKey)
void	setRadix(int radix)
void	setReadOnly(boolean readOnly)
void	setRemarks(java.lang.String remarks)
void	setScale(int scale)
void	setSchema(java.lang.String schema)
void	setSearchable(boolean searchable)
void	setSigned(boolean signed)
void	setSqlType(int sqlType)
void	setTable(java.lang.String table)
void	setType(java.lang.String type)
void	setTypeName(java.lang.String typeName)
private boolean	stringExists(java.lang.String str)
java.lang.String	toXml(java.lang.String extraOffset)

Methods inherited from class java.lang.Object

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

Field Detail

COLNAME_TAG

public static final java.lang.String COLNAME_TAG

See Also:

Constant Field Values

SCHEMA_ATTR

public static final java.lang.String SCHEMA_ATTR

See Also:

Constant Field Values

CATALOG_ATTR

public static final java.lang.String CATALOG_ATTR

See Also:

Constant Field Values

TABLE_ATTR

public static final java.lang.String TABLE_ATTR

See Also:

Constant Field Values

TYPE_ATTR

public static final java.lang.String TYPE_ATTR

See Also:

Constant Field Values

PRECISION_ATTR

public static final java.lang.String PRECISION_ATTR

See Also:

Constant Field Values

SCALE_ATTR

public static final java.lang.String SCALE_ATTR

See Also:

Constant Field Values

NULLABLE_ATTR

public static final java.lang.String NULLABLE_ATTR

See Also:

Constant Field Values

SIGNED_ATTR

public static final java.lang.String SIGNED_ATTR

See Also:

Constant Field Values

SEARCHABLE_ATTR

public static final java.lang.String SEARCHABLE_ATTR

See Also:

Constant Field Values

RO_ATTR

public static final java.lang.String RO_ATTR

See Also:

Constant Field Values

DATA_TYPE

public static final java.lang.String DATA_TYPE

See Also:

Constant Field Values

PK_ATTR

public static final java.lang.String PK_ATTR

See Also:

Constant Field Values

PK_NAME_ATTR

public static final java.lang.String PK_NAME_ATTR

See Also:

Constant Field Values

FK_TABLE_CAT_ATTR

public static final java.lang.String FK_TABLE_CAT_ATTR

See Also:

Constant Field Values

FK_TABLE_SCHEM_ATTR

public static final java.lang.String FK_TABLE_SCHEM_ATTR

See Also:

Constant Field Values

FK_TABLE_NAME_ATTR

public static final java.lang.String FK_TABLE_NAME_ATTR

See Also:

Constant Field Values

FK_COLUMN_NAME_ATTR

public static final java.lang.String FK_COLUMN_NAME_ATTR

See Also:

Constant Field Values

FK_KEY_SEQ_ATTR

public static final java.lang.String FK_KEY_SEQ_ATTR

See Also:

Constant Field Values

FK_UPDATE_RULE_ATTR

public static final java.lang.String FK_UPDATE_RULE_ATTR

See Also:

Constant Field Values

FK_DELETE_RULE_ATTR

public static final java.lang.String FK_DELETE_RULE_ATTR

See Also:

Constant Field Values

FK_DEFERRABILITY_ATTR

public static final java.lang.String FK_DEFERRABILITY_ATTR

See Also:

Constant Field Values

DATA_TYPE_ATTR

public static final java.lang.String DATA_TYPE_ATTR

See Also:

Constant Field Values

COLUMN_SIZE_ATTR

public static final java.lang.String COLUMN_SIZE_ATTR

See Also:

Constant Field Values

DECIMAL_DIGITS_ATTR

public static final java.lang.String DECIMAL_DIGITS_ATTR

See Also:

Constant Field Values

NUM_PREC_RADIX_ATTR

public static final java.lang.String NUM_PREC_RADIX_ATTR

See Also:

Constant Field Values

REMARKS_ATTR

public static final java.lang.String REMARKS_ATTR

See Also:

Constant Field Values

COLUMN_DEF_ATTR

public static final java.lang.String COLUMN_DEF_ATTR

See Also:

Constant Field Values

CHAR_OCTET_LENGTH_ATTR

public static final java.lang.String CHAR_OCTET_LENGTH_ATTR

See Also:

Constant Field Values

ORDINAL_POSITION_ATTR

public static final java.lang.String ORDINAL_POSITION_ATTR

See Also:

Constant Field Values

LABEL_ATTR

public static final java.lang.String LABEL_ATTR

See Also:

Constant Field Values

AUTO_INCREMENT_ATTR

public static final java.lang.String AUTO_INCREMENT_ATTR

See Also:

Constant Field Values

CASE_SENSITIVE_ATTR

public static final java.lang.String CASE_SENSITIVE_ATTR

See Also:

Constant Field Values

TYPE_NAME_ATTR

public static final java.lang.String TYPE_NAME_ATTR

See Also:

Constant Field Values

colName

private java.lang.String colName

table

private java.lang.String table

schema

private java.lang.String schema

catalog

private java.lang.String catalog

type

private java.lang.String type

precision

private int precision

scale

private int scale

nullable

private int nullable

searchable

private boolean searchable

signed

private boolean signed

readOnly

private boolean readOnly

primaryKey

private boolean primaryKey

pkName

private java.lang.String pkName

sqlType

private int sqlType

colSize

private int colSize

radix

private int radix

remarks

private java.lang.String remarks

colDefault

private java.lang.String colDefault

charLength

private int charLength

pos

private int pos

fkCatalog

private java.lang.String fkCatalog

fkSchema

private java.lang.String fkSchema

fkTable

private java.lang.String fkTable

fkCol

private java.lang.String fkCol

fkSeq

private java.lang.String fkSeq

fkUpdRule

private java.lang.String fkUpdRule

fkDelRule

private java.lang.String fkDelRule

fkDef

private java.lang.String fkDef

label

private java.lang.String label

autoInc

private boolean autoInc

caseSens

private boolean caseSens

typeName

private java.lang.String typeName

Constructor Detail

SqlColumn

public SqlColumn(I_Info info)

Method Detail

getCatalog

public java.lang.String getCatalog()

setCatalog

public void setCatalog(java.lang.String catalog)

getPrecision

public int getPrecision()

setPrecision

public void setPrecision(int precision)

isReadOnly

public boolean isReadOnly()

isSearchable

public boolean isSearchable()

setSearchable

public void setSearchable(boolean searchable)

setReadOnly

public void setReadOnly(boolean readOnly)

getScale

public int getScale()

setScale

public void setScale(int scale)

getSchema

public java.lang.String getSchema()

setSchema

public void setSchema(java.lang.String schema)

isSigned

public boolean isSigned()

getFkCatalog

public java.lang.String getFkCatalog()

setFkCatalog

public void setFkCatalog(java.lang.String fkCatalog)

getFkCol

public java.lang.String getFkCol()

setFkCol

public void setFkCol(java.lang.String fkCol)

getFkDef

public java.lang.String getFkDef()

setFkDef

public void setFkDef(java.lang.String fkDef)

getFkDelRule

public java.lang.String getFkDelRule()

setFkDelRule

public void setFkDelRule(java.lang.String fkDelRule)

getFkSchema

public java.lang.String getFkSchema()

setFkSchema

public void setFkSchema(java.lang.String fkSchema)

getFkSeq

public java.lang.String getFkSeq()

setFkSeq

public void setFkSeq(java.lang.String fkSeq)

getFkTable

public java.lang.String getFkTable()

setFkTable

public void setFkTable(java.lang.String fkTable)

getFkUpdRule

public java.lang.String getFkUpdRule()

setFkUpdRule

public void setFkUpdRule(java.lang.String fkUpdRule)

setSigned

public void setSigned(boolean signed)

getTable

public java.lang.String getTable()

setTable

public void setTable(java.lang.String table)

getType

public java.lang.String getType()

setSqlType

public void setSqlType(int sqlType)

getSqlType

public int getSqlType()

setType

public void setType(java.lang.String type)

getColName

public java.lang.String getColName()

setColName

public void setColName(java.lang.String colName)

isPrimaryKey

public boolean isPrimaryKey()

setPrimaryKey

public void setPrimaryKey(boolean primaryKey)

getNullable

public int getNullable()

setNullable

public void setNullable(int nullable)

getCharLength

public int getCharLength()

setCharLength

public void setCharLength(int charLength)

getColSize

public int getColSize()

setColSize

public void setColSize(int colSize)

getColDefault

public java.lang.String getColDefault()

setColDefault

public void setColDefault(java.lang.String colDefault)

getPos

public int getPos()

setPos

public void setPos(int pos)

getRadix

public int getRadix()

setRadix

public void setRadix(int radix)

getRemarks

public java.lang.String getRemarks()

setRemarks

public void setRemarks(java.lang.String remarks)

getPkName

public java.lang.String getPkName()

setPkName

public void setPkName(java.lang.String pkName)

isAutoInc

public boolean isAutoInc()

setAutoInc

public void setAutoInc(boolean autoInc)

isCaseSens

public boolean isCaseSens()

setCaseSens

public void setCaseSens(boolean caseSens)

getLabel

public java.lang.String getLabel()

setLabel

public void setLabel(java.lang.String label)

getTypeName

public java.lang.String getTypeName()

setTypeName

public void setTypeName(java.lang.String typeName)

stringExists

private boolean stringExists(java.lang.String str)

toXml

public java.lang.String toXml(java.lang.String extraOffset)

isFk

public boolean isFk()

getSqlTypeAsText

public static java.lang.String getSqlTypeAsText(int sqlType)

getComplete

public static SqlColumn getComplete()

main

public static void main(java.lang.String[] args)

isSameString

private static boolean isSameString(java.lang.String str1,
                                    java.lang.String str2)

isSame

public boolean isSame(SqlColumn col)

nextChar

private final ClientProperty nextChar(java.util.Random random,
                                      int numOfChars)

nextNumber

private final ClientProperty nextNumber(java.util.Random random,
                                        int max)

nextDate

private final ClientProperty nextDate(java.util.Random random)

generateRandomObject

public ClientProperty generateRandomObject()

doClone

public SqlColumn doClone()