Package org.gvsig.fmap.dal.feature

Interface SQLBuilder_save

public interface SQLBuilder_save

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static interface	SQLBuilder_save.AlterTableBuilder
static interface	SQLBuilder_save.ColumnBuilder
static interface	SQLBuilder_save.CreateTableBuilder
static interface	SQLBuilder_save.DeleteBuilder
static interface	SQLBuilder_save.DropTableBuilder
static interface	SQLBuilder_save.ExpBuilder
static interface	SQLBuilder_save.FromBuilder
static enum	SQLBuilder_save.GeometrySupportType
static interface	SQLBuilder_save.GrantBuilder
static interface	SQLBuilder_save.InsertBuilder
static interface	SQLBuilder_save.OpBuilder
static interface	SQLBuilder_save.Parameter
static enum	SQLBuilder_save.Privilege
static interface	SQLBuilder_save.SelectBuilder
static interface	SQLBuilder_save.UpdateBuilder
static interface	SQLBuilder_save.UpdateTableStatisticsBuilder

Method Summary

Modifier and Type	Method	Description
void	addConstantParameter(Object value)
void	addParameter(int type, String name)
void	addParameter(int type, String name, org.gvsig.crs.projection.lib.Projection crs)
void	addParameter(org.gvsig.tools.dataTypes.DataType type, String name)
SQLBuilder_save.AlterTableBuilder	alter_table()
SQLBuilder_save.OpBuilder	and(String op1, String op2)
String	bytearray(byte[] data)
void	clearParameters()
String	count(String column)
SQLBuilder_save.CreateTableBuilder	create_table()
SQLBuilder_save.ExpBuilder	createExpresionBuilder()
SQLBuilder_save.ExpBuilder	createExpresionBuilder(String x)
SQLBuilder_save.ExpBuilder	createExpresionBuilder(SQLBuilder_save.OpBuilder x)
String	crs(String crs)
String	crs(org.gvsig.crs.projection.lib.Projection crs)
String	default_schema()
SQLBuilder_save.DeleteBuilder	delete()
SQLBuilder_save.DropTableBuilder	drop_table()
SQLBuilder_save.OpBuilder	eq(String op1, String op2)
SQLBuilder_save.OpBuilder	ge(String op1, String op2)
String	geometry(org.gvsig.fmap.geom.Geometry geom, org.gvsig.crs.projection.lib.Projection crs)
String	geometry(org.gvsig.fmap.geom.primitive.Envelope env, org.gvsig.crs.projection.lib.Projection crs)
SQLBuilder_save.GeometrySupportType	geometry_support_type()
byte[]	getEWKB(org.gvsig.fmap.geom.Geometry geom)
byte[]	getEWKB(org.gvsig.fmap.geom.primitive.Envelope env)
List<SQLBuilder_save.Parameter>	getParameters()
byte[]	getWKB(org.gvsig.fmap.geom.Geometry geom)
byte[]	getWKB(org.gvsig.fmap.geom.primitive.Envelope env)
String	getWKT(org.gvsig.fmap.geom.Geometry geom)
String	getWKT(org.gvsig.fmap.geom.primitive.Envelope env)
SQLBuilder_save.GrantBuilder	grant()
SQLBuilder_save.OpBuilder	gt(String op1, String op2)
boolean	has_spatial_functions()
String	identifier(String id)
SQLBuilder_save.OpBuilder	ilike(String op1, String op2)
SQLBuilder_save.InsertBuilder	insert()
String	isNull(String s)
String	lcase(String s)
SQLBuilder_save.OpBuilder	le(String op1, String op2)
SQLBuilder_save.OpBuilder	like(String op1, String op2)
SQLBuilder_save.OpBuilder	lt(String op1, String op2)
SQLBuilder_save.OpBuilder	ne(String op1, String op2)
SQLBuilder_save.OpBuilder	or(String op1, String op2)
SQLBuilder_save.SelectBuilder	select()
String	sqltype(int dataType, int p, int s)
String	ST_AsBinary(String geom)
String	ST_AsEWKB(String geom)
String	ST_AsText(String geom)
String	ST_Contains(String geom1, String geom2)
String	ST_Crosses(String geom1, String geom2)
String	ST_Envelope(String geom)
String	ST_ExtentAggregate(String geom)
String	ST_GeomFromEWKB(String geom, String crs)
String	ST_GeomFromEWKB(org.gvsig.fmap.geom.Geometry geom, org.gvsig.crs.projection.lib.Projection crs)
String	ST_GeomFromText(String geom, int crs)
String	ST_GeomFromText(String geom, String crs)
String	ST_GeomFromText(org.gvsig.fmap.geom.Geometry geom, org.gvsig.crs.projection.lib.Projection crs)
String	ST_GeomFromText(org.gvsig.fmap.geom.primitive.Envelope env, org.gvsig.crs.projection.lib.Projection crs)
String	ST_GeomFromWKB(String geom, String crs)
String	ST_GeomFromWKB(org.gvsig.fmap.geom.Geometry geom, org.gvsig.crs.projection.lib.Projection crs)
String	ST_Intersects(String geom1, String geom2)
String	ST_IsClosed(String geom1, String geom2)
String	ST_Overlaps(String geom1, String geom2)
String	ST_Touches(String geom1, String geom2)
String	ST_UnionAggregate(String geom)
String	ST_Within(String geom1, String geom2)
String	string(String s)
String	ucase(String s)
SQLBuilder_save.UpdateBuilder	update()
SQLBuilder_save.UpdateTableStatisticsBuilder	update_table_statistics()

