org.gvsig.fmap.dal

Interface SQLBuilder

All Superinterfaces:

ExpressionBuilder

All Known Implementing Classes:

H2SpatialSQLBuilder, JDBCSQLBuilderBase, PostgreSQLBuilder, SQLBuilderBase

public interface SQLBuilder
extends ExpressionBuilder

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	SQLBuilder.AlterTableBuilder
static interface	SQLBuilder.ColumnDescriptorBuilder
static interface	SQLBuilder.CountBuilder
static interface	SQLBuilder.CreateTableBuilder
static interface	SQLBuilder.DeleteBuilder
static interface	SQLBuilder.DropTableBuilder
static interface	SQLBuilder.FromBuilder
static interface	SQLBuilder.GrantBuilder
static interface	SQLBuilder.GrantRoleBuilder
static interface	SQLBuilder.InsertBuilder
static interface	SQLBuilder.InsertColumnBuilder
static interface	SQLBuilder.OrderByBuilder
static class	SQLBuilder.Privilege
static interface	SQLBuilder.SelectBuilder
static interface	SQLBuilder.SelectColumnBuilder
static interface	SQLBuilder.SQLConfig
static interface	SQLBuilder.Statement
static interface	SQLBuilder.TableNameBuilder
static interface	SQLBuilder.UpdateBuilder
static interface	SQLBuilder.UpdateColumnBuilder
static interface	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

Method Summary

Modifier and Type	Method and Description
SQLBuilder.AlterTableBuilder	alter_table()
SQLBuilder.CountBuilder	count()
SQLBuilder.CreateTableBuilder	create_table()
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 dataType, int p, int s)
ExpressionBuilder.Function	ST_ExtentAggregate(ExpressionBuilder.Value geom)
ExpressionBuilder.Function	ST_UnionAggregate(ExpressionBuilder.Value geom)
boolean	supportSchemas()
SQLBuilder.UpdateTableStatisticsBuilder	update_table_statistics()
SQLBuilder.UpdateBuilder	update()

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

accept, 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

Method Detail

default_schema

String default_schema()

supportSchemas

boolean supportSchemas()

sqltype

String sqltype(int dataType,
               int p,
               int s)

sqlgeometrytype

Object sqlgeometrytype(int type,
                       int subtype)

sqlgeometrydimension

Object sqlgeometrydimension(int type,
                            int subtype)

select

SQLBuilder.SelectBuilder select()

update

SQLBuilder.UpdateBuilder update()

insert

SQLBuilder.InsertBuilder insert()

delete

SQLBuilder.DeleteBuilder delete()

alter_table

SQLBuilder.AlterTableBuilder alter_table()

create_table

SQLBuilder.CreateTableBuilder create_table()

grant

SQLBuilder.GrantBuilder grant()

drop_table

SQLBuilder.DropTableBuilder drop_table()

update_table_statistics

SQLBuilder.UpdateTableStatisticsBuilder update_table_statistics()

count

SQLBuilder.CountBuilder count()

ST_ExtentAggregate

ExpressionBuilder.Function ST_ExtentAggregate(ExpressionBuilder.Value geom)

ST_UnionAggregate

ExpressionBuilder.Function ST_UnionAggregate(ExpressionBuilder.Value geom)