Uses of Class
org.apache.sis.internal.metadata.sql.SQLBuilder
Packages that use SQLBuilder
Package
Description
A set of helper classes for SQL handling in the Apache SIS implementation.
Build
DefaultFeatureType
s by inspection of database schemas.Specialization of
org.apache.sis.internal.sql.feature
for the PostGIS database.An implementation of Metadata interfaces
fetching the data from an SQL database.
-
Uses of SQLBuilder in org.apache.sis.internal.metadata.sql
Methods in org.apache.sis.internal.metadata.sql that return SQLBuilderModifier and TypeMethodDescriptionfinal SQLBuilder
SQLBuilder.append
(char c) Appends the given character.final SQLBuilder
SQLBuilder.append
(int n) Appends the given integer.final SQLBuilder
SQLBuilder.append
(long n) Appends the given long integer.final SQLBuilder
Appends the given text verbatim.final SQLBuilder
SQLBuilder.appendEqualsValue
(Object value) Appends a"= <value>"
string in aSELECT
statement.final SQLBuilder
SQLBuilder.appendFetchPage
(long offset, long count) AppendsOFFSET
andFETCH
clauses for fetching only a page of data.final SQLBuilder
SQLBuilder.appendIdentifier
(String identifier) Appends an identifier between quote characters.final SQLBuilder
SQLBuilder.appendIdentifier
(String schema, String identifier) Appends an identifier for an element in the given schema.final SQLBuilder
SQLBuilder.appendIdentifier
(String catalog, String schema, String identifier) Appends an identifier for an element in the given schema and catalog.final SQLBuilder
SQLBuilder.appendValue
(Object value) Appends a value in aSELECT
orINSERT
statement.final SQLBuilder
SQLBuilder.appendValue
(String value) Appends a value in aSELECT
orINSERT
statement.final SQLBuilder
SQLBuilder.appendWildcardEscaped
(String value) Appends a string as an escapedLIKE
argument.final SQLBuilder
SQLBuilder.clear()
Clears this builder and make it ready for creating a new SQL statement.final SQLBuilder
SQLBuilder.insertDistinctAfterSelect()
Inserts theDISTINCT
keyword afterSELECT
. -
Uses of SQLBuilder in org.apache.sis.internal.sql.feature
Subclasses of SQLBuilder in org.apache.sis.internal.sql.featureModifier and TypeClassDescriptionfinal class
Builder for the SQL fragment on the right side of theWHERE
keyword.Methods in org.apache.sis.internal.sql.feature that return SQLBuilderModifier and TypeMethodDescriptionprivate static SQLBuilder
InfoStatements.appendCondition
(SQLBuilder sql, char prefix, String column) Appends a statement after"WHERE"
such as""F_TABLE_NAME = ?"
.Methods in org.apache.sis.internal.sql.feature with parameters of type SQLBuilderModifier and TypeMethodDescriptionprivate static int
FeatureAdapter.appendColumn
(SQLBuilder sql, String column, Map<String, Integer> columnIndices) Appends a columns in the given builder and remember the column indices.private static SQLBuilder
InfoStatements.appendCondition
(SQLBuilder sql, char prefix, String column) Appends a statement after"WHERE"
such as""F_TABLE_NAME = ?"
.private void
InfoStatements.appendFrom
(SQLBuilder sql, String table) Appends a" FROM <table> WHERE "
text to the given builder.(package private) final void
Table.appendFromClause
(SQLBuilder sql) Appends the catalog, schema and table name to the given builder after the"FROM"
keyword.final void
Database.appendFunctionCall
(SQLBuilder sql, String function) Appends a call to a function defined in the spatial schema.private static int[]
FeatureAdapter.getColumnIndices
(SQLBuilder sql, Relation dependency, Map<String, Integer> columnIndices) Computes the 1-based indices of columns of foreigner keys of given dependency. -
Uses of SQLBuilder in org.apache.sis.internal.sql.postgis
Fields in org.apache.sis.internal.sql.postgis declared as SQLBuilderModifier and TypeFieldDescriptionprivate final SQLBuilder
ExtentEstimator.builder
A temporary buffer with helper methods for building the SQL statement. -
Uses of SQLBuilder in org.apache.sis.metadata.sql
Fields in org.apache.sis.metadata.sql declared as SQLBuilderModifier and TypeFieldDescriptionprivate final SQLBuilder
IdentifierGenerator.buffer
A helper object for building SQL statements, determined from database metadata.private SQLBuilder
MetadataSource.helper
A helper class used for constructing SQL statements.Methods in org.apache.sis.metadata.sql that return SQLBuilderModifier and TypeMethodDescription(package private) final SQLBuilder
MetadataSource.helper()
Returns a helper class for building SQL statements.Methods in org.apache.sis.metadata.sql with parameters of type SQLBuilderModifier and TypeMethodDescription(package private) final String
MetadataSource.search
(String table, Set<String> columns, Map<String, Object> metadata, Statement stmt, SQLBuilder helper) Searches for the given metadata in the database.Constructors in org.apache.sis.metadata.sql with parameters of type SQLBuilderModifierConstructorDescription(package private)
IdentifierGenerator
(MetadataSource source, String schema, String table, String column, SQLBuilder buffer) Creates a new generator.