com.xdev.jadoth.sqlengine.internal.tables

Class SqlTable

java.lang.Object

com.xdev.jadoth.sqlengine.internal.tables.SqlQualifiedIdentity

com.xdev.jadoth.sqlengine.internal.tables.SqlQualifiedIdentityWithAlias

com.xdev.jadoth.sqlengine.internal.tables.SqlTableIdentity

com.xdev.jadoth.sqlengine.internal.tables.SqlTable

All Implemented Interfaces:

TableExpression, Serializable

Direct Known Subclasses:

SqlDdlTable

public abstract class SqlTable
extends SqlTableIdentity

The Class SqlTable.

Author:

Thomas Muenz

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	SqlTable.Database The Class Database.
class	SqlTable.Indices The Class Indices.
static class	SqlTable.Sql The Class Sql.
class	SqlTable.Util The Class Util.

Nested classes/interfaces inherited from interface com.xdev.jadoth.sqlengine.internal.interfaces.TableExpression

TableExpression.Utils

Field Summary

Fields

Modifier and Type	Field and Description
protected SqlField[]	cachedFields The cached fields.
protected String[]	columnNames The column names.
protected DatabaseGateway<?>	databaseGateway The database gateway.
SqlTable.Database	db The db.
static String	LABEL_METHOD_BitmapIndex The Constant LABEL_METHOD_BitmapIndex.
static String	LABEL_METHOD_ForeignKey The Constant LABEL_METHOD_ForeignKey.
static String	LABEL_METHOD_Index The Constant LABEL_METHOD_Index.
static String	LABEL_METHOD_PrimaryKey The Constant LABEL_METHOD_PrimaryKey.
static String	LABEL_METHOD_UniqueIndex The Constant LABEL_METHOD_UniqueIndex.
protected static String	NOT_NULL The Constant NOT_NULL.
protected static String	NULL The Constant NULL.
protected SqlPrimaryKey	primaryKey The primary key.
protected static String	UNIQUE The Constant UNIQUE.
SqlTable.Util	util The util.

Constructor Summary

Constructors

Constructor and Description
SqlTable(SqlTable table, String alias) Instantiates a new sql table.
SqlTable(String schema, String name, String alias) Instantiates a new sql table.
SqlTable(String schema, String name, String alias, String[] columnNames) Instantiates a new sql table.

Method Summary

