org.gvsig.fmap.dal.feature.spi

Class SQLBuilderBase

java.lang.Object

org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

All Implemented Interfaces:

ExpressionBuilder.Visitable, SQLBuilder

Direct Known Subclasses:

JDBCSQLBuilderBase

public class SQLBuilderBase
extends java.lang.Object
implements SQLBuilder

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected class	SQLBuilderBase.AbstractStatement
protected class	SQLBuilderBase.AbstractStatementPart
class	SQLBuilderBase.AlterTableBuilderBase
class	SQLBuilderBase.ColumnBase
protected class	SQLBuilderBase.ColumnDescriptorBase
class	SQLBuilderBase.CountBuilderBase
class	SQLBuilderBase.CreateIndexBuilderBase
class	SQLBuilderBase.CreateTableBuilderBase
class	SQLBuilderBase.DeleteBuilderBase
class	SQLBuilderBase.DropIndexBuilderBase
class	SQLBuilderBase.DropTableBuilderBase
class	SQLBuilderBase.FromBuilderBase
class	SQLBuilderBase.GrantBuilderBase
class	SQLBuilderBase.GrantRoleBuilderBase
class	SQLBuilderBase.InsertBuilderBase
class	SQLBuilderBase.InsertColumnBuilderBase
protected class	SQLBuilderBase.JoinBase
class	SQLBuilderBase.MergeBuilderBase
class	SQLBuilderBase.OrderByBuilderBase
class	SQLBuilderBase.SelectBuilderBase
class	SQLBuilderBase.SelectColumnBuilderBase
class	SQLBuilderBase.TableNameBuilderBase
class	SQLBuilderBase.UpdateBuilderBase
class	SQLBuilderBase.UpdateColumnBuilderBase
class	SQLBuilderBase.UpdateTableStatisticsBuilderBase

Nested classes/interfaces inherited from interface org.gvsig.fmap.dal.SQLBuilder

SQLBuilder.AlterTableBuilder, SQLBuilder.Column, SQLBuilder.ColumnDescriptor, SQLBuilder.CountBuilder, SQLBuilder.CreateIndexBuilder, SQLBuilder.CreateTableBuilder, SQLBuilder.DeleteBuilder, SQLBuilder.DropIndexBuilder, SQLBuilder.DropTableBuilder, SQLBuilder.FromBuilder, SQLBuilder.GrantBuilder, SQLBuilder.GrantRoleBuilder, SQLBuilder.InsertBuilder, SQLBuilder.InsertColumnBuilder, SQLBuilder.JoinBuilder, SQLBuilder.MergeBuilder, SQLBuilder.OrderByBuilder, SQLBuilder.Privilege, SQLBuilder.SelectBuilder, SQLBuilder.SelectColumnBuilder, SQLBuilder.Statement, SQLBuilder.StatementPart, SQLBuilder.TableNameBuilder, SQLBuilder.UpdateBuilder, SQLBuilder.UpdateColumnBuilder, SQLBuilder.UpdateTableStatisticsBuilder

Field Summary

Fields

