- All Implemented Interfaces:
Serializable,Iterable<BigDecimal>,Collection<BigDecimal>,List<BigDecimal>,ArrayOrAssociativeArrayRecord<BigDecimal>,ArrayRecord<BigDecimal>,Attachable,Formattable
- Enclosing class:
DefaultBinding<T,U>
- See Also:
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionfinal voidAttach this object to a newConfiguration.final Configurationprotected final DSLContextcreate()Deprecated.final voiddetach()Detach this object from its currentConfiguration.final Stringformat()Get a simple formatted representation of this result.final Stringformat(int maxRecords) Get a simple formatted representation of this result.final voidformat(OutputStream stream) LikeFormattable.format(), but the data is output onto anOutputStream.final voidformat(OutputStream stream, int maxRecords) LikeFormattable.format(int), but the data is output onto anOutputStream.final voidformat(OutputStream stream, TXTFormat format) LikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.final voidLikeFormattable.format(), but the data is output onto aWriter.final voidLikeFormattable.format(int), but the data is output onto aWriter.final StringGet a simple formatted representation of this result.final StringGet this result as an ASCII chart.final voidformatChart(OutputStream stream) LikeFormattable.formatChart(), but the data is output onto anOutputStream.final voidformatChart(OutputStream stream, ChartFormat format) LikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.final voidformatChart(Writer writer) LikeFormattable.formatChart(), but the data is output onto aWriter.final StringformatChart(ChartFormat format) Get this result as an ASCII chart.final StringGet a simple formatted representation of this result as CSV.final StringformatCSV(boolean header) Get a simple formatted representation of this result as CSV.final StringformatCSV(boolean header, char delimiter) Get a simple formatted representation of this result as CSV.final StringGet a simple formatted representation of this result as CSV.final StringformatCSV(char delimiter) Get a simple formatted representation of this result as CSV.final StringGet a simple formatted representation of this result as CSV.final voidformatCSV(OutputStream stream) LikeFormattable.formatCSV(), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, boolean header) LikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, boolean header, char delimiter) LikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, boolean header, char delimiter, String nullString) LikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, char delimiter) LikeFormattable.formatCSV(char), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, char delimiter, String nullString) LikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.final voidformatCSV(OutputStream stream, CSVFormat format) LikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.final voidLikeFormattable.formatCSV(), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(boolean), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(char), but the data is output onto aWriter.final voidLikeFormattable.formatCSV(char, String), but the data is output onto aWriter.final StringGet a simple formatted representation of this result as CSV.final StringGet a simple formatted representation of this result as HTML.final voidformatHTML(OutputStream stream) LikeFormattable.formatHTML(), but the data is output onto anOutputStream.final StringGet this result as a set ofINSERTstatements.final voidformatInsert(OutputStream stream) LikeFormattable.formatInsert(), but the data is output onto anOutputStream.final voidformatInsert(OutputStream stream, Table<?> table, Field<?>... f) LikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.final StringformatInsert(Table<?> table, Field<?>... f) Get this result as a set ofINSERTstatements.final StringGet a simple formatted representation of this result as a JSON array of array.final voidformatJSON(OutputStream stream) LikeFormattable.formatJSON(), but the data is output onto anOutputStream.final voidformatJSON(OutputStream stream, JSONFormat format) LikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.final voidformatJSON(Writer writer) LikeFormattable.formatJSON(), but the data is output onto aWriter.final StringformatJSON(JSONFormat format) Get a simple formatted representation of this result as a JSON data structure, according to the format.final StringGet this result formatted as XML.final voidformatXML(OutputStream stream) LikeFormattable.formatXML(), but the data is output onto anOutputStream.final voidformatXML(OutputStream stream, XMLFormat format) LikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.final voidLikeFormattable.formatXML(), but the data is output onto aWriter.final StringGet this result formatted as XML.final DocumentintoXML()Get this result as XML.final <H extends ContentHandler>
HintoXML(H handler) Get this result as XML using a SAXContentHandler.Methods inherited from class org.jooq.impl.ArrayRecordImpl
add, add, addAll, addAll, clear, contains, containsAll, equals, format, formatChart, formatCSV, formatHTML, formatInsert, formatInsert, formatJSON, formatXML, get, getArrayType, getCatalog, getDataType, getName, getPackage, getSchema, hashCode, indexOf, intoXML, intoXML, isEmpty, isSQLUsable, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, size, subList, toArray, toArray, toList, toStringMethods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, waitMethods inherited from interface org.jooq.Attachable
attach, configuration, detachMethods inherited from interface java.util.Collection
parallelStream, removeIf, stream, toArrayMethods inherited from interface org.jooq.Formattable
format, format, format, format, format, format, format, format, formatChart, formatChart, formatChart, formatChart, formatChart, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatCSV, formatHTML, formatHTML, formatInsert, formatInsert, formatInsert, formatInsert, formatJSON, formatJSON, formatJSON, formatJSON, formatJSON, formatXML, formatXML, formatXML, formatXML, formatXML, intoXML, intoXMLMethods inherited from interface java.util.List
replaceAll, sort, spliterator
-
Constructor Details
-
SdoOrdinateArray
public SdoOrdinateArray()
-
-
Method Details
-
create
Deprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()andConfiguration.dsl()instead.This method is used in generated code! -
attach
Description copied from interface:AttachableAttach this object to a newConfiguration.- Specified by:
attachin interfaceAttachable- Parameters:
c- A configuration ornull, if you wish to detach thisAttachablefrom its previous configuration.
-
detach
public final void detach()Description copied from interface:AttachableDetach this object from its currentConfiguration.This is the same as calling
attach(null).- Specified by:
detachin interfaceAttachable
-
configuration
Description copied from interface:Attachable- Specified by:
configurationin interfaceAttachable
-
format
Description copied from interface:FormattableGet a simple formatted representation of this result.This is the same as calling
Formattable.format(int)withmaxRows = Integer.MAX_VALUE- Specified by:
formatin interfaceFormattable- Returns:
- The formatted result
-
format
Description copied from interface:FormattableGet a simple formatted representation of this result.- Specified by:
formatin interfaceFormattable- Parameters:
maxRecords- The maximum number of records to include in the formatted result- Returns:
- The formatted result
-
format
Description copied from interface:FormattableGet a simple formatted representation of this result.- Specified by:
formatin interfaceFormattable- Parameters:
format- The formatting information- Returns:
- The formatted result
-
format
Description copied from interface:FormattableLikeFormattable.format(), but the data is output onto anOutputStream.- Specified by:
formatin interfaceFormattable
-
format
Description copied from interface:FormattableLikeFormattable.format(int), but the data is output onto anOutputStream.- Specified by:
formatin interfaceFormattable
-
format
Description copied from interface:FormattableLikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.- Specified by:
formatin interfaceFormattable
-
format
Description copied from interface:FormattableLikeFormattable.format(), but the data is output onto aWriter.- Specified by:
formatin interfaceFormattable
-
format
Description copied from interface:FormattableLikeFormattable.format(int), but the data is output onto aWriter.- Specified by:
formatin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(true, ',', "")- Specified by:
formatCSVin interfaceFormattable- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(',', "")- Specified by:
formatCSVin interfaceFormattable- Parameters:
header- Whether to emit a CSV header line- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(true, delimiter, "")- Specified by:
formatCSVin interfaceFormattable- Parameters:
delimiter- The delimiter to use between records- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(delimiter, "")- Specified by:
formatCSVin interfaceFormattable- Parameters:
header- Whether to emit a CSV header linedelimiter- The delimiter to use between records- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(true, delimiter, nullString)- Specified by:
formatCSVin interfaceFormattable- Parameters:
delimiter- The delimiter to use between recordsnullString- A special string for encodingNULLvalues.- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.- Specified by:
formatCSVin interfaceFormattable- Parameters:
header- Whether to emit a CSV header linedelimiter- The delimiter to use between recordsnullString- A special string for encodingNULLvalues.- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.- Specified by:
formatCSVin interfaceFormattable- Returns:
- The formatted result
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatJSON
Description copied from interface:FormattableGet a simple formatted representation of this result as a JSON array of array.The format is the following:
{"fields":[{"name":"field-1","type":"type-1"}, {"name":"field-2","type":"type-2"}, ..., {"name":"field-n","type":"type-n"}], "records":[[value-1-1,value-1-2,...,value-1-n], [value-2-1,value-2-2,...,value-2-n]]}- Specified by:
formatJSONin interfaceFormattable- Returns:
- The formatted result
-
formatJSON
Description copied from interface:FormattableGet a simple formatted representation of this result as a JSON data structure, according to the format.- Specified by:
formatJSONin interfaceFormattable- Returns:
- The formatted result
- See Also:
-
formatJSON
Description copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto anOutputStream.- Specified by:
formatJSONin interfaceFormattable
-
formatJSON
Description copied from interface:FormattableLikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.- Specified by:
formatJSONin interfaceFormattable
-
formatJSON
Description copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto aWriter.- Specified by:
formatJSONin interfaceFormattable
-
formatXML
Description copied from interface:FormattableGet this result formatted as XML.- Specified by:
formatXMLin interfaceFormattable- See Also:
-
formatXML
Description copied from interface:FormattableGet this result formatted as XML.- Specified by:
formatXMLin interfaceFormattable- See Also:
-
formatXML
Description copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto anOutputStream.- Specified by:
formatXMLin interfaceFormattable
-
formatXML
Description copied from interface:FormattableLikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.- Specified by:
formatXMLin interfaceFormattable
-
formatXML
Description copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto aWriter.- Specified by:
formatXMLin interfaceFormattable
-
formatChart
Description copied from interface:FormattableGet this result as an ASCII chart.- Specified by:
formatChartin interfaceFormattable- See Also:
-
formatChart
Description copied from interface:FormattableGet this result as an ASCII chart.When running a query like this:
Where the formatted result would look like this:String chart = create.select( BOOK_TO_BOOK_STORE.BOOK_STORE_NAME, count(BOOK_TO_BOOK_STORE.BOOK_ID).as("books") ) .from(BOOK_TO_BOOK_STORE) .groupBy(BOOK_TO_BOOK_STORE.BOOK_STORE_NAME) .fetch() .formatChart();+-------------------------+-----+ |BOOK_STORE_NAME |books| +-------------------------+-----+ |Buchhandlung im Volkshaus| 1| |Ex Libris | 2| |Orell Füssli | 3| +-------------------------+-----+
Then the chart might look something like this:3.00| █████████████████████████ 2.91| █████████████████████████ 2.82| █████████████████████████ 2.73| █████████████████████████ 2.64| █████████████████████████ 2.55| █████████████████████████ 2.45| █████████████████████████ 2.36| █████████████████████████ 2.27| █████████████████████████ 2.18| █████████████████████████ 2.09| █████████████████████████ 2.00| ██████████████████████████████████████████████████ 1.91| ██████████████████████████████████████████████████ 1.82| ██████████████████████████████████████████████████ 1.73| ██████████████████████████████████████████████████ 1.64| ██████████████████████████████████████████████████ 1.55| ██████████████████████████████████████████████████ 1.45| ██████████████████████████████████████████████████ 1.36| ██████████████████████████████████████████████████ 1.27| ██████████████████████████████████████████████████ 1.18| ██████████████████████████████████████████████████ 1.09| ██████████████████████████████████████████████████ 1.00|███████████████████████████████████████████████████████████████████████████ ----+--------------------------------------------------------------------------- | Buchhandlung im Volkshaus Ex Libris Orell FüssliIt is possible to specify a variety ofChartFormatformatting specifications, such as the width, height, display type (default, stacked, 100% stacked), the column index of the category and value columns, etc.- Specified by:
formatChartin interfaceFormattable- See Also:
-
formatChart
Description copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto anOutputStream.- Specified by:
formatChartin interfaceFormattable
-
formatChart
Description copied from interface:FormattableLikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.- Specified by:
formatChartin interfaceFormattable
-
formatChart
Description copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto aWriter.- Specified by:
formatChartin interfaceFormattable
-
formatInsert
Description copied from interface:FormattableGet this result as a set ofINSERTstatements.This uses the the first record's
TableRecord.getTable(), if the first record is aTableRecord. Otherwise, this generatesINSERTstatements into an"UNKNOWN_TABLE". In both cases, theFields.fields()are used for column names.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
Description copied from interface:FormattableLikeFormattable.formatInsert(), but the data is output onto anOutputStream.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
Description copied from interface:FormattableGet this result as a set ofINSERTstatements.This explicitly specifies the table (and optionally the fields) to insert into. If the
fieldsargument is left empty, theFields.fields()are used, instead.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
Description copied from interface:FormattableLikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.- Specified by:
formatInsertin interfaceFormattable
-
formatHTML
Description copied from interface:FormattableGet a simple formatted representation of this result as HTML.The HTML code is formatted as follows:
<table> <thead> <tr> <th>field-1</th> <th>field-2</th> ... <th>field-n</th> </tr> </thead> <tbody> <tr> <th>value-1-1</th> <th>value-1-2</th> ... <th>value-1-n</th> </tr> <tr> <th>value-2-1</th> <th>value-2-2</th> ... <th>value-2-n</th> </tr> ... </tbody> </table>- Specified by:
formatHTMLin interfaceFormattable- Returns:
- The formatted result
-
formatHTML
Description copied from interface:FormattableLikeFormattable.formatHTML(), but the data is output onto anOutputStream.- Specified by:
formatHTMLin interfaceFormattable
-
intoXML
Description copied from interface:FormattableGet this result as XML.- Specified by:
intoXMLin interfaceFormattable- See Also:
-
intoXML
Description copied from interface:FormattableGet this result as XML using a SAXContentHandler.- Specified by:
intoXMLin interfaceFormattable- Parameters:
handler- The custom content handler.- Returns:
- The argument content handler is returned for convenience.
- Throws:
SAXException- See Also:
-
Attachable.configuration()andConfiguration.dsl()instead.