Modifier and Type	Method and Description
SqlTable	AS(String newAlias) AS.
protected static SqlField	BIGINT(String... params) BIGINT.
protected static SqlField	BINARY(int length, String... params) BINARY.
protected static SqlIndex	BitmapIndex(Object... columnList) Bitmap index.
protected static SqlField	BLOB(int length, String... params) BLOB.
protected static SqlField	BOOLEAN(String... params) BOOLEAN.
protected static SqlField	CHAR(int length, String... params) CHAR.
protected static SqlField	CLOB(int length, String... params) CLOB.
protected static SqlField	createColumn(SQL.DATATYPE type, int length, Integer precision, Integer scale, Object... params) Creates the column.
protected static SqlField	createColumn(String name, SQL.DATATYPE type, int length) Creates the column.
protected static SqlField	createColumn(String name, SQL.DATATYPE type, int length, Integer precision, Integer scale, boolean notNull, boolean unique, String defaultValue) Creates the column.
protected static SqlField	DATE(String... params) DATE.
protected static SqlField	DECIMAL(Integer precision, Integer scale, String... params) DECIMAL.
protected static SqlField	DECIMAL(Integer precision, String... params) DECIMAL.
protected static SqlField	DECIMAL(String... params) DECIMAL.
protected static SqlField	DOUBLE(String... params) DOUBLE.
protected static SqlField	FLOAT(String... params) FLOAT.
protected static SqlIndex	ForeignKey(Object... columnList) Foreign key.
protected DatabaseGateway<?>	getDatabaseGateway() Gets the database gateway.
protected SqlTable.Database	getDbIntern() Gets the db intern.
protected SqlTable.Indices	getIndicesIntern() Gets the indices intern.
protected SqlTable	getTopLevelInstance() Gets the top level instance.
protected static SqlIndex	Index(Object... columnList) Index.
protected void	initializeColumns() Initialize columns.
protected void	initializeIndices() Initialize indices.
protected static SqlField	INT(String... params) INT.
protected static SqlField	LONGVARBINARY(int length, String... params) LONGVARBINARY.
protected static SqlField	LONGVARCHAR(int length, String... params) LONGVARCHAR.
protected static SqlField	NCHAR(int length, String... params) NCHAR.
protected static SqlField	NUMERIC(Integer precision, Integer scale, String... params) NUMERIC.
protected static SqlField	NUMERIC(Integer precision, String... params) NUMERIC.
protected static SqlField	NUMERIC(String... params) NUMERIC.
protected static SqlField	NVARCHAR(int length, String... params) NVARCHAR.
protected static SqlPrimaryKey	PrimaryKey(Object... columnList) Primary key.
protected static SqlField	REAL(String... params) REAL.
protected SELECT[]	selectFromHirarchieFlat(Object[] columns) Select from hirarchie flat.
protected SELECT	selectFromHirarchieHirarchical(Object[] columns) Select from hirarchie hirarchical.
protected static SqlField	SMALLINT(String... params) SMALLINT.
SqlTable.Sql	sql()
protected static SqlField	TIME(String... params) TIME.
protected static SqlField	TIMESTAMP(String... params) TIMESTAMP.
protected static SqlField	TINYINT(String... params) TINYINT.
protected static SqlIndex	UniqueIndex(Object... columnList) Unique index.
protected static SqlField	VARBINARY(int length, String... params) VARBINARY.
protected static SqlField	VARCHAR(int length, String... params) VARCHAR.

Methods inherited from class com.xdev.jadoth.sqlengine.internal.tables.SqlTableIdentity

equals, hashCode

Methods inherited from class com.xdev.jadoth.sqlengine.internal.tables.SqlQualifiedIdentity

toString

Methods inherited from class java.lang.Object

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

Field Detail

LABEL_METHOD_PrimaryKey

public static final String LABEL_METHOD_PrimaryKey

The Constant LABEL_METHOD_PrimaryKey.

See Also:

Constant Field Values

LABEL_METHOD_ForeignKey

public static final String LABEL_METHOD_ForeignKey

The Constant LABEL_METHOD_ForeignKey.

See Also:

Constant Field Values

LABEL_METHOD_Index

public static final String LABEL_METHOD_Index

The Constant LABEL_METHOD_Index.

See Also:

Constant Field Values

LABEL_METHOD_BitmapIndex

public static final String LABEL_METHOD_BitmapIndex

The Constant LABEL_METHOD_BitmapIndex.

See Also:

Constant Field Values

LABEL_METHOD_UniqueIndex

public static final String LABEL_METHOD_UniqueIndex

The Constant LABEL_METHOD_UniqueIndex.

See Also:

Constant Field Values

NULL

protected static final String NULL

The Constant NULL.

See Also:

Constant Field Values

NOT_NULL

protected static final String NOT_NULL

The Constant NOT_NULL.

UNIQUE

protected static final String UNIQUE

The Constant UNIQUE.

See Also:

Constant Field Values

db

public final SqlTable.Database db

The db.

util

public final SqlTable.Util util

The util.

databaseGateway

protected DatabaseGateway<?> databaseGateway

The database gateway.

cachedFields

protected SqlField[] cachedFields

The cached fields.

columnNames

protected String[] columnNames

The column names.

primaryKey

protected SqlPrimaryKey primaryKey

The primary key.

Constructor Detail

SqlTable

public SqlTable(String schema,
                String name,
                String alias)

Instantiates a new sql table.

Parameters:

schema - the schema

name - the name

alias - the alias

SqlTable

public SqlTable(SqlTable table,
                String alias)

Instantiates a new sql table.

Parameters:

table - the table