Modifier and Type	Field and Description
protected java.lang.String[]	aggregateFunctionNames
protected boolean	allowAutomaticValues
protected SQLBuilder.AlterTableBuilder	alter_table
protected java.lang.String	constant_false
protected java.lang.String	constant_true
protected SQLBuilder.CreateIndexBuilder	create_index
protected SQLBuilder.CreateTableBuilder	create_table
protected java.lang.String	defaultSchema
protected SQLBuilder.DeleteBuilder	delete
protected SQLBuilder.DropIndexBuilder	drop_index
protected SQLBuilder.DropTableBuilder	drop_table
protected GeometryExpressionBuilder	expressionBuilder
protected GeometryExpressionBuilderHelper.GeometrySupportType	geometrySupportType
protected SQLBuilder.GrantBuilder	grant
protected boolean	hasSpatialFunctions
protected SQLBuilder.InsertBuilder	insert
protected static Logger	LOGGER
protected SQLBuilder.MergeBuilder	merge
protected SQLBuilder.SelectBuilder	select
protected java.lang.String	STMT_DELETE_FROM_table
protected java.lang.String	STMT_DELETE_FROM_table_WHERE_expresion
protected java.lang.String	STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table
protected java.lang.String	STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table
protected java.lang.String	STMT_DROP_TABLE_table
protected java.lang.String	STMT_GRANT_privileges_ON_table_TO_role
protected java.lang.String	STMT_INSERT_INTO_table_columns_VALUES_values
protected java.lang.String	STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values
protected java.lang.String	STMT_UPDATE_table_SET_columnsAndValues
protected java.lang.String	STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion
protected java.lang.String	STMT_UPDATE_TABLE_STATISTICS_table
protected boolean	supportSchemas
protected SQLBuilder.TableNameBuilder	table_name
protected java.lang.String	type_boolean
protected java.lang.String	type_byte
protected java.lang.String	type_bytearray
protected java.lang.String	type_char
protected java.lang.String	type_date
protected java.lang.String	type_decimal_p
protected java.lang.String	type_decimal_ps
protected java.lang.String	type_double
protected java.lang.String	type_FILE
protected java.lang.String	type_float
protected java.lang.String	type_FOLDER
protected java.lang.String	type_geometry
protected java.lang.String	type_int
protected java.lang.String	type_long
protected java.lang.String	type_string
protected java.lang.String	type_string_0
protected java.lang.String	type_string_p
protected java.lang.String	type_time
protected java.lang.String	type_timestamp
protected java.lang.String	type_URI
protected java.lang.String	type_URL
protected java.lang.String	type_version
protected SQLBuilder.UpdateBuilder	update
protected SQLBuilder.UpdateTableStatisticsBuilder	update_table_statistics

Fields inherited from interface org.gvsig.fmap.dal.SQLBuilder

DEFAULT_RECOMENDED_SQL_LENGTH, FEATURE_ATTRIBUTE_DESCRIPTOR, PROP_ADD_TABLE_NAME_TO_COLUMNS, PROP_FEATURE_TYPE, PROP_JDBCHELPER, PROP_QUERY, PROP_SQLBUILDER, PROP_SYMBOLTABLE, PROP_TABLE, PROP_TABLENAME

Constructor Summary

Constructors

Constructor and Description
SQLBuilderBase()

Method Summary

