Revision 47579 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/main/java/org/gvsig/sqlite/dal/geopackage/index/GeopackageIndexRTree.java

View differences:

GeopackageIndexRTree.java
15 15 
    //
16 16
17 17 
    private static final String ATTRIBUTE_INDEX_FLAG_NAME = "gpkg_rtree_index";
18 
    private static final String GROUP_NAME = "rtree";
18 
    public static final String GROUP_NAME = "rtree";
19 19
20 20 

  		




  21
  21
  
    
    public GeopackageIndexRTree() {


  		




  ......




  48
  48
  
    
        return sqls;


  		




  49
  49
  
    
    }


  		




  50
  50
  
    

  		




  
  51
  
    
    @Override


  		




  51
  52
  
    
    public String getEnvelopeSQL(String tablename, String fieldnamegeom) {


  		




  52
  53
  
    
        String sql = TemplateUtils.getSqlTemplate(getGroup(), "bbox_of_index", tablename, fieldnamegeom);


  		




  53
  54
  
    
        return sql;


  		




  54
  55
  
    
    }


  		




  
  56
  
    

  		




  
  57
  
    
    @Override


  		




  
  58
  
    
    public List<String> getRemoveIndexSQL(String tablename, String fieldnamegeom) {


  		




  
  59
  
    
        List<String> sqls = new ArrayList<>();


  		




  
  60
  
    
        


  		




  
  61
  
    
        sqls.add(String.format("DROP TRIGGER IF EXISTS \"rtree_%s_%s_delete\"",tablename, fieldnamegeom));


  		




  
  62
  
    
        sqls.add(String.format("DROP TRIGGER IF EXISTS \"rtree_%s_%s_insert\"",tablename, fieldnamegeom));


  		




  
  63
  
    
        sqls.add(String.format("DROP TRIGGER IF EXISTS \"rtree_%s_%s_update1\"",tablename, fieldnamegeom));


  		




  
  64
  
    
        sqls.add(String.format("DROP TRIGGER IF EXISTS \"rtree_%s_%s_update2\"",tablename, fieldnamegeom));


  		




  
  65
  
    
        sqls.add(String.format("DROP TRIGGER IF EXISTS \"rtree_%s_%s_update3\"",tablename, fieldnamegeom));


  		




  
  66
  
    
        sqls.add(String.format("DROP TRIGGER IF EXISTS \"rtree_%s_%s_update4\"",tablename, fieldnamegeom));


  		




  
  67
  
    

  		




  
  68
  
    
        sqls.add(String.format("DROP TABLE IF EXISTS \"rtree_%s_%s\"",tablename, fieldnamegeom));


  		




  
  69
  
    
        sqls.add(String.format("DROP TABLE IF EXISTS \"rtree_%s_%s_node\"",tablename, fieldnamegeom));


  		




  
  70
  
    
        sqls.add(String.format("DROP TABLE IF EXISTS \"rtree_%s_%s_parent\"",tablename, fieldnamegeom));


  		




  
  71
  
    
        sqls.add(String.format("DROP TABLE IF EXISTS \"rtree_%s_%s_rowid\"",tablename, fieldnamegeom));


  		




  
  72
  
    
        


  		




  
  73
  
    
        return sqls;


  		




  
  74
  
    
    }


  		




  
  75
  
    

  		




  55
  76
  
    
}


  		












Also available in:  Unified diff