Application: gvSIG desktop

  /**

   * Returns true if a subquery should be used. It will only take effect 

   * when the sql perameter of the connection has a value. 

   * @return 

   */

  public boolean isUseSubquery();

  /**

   * Indicates whether to use a subquery or not in case the connection has 

   * an sql indicated. This flag will have no effect if the "sql" parameter 

   * in the connection has not been specified.

   * By default it will be true and whenever an sql has been indicated in the 

   * connection, a subquery will be used to access the data. If false is assigned, 

   * the sql should return, in the same order, the rows required by the 

   * FeatureType of the store.

   * 

   * @param useSubquery 

   */

  public void setUseSubquery(boolean useSubquery);

    private String storeName;

    private boolean useSubquery;

        super();

        this.useSubquery = true; // true for backwards compatibility. 

    }

	this.storeName = storeName;

        this();

        this();

        this();

        this();

        this();

        this();

        state.set("useSubquery", this.useSubquery);

        this.useSubquery = state.getBoolean("useSubquery",true);

        this.storeName = state.getString("storeName");

        definition.addDynFieldBoolean("useSubquery").setMandatory(false);

    this.useSubquery = other.useSubquery;

    @Override

    public boolean isUseSubquery() {

        return useSubquery;

    }

    @Override

    public void setUseSubquery(boolean useSubquery) {

        this.useSubquery = useSubquery;

    }

        ArrayList<ExpressionBuilder.Value> valuesToRemoveFeatureType = new ArrayList<>();

        if( shouldUseACustomSelect() ) {

            String sql = table.getSubquery();

            if( StringUtils.containsAny(sql, "${where_filter}", "${and_filter}") ) {

                Evaluator filter = query.getFilter();

                if (filter != null) {

                    String sqlfilter = filter.getSQL();

                    if (!StringUtils.isEmpty(sqlfilter)) {

                        if (this.helper.supportFilter(this.storeType, filter)) {

                            select.where().set(expbuilder.toValue(sqlfilter));

                        }

                    }

                }

                if (!StringUtils.isEmpty(baseFilter)) {

                    select.where().and(expbuilder.toValue(baseFilter));

                }

            }

            if( StringUtils.containsAny(sql, "${order_by_orderspec}", "${comma_orderspec}") ) {

                FeatureQueryOrder order = query.getOrder();

                if (order != null) {

                    for (FeatureQueryOrderMember member : order.members()) {

                        String attrName = member.getAttributeName();

                        ExpressionBuilder.Variable col = expbuilder.column(attrName);

                        select.order_by().value(col).ascending(member.getAscending());

                    }

                }

            }

            if( select.has_where() || select.has_order_by() ) {

                sqlbuilder.setProperties(

                        null,

                        PROP_FEATURE_TYPE, this.storeType,

                        PROP_TABLE, table,

                        PROP_SYMBOLTABLE, this.query==null? null:this.query.getSymbolTable(),

                        PROP_JDBCHELPER, this.helper,

                        PROP_QUERY, this.query

                );

                for (ExpressionBuilder.Value value : valuesToRemoveFeatureType) {

                    value.setProperty(PROP_FEATURE_TYPE, null);

                }

                if( select.has_where()) {

                    String s = select.where().toString();

                    sql = StringUtils.replace(sql, "${where_filter}", "WHERE " + s);

                    sql = StringUtils.replace(sql, "${and_filter}", "AND (" + s + ")");

                }

                if( select.has_order_by() ) {

                    String s = select.order_by().toString();

                    sql = StringUtils.replace(sql, "${order_by_orderspec}", "ORDER BY " + s);

                    sql = StringUtils.replace(sql, "${comma_orderspec}", ", "+ s);

                }

            }

            for (FeatureAttributeDescriptor attr : storeType) {

                columns.add(attr);

            }

            return sql;

        }

                    ExpressionBuilder.Variable col = expbuilder.column(attrName);

                    // En el groupBy no queremos que se sustituya el nombre del campo calculado

                    // por su expresion. Se encarga el formater y lo evitamos quitandole el ftype

                    // al value.

                    valuesToRemoveFeatureType.add(col);

                    select.order_by().value(col).ascending(member.getAscending());

    private boolean shouldUseACustomSelect() {

        if( !table.hasSubquery() ) {

            return false;

        }

        if( this.query == null ) {

            return false;

        }

        if( this.query.isUseSubquery() ) {

            return false;

        }

        if( this.query.hasGroupByColumns() ) {

            return false;

        }

        if( this.query.hasAggregateFunctions() ) {

            return false;

        }        

        if( !this.query.hasFilter() && !this.query.hasOrder() ) {

            return true;

        }

//        si el filtro es incompatible con la BBDD

//            return false

//        si el orden es incompatible con la BBDD

//            return false

//        si filtro u orden usan la funcion foreing_value 

//            return false;

        return true;

    }