Modifier and Type	Method and Description
void	accept(ExpressionBuilder.Visitor visitor, ExpressionBuilder.VisitorFilter filter)
SQLBuilder.AlterTableBuilder	alter_table()
java.lang.String	as_clob(java.lang.String s)
java.lang.String	as_identifier(java.lang.String id)
java.lang.String	as_string(boolean value)
java.lang.String	as_string(byte[] data)
java.lang.String	as_string(java.lang.Number value)
java.lang.String	as_string(java.lang.Object value)
java.lang.String	as_string(java.lang.String s)
SQLBuilder.Column	column_from(ExpressionBuilder.Variable variable)
SQLBuilder.Column	column_from(SQLBuilder.TableNameBuilder table, ExpressionBuilder.Variable variable)
SQLBuilder.SelectColumnBuilder	column()
SQLBuilder.Column	column(SQLBuilder.TableNameBuilder table, java.lang.String name)
SQLBuilder.Column	column(java.lang.String name)
SQLBuilder.CountBuilder	count()
SQLBuilder.CreateIndexBuilder	create_index()
SQLBuilder.CreateTableBuilder	create_table()
protected SQLBuilder.AlterTableBuilder	createAlterTableBuilder()
SQLBuilder.CreateIndexBuilder	createCreateIndexBuilder()
protected SQLBuilder.CreateTableBuilder	createCreateTableBuilder()
protected SQLBuilder.DeleteBuilder	createDeleteBuilder()
SQLBuilder.DropIndexBuilder	createDropIndexBuilder()
protected SQLBuilder.DropTableBuilder	createDropTableBuilder()
protected GeometryExpressionBuilder	createExpressionBuilder()
protected SQLBuilder.FromBuilder	createFromBuilder()
protected SQLBuilder.GrantBuilder	createGrantBuilder()
protected SQLBuilder.GrantRoleBuilder	createGrantRoleBuilder(SQLBuilder.TableNameBuilder table, java.lang.String role)
protected SQLBuilder.InsertBuilder	createInsertBuilder()
protected SQLBuilder.InsertColumnBuilder	createInsertColumnBuilder()
protected SQLBuilderBase.JoinBase	createJoin(java.lang.String type, SQLBuilder.TableNameBuilder table, ExpressionBuilder.Value expression)
protected SQLBuilder.MergeBuilder	createMergeBuilder()
protected SQLBuilder.OrderByBuilder	createOrderByBuilder()
SQLBuilder.SelectBuilder	createSelectBuilder()
protected SQLBuilder.SelectColumnBuilder	createSelectColumnBuilder()
SQLBuilder.TableNameBuilder	createTableNameBuilder()
protected SQLBuilder.UpdateBuilder	createUpdateBuilder()
protected SQLBuilder.UpdateColumnBuilder	createUpdateColumnBuilder()
protected SQLBuilder.UpdateTableStatisticsBuilder	createUpdateTableStatisticsBuilder()
java.lang.String	default_schema()
SQLBuilder.DeleteBuilder	delete()
SQLBuilder.DropIndexBuilder	drop_index()
SQLBuilder.DropTableBuilder	drop_table()
GeometryExpressionBuilder	expression()
Formatter	formatter()
GeometryExpressionBuilderHelper.GeometrySupportType	geometry_support_type()
java.lang.String	getConstrainName(SQLBuilder.TableNameBuilder table, java.lang.String columnName, java.lang.String constrainType)
int	getMaxRecomendedSQLLength()
SQLBuilder.GrantBuilder	grant()
boolean	has_spatial_functions()
SQLBuilder.InsertBuilder	insert()
boolean	isAggregateFunction(java.lang.String funcname)
SQLBuilder.MergeBuilder	merge()
java.util.List<java.lang.String>	parameters_names()
java.util.List<ExpressionBuilder.Parameter>	parameters()
java.lang.String	quote_for_identifiers()
java.lang.String	quote_for_strings()
SQLBuilder.SelectBuilder	select()
void	setProperties(java.lang.Class filter, java.lang.Object... values)
void	setProperties(ExpressionBuilder.Visitable visitable, java.lang.Class filter, java.lang.Object... values)
java.lang.Object	sqlgeometrydimension(int type, int subtype)
java.lang.Object	sqlgeometrytype(int type, int subtype)
java.lang.String	sqltype(int type, int size, int precision, int scale, int geomType, int geomSubtype)
java.lang.Object	srs_id(IProjection projection)
boolean	support_schemas()
SQLBuilder.TableNameBuilder	table_name()
java.lang.String	toString()
java.lang.String	toString(Formatter formatter)
SQLBuilder.UpdateTableStatisticsBuilder	update_table_statistics()
SQLBuilder.UpdateBuilder	update()
java.util.List<java.lang.String>	variables_names()
java.util.List<ExpressionBuilder.Variable>	variables()

Methods inherited from class java.lang.Object

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

Field Detail

LOGGER

protected static final Logger LOGGER

select

protected SQLBuilder.SelectBuilder select

update

protected SQLBuilder.UpdateBuilder update

merge

protected SQLBuilder.MergeBuilder merge

insert

protected SQLBuilder.InsertBuilder insert

delete

protected SQLBuilder.DeleteBuilder delete

alter_table

protected SQLBuilder.AlterTableBuilder alter_table

create_table

protected SQLBuilder.CreateTableBuilder create_table

grant