alias - the alias

SqlTable

public SqlTable(String schema,
                String name,
                String alias,
                String[] columnNames)

Instantiates a new sql table.

Parameters:

schema - the schema

name - the name

alias - the alias

columnNames - the column names

Method Detail

createColumn

protected static SqlField createColumn(SQL.DATATYPE type,
                                       int length,
                                       Integer precision,
                                       Integer scale,
                                       Object... params)

Creates the column.

Parameters:

type - the type

length - the length

precision - the precision

scale - the scale

params - the params

Returns:

the sql field

createColumn

protected static SqlField createColumn(String name,
                                       SQL.DATATYPE type,
                                       int length)

Creates the column.

Parameters:

name - the name

type - the type

length - the length

Returns:

the sql field

createColumn

protected static SqlField createColumn(String name,
                                       SQL.DATATYPE type,
                                       int length,
                                       Integer precision,
                                       Integer scale,
                                       boolean notNull,
                                       boolean unique,
                                       String defaultValue)

Creates the column.

Parameters:

name - the name

type - the type

length - the length

precision - the precision

scale - the scale

notNull - the not null

unique - the unique

defaultValue - the default value

Returns:

the sql field

TINYINT

protected static final SqlField TINYINT(String... params)

TINYINT.

Parameters:

params - the params

Returns:

the sql field

SMALLINT

protected static final SqlField SMALLINT(String... params)

SMALLINT.

Parameters:

params - the params

Returns:

the sql field

INT

protected static final SqlField INT(String... params)

INT.

Parameters:

params - the params

Returns:

the sql field

BIGINT

protected static final SqlField BIGINT(String... params)

BIGINT.

Parameters:

params - the params

Returns:

the sql field

BOOLEAN

protected static final SqlField BOOLEAN(String... params)

BOOLEAN.

Parameters:

params - the params

Returns:

the sql field

CHAR

protected static final SqlField CHAR(int length,
                                     String... params)

CHAR.

Parameters:

length - the length

params - the params

Returns:

the sql field

VARCHAR

protected static final SqlField VARCHAR(int length,
                                        String... params)

VARCHAR.

Parameters:

length - the length

params - the params

Returns:

the sql field

NCHAR

protected static final SqlField NCHAR(int length,
                                      String... params)

NCHAR.

Parameters:

length - the length

params - the params

Returns:

the sql field

NVARCHAR

protected static final SqlField NVARCHAR(int length,
                                         String... params)

NVARCHAR.

Parameters:

length - the length

params - the params

Returns:

the sql field

BINARY

protected static final SqlField BINARY(int length,
                                       String... params)

BINARY.

Parameters:

length - the length

params - the params

Returns:

the sql field

VARBINARY

protected static final SqlField VARBINARY(int length,
                                          String... params)

VARBINARY.

Parameters:

length - the length

params - the params

Returns:

the sql field

REAL

protected static final SqlField REAL(String... params)

REAL.

Parameters:

params - the params

Returns:

the sql field

FLOAT

protected static final SqlField FLOAT(String... params)

FLOAT.

Parameters:

params - the params

Returns:

the sql field

DOUBLE

protected static final SqlField DOUBLE(String... params)

DOUBLE.

Parameters:

params - the params

Returns:

the sql field

NUMERIC

protected static final SqlField NUMERIC(String... params)

NUMERIC.

Parameters:

params - the params

Returns:

the sql field

NUMERIC

protected static final SqlField NUMERIC(Integer precision,
                                        String... params)

NUMERIC.

Parameters:

precision - the precision

params - the params

Returns:

the sql field

NUMERIC

protected static final SqlField NUMERIC(Integer precision,
                                        Integer scale,
                                        String... params)

NUMERIC.

Parameters:

precision - the precision

scale - the scale

params - the params

Returns:

the sql field

DECIMAL

protected static final SqlField DECIMAL(String... params)

DECIMAL.

Parameters:

params - the params

Returns:

the sql field

DECIMAL

protected static final SqlField DECIMAL(Integer precision,
                                        String... params)

