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
DefaultFeatureTypes 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 SQLBuilderSQLBuilder.append(char c) Appends the given character.final SQLBuilderSQLBuilder.append(int n) Appends the given integer.final SQLBuilderSQLBuilder.append(long n) Appends the given long integer.final SQLBuilderAppends the given text verbatim.final SQLBuilderSQLBuilder.appendEqualsValue(Object value) Appends a"= <value>"string in aSELECTstatement.final SQLBuilderSQLBuilder.appendFetchPage(long offset, long count) AppendsOFFSETandFETCHclauses for fetching only a page of data.final SQLBuilderSQLBuilder.appendIdentifier(String identifier) Appends an identifier between quote characters.final SQLBuilderSQLBuilder.appendIdentifier(String schema, String identifier) Appends an identifier for an element in the given schema.final SQLBuilderSQLBuilder.appendIdentifier(String catalog, String schema, String identifier) Appends an identifier for an element in the given schema and catalog.final SQLBuilderSQLBuilder.appendValue(Object value) Appends a value in aSELECTorINSERTstatement.final SQLBuilderSQLBuilder.appendValue(String value) Appends a value in aSELECTorINSERTstatement.final SQLBuilderSQLBuilder.appendWildcardEscaped(String value) Appends a string as an escapedLIKEargument.final SQLBuilderSQLBuilder.clear()Clears this builder and make it ready for creating a new SQL statement.final SQLBuilderSQLBuilder.insertDistinctAfterSelect()Inserts theDISTINCTkeyword afterSELECT. -
Uses of SQLBuilder in org.apache.sis.internal.sql.feature
Subclasses of SQLBuilder in org.apache.sis.internal.sql.featureModifier and TypeClassDescriptionfinal classBuilder for the SQL fragment on the right side of theWHEREkeyword.Methods in org.apache.sis.internal.sql.feature that return SQLBuilderModifier and TypeMethodDescriptionprivate static SQLBuilderInfoStatements.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 intFeatureAdapter.appendColumn(SQLBuilder sql, String column, Map<String, Integer> columnIndices) Appends a columns in the given builder and remember the column indices.private static SQLBuilderInfoStatements.appendCondition(SQLBuilder sql, char prefix, String column) Appends a statement after"WHERE"such as""F_TABLE_NAME = ?".private voidInfoStatements.appendFrom(SQLBuilder sql, String table) Appends a" FROM <table> WHERE "text to the given builder.(package private) final voidTable.appendFromClause(SQLBuilder sql) Appends the catalog, schema and table name to the given builder after the"FROM"keyword.final voidDatabase.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 SQLBuilderExtentEstimator.builderA 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 SQLBuilderIdentifierGenerator.bufferA helper object for building SQL statements, determined from database metadata.private SQLBuilderMetadataSource.helperA helper class used for constructing SQL statements.Methods in org.apache.sis.metadata.sql that return SQLBuilderModifier and TypeMethodDescription(package private) final SQLBuilderMetadataSource.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 StringMetadataSource.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.