Application: gvSIG desktop

import java.util.List;

import org.cresques.cts.IProjection;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

    public enum Privilege {

        SELECT,

        INSERT,

        ALL

    };

        public String getName();

        public int getType();

        public int getSize();

        public int getPrecision();

        public boolean isPrimaryKey();

        public boolean isIndexed();

        public boolean isAutomatic();

        boolean allowNulls();

        public Object getDefaultValue();

        public int getGeometryType();

        public int getGeometrySubtype();

        public Object getGeometrySRSId();

        public boolean isGeometry();

        public DataStoreParameters getStoreParameters();

        public void setName(String name);

        public void setType(int type);

        public void setSize(int size);

        public void setPrecision(int precision);

        public void setIsPrimaryKey(boolean isPk);

        public void setIsAutomatic(boolean isAutomatic);

        public void setAllowNulls(boolean allowNulls);

        public void setDefaultValue(Object defaultValue);

        public void setGeometryType(int geom_type);

        public void setGeometrySubtype(int geom_subtype);

        public void setGeometrySRSId(Object geom_srsid);

    }

    }

        public TableNameBuilder database(String name);

        public TableNameBuilder schema(String name);

        public TableNameBuilder name(String name);

        public String getDatabase();

        public String getSchema();

        public String getName();

        public boolean has_database();

        public boolean has_schema();

    }

        public CountBuilder all();

        public CountBuilder column(Value value);

        public CountBuilder distinct();

    }

        public SelectColumnBuilder name(String name);

        public SelectColumnBuilder value(Value value);

        public SelectColumnBuilder as(String alias);

        public SelectColumnBuilder as_geometry();

        public SelectColumnBuilder all();

        public String getName();

        public String getAlias();

        public String getValue();

    }

        public InsertColumnBuilder name(String name);

        public InsertColumnBuilder with_value(Value value);

        public String getName();

        public Value getValue();

    }

    public interface UpdateColumnBuilder extends InsertColumnBuilder {

        @Override

        public UpdateColumnBuilder name(String name);

        @Override

        public UpdateColumnBuilder with_value(Value value);

        @Override

        public String getName();

        @Override

        public Value getValue();

    }

        public TableNameBuilder table();

        public FromBuilder subquery(String subquery);

        public FromBuilder custom(String passthrough);

    }

        public OrderByBuilder column(String name);

        public OrderByBuilder ascending(boolean asc);

        public OrderByBuilder ascending();

        public OrderByBuilder descending();

        public OrderByBuilder custom(String order);

    }

    public interface SelectBuilder extends Statement {

        public SelectColumnBuilder column();

        public FromBuilder from();

        public ExpressionBuilder where();

        public OrderByBuilder order_by();

        public SelectBuilder distinct();

        public SelectBuilder limit(long limit);

        public SelectBuilder limit(Long limit);

        /**

         * @param offset

         * @return this SelectBuilder

         */

        public SelectBuilder offset(long offset);

        public boolean has_column(String name);

        public boolean has_where();

        public boolean has_from();

        public boolean has_order_by();

        public boolean has_limit();

        public boolean has_offset();

        /**

         * @return the SQL select statement.

         */

        @Override

        public String toString();

    }

    public interface UpdateBuilder extends Statement {

        public TableNameBuilder table();

        public UpdateColumnBuilder column();

        public ExpressionBuilder where();

        public boolean has_where();

    }

    public interface InsertBuilder extends Statement {

        public TableNameBuilder table();

        public InsertColumnBuilder column();

    }

    public interface DeleteBuilder extends Statement {

        public TableNameBuilder table();

        public ExpressionBuilder where();

        public boolean has_where();

    }

    public interface AlterTableBuilder extends Statement {

        public TableNameBuilder table();

        public AlterTableBuilder drop_column(String columnName);

        public AlterTableBuilder add_column(FeatureAttributeDescriptor fad);

        public AlterTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls);

        public AlterTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls);

        public AlterTableBuilder alter_column(FeatureAttributeDescriptor fad);

        public AlterTableBuilder alter_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue);

        public AlterTableBuilder alter_geometry_column(String columnName, int geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls);

        public AlterTableBuilder alter_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls);

        public AlterTableBuilder rename_column(String source, String target);

        public boolean isEmpty();

        public List<String> toStrings();

    }

    public interface CreateTableBuilder extends Statement {

        public TableNameBuilder table();

        public CreateTableBuilder add_column(FeatureAttributeDescriptor fad);

        public CreateTableBuilder add_column(String columnName, int type, int type_p, int type_s, boolean isPk, boolean isIndexed, boolean allowNulls, boolean isAutomatic, Object defaultValue);

        public CreateTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, IProjection proj, boolean isIndexed, boolean allowNulls);

        public CreateTableBuilder add_geometry_column(String columnName, int geom_type, int geom_subtype, Object srsdbcode, boolean isIndexed, boolean allowNulls);

        public ColumnDescriptor getColumnDescriptor(String columnName);

        public List<String> toStrings();

    }

    public interface UpdateTableStatisticsBuilder extends Statement {

        public TableNameBuilder table();

        public List<String> toStrings();

    }

        public GrantRoleBuilder privilege(Privilege privilege);

        public GrantRoleBuilder select();

        public GrantRoleBuilder insert();

        public GrantRoleBuilder delete();

        public GrantRoleBuilder truncate();

        public GrantRoleBuilder reference();

        public GrantRoleBuilder update();

        public GrantRoleBuilder trigger();

        public GrantRoleBuilder all();

    }

    public interface GrantBuilder extends Statement {

        public TableNameBuilder table();

        public List<String> toStrings();

    }

    public interface DropTableBuilder extends Statement {

        public TableNameBuilder table();

        public List<String> toStrings();

    }

    public interface CreateIndexBuilder extends Statement {

        public CreateIndexBuilder if_not_exist();

        public CreateIndexBuilder unique();

        public CreateIndexBuilder name(String name);

        public CreateIndexBuilder spatial();

        public CreateIndexBuilder column(String name);

        public TableNameBuilder table();

        public List<String> toStrings();

    }

    public String sqltype(int dataType, int p, int s, int geomType, int geomSubtype);

    public Object sqlgeometrytype(int type, int subtype);

    public Object sqlgeometrydimension(int type, int subtype);

    public SelectBuilder select();

    public UpdateBuilder update();

    public InsertBuilder insert();

    public DeleteBuilder delete();

    public AlterTableBuilder alter_table();

    public CreateTableBuilder create_table();

    public CreateIndexBuilder create_index();

    public GrantBuilder grant();

    public UpdateTableStatisticsBuilder update_table_statistics();

    public CountBuilder count();

}