Package org.gvsig.fmap.dal.feature.spi

Class SQLBuilderBase.SelectBuilderBase

java.lang.Object
org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatementPart
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectBuilderBase
All Implemented Interfaces:
Cloneable, org.gvsig.expressionevaluator.ExpressionBuilder.Value, org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder.SelectBuilder, org.gvsig.fmap.dal.SQLBuilder.Statement, org.gvsig.fmap.dal.SQLBuilder.StatementPart, org.gvsig.tools.lang.Cloneable, org.gvsig.tools.util.PropertiesSupport
Enclosing class:
SQLBuilderBase
public class SQLBuilderBase.SelectBuilderBase extends SQLBuilderBase.AbstractStatement implements org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected boolean
    check_order_and_offset
     
    protected List<org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder>
    columns
     
    protected boolean
    distinct
     
    protected org.gvsig.fmap.dal.SQLBuilder.FromBuilder
    from
     
    protected List<org.gvsig.expressionevaluator.ExpressionBuilder.Value>
    groupColumn
     
    protected long
    limit
     
    protected long
    offset
     
    protected List<org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder>
    order_by
     
    protected org.gvsig.expressionevaluator.GeometryExpressionBuilder
    where
     

    Fields inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    properties

  • Constructor Summary

    Constructors
    Constructor
    Description
    SelectBuilderBase()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    accept(org.gvsig.expressionevaluator.ExpressionBuilder.Visitor visitor, org.gvsig.expressionevaluator.ExpressionBuilder.VisitorFilter filter)
     
    org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder
    column()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder
    column(String name)
     
    org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder
    column(org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder columnBuilder)
     
    void
    disable_check_order_and_offset()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    distinct()
     
    org.gvsig.fmap.dal.SQLBuilder.FromBuilder
    from()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder
    getColumn(String name)
     
    List<org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder>
    getColumns()
     
    List<org.gvsig.expressionevaluator.ExpressionBuilder.Value>
    getGroups()
     
    org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder
    getOrderBy(String column)
     
    org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder
    getOrderBy(org.gvsig.expressionevaluator.ExpressionBuilder.Value column)
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    group_by(org.gvsig.expressionevaluator.ExpressionBuilder.Value... columns)
     
    boolean
    has_aggregate_functions()
     
    boolean
    has_column(String name)
     
    boolean
    has_from()
     
    boolean
    has_group_by()
     
    boolean
    has_limit()
     
    boolean
    has_offset()
     
    boolean
    has_order_by()
     
    boolean
    has_where()
     
    boolean
    isGroupBy(String column)
     
    protected boolean
    isValid(StringBuilder message)
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    limit(long limit)
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    limit(Long limit)
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    offset(long offset)
     
    org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder
    order_by()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    remove_all_columns()
     
    void
    remove_column(String columnName)
     
    void
    replace(org.gvsig.expressionevaluator.ExpressionBuilder.Value target, org.gvsig.expressionevaluator.ExpressionBuilder.Value replacement)
     
    String
    toString()
     
    String
    toString(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter)
     
    org.gvsig.expressionevaluator.GeometryExpressionBuilder
    where()
     

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

    clone

    Methods inherited from class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    copyPropertiesFrom, getProperties, getProperty, setProperty

    Methods inherited from class java.lang.Object

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

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

    clone, copyPropertiesFrom

    Methods inherited from interface org.gvsig.tools.util.PropertiesSupport

    getProperties, getProperty, setProperty

  • Field Details

    • from

      protected org.gvsig.fmap.dal.SQLBuilder.FromBuilder from

    • where

      protected org.gvsig.expressionevaluator.GeometryExpressionBuilder where

    • limit

      protected long limit

    • offset

      protected long offset

    • columns

      protected List<org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder> columns

    • order_by

      protected List<org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder> order_by

    • distinct

      protected boolean distinct

    • groupColumn

      protected List<org.gvsig.expressionevaluator.ExpressionBuilder.Value> groupColumn

    • check_order_and_offset

      protected boolean check_order_and_offset

  • Constructor Details

    • SelectBuilderBase

      public SelectBuilderBase()

  • Method Details

    • getGroups

      public List<org.gvsig.expressionevaluator.ExpressionBuilder.Value> getGroups()
      Specified by:
      getGroups in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • getColumns

      public List<org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder> getColumns()
      Specified by:
      getColumns in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • remove_column

      public void remove_column(String columnName)
      Specified by:
      remove_column in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • group_by

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder group_by(org.gvsig.expressionevaluator.ExpressionBuilder.Value... columns)
      Specified by:
      group_by in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • accept

      public void accept(org.gvsig.expressionevaluator.ExpressionBuilder.Visitor visitor, org.gvsig.expressionevaluator.ExpressionBuilder.VisitorFilter filter)
      Specified by:
      accept in interface org.gvsig.expressionevaluator.ExpressionBuilder.Visitable
      Overrides:
      accept in class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    • replace

      public void replace(org.gvsig.expressionevaluator.ExpressionBuilder.Value target, org.gvsig.expressionevaluator.ExpressionBuilder.Value replacement)
      Specified by:
      replace in interface org.gvsig.expressionevaluator.ExpressionBuilder.Value
      Overrides:
      replace in class org.gvsig.expressionevaluator.ExpressionBuilder.AbstractValue

    • distinct

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder distinct()
      Specified by:
      distinct in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • column

      public org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder column()
      Specified by:
      column in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • column

      public org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder column(org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder columnBuilder)
      Specified by:
      column in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • column

      public org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder column(String name)
      Specified by:
      column in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • getColumn

      public org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder getColumn(String name)
      Specified by:
      getColumn in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • remove_all_columns

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder remove_all_columns()
      Specified by:
      remove_all_columns in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_column

      public boolean has_column(String name)
      Specified by:
      has_column in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • from

      public org.gvsig.fmap.dal.SQLBuilder.FromBuilder from()
      Specified by:
      from in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_from

      public boolean has_from()
      Specified by:
      has_from in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • where

      public org.gvsig.expressionevaluator.GeometryExpressionBuilder where()
      Specified by:
      where in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_where

      public boolean has_where()
      Specified by:
      has_where in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • limit

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder limit(long limit)
      Specified by:
      limit in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • limit

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder limit(Long limit)
      Specified by:
      limit in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_limit

      public boolean has_limit()
      Specified by:
      has_limit in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • offset

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder offset(long offset)
      Specified by:
      offset in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_offset

      public boolean has_offset()
      Specified by:
      has_offset in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • order_by

      public org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder order_by()
      Specified by:
      order_by in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • getOrderBy

      public org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder getOrderBy(org.gvsig.expressionevaluator.ExpressionBuilder.Value column)
      Specified by:
      getOrderBy in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • getOrderBy

      public org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder getOrderBy(String column)
      Specified by:
      getOrderBy in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • isGroupBy

      public boolean isGroupBy(String column)
      Specified by:
      isGroupBy in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_order_by

      public boolean has_order_by()
      Specified by:
      has_order_by in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_group_by

      public boolean has_group_by()
      Specified by:
      has_group_by in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • has_aggregate_functions

      public boolean has_aggregate_functions()
      Specified by:
      has_aggregate_functions in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • disable_check_order_and_offset

      public void disable_check_order_and_offset()
      Specified by:
      disable_check_order_and_offset in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder

    • isValid

      protected boolean isValid(StringBuilder message)

    • toString

      public String toString()
      Specified by:
      toString in interface org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
      Overrides:
      toString in class Object

    • toString

      public String toString(org.gvsig.expressionevaluator.Formatter<org.gvsig.expressionevaluator.ExpressionBuilder.Value> formatter)
      Specified by:
      toString in interface org.gvsig.expressionevaluator.ExpressionBuilder.Value