org.gvsig.fmap.dal

Interface SQLBuilder

All Superinterfaces:

ExpressionBuilder.Visitable

All Known Implementing Classes:

H2SpatialSQLBuilder, JDBCSQLBuilderBase, MDBSQLBuilder, PostgreSQLBuilder, SQLBuilderBase, SQLiteSQLBuilder

public interface SQLBuilder
extends ExpressionBuilder.Visitable

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	SQLBuilder.AlterTableBuilder
static interface	SQLBuilder.Column
static interface	SQLBuilder.ColumnDescriptor
static interface	SQLBuilder.CountBuilder
static interface	SQLBuilder.CreateIndexBuilder
static interface	SQLBuilder.CreateTableBuilder
static interface	SQLBuilder.DeleteBuilder
static interface	SQLBuilder.DropIndexBuilder
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.JoinBuilder
static interface	SQLBuilder.MergeBuilder
static interface	SQLBuilder.OrderByBuilder
static class	SQLBuilder.Privilege
static interface	SQLBuilder.SelectBuilder
static interface	SQLBuilder.SelectColumnBuilder
static interface	SQLBuilder.Statement
static interface	SQLBuilder.StatementPart
static interface	SQLBuilder.TableNameBuilder
static interface	SQLBuilder.UpdateBuilder
static interface	SQLBuilder.UpdateColumnBuilder
static interface	SQLBuilder.UpdateTableStatisticsBuilder

Field Summary

Fields

Modifier and Type	Field and Description
static int	DEFAULT_RECOMENDED_SQL_LENGTH
static java.lang.String	FEATURE_ATTRIBUTE_DESCRIPTOR
static java.lang.String	PROP_ADD_TABLE_NAME_TO_COLUMNS
static java.lang.String	PROP_FEATURE_TYPE
static java.lang.String	PROP_JDBCHELPER
static java.lang.String	PROP_QUERY
static java.lang.String	PROP_SQLBUILDER
static java.lang.String	PROP_SYMBOLTABLE
static java.lang.String	PROP_TABLE
static java.lang.String	PROP_TABLENAME

Method Summary

Modifier and Type	Method and Description
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[] s)
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()
SQLBuilder.SelectBuilder	createSelectBuilder()
SQLBuilder.TableNameBuilder	createTableNameBuilder()
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()
SQLBuilder.SelectBuilder	select()
void	setProperties(java.lang.Class classToApply, 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 dataType, 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(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 interface org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

accept

Field Detail

PROP_FEATURE_TYPE

static final java.lang.String PROP_FEATURE_TYPE

See Also:

Constant Field Values

PROP_TABLE

static final java.lang.String PROP_TABLE

See Also:

Constant Field Values

PROP_TABLENAME

static final java.lang.String PROP_TABLENAME

See Also:

Constant Field Values

PROP_SYMBOLTABLE

static final java.lang.String PROP_SYMBOLTABLE

See Also:

Constant Field Values

PROP_JDBCHELPER

static final java.lang.String PROP_JDBCHELPER

See Also:

Constant Field Values

PROP_QUERY

static final java.lang.String PROP_QUERY

See Also:

Constant Field Values

PROP_SQLBUILDER

static final java.lang.String PROP_SQLBUILDER

See Also:

Constant Field Values

PROP_ADD_TABLE_NAME_TO_COLUMNS

static final java.lang.String PROP_ADD_TABLE_NAME_TO_COLUMNS

See Also:

Constant Field Values

FEATURE_ATTRIBUTE_DESCRIPTOR

static final java.lang.String FEATURE_ATTRIBUTE_DESCRIPTOR

See Also:

Constant Field Values

DEFAULT_RECOMENDED_SQL_LENGTH

static final int DEFAULT_RECOMENDED_SQL_LENGTH

See Also:

Constant Field Values

Method Detail

default_schema

java.lang.String default_schema()

support_schemas

boolean support_schemas()

has_spatial_functions

boolean has_spatial_functions()

geometry_support_type

GeometryExpressionBuilderHelper.GeometrySupportType geometry_support_type()

sqltype

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

sqlgeometrytype

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

sqlgeometrydimension

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

srs_id

java.lang.Object srs_id(IProjection projection)

toString

java.lang.String toString(Formatter formatter)

variables

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

variables_names

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

parameters

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

parameters_names

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

table_name

SQLBuilder.TableNameBuilder table_name()

createTableNameBuilder

SQLBuilder.TableNameBuilder createTableNameBuilder()

column

SQLBuilder.SelectColumnBuilder column()

select

SQLBuilder.SelectBuilder select()

update

SQLBuilder.UpdateBuilder update()

insert

SQLBuilder.InsertBuilder insert()

merge

SQLBuilder.MergeBuilder merge()

delete

SQLBuilder.DeleteBuilder delete()

alter_table

SQLBuilder.AlterTableBuilder alter_table()

create_table

SQLBuilder.CreateTableBuilder create_table()

create_index

SQLBuilder.CreateIndexBuilder create_index()

drop_index

SQLBuilder.DropIndexBuilder drop_index()

grant

SQLBuilder.GrantBuilder grant()

drop_table

SQLBuilder.DropTableBuilder drop_table()

update_table_statistics

SQLBuilder.UpdateTableStatisticsBuilder update_table_statistics()

count

SQLBuilder.CountBuilder count()

expression

GeometryExpressionBuilder expression()

as_identifier

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

as_clob

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

as_string

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

as_string

java.lang.String as_string(byte[] s)

as_string

java.lang.String as_string(boolean value)

as_string

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

as_string

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

column

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

column

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

column_from

SQLBuilder.Column column_from(ExpressionBuilder.Variable variable)

column_from

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

setProperties

void setProperties(java.lang.Class classToApply,
                   java.lang.Object... values)

setProperties

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

formatter

Formatter formatter()

isAggregateFunction

boolean isAggregateFunction(java.lang.String funcname)

getMaxRecomendedSQLLength

int getMaxRecomendedSQLLength()

createSelectBuilder

SQLBuilder.SelectBuilder createSelectBuilder()

getConstrainName

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