org.gvsig.sqlite.dal

Class SQLiteSQLBuilder

java.lang.Object

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

org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

org.gvsig.sqlite.dal.SQLiteSQLBuilder

All Implemented Interfaces:

org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder

public class SQLiteSQLBuilder
extends org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	SQLiteSQLBuilder.SQLiteAlterTableBuilder
class	SQLiteSQLBuilder.SQLiteCreateIndexBuilder
protected class	SQLiteSQLBuilder.SQLiteCreateTableBuilder
protected class	SQLiteSQLBuilder.SQLiteDropTableBuilder
class	SQLiteSQLBuilder.SQLiteSelectBuilderBase
class	SQLiteSQLBuilder.SQLiteTableNameBuilderBase

Nested classes/interfaces inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatementPart, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AlterTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.ColumnBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.ColumnDescriptorBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CountBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CreateIndexBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CreateTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DeleteBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DropIndexBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DropTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.FromBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.GrantBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.GrantRoleBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.JoinBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.MergeBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.OrderByBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.TableNameBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateTableStatisticsBuilderBase

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

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

Field Summary

Fields

Modifier and Type	Field and Description
protected org.gvsig.expressionevaluator.Formatter	formatter

Fields inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

helper

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

aggregateFunctionNames, allowAutomaticValues, alter_table, constant_false, constant_true, create_index, create_table, defaultSchema, delete, drop_index, drop_table, expressionBuilder, geometrySupportType, grant, hasSpatialFunctions, insert, LOGGER, merge, select, STMT_DELETE_FROM_table, STMT_DELETE_FROM_table_WHERE_expresion, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table, STMT_DROP_TABLE_table, STMT_GRANT_privileges_ON_table_TO_role, STMT_INSERT_INTO_table_columns_VALUES_values, STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values, STMT_UPDATE_table_SET_columnsAndValues, STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion, STMT_UPDATE_TABLE_STATISTICS_table, supportSchemas, table_name, type_boolean, type_byte, type_bytearray, type_char, type_date, type_decimal_p, type_decimal_ps, type_double, type_FILE, type_float, type_FOLDER, type_geometry, type_int, type_long, type_string, type_string_0, type_string_p, type_time, type_timestamp, type_URI, type_URL, type_version, update, 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
SQLiteSQLBuilder(SQLiteHelper helper)

Method Summary

Modifier and Type	Method and Description
protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder	createAlterTableBuilder()
org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder	createCreateIndexBuilder()
protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder	createCreateTableBuilder()
protected org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder	createDropTableBuilder()
org.gvsig.fmap.dal.SQLBuilder.SelectBuilder	createSelectBuilder()
org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder	createTableNameBuilder()
org.gvsig.expressionevaluator.GeometryExpressionBuilder	expression()
org.gvsig.expressionevaluator.Formatter	formatter()
SQLiteHelper	getHelper()
protected byte[]	getNativeBytes(java.sql.Connection conn, org.gvsig.fmap.geom.Geometry geometry)
org.gvsig.tools.dispose.Disposable	setParameters(java.sql.PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
java.lang.Object	sqlgeometrydimension(int type, int subtype)

Methods inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

debug_setStatementParameters, forceGeometryType, getGeometryManager, getParameters, getParameters, setParameters, setParameters, setStatementParameters, setStatementParameters, setStatementValue, srs_id

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

accept, alter_table, as_clob, as_identifier, as_string, as_string, as_string, as_string, as_string, column_from, column_from, column, column, column, count, create_index, create_table, createDeleteBuilder, createDropIndexBuilder, createExpressionBuilder, createFromBuilder, createGrantBuilder, createGrantRoleBuilder, createInsertBuilder, createInsertColumnBuilder, createJoin, createMergeBuilder, createOrderByBuilder, createSelectColumnBuilder, createUpdateBuilder, createUpdateColumnBuilder, createUpdateTableStatisticsBuilder, default_schema, delete, drop_index, drop_table, geometry_support_type, getConstrainName, getMaxRecomendedSQLLength, grant, has_spatial_functions, insert, isAggregateFunction, merge, parameters_names, parameters, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, sqlgeometrytype, sqltype, support_schemas, table_name, toString, toString, update_table_statistics, update, variables_names, variables

Methods inherited from class java.lang.Object

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

Field Detail

formatter

protected org.gvsig.expressionevaluator.Formatter formatter

Constructor Detail

SQLiteSQLBuilder

public SQLiteSQLBuilder(SQLiteHelper helper)

Method Detail

createAlterTableBuilder

protected org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder createAlterTableBuilder()

Overrides:

createAlterTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

createCreateIndexBuilder

public org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()

Overrides:

createCreateIndexBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

createCreateTableBuilder

protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder createCreateTableBuilder()

Overrides:

createCreateTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

createDropTableBuilder

protected org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder createDropTableBuilder()

Overrides:

createDropTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

createSelectBuilder

public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder createSelectBuilder()

Specified by:

createSelectBuilder in interface org.gvsig.fmap.dal.SQLBuilder

Overrides:

createSelectBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

createTableNameBuilder

public org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder createTableNameBuilder()

Specified by:

createTableNameBuilder in interface org.gvsig.fmap.dal.SQLBuilder

Overrides:

createTableNameBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

expression

public org.gvsig.expressionevaluator.GeometryExpressionBuilder expression()

Specified by:

expression in interface org.gvsig.fmap.dal.SQLBuilder

Overrides:

expression in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

formatter

public org.gvsig.expressionevaluator.Formatter formatter()

Specified by:

formatter in interface org.gvsig.fmap.dal.SQLBuilder

Overrides:

formatter in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

getHelper

public SQLiteHelper getHelper()

Overrides:

getHelper in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

getNativeBytes

protected byte[] getNativeBytes(java.sql.Connection conn,
                                org.gvsig.fmap.geom.Geometry geometry)
                         throws java.lang.Exception

Overrides:

getNativeBytes in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

Throws:

java.lang.Exception

setParameters

public org.gvsig.tools.dispose.Disposable setParameters(java.sql.PreparedStatement st,
                                                        org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)

Overrides:

setParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

sqlgeometrydimension

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

Specified by:

sqlgeometrydimension in interface org.gvsig.fmap.dal.SQLBuilder

Overrides:

sqlgeometrydimension in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase