Package 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
    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
    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
    Description
    SQLiteSQLBuilder(SQLiteHelper helper)
     

  • Method Summary

    Modifier and Type
    Method
    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(Connection conn, org.gvsig.fmap.geom.Geometry geometry)
     
    org.gvsig.tools.dispose.Disposable
    setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
     
    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, column, column, column_from, column_from, 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, parameters_names, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, sqlgeometrytype, sqltype, support_schemas, table_name, toString, toString, update, update_table_statistics, variables, variables_names

    Methods inherited from class java.lang.Object

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

  • Field Details

    • formatter

      protected org.gvsig.expressionevaluator.Formatter formatter

  • Constructor Details

    • SQLiteSQLBuilder

      public SQLiteSQLBuilder(SQLiteHelper helper)

  • Method Details

    • sqlgeometrydimension

      public 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

    • getHelper

      public SQLiteHelper getHelper()
      Overrides:
      getHelper in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • setParameters

      public org.gvsig.tools.dispose.Disposable setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
      Overrides:
      setParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • getNativeBytes

      protected byte[] getNativeBytes(Connection conn, org.gvsig.fmap.geom.Geometry geometry) throws Exception
      Overrides:
      getNativeBytes in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase
      Throws:
      Exception

    • 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

    • 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

    • createDropTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder createDropTableBuilder()
      Overrides:
      createDropTableBuilder 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

    • 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

    • 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

    • 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