protected SQLBuilder.GrantBuilder grant

drop_table

protected SQLBuilder.DropTableBuilder drop_table

update_table_statistics

protected SQLBuilder.UpdateTableStatisticsBuilder update_table_statistics

create_index

protected SQLBuilder.CreateIndexBuilder create_index

drop_index

protected SQLBuilder.DropIndexBuilder drop_index

table_name

protected SQLBuilder.TableNameBuilder table_name

expressionBuilder

protected GeometryExpressionBuilder expressionBuilder

defaultSchema

protected java.lang.String defaultSchema

supportSchemas

protected boolean supportSchemas

hasSpatialFunctions

protected boolean hasSpatialFunctions

geometrySupportType

protected GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType

allowAutomaticValues

protected boolean allowAutomaticValues

constant_true

protected java.lang.String constant_true

constant_false

protected java.lang.String constant_false

type_boolean

protected java.lang.String type_boolean

type_byte

protected java.lang.String type_byte

type_bytearray

protected java.lang.String type_bytearray

type_geometry

protected java.lang.String type_geometry

type_char

protected java.lang.String type_char

type_date

protected java.lang.String type_date

type_double

protected java.lang.String type_double

type_decimal_ps

protected java.lang.String type_decimal_ps

type_decimal_p

protected java.lang.String type_decimal_p

type_float

protected java.lang.String type_float

type_int

protected java.lang.String type_int

type_long

protected java.lang.String type_long

type_string

protected java.lang.String type_string

type_string_0

protected java.lang.String type_string_0

type_string_p

protected java.lang.String type_string_p

type_time

protected java.lang.String type_time

type_timestamp

protected java.lang.String type_timestamp

type_version

protected java.lang.String type_version

type_URI

protected java.lang.String type_URI

type_URL

protected java.lang.String type_URL

type_FILE

protected java.lang.String type_FILE

type_FOLDER

protected java.lang.String type_FOLDER

STMT_DELETE_FROM_table_WHERE_expresion

protected java.lang.String STMT_DELETE_FROM_table_WHERE_expresion

STMT_DELETE_FROM_table

protected java.lang.String STMT_DELETE_FROM_table

STMT_INSERT_INTO_table_columns_VALUES_values

protected java.lang.String STMT_INSERT_INTO_table_columns_VALUES_values

STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values

protected java.lang.String STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values

STMT_UPDATE_TABLE_STATISTICS_table

protected java.lang.String STMT_UPDATE_TABLE_STATISTICS_table

STMT_DROP_TABLE_table

protected java.lang.String STMT_DROP_TABLE_table

STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table

protected java.lang.String STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table

STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table

protected java.lang.String STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table

STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion

protected java.lang.String STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion

STMT_UPDATE_table_SET_columnsAndValues

protected java.lang.String STMT_UPDATE_table_SET_columnsAndValues

STMT_GRANT_privileges_ON_table_TO_role

protected java.lang.String STMT_GRANT_privileges_ON_table_TO_role

aggregateFunctionNames

protected java.lang.String[] aggregateFunctionNames

Constructor Detail

SQLBuilderBase

public SQLBuilderBase()

Method Detail

setProperties

public void setProperties(java.lang.Class filter,
                          java.lang.Object... values)

Specified by:

setProperties in interface SQLBuilder

setProperties

public void setProperties(ExpressionBuilder.Visitable visitable,
                          java.lang.Class filter,
                          java.lang.Object... values)

Specified by:

setProperties in interface SQLBuilder

quote_for_identifiers

public java.lang.String quote_for_identifiers()

quote_for_strings

public java.lang.String quote_for_strings()

as_identifier

public java.lang.String as_identifier(java.lang.String id)

Specified by:

as_identifier in interface SQLBuilder

as_clob

public java.lang.String as_clob(java.lang.String s)

Specified by:

as_clob in interface SQLBuilder

as_string

public java.lang.String as_string(java.lang.String s)

