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:

ExpressionBuilder.Visitable, SQLBuilder

public class SQLiteSQLBuilder
extends 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

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

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

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

Field Summary

Fields

Modifier and Type	Field and Description
protected 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 SQLBuilder.AlterTableBuilder	createAlterTableBuilder()
SQLBuilder.CreateIndexBuilder	createCreateIndexBuilder()
protected SQLBuilder.CreateTableBuilder	createCreateTableBuilder()
protected SQLBuilder.DropTableBuilder	createDropTableBuilder()
SQLBuilder.SelectBuilder	createSelectBuilder()
SQLBuilder.TableNameBuilder	createTableNameBuilder()
GeometryExpressionBuilder	expression()
Formatter	formatter()
SQLiteHelper	getHelper()
protected byte[]	getNativeBytes(java.sql.Connection conn, Geometry geometry)
Disposable	setParameters(java.sql.PreparedStatement st, 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 Formatter formatter

Constructor Detail

SQLiteSQLBuilder

public SQLiteSQLBuilder(SQLiteHelper helper)

Method Detail

sqlgeometrydimension

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

Specified by:

sqlgeometrydimension in interface SQLBuilder

Overrides:

sqlgeometrydimension in class SQLBuilderBase

getHelper

public SQLiteHelper getHelper()

Overrides:

getHelper in class JDBCSQLBuilderBase

setParameters

public Disposable setParameters(java.sql.PreparedStatement st,
                                FeatureProvider feature)

Overrides:

setParameters in class JDBCSQLBuilderBase

getNativeBytes

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

Overrides:

getNativeBytes in class JDBCSQLBuilderBase

Throws:

java.lang.Exception

createTableNameBuilder

public SQLBuilder.TableNameBuilder createTableNameBuilder()

Specified by:

createTableNameBuilder in interface SQLBuilder

Overrides:

createTableNameBuilder in class SQLBuilderBase

createAlterTableBuilder

protected SQLBuilder.AlterTableBuilder createAlterTableBuilder()

Overrides:

createAlterTableBuilder in class SQLBuilderBase

createCreateIndexBuilder

public SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()

Overrides:

createCreateIndexBuilder in class SQLBuilderBase

createDropTableBuilder

protected SQLBuilder.DropTableBuilder createDropTableBuilder()

Overrides:

createDropTableBuilder in class SQLBuilderBase

createCreateTableBuilder

protected SQLBuilder.CreateTableBuilder createCreateTableBuilder()

Overrides:

createCreateTableBuilder in class SQLBuilderBase

createSelectBuilder

public SQLBuilder.SelectBuilder createSelectBuilder()

Specified by:

createSelectBuilder in interface SQLBuilder

Overrides:

createSelectBuilder in class SQLBuilderBase

formatter

public Formatter formatter()

Specified by:

formatter in interface SQLBuilder

Overrides:

formatter in class SQLBuilderBase

expression

public GeometryExpressionBuilder expression()

Specified by:

expression in interface SQLBuilder

Overrides:

expression in class SQLBuilderBase