Revision 43687 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.api/src/main/java/org/gvsig/fmap/dal/SQLBuilder.java

View differences:

SQLBuilder.java
63 63
        public final static String UPDATE_table_SET_columnsAndValues_WHERE_expresion = "UPDATE_table_SET_columnsAndValues_WHERE_expresion";
64 64
        public final static String UPDATE_table_SET_columnsAndValues = "UPDATE_table_SET_columnsAndValues";
65 65
        public final static String GRANT_privileges_ON_table_TO_role = "GRANT_privileges_ON_table_TO_role";
66
        public final static String CREATE_INDEX_name_ON_table_column = "CREATE_INDEX_name_ON_table_column";
67
        public final static String CREATE_INDEX_name_ON_table_USING_GIST_column = "CREATE_INDEX_name_ON_table_USING_GIST_column";
66
//        public final static String CREATE_INDEX_name_ON_table_column = "CREATE_INDEX_name_ON_table_column";
67
//        public final static String CREATE_INDEX_name_ON_table_USING_GIST_column = "CREATE_INDEX_name_ON_table_USING_GIST_column";
68 68
   
69 69
    }
70 70
    
......
91 91
        public Object getDefaultValue();
92 92
        public int getGeometryType();
93 93
        public int getGeometrySubtype();
94
        public int getGeometrySRSId();
94
        public Object getGeometrySRSId();
95 95
        public boolean isGeometry();
96 96
        
97 97
        public void setName(String name);
......
104 104
        public void setDefaultValue(Object defaultValue);
105 105
        public void setGeometryType(int geom_type);
106 106
        public void setGeometrySubtype(int geom_subtype);
107
        public void setGeometrySRSId(int geom_srsid);
107
        public void setGeometrySRSId(Object geom_srsid);
108 108
    }
109 109

  
110 110
    public interface CountBuilder extends Value {
......
218 218
        public AlterTableBuilder drop_column(String columnName);
219 219
        public AlterTableBuilder add_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue);
220 220
        public AlterTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls);
221
        public AlterTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls);
221 222
        public AlterTableBuilder alter_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue);
222 223
        public AlterTableBuilder alter_geometry_column(String columnName, int geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls);
224
        public AlterTableBuilder alter_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls);
223 225
        public AlterTableBuilder rename_column(String source, String target);
226
        public boolean isEmpty();
224 227
        public List<String> toStrings();
225 228
    }
226 229
    
......
228 231
        public TableNameBuilder table();
229 232
        public CreateTableBuilder add_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue);
230 233
        public CreateTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls);
234
        public CreateTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls);
231 235
        public ColumnDescriptorBuilder getColumnDescriptor(String columnName);
232 236
        public List<String> toStrings();
233 237
    }
......
259 263
        public TableNameBuilder table();
260 264
        public List<String> toStrings();
261 265
    }
266
    
267
    public interface CreateIndexBuilder extends Statement {
268
        public CreateIndexBuilder if_not_exist();
269
        public CreateIndexBuilder unique();
270
        public CreateIndexBuilder name(String name);
271
        public CreateIndexBuilder spatial();
272
        public CreateIndexBuilder column(String name);
273
        public TableNameBuilder table();
274
        public List<String> toStrings();
275
    }
262 276

  
263 277
    public String default_schema();
264 278
    
......
284 298
    public AlterTableBuilder alter_table();
285 299

  
286 300
    public CreateTableBuilder create_table();
301
    
302
    public CreateIndexBuilder create_index();
287 303

  
288 304
    public GrantBuilder grant();
289 305

  

Also available in: Unified diff