Method Details

has_spatial_functions

boolean has_spatial_functions()

ST_AsText

String ST_AsText(String geom)

ST_AsBinary

String ST_AsBinary(String geom)

ST_AsEWKB

String ST_AsEWKB(String geom)

ST_Envelope

String ST_Envelope(String geom)

ST_ExtentAggregate

String ST_ExtentAggregate(String geom)

ST_UnionAggregate

String ST_UnionAggregate(String geom)

ST_GeomFromText

String ST_GeomFromText(String geom,
 String crs)

ST_GeomFromWKB

String ST_GeomFromWKB(String geom,
 String crs)

ST_GeomFromEWKB

String ST_GeomFromEWKB(String geom,
 String crs)

ST_GeomFromText

String ST_GeomFromText(String geom,
 int crs)

ST_GeomFromText

String ST_GeomFromText(org.gvsig.fmap.geom.Geometry geom,
 org.gvsig.crs.projection.lib.Projection crs)

ST_GeomFromWKB

String ST_GeomFromWKB(org.gvsig.fmap.geom.Geometry geom,
 org.gvsig.crs.projection.lib.Projection crs)

ST_GeomFromEWKB

String ST_GeomFromEWKB(org.gvsig.fmap.geom.Geometry geom,
 org.gvsig.crs.projection.lib.Projection crs)

ST_GeomFromText

String ST_GeomFromText(org.gvsig.fmap.geom.primitive.Envelope env,
 org.gvsig.crs.projection.lib.Projection crs)

ST_Intersects

String ST_Intersects(String geom1,
 String geom2)

ST_Contains

String ST_Contains(String geom1,
 String geom2)

ST_Crosses

String ST_Crosses(String geom1,
 String geom2)

ST_IsClosed

String ST_IsClosed(String geom1,
 String geom2)

ST_Overlaps

String ST_Overlaps(String geom1,
 String geom2)

ST_Touches

String ST_Touches(String geom1,
 String geom2)

ST_Within

String ST_Within(String geom1,
 String geom2)

isNull

String isNull(String s)

default_schema

String default_schema()

count

String count(String column)

lcase

String lcase(String s)

ucase

String ucase(String s)

getWKT

String getWKT(org.gvsig.fmap.geom.Geometry geom)

getWKB

byte[] getWKB(org.gvsig.fmap.geom.Geometry geom)

getEWKB

byte[] getEWKB(org.gvsig.fmap.geom.Geometry geom)

getWKT

String getWKT(org.gvsig.fmap.geom.primitive.Envelope env)

getWKB

byte[] getWKB(org.gvsig.fmap.geom.primitive.Envelope env)

getEWKB

byte[] getEWKB(org.gvsig.fmap.geom.primitive.Envelope env)

geometry

String geometry(org.gvsig.fmap.geom.Geometry geom,
 org.gvsig.crs.projection.lib.Projection crs)

geometry

String geometry(org.gvsig.fmap.geom.primitive.Envelope env,
 org.gvsig.crs.projection.lib.Projection crs)

string

String string(String s)

identifier

String identifier(String id)

bytearray

String bytearray(byte[] data)

crs

String crs(String crs)

crs

String crs(org.gvsig.crs.projection.lib.Projection crs)

sqltype

String sqltype(int dataType,
 int p,
 int s)

geometry_support_type

SQLBuilder_save.GeometrySupportType geometry_support_type()

and

SQLBuilder_save.OpBuilder and(String op1,
 String op2)

or

SQLBuilder_save.OpBuilder or(String op1,
 String op2)

eq

SQLBuilder_save.OpBuilder eq(String op1,
 String op2)

ne

SQLBuilder_save.OpBuilder ne(String op1,
 String op2)

gt

SQLBuilder_save.OpBuilder gt(String op1,
 String op2)

ge

SQLBuilder_save.OpBuilder ge(String op1,
 String op2)

lt

SQLBuilder_save.OpBuilder lt(String op1,
 String op2)

le

SQLBuilder_save.OpBuilder le(String op1,
 String op2)

like

SQLBuilder_save.OpBuilder like(String op1,
 String op2)

ilike

SQLBuilder_save.OpBuilder ilike(String op1,
 String op2)

createExpresionBuilder

SQLBuilder_save.ExpBuilder createExpresionBuilder(String x)

createExpresionBuilder

SQLBuilder_save.ExpBuilder createExpresionBuilder(SQLBuilder_save.OpBuilder x)

createExpresionBuilder

SQLBuilder_save.ExpBuilder createExpresionBuilder()

clearParameters

void clearParameters()

addParameter

void addParameter(org.gvsig.tools.dataTypes.DataType type,
 String name)

addParameter

void addParameter(int type,
 String name)

addParameter

void addParameter(int type,
 String name,
 org.gvsig.crs.projection.lib.Projection crs)

addConstantParameter

void addConstantParameter(Object value)

getParameters

List<SQLBuilder_save.Parameter> getParameters()

select

SQLBuilder_save.SelectBuilder select()

update

SQLBuilder_save.UpdateBuilder update()

insert

SQLBuilder_save.InsertBuilder insert()

delete

SQLBuilder_save.DeleteBuilder delete()

alter_table

SQLBuilder_save.AlterTableBuilder alter_table()

create_table

SQLBuilder_save.CreateTableBuilder create_table()

grant

SQLBuilder_save.GrantBuilder grant()

drop_table

SQLBuilder_save.DropTableBuilder drop_table()

update_table_statistics

SQLBuilder_save.UpdateTableStatisticsBuilder update_table_statistics()