Revision 218 trunk/org.gvsig.mssqlserver/org.gvsig.mssqlserver.provider/src/main/java/org/gvsig/mssqlserver/dal/MSSQLServerSQLBuilder.java

View differences:

MSSQLServerSQLBuilder.java
3 3 
import java.text.MessageFormat;
4 4 
import java.util.ArrayList;
5 5 
import java.util.List;
6 
import org.apache.commons.lang3.StringUtils;
7 
import org.cresques.cts.IProjection;
8 6 
import org.gvsig.expressionevaluator.ExpressionBuilder;
9 7 
import org.gvsig.expressionevaluator.Formatter;
10 8 
import org.gvsig.fmap.dal.DataTypes;
11 9 
import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;
12 
import org.gvsig.fmap.geom.Geometry;
13 10 
import org.gvsig.fmap.geom.primitive.Envelope;
14 11 
import org.gvsig.mssqlserver.dal.expressionbuilderformatter.MSSQLServerFormatter;
15 12 

  		




  ......




  19
  16
  
    
    public static final String FORMAT_ST_GEOMFROMEWKB= "geometry::STGeomFromWKB({0}, {1})";


  		




  20
  17
  
    
    public static final String FORMAT_ST_GEOMFROMWKB= "geometry::STGeomFromWKB({0}, {1})";


  		




  21
  18
  
    
    public static final String FORMAT_ST_GEOMFROMTEXT= "geometry::STGeomFromText({0}, {1})";


  		




  
  19
  
    
    public static final String FORMAT_OPERATOR_ILIKE = "LOWER({0}) LIKE LOWER({1})";


  		




  
  20
  
    
    public static final String FORMAT_OPERATOR_NOTISNULL = "( ({0}) IS NOT NULL )";


  		




  22
  21
  
    
    


  		




  23
  22
  
    
//    public interface MSSQLServerSQLConfig extends SQLConfig {


  		




  24
  23
  
    
//        public static final String ST_GeomFromTextEx = "ST_GeomFromTextEx";


  		




  ......




  75
  74
  
    
//       DID this.ST_SRID, "(({0}).STSrid)");


  		




  76
  75
  
    
//       DID this.ST_AsText, "({0}).STAsText()");


  		




  77
  76
  
    
//       DID this.ST_AsBinary, "({0}).STAsBinary()");


  		




  78
  
  
    
//        this.ST_AsEWKB, "({0}).STAsBinary()");


  		




  
  77
  
    
//       DID this.ST_AsEWKB, "({0}).STAsBinary()");


  		




  79
  78
  
    
//       DID this.ST_ExtentAggregate, "geometry::EnvelopeAggregate({0})");


  		




  80
  79
  
    
//       DID this.ST_UnionAggregate, "geometry::UnionAggregate({0})");


  		




  81
  80
  
    
//       DID this.ST_Contains, "(({0}).STContains({1})=1)");


  		




  ......




  91
  90
  
    
//       DID this.ST_GeomFromText, "geometry::STGeomFromText({0}, {1})");


  		




  92
  91
  
    
//       DID this.ST_GeomFromWKB, "geometry::STGeomFromWKB({0}, {1})");


  		




  93
  92
  
    
//       DID this.ST_GeomFromEWKB, "geometry::STGeomFromWKB({0}, {1})");


  		




  94
  
  
    
//        this.ST_Simplify, "({0}).Reduce({1})");


  		




  
  93
  
    
//       DID this.ST_Simplify, "({0}).Reduce({1})");


  		




  95
  94
  
    
//        this.lcase, "LOWER({0})");


  		




  96
  95
  
    
//        this.ucase, "UPPER({0})");


  		




  97
  
  
    
//        this.operator_ILIKE, "LOWER({0}) LIKE LOWER({1})");


  		




  98
  
  
    
//        this.notIsNull,"( ({0}) IS NOT NULL )" );


  		




  99
  96
  
    
//


  		




  100
  97
  
    
//        config.set(MSSQLServerSQLConfig.ST_ExtentAggregateEx, "{1}::EnvelopeAggregate({0})");


  		




  101
  98
  
    
//        config.set(MSSQLServerSQLConfig.ST_UnionAggregateEx, "{1}::UnionAggregate({0})");


  		












Also available in:  Unified diff