org.gvsig.fmap.dal.feature.spi

Class SQLBuilderBase

java.lang.Object

org.gvsig.fmap.dal.feature.spi.ExpressionBuilderBase

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

All Implemented Interfaces:

ExpressionBuilder, SQLBuilder

Direct Known Subclasses:

JDBCSQLBuilderBase

public class SQLBuilderBase
extends ExpressionBuilderBase
implements SQLBuilder

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	SQLBuilderBase.AlterTableBuilderBase
protected class	SQLBuilderBase.ColumnDescriptorBuilderBase
class	SQLBuilderBase.CountBuilderBase
class	SQLBuilderBase.CreateTableBuilderBase
class	SQLBuilderBase.DeleteBuilderBase
class	SQLBuilderBase.DropTableBuilderBase
class	SQLBuilderBase.FromBuilderBase
class	SQLBuilderBase.GrantBuilderBase
class	SQLBuilderBase.GrantRoleBuilderBase
class	SQLBuilderBase.InsertBuilderBase
class	SQLBuilderBase.InsertColumnBuilderBase
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 class org.gvsig.fmap.dal.feature.spi.ExpressionBuilderBase

ExpressionBuilderBase.AbstractValue, ExpressionBuilderBase.BinaryOperatorBase, ExpressionBuilderBase.ClassVisitorFilter, ExpressionBuilderBase.ConfigBase, ExpressionBuilderBase.ConstantBase, ExpressionBuilderBase.CustomBase, ExpressionBuilderBase.FunctionBase, ExpressionBuilderBase.GeometryValueBase, ExpressionBuilderBase.GroupBase, ExpressionBuilderBase.ParameterBase, ExpressionBuilderBase.VariableBase

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

SQLBuilder.AlterTableBuilder, SQLBuilder.ColumnDescriptorBuilder, SQLBuilder.CountBuilder, SQLBuilder.CreateTableBuilder, SQLBuilder.DeleteBuilder, SQLBuilder.DropTableBuilder, SQLBuilder.FromBuilder, SQLBuilder.GrantBuilder, SQLBuilder.GrantRoleBuilder, SQLBuilder.InsertBuilder, SQLBuilder.InsertColumnBuilder, SQLBuilder.OrderByBuilder, SQLBuilder.Privilege, SQLBuilder.SelectBuilder, SQLBuilder.SelectColumnBuilder, SQLBuilder.SQLConfig, SQLBuilder.Statement, SQLBuilder.TableNameBuilder, SQLBuilder.UpdateBuilder, SQLBuilder.UpdateColumnBuilder, SQLBuilder.UpdateTableStatisticsBuilder

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

ExpressionBuilder.BinaryOperator, ExpressionBuilder.Config, ExpressionBuilder.Constant, ExpressionBuilder.Custom, ExpressionBuilder.Function, ExpressionBuilder.GeometrySupportType, ExpressionBuilder.GeometryValue, ExpressionBuilder.Group, ExpressionBuilder.Parameter, ExpressionBuilder.Parameters, ExpressionBuilder.ParameterType, ExpressionBuilder.Value, ExpressionBuilder.Variable, ExpressionBuilder.Visitable, ExpressionBuilder.Visitor, ExpressionBuilder.VisitorFilter

Field Summary

Fields

Modifier and Type	Field and Description
protected SQLBuilder.AlterTableBuilder	alter_table
protected SQLBuilder.CreateTableBuilder	create_table
protected SQLBuilder.DeleteBuilder	delete
protected SQLBuilder.DropTableBuilder	drop_table
protected SQLBuilder.GrantBuilder	grant
protected SQLBuilder.InsertBuilder	insert
protected static Logger	logger
protected List<ExpressionBuilder.Parameter>	parameters
protected SQLBuilder.SelectBuilder	select
protected SQLBuilder.UpdateBuilder	update
protected SQLBuilder.UpdateTableStatisticsBuilder	update_table_statistics

Fields inherited from class org.gvsig.fmap.dal.feature.spi.ExpressionBuilderBase

config, value

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()
SQLBuilder.CountBuilder	count()
SQLBuilder.CreateTableBuilder	create_table()
protected SQLBuilder.AlterTableBuilder	createAlterTableBuilder()
protected SQLBuilder.CreateTableBuilder	createCreateTableBuilder()
protected SQLBuilder.DeleteBuilder	createDeleteBuilder()
protected SQLBuilder.DropTableBuilder	createDropTableBuilder()
protected SQLBuilder.FromBuilder	createFromBuilder()
protected SQLBuilder.GrantBuilder	createGrantBuilder()
protected SQLBuilder.GrantRoleBuilder	createGrantRoleBuilder(SQLBuilder.TableNameBuilder table, String role)
protected SQLBuilder.InsertBuilder	createInsertBuilder()
protected SQLBuilder.InsertColumnBuilder	createInsertColumnBuilder()
protected SQLBuilder.OrderByBuilder	createOrderByBuilder()
protected SQLBuilder.SelectBuilder	createSelectBuilder()
protected SQLBuilder.SelectColumnBuilder	createSelectColumnBuilder()
protected SQLBuilder.TableNameBuilder	createTableNameBuilder()
protected SQLBuilder.UpdateBuilder	createUpdateBuilder()
protected SQLBuilder.UpdateColumnBuilder	createUpdateColumnBuilder()
protected SQLBuilder.UpdateTableStatisticsBuilder	createUpdateTableStatisticsBuilder()
String	default_schema()
SQLBuilder.DeleteBuilder	delete()
SQLBuilder.DropTableBuilder	drop_table()
SQLBuilder.GrantBuilder	grant()
SQLBuilder.InsertBuilder	insert()
SQLBuilder.SelectBuilder	select()
Object	sqlgeometrydimension(int type, int subtype)
Object	sqlgeometrytype(int type, int subtype)
String	sqltype(int type, int p, int s)
ExpressionBuilder.Function	ST_ExtentAggregate(ExpressionBuilder.Value geom)
ExpressionBuilder.Function	ST_UnionAggregate(ExpressionBuilder.Value geom)
boolean	supportSchemas()
String	toString()
SQLBuilder.UpdateTableStatisticsBuilder	update_table_statistics()
SQLBuilder.UpdateBuilder	update()