Specified by:

as_string in interface SQLBuilder

as_string

public java.lang.String as_string(byte[] data)

Specified by:

as_string in interface SQLBuilder

as_string

public java.lang.String as_string(boolean value)

Specified by:

as_string in interface SQLBuilder

as_string

public java.lang.String as_string(java.lang.Number value)

Specified by:

as_string in interface SQLBuilder

as_string

public java.lang.String as_string(java.lang.Object value)

Specified by:

as_string in interface SQLBuilder

expression

public GeometryExpressionBuilder expression()

Specified by:

expression in interface SQLBuilder

has_spatial_functions

public boolean has_spatial_functions()

Specified by:

has_spatial_functions in interface SQLBuilder

geometry_support_type

public GeometryExpressionBuilderHelper.GeometrySupportType geometry_support_type()

Specified by:

geometry_support_type in interface SQLBuilder

createExpressionBuilder

protected GeometryExpressionBuilder createExpressionBuilder()

srs_id

public java.lang.Object srs_id(IProjection projection)

Specified by:

srs_id in interface SQLBuilder

default_schema

public java.lang.String default_schema()

Specified by:

default_schema in interface SQLBuilder

support_schemas

public boolean support_schemas()

Specified by:

support_schemas in interface SQLBuilder

sqltype

public java.lang.String sqltype(int type,
                                int size,
                                int precision,
                                int scale,
                                int geomType,
                                int geomSubtype)

Specified by:

sqltype in interface SQLBuilder

sqlgeometrytype

public java.lang.Object sqlgeometrytype(int type,
                                        int subtype)

Specified by:

sqlgeometrytype in interface SQLBuilder

sqlgeometrydimension

public java.lang.Object sqlgeometrydimension(int type,
                                             int subtype)

Specified by:

sqlgeometrydimension in interface SQLBuilder

column

public SQLBuilder.SelectColumnBuilder column()

Specified by:

column in interface SQLBuilder

createTableNameBuilder

public SQLBuilder.TableNameBuilder createTableNameBuilder()

Specified by:

createTableNameBuilder in interface SQLBuilder

createSelectColumnBuilder

protected SQLBuilder.SelectColumnBuilder createSelectColumnBuilder()

createUpdateColumnBuilder

protected SQLBuilder.UpdateColumnBuilder createUpdateColumnBuilder()

createInsertColumnBuilder

protected SQLBuilder.InsertColumnBuilder createInsertColumnBuilder()

createOrderByBuilder

protected SQLBuilder.OrderByBuilder createOrderByBuilder()

createFromBuilder

protected SQLBuilder.FromBuilder createFromBuilder()

createSelectBuilder

public SQLBuilder.SelectBuilder createSelectBuilder()

Specified by:

createSelectBuilder in interface SQLBuilder

createUpdateBuilder

protected SQLBuilder.UpdateBuilder createUpdateBuilder()

createDeleteBuilder

protected SQLBuilder.DeleteBuilder createDeleteBuilder()

createGrantBuilder

protected SQLBuilder.GrantBuilder createGrantBuilder()

createGrantRoleBuilder

protected SQLBuilder.GrantRoleBuilder createGrantRoleBuilder(SQLBuilder.TableNameBuilder table,
                                                             java.lang.String role)

createDropTableBuilder

protected SQLBuilder.DropTableBuilder createDropTableBuilder()

createCreateTableBuilder

protected SQLBuilder.CreateTableBuilder createCreateTableBuilder()

createAlterTableBuilder

protected SQLBuilder.AlterTableBuilder createAlterTableBuilder()

createInsertBuilder

protected SQLBuilder.InsertBuilder createInsertBuilder()

createMergeBuilder

protected SQLBuilder.MergeBuilder createMergeBuilder()

createUpdateTableStatisticsBuilder

protected SQLBuilder.UpdateTableStatisticsBuilder createUpdateTableStatisticsBuilder()

createCreateIndexBuilder

public SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()

