Package org.gvsig.fmap.dal

Interface SQLBuilder

All Superinterfaces:

org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

public interface SQLBuilder
extends org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

Nested Class Summary

Nested Classes

Modifier and Type	Interface	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 enum	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	Description
static final int	DEFAULT_RECOMENDED_SQL_LENGTH
static final String	FEATURE_ATTRIBUTE_DESCRIPTOR
static final String	PROP_ADD_TABLE_NAME_TO_COLUMNS
static final String	PROP_FEATURE_TYPE
static final String	PROP_JDBCHELPER
static final String	PROP_QUERY
static final String	PROP_SQLBUILDER
static final String	PROP_SYMBOLTABLE
static final String	PROP_TABLE
static final String	PROP_TABLENAME

Method Summary

Modifier and Type	Method	Description
SQLBuilder.AlterTableBuilder	alter_table()
String	as_clob(String s)
String	as_identifier(String id)
String	as_string(boolean value)
String	as_string(byte[] s)
String	as_string(Number value)
String	as_string(Object value)
String	as_string(String s)
SQLBuilder.SelectColumnBuilder	column()
SQLBuilder.Column	column(String name)
SQLBuilder.Column	column(SQLBuilder.TableNameBuilder table, String name)
SQLBuilder.Column	column_from(org.gvsig.expressionevaluator.ExpressionBuilder.Variable variable)
SQLBuilder.Column	column_from(SQLBuilder.TableNameBuilder table, org.gvsig.expressionevaluator.ExpressionBuilder.Variable variable)
SQLBuilder.CountBuilder	count()
SQLBuilder.CreateIndexBuilder	create_index()
SQLBuilder.CreateTableBuilder	create_table()
SQLBuilder.SelectBuilder	createSelectBuilder()
SQLBuilder.TableNameBuilder	createTableNameBuilder()
String	default_schema()
SQLBuilder.DeleteBuilder	delete()
SQLBuilder.DropIndexBuilder	drop_index()
SQLBuilder.DropTableBuilder	drop_table()
org.gvsig.expressionevaluator.GeometryExpressionBuilder	expression()
org.gvsig.expressionevaluator.Formatter	formatter()
org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType	geometry_support_type()
String	getConstrainName(SQLBuilder.TableNameBuilder table, String columnName, String constrainType)
int	getMaxRecomendedSQLLength()
SQLBuilder.GrantBuilder	grant()
boolean	has_spatial_functions()
SQLBuilder.InsertBuilder	insert()
boolean	isAggregateFunction(String funcname)
SQLBuilder.MergeBuilder	merge()
List<org.gvsig.expressionevaluator.ExpressionBuilder.Parameter>	parameters()
List<String>	parameters_names()
SQLBuilder.SelectBuilder	select()
void	setProperties(Class classToApply, Object... values)
void	setProperties(org.gvsig.expressionevaluator.ExpressionBuilder.Visitable visitable, Class filter, Object... values)
Object	sqlgeometrydimension(int type, int subtype)
Object	sqlgeometrytype(int type, int subtype)
String	sqltype(int dataType, int size, int precision, int scale, int geomType, int geomSubtype)
Object	srs_id(org.gvsig.crs.projection.lib.Projection projection)
boolean	support_schemas()
SQLBuilder.TableNameBuilder	table_name()
String	toString(org.gvsig.expressionevaluator.Formatter formatter)
SQLBuilder.UpdateBuilder	update()
SQLBuilder.UpdateTableStatisticsBuilder	update_table_statistics()
List<org.gvsig.expressionevaluator.ExpressionBuilder.Variable>	variables()
List<String>	variables_names()

Methods inherited from interface org.gvsig.expressionevaluator.ExpressionBuilder.Visitable

accept

Field Details

PROP_FEATURE_TYPE

static final String PROP_FEATURE_TYPE

See Also:

• Constant Field Values

PROP_TABLE

static final String PROP_TABLE

See Also:

• Constant Field Values

PROP_TABLENAME

static final String PROP_TABLENAME

See Also:

• Constant Field Values

PROP_SYMBOLTABLE

static final String PROP_SYMBOLTABLE

See Also:

• Constant Field Values

PROP_JDBCHELPER

static final String PROP_JDBCHELPER

See Also:

• Constant Field Values

PROP_QUERY

static final String PROP_QUERY

See Also:

• Constant Field Values

PROP_SQLBUILDER

static final String PROP_SQLBUILDER

See Also:

• Constant Field Values

PROP_ADD_TABLE_NAME_TO_COLUMNS

static final String PROP_ADD_TABLE_NAME_TO_COLUMNS

See Also:

• Constant Field Values

FEATURE_ATTRIBUTE_DESCRIPTOR

static final 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 Details

default_schema

String default_schema()

support_schemas

boolean support_schemas()

has_spatial_functions

boolean has_spatial_functions()

geometry_support_type

org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometry_support_type()

sqltype

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

sqlgeometrytype

Object sqlgeometrytype(int type,
 int subtype)

sqlgeometrydimension

Object sqlgeometrydimension(int type,
 int subtype)

srs_id

Object srs_id(org.gvsig.crs.projection.lib.Projection projection)

toString

String toString(org.gvsig.expressionevaluator.Formatter formatter)

variables

List<org.gvsig.expressionevaluator.ExpressionBuilder.Variable> variables()

variables_names

List<String> variables_names()

parameters

List<org.gvsig.expressionevaluator.ExpressionBuilder.Parameter> parameters()

parameters_names

List<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

org.gvsig.expressionevaluator.GeometryExpressionBuilder expression()

as_identifier

String as_identifier(String id)

as_clob

String as_clob(String s)

as_string

String as_string(String s)

as_string

String as_string(byte[] s)

as_string

String as_string(boolean value)

as_string

String as_string(Number value)

as_string

String as_string(Object value)

column

SQLBuilder.Column column(String name)

column

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

column_from

SQLBuilder.Column column_from(org.gvsig.expressionevaluator.ExpressionBuilder.Variable variable)

column_from

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

setProperties

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

setProperties

void setProperties(org.gvsig.expressionevaluator.ExpressionBuilder.Visitable visitable,
 Class filter,
 Object... values)

formatter

org.gvsig.expressionevaluator.Formatter formatter()

isAggregateFunction

boolean isAggregateFunction(String funcname)

getMaxRecomendedSQLLength

int getMaxRecomendedSQLLength()

createSelectBuilder

SQLBuilder.SelectBuilder createSelectBuilder()

getConstrainName

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