- All Implemented Interfaces:
Serializable
,Iterable<BigDecimal>
,Collection<BigDecimal>
,List<BigDecimal>
,ArrayRecord<BigDecimal>
,Attachable
,Formattable
- Enclosing class:
- DefaultBinding<T,
U>
- See Also:
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionfinal void
Attach this object to a newConfiguration
.final Configuration
protected final DSLContext
create()
Deprecated.final void
detach()
Detach this object from its currentConfiguration
.final String
format()
Get a simple formatted representation of this result.final String
format
(int maxRecords) Get a simple formatted representation of this result.final void
format
(OutputStream stream) LikeFormattable.format()
, but the data is output onto anOutputStream
.final void
format
(OutputStream stream, int maxRecords) LikeFormattable.format(int)
, but the data is output onto anOutputStream
.final void
format
(OutputStream stream, TXTFormat format) LikeFormattable.format(TXTFormat)
, but the data is output onto anOutputStream
.final void
LikeFormattable.format()
, but the data is output onto aWriter
.final void
LikeFormattable.format(int)
, but the data is output onto aWriter
.final String
Get a simple formatted representation of this result.final String
Get this result as an ASCII chart.final void
formatChart
(OutputStream stream) LikeFormattable.formatChart()
, but the data is output onto anOutputStream
.final void
formatChart
(OutputStream stream, ChartFormat format) LikeFormattable.formatChart(ChartFormat)
, but the data is output onto anOutputStream
.final void
formatChart
(Writer writer) LikeFormattable.formatChart()
, but the data is output onto aWriter
.final String
formatChart
(ChartFormat format) Get this result as an ASCII chart.final String
Get a simple formatted representation of this result as CSV.final String
formatCSV
(boolean header) Get a simple formatted representation of this result as CSV.final String
formatCSV
(boolean header, char delimiter) Get a simple formatted representation of this result as CSV.final String
Get a simple formatted representation of this result as CSV.final String
formatCSV
(char delimiter) Get a simple formatted representation of this result as CSV.final String
Get a simple formatted representation of this result as CSV.final void
formatCSV
(OutputStream stream) LikeFormattable.formatCSV()
, but the data is output onto anOutputStream
.final void
formatCSV
(OutputStream stream, boolean header) LikeFormattable.formatCSV(boolean)
, but the data is output onto anOutputStream
.final void
formatCSV
(OutputStream stream, boolean header, char delimiter) LikeFormattable.formatCSV(boolean, char)
, but the data is output onto anOutputStream
.final void
formatCSV
(OutputStream stream, boolean header, char delimiter, String nullString) LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto anOutputStream
.final void
formatCSV
(OutputStream stream, char delimiter) LikeFormattable.formatCSV(char)
, but the data is output onto anOutputStream
.final void
formatCSV
(OutputStream stream, char delimiter, String nullString) LikeFormattable.formatCSV(char, String)
, but the data is output onto anOutputStream
.final void
formatCSV
(OutputStream stream, CSVFormat format) LikeFormattable.formatCSV(CSVFormat)
, but the data is output onto anOutputStream
.final void
LikeFormattable.formatCSV()
, but the data is output onto aWriter
.final void
LikeFormattable.formatCSV(boolean)
, but the data is output onto aWriter
.final void
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto aWriter
.final void
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto aWriter
.final void
LikeFormattable.formatCSV(char)
, but the data is output onto aWriter
.final void
LikeFormattable.formatCSV(char, String)
, but the data is output onto aWriter
.final String
Get a simple formatted representation of this result as CSV.final String
Get a simple formatted representation of this result as HTML.final void
formatHTML
(OutputStream stream) LikeFormattable.formatHTML()
, but the data is output onto anOutputStream
.final String
Get this result as a set ofINSERT
statements.final void
formatInsert
(OutputStream stream) LikeFormattable.formatInsert()
, but the data is output onto anOutputStream
.final void
formatInsert
(OutputStream stream, Table<?> table, Field<?>... f) LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.final String
formatInsert
(Table<?> table, Field<?>... f) Get this result as a set ofINSERT
statements.final String
Get a simple formatted representation of this result as a JSON array of array.final void
formatJSON
(OutputStream stream) LikeFormattable.formatJSON()
, but the data is output onto anOutputStream
.final void
formatJSON
(OutputStream stream, JSONFormat format) LikeFormattable.formatJSON(JSONFormat)
, but the data is output onto anOutputStream
.final void
formatJSON
(Writer writer) LikeFormattable.formatJSON()
, but the data is output onto aWriter
.final String
formatJSON
(JSONFormat format) Get a simple formatted representation of this result as a JSON data structure, according to the format.final String
Get this result formatted as XML.final void
formatXML
(OutputStream stream) LikeFormattable.formatXML()
, but the data is output onto anOutputStream
.final void
formatXML
(OutputStream stream, XMLFormat format) LikeFormattable.formatXML(XMLFormat)
, but the data is output onto anOutputStream
.final void
LikeFormattable.formatXML()
, but the data is output onto aWriter
.final String
Get this result formatted as XML.final Document
intoXML()
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, get, getArrayType, getCatalog, getDataType, getList, getName, getPackage, getSchema, hashCode, indexOf, intoXML, intoXML, isEmpty, isSQLUsable, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, set, set, size, subList, toArray, toArray, toString
Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.jooq.Attachable
attach, configuration, detach
Methods inherited from interface java.util.Collection
parallelStream, removeIf, stream, toArray
Methods 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:Attachable
Attach this object to a newConfiguration
.- Specified by:
attach
in interfaceAttachable
- Parameters:
c
- A configuration ornull
, if you wish to detach thisAttachable
from its previous configuration.
-
detach
public final void detach()Description copied from interface:Attachable
Detach this object from its currentConfiguration
.This is the same as calling
attach(null)
.- Specified by:
detach
in interfaceAttachable
-
configuration
Description copied from interface:Attachable
- Specified by:
configuration
in interfaceAttachable
-
format
Description copied from interface:Formattable
Get a simple formatted representation of this result.This is the same as calling
Formattable.format(int)
withmaxRows = Integer.MAX_VALUE
- Specified by:
format
in interfaceFormattable
- Returns:
- The formatted result
-
format
Description copied from interface:Formattable
Get a simple formatted representation of this result.- Specified by:
format
in interfaceFormattable
- Parameters:
maxRecords
- The maximum number of records to include in the formatted result- Returns:
- The formatted result
-
format
Description copied from interface:Formattable
Get a simple formatted representation of this result.- Specified by:
format
in interfaceFormattable
- Parameters:
format
- The formatting information- Returns:
- The formatted result
-
format
Description copied from interface:Formattable
LikeFormattable.format()
, but the data is output onto anOutputStream
.- Specified by:
format
in interfaceFormattable
-
format
Description copied from interface:Formattable
LikeFormattable.format(int)
, but the data is output onto anOutputStream
.- Specified by:
format
in interfaceFormattable
-
format
Description copied from interface:Formattable
LikeFormattable.format(TXTFormat)
, but the data is output onto anOutputStream
.- Specified by:
format
in interfaceFormattable
-
format
Description copied from interface:Formattable
LikeFormattable.format()
, but the data is output onto aWriter
.- Specified by:
format
in interfaceFormattable
-
format
Description copied from interface:Formattable
LikeFormattable.format(int)
, but the data is output onto aWriter
.- Specified by:
format
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
Get a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(true, ',', "")
- Specified by:
formatCSV
in interfaceFormattable
- Returns:
- The formatted result
-
formatCSV
Description copied from interface:Formattable
Get a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(',', "")
- Specified by:
formatCSV
in interfaceFormattable
- Parameters:
header
- Whether to emit a CSV header line- Returns:
- The formatted result
-
formatCSV
Description copied from interface:Formattable
Get a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(true, delimiter, "")
- Specified by:
formatCSV
in interfaceFormattable
- Parameters:
delimiter
- The delimiter to use between records- Returns:
- The formatted result
-
formatCSV
Description copied from interface:Formattable
Get a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(delimiter, "")
- Specified by:
formatCSV
in 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:Formattable
Get a simple formatted representation of this result as CSV.This is the same as calling
formatCSV(true, delimiter, nullString)
- Specified by:
formatCSV
in interfaceFormattable
- Parameters:
delimiter
- The delimiter to use between recordsnullString
- A special string for encodingNULL
values.- Returns:
- The formatted result
-
formatCSV
Description copied from interface:Formattable
Get a simple formatted representation of this result as CSV.- Specified by:
formatCSV
in interfaceFormattable
- Parameters:
header
- Whether to emit a CSV header linedelimiter
- The delimiter to use between recordsnullString
- A special string for encodingNULL
values.- Returns:
- The formatted result
-
formatCSV
Description copied from interface:Formattable
Get a simple formatted representation of this result as CSV.- Specified by:
formatCSV
in interfaceFormattable
- Returns:
- The formatted result
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV()
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(char)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(char, String)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(CSVFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV()
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(char)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(char, String)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatJSON
Description copied from interface:Formattable
Get 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:
formatJSON
in interfaceFormattable
- Returns:
- The formatted result
-
formatJSON
Description copied from interface:Formattable
Get a simple formatted representation of this result as a JSON data structure, according to the format.- Specified by:
formatJSON
in interfaceFormattable
- Returns:
- The formatted result
- See Also:
-
formatJSON
Description copied from interface:Formattable
LikeFormattable.formatJSON()
, but the data is output onto anOutputStream
.- Specified by:
formatJSON
in interfaceFormattable
-
formatJSON
Description copied from interface:Formattable
LikeFormattable.formatJSON(JSONFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatJSON
in interfaceFormattable
-
formatJSON
Description copied from interface:Formattable
LikeFormattable.formatJSON()
, but the data is output onto aWriter
.- Specified by:
formatJSON
in interfaceFormattable
-
formatXML
Description copied from interface:Formattable
Get this result formatted as XML.- Specified by:
formatXML
in interfaceFormattable
- See Also:
-
formatXML
Description copied from interface:Formattable
Get this result formatted as XML.- Specified by:
formatXML
in interfaceFormattable
- See Also:
-
formatXML
Description copied from interface:Formattable
LikeFormattable.formatXML()
, but the data is output onto anOutputStream
.- Specified by:
formatXML
in interfaceFormattable
-
formatXML
Description copied from interface:Formattable
LikeFormattable.formatXML(XMLFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatXML
in interfaceFormattable
-
formatXML
Description copied from interface:Formattable
LikeFormattable.formatXML()
, but the data is output onto aWriter
.- Specified by:
formatXML
in interfaceFormattable
-
formatChart
Description copied from interface:Formattable
Get this result as an ASCII chart.- Specified by:
formatChart
in interfaceFormattable
- See Also:
-
formatChart
Description copied from interface:Formattable
Get 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üssli
It is possible to specify a variety ofChartFormat
formatting specifications, such as the width, height, display type (default, stacked, 100% stacked), the column index of the category and value columns, etc.- Specified by:
formatChart
in interfaceFormattable
- See Also:
-
formatChart
Description copied from interface:Formattable
LikeFormattable.formatChart()
, but the data is output onto anOutputStream
.- Specified by:
formatChart
in interfaceFormattable
-
formatChart
Description copied from interface:Formattable
LikeFormattable.formatChart(ChartFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatChart
in interfaceFormattable
-
formatChart
Description copied from interface:Formattable
LikeFormattable.formatChart()
, but the data is output onto aWriter
.- Specified by:
formatChart
in interfaceFormattable
-
formatInsert
Description copied from interface:Formattable
Get this result as a set ofINSERT
statements.This uses the the first record's
TableRecord.getTable()
, if the first record is aTableRecord
. Otherwise, this generatesINSERT
statements into an"UNKNOWN_TABLE"
. In both cases, theFields.fields()
are used for column names.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
Description copied from interface:Formattable
LikeFormattable.formatInsert()
, but the data is output onto anOutputStream
.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
Description copied from interface:Formattable
Get this result as a set ofINSERT
statements.This explicitly specifies the table (and optionally the fields) to insert into. If the
fields
argument is left empty, theFields.fields()
are used, instead.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
Description copied from interface:Formattable
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.- Specified by:
formatInsert
in interfaceFormattable
-
formatHTML
Description copied from interface:Formattable
Get 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:
formatHTML
in interfaceFormattable
- Returns:
- The formatted result
-
formatHTML
Description copied from interface:Formattable
LikeFormattable.formatHTML()
, but the data is output onto anOutputStream
.- Specified by:
formatHTML
in interfaceFormattable
-
intoXML
Description copied from interface:Formattable
Get this result as XML.- Specified by:
intoXML
in interfaceFormattable
- See Also:
-
intoXML
Description copied from interface:Formattable
Get this result as XML using a SAXContentHandler
.- Specified by:
intoXML
in 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.