createDropIndexBuilder

public SQLBuilder.DropIndexBuilder createDropIndexBuilder()

select

public SQLBuilder.SelectBuilder select()

Specified by:

select in interface SQLBuilder

update

public SQLBuilder.UpdateBuilder update()

Specified by:

update in interface SQLBuilder

update_table_statistics

public SQLBuilder.UpdateTableStatisticsBuilder update_table_statistics()

Specified by:

update_table_statistics in interface SQLBuilder

drop_table

public SQLBuilder.DropTableBuilder drop_table()

Specified by:

drop_table in interface SQLBuilder

create_index

public SQLBuilder.CreateIndexBuilder create_index()

Specified by:

create_index in interface SQLBuilder

drop_index

public SQLBuilder.DropIndexBuilder drop_index()

Specified by:

drop_index in interface SQLBuilder

delete

public SQLBuilder.DeleteBuilder delete()

Specified by:

delete in interface SQLBuilder

insert

public SQLBuilder.InsertBuilder insert()

Specified by:

insert in interface SQLBuilder

merge

public SQLBuilder.MergeBuilder merge()

Specified by:

merge in interface SQLBuilder

table_name

public SQLBuilder.TableNameBuilder table_name()

Specified by:

table_name in interface SQLBuilder

alter_table

public SQLBuilder.AlterTableBuilder alter_table()

Specified by:

alter_table in interface SQLBuilder

create_table

public SQLBuilder.CreateTableBuilder create_table()

Specified by:

create_table in interface SQLBuilder

grant

public SQLBuilder.GrantBuilder grant()

Specified by:

grant in interface SQLBuilder

column

public SQLBuilder.Column column(java.lang.String name)

Specified by:

column in interface SQLBuilder

column

public SQLBuilder.Column column(SQLBuilder.TableNameBuilder table,
                                java.lang.String name)

Specified by:

column in interface SQLBuilder

column_from

public SQLBuilder.Column column_from(ExpressionBuilder.Variable variable)

Specified by:

column_from in interface SQLBuilder

column_from

public SQLBuilder.Column column_from(SQLBuilder.TableNameBuilder table,
                                     ExpressionBuilder.Variable variable)

Specified by:

column_from in interface SQLBuilder

createJoin

protected SQLBuilderBase.JoinBase createJoin(java.lang.String type,
                                             SQLBuilder.TableNameBuilder table,
                                             ExpressionBuilder.Value expression)

accept

public void accept(ExpressionBuilder.Visitor visitor,
                   ExpressionBuilder.VisitorFilter filter)

Specified by:

accept in interface ExpressionBuilder.Visitable

formatter

public Formatter formatter()

Specified by:

formatter in interface SQLBuilder

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

toString

public java.lang.String toString(Formatter formatter)

Specified by:

toString in interface SQLBuilder

count

public SQLBuilder.CountBuilder count()

Specified by:

count in interface SQLBuilder

parameters

public java.util.List<ExpressionBuilder.Parameter> parameters()

Specified by:

parameters in interface SQLBuilder

variables

public java.util.List<ExpressionBuilder.Variable> variables()

Specified by:

variables in interface SQLBuilder

parameters_names

public java.util.List<java.lang.String> parameters_names()

Specified by:

parameters_names in interface SQLBuilder

variables_names

public java.util.List<java.lang.String> variables_names()

Specified by:

variables_names in interface SQLBuilder

isAggregateFunction

public boolean isAggregateFunction(java.lang.String funcname)

Specified by:

isAggregateFunction in interface SQLBuilder

getMaxRecomendedSQLLength

public int getMaxRecomendedSQLLength()

Specified by:

getMaxRecomendedSQLLength in interface SQLBuilder

getConstrainName

public java.lang.String getConstrainName(SQLBuilder.TableNameBuilder table,
                                         java.lang.String columnName,
                                         java.lang.String constrainType)

Specified by:

getConstrainName in interface SQLBuilder