Methods inherited from class org.gvsig.fmap.dal.feature.spi.ExpressionBuilderBase

add, and, and, binaryOperator, bytearray_0x, bytearray_hex, bytearray_x, bytearray, column, concat, constant, createExpressionBuilder, custom, div, envelope, eq, Find_SRID, function, ge, geometry_support_type, geometry, getAsGeometry, getConfig, getParameters, getSRSId, getValue, getVariables, group, gt, has_spatial_functions, identifier, ilike, isNull, lcase, le, like, lt, mult, ne, not, notIsNull, or, or, parameter, parameter, set, setValue, srs, ST_AsBinary, ST_AsEWKB, ST_AsText, ST_Contains, ST_Crosses, ST_Disjoint, ST_Envelope, ST_Equals, ST_GeomFromEWKB, ST_GeomFromText, ST_GeomFromWKB, ST_Intersects, ST_IsClosed, ST_Overlaps, ST_Simplify, ST_SRID, ST_Touches, ST_Within, string, subst, ucase, variable

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.gvsig.fmap.dal.ExpressionBuilder

add, and, and, bytearray, column, concat, constant, createExpressionBuilder, custom, div, envelope, eq, Find_SRID, ge, geometry_support_type, geometry, getAsGeometry, getConfig, getParameters, getSRSId, getValue, getVariables, group, gt, has_spatial_functions, identifier, ilike, isNull, lcase, le, like, lt, mult, ne, not, notIsNull, or, or, parameter, parameter, set, setValue, srs, ST_AsBinary, ST_AsEWKB, ST_AsText, ST_Contains, ST_Crosses, ST_Disjoint, ST_Envelope, ST_Equals, ST_GeomFromEWKB, ST_GeomFromText, ST_GeomFromWKB, ST_Intersects, ST_IsClosed, ST_Overlaps, ST_Simplify, ST_SRID, ST_Touches, ST_Within, string, subst, ucase, variable

Field Detail

logger

protected static final Logger logger

select

protected SQLBuilder.SelectBuilder select

update

protected SQLBuilder.UpdateBuilder update

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

parameters

protected List<ExpressionBuilder.Parameter> parameters

Constructor Detail

SQLBuilderBase

public SQLBuilderBase()

Method Detail

default_schema

public String default_schema()

Specified by:

default_schema in interface SQLBuilder

supportSchemas

public boolean supportSchemas()

Specified by:

supportSchemas in interface SQLBuilder

sqltype

public String sqltype(int type,
                      int p,
                      int s)

Specified by:

sqltype in interface SQLBuilder

sqlgeometrytype

public Object sqlgeometrytype(int type,
                              int subtype)

Specified by:

sqlgeometrytype in interface SQLBuilder

sqlgeometrydimension

public Object sqlgeometrydimension(int type,
                                   int subtype)

Specified by:

sqlgeometrydimension in interface SQLBuilder

createTableNameBuilder

protected SQLBuilder.TableNameBuilder createTableNameBuilder()

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

protected SQLBuilder.SelectBuilder createSelectBuilder()

createUpdateBuilder

protected SQLBuilder.UpdateBuilder createUpdateBuilder()

createDeleteBuilder

protected SQLBuilder.DeleteBuilder createDeleteBuilder()

createGrantBuilder

protected SQLBuilder.GrantBuilder createGrantBuilder()

createGrantRoleBuilder

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

createDropTableBuilder

protected SQLBuilder.DropTableBuilder createDropTableBuilder()

createCreateTableBuilder

protected SQLBuilder.CreateTableBuilder createCreateTableBuilder()

createAlterTableBuilder

protected SQLBuilder.AlterTableBuilder createAlterTableBuilder()

createInsertBuilder

protected SQLBuilder.InsertBuilder createInsertBuilder()

createUpdateTableStatisticsBuilder

protected SQLBuilder.UpdateTableStatisticsBuilder createUpdateTableStatisticsBuilder()

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

delete

public SQLBuilder.DeleteBuilder delete()

Specified by:

delete in interface SQLBuilder

insert

public SQLBuilder.InsertBuilder insert()

Specified by:

insert 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

accept

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

Specified by:

accept in interface ExpressionBuilder

Overrides:

accept in class ExpressionBuilderBase

toString

public String toString()

Overrides:

toString in class ExpressionBuilderBase

ST_UnionAggregate

public ExpressionBuilder.Function ST_UnionAggregate(ExpressionBuilder.Value geom)

Specified by:

ST_UnionAggregate in interface SQLBuilder

ST_ExtentAggregate

public ExpressionBuilder.Function ST_ExtentAggregate(ExpressionBuilder.Value geom)

Specified by:

ST_ExtentAggregate in interface SQLBuilder

count

public SQLBuilder.CountBuilder count()

Specified by:

count in interface SQLBuilder