DECIMAL.

Parameters:

precision - the precision

params - the params

Returns:

the sql field

DECIMAL

protected static final SqlField DECIMAL(Integer precision,
                                        Integer scale,
                                        String... params)

DECIMAL.

Parameters:

precision - the precision

scale - the scale

params - the params

Returns:

the sql field

TIME

protected static final SqlField TIME(String... params)

TIME.

Parameters:

params - the params

Returns:

the sql field

DATE

protected static final SqlField DATE(String... params)

DATE.

Parameters:

params - the params

Returns:

the sql field

TIMESTAMP

protected static final SqlField TIMESTAMP(String... params)

TIMESTAMP.

Parameters:

params - the params

Returns:

the sql field

LONGVARCHAR

protected static final SqlField LONGVARCHAR(int length,
                                            String... params)

LONGVARCHAR.

Parameters:

length - the length

params - the params

Returns:

the sql field

LONGVARBINARY

protected static final SqlField LONGVARBINARY(int length,
                                              String... params)

LONGVARBINARY.

Parameters:

length - the length

params - the params

Returns:

the sql field

BLOB

protected static final SqlField BLOB(int length,
                                     String... params)

BLOB.

Parameters:

length - the length

params - the params

Returns:

the sql field

CLOB

protected static final SqlField CLOB(int length,
                                     String... params)

CLOB.

Parameters:

length - the length

params - the params

Returns:

the sql field

PrimaryKey

protected static final SqlPrimaryKey PrimaryKey(Object... columnList)

Primary key.

Parameters:

columnList - the column list

Returns:

the sql primary key

ForeignKey

protected static final SqlIndex ForeignKey(Object... columnList)

Foreign key.

Parameters:

columnList - the column list

Returns:

the sql index

Index

protected static final SqlIndex Index(Object... columnList)

Index.

Parameters:

columnList - the column list

Returns:

the sql index

BitmapIndex

protected static final SqlIndex BitmapIndex(Object... columnList)

Bitmap index.

Parameters:

columnList - the column list

Returns:

the sql index

UniqueIndex

protected static final SqlIndex UniqueIndex(Object... columnList)

Unique index.

Parameters:

columnList - the column list

Returns:

the sql index

sql

public SqlTable.Sql sql()

Overrides:

sql in class SqlTableIdentity

AS

public SqlTable AS(String newAlias)
            throws SQLEngineException

Description copied from interface: TableExpression

AS.

Specified by:

AS in interface TableExpression

Overrides:

AS in class SqlTableIdentity

Parameters:

newAlias -

Returns:

Throws:

SQLEngineException

See Also:

SqlTableIdentity.AS(java.lang.String)

getTopLevelInstance

protected SqlTable getTopLevelInstance()

Description copied from class: SqlTableIdentity

Gets the top level instance.

Overrides:

getTopLevelInstance in class SqlTableIdentity

Returns:

See Also:

SqlTableIdentity.getTopLevelInstance()

initializeColumns

protected void initializeColumns()

Initialize columns.

Parameters:

forceInitialize - the force initialize

initializeIndices

protected void initializeIndices()

Initialize indices.

Parameters:

forceInitialize - the force initialize

getDatabaseGateway

protected DatabaseGateway<?> getDatabaseGateway()

Gets the database gateway.

Returns:

the database gateway

getDbIntern

protected SqlTable.Database getDbIntern()

Gets the db intern.

Returns:

the db intern

getIndicesIntern

protected SqlTable.Indices getIndicesIntern()

Gets the indices intern.

Returns:

the indices intern

selectFromHirarchieHirarchical

protected SELECT selectFromHirarchieHirarchical(Object[] columns)

Select from hirarchie hirarchical.

Parameters:

columns - the columns

Returns:

the sELECT

selectFromHirarchieFlat

protected SELECT[] selectFromHirarchieFlat(Object[] columns)

Select from hirarchie flat.

Parameters:

columns - the columns

Returns:

the sELEC t[]