Class ArrayRecordImpl<T>
- java.lang.Object
-
- org.jooq.impl.ArrayRecordImpl<T>
-
- All Implemented Interfaces:
java.io.Serializable
,java.lang.Iterable<T>
,java.util.Collection<T>
,java.util.List<T>
,ArrayRecord<T>
,Attachable
,Formattable
@Pro @Internal public class ArrayRecordImpl<T> extends java.lang.Object implements ArrayRecord<T>
A common base class for Oracle ARRAY typesThis type is for JOOQ INTERNAL USE only. Do not reference directly
- Author:
- Lukas Eder
- See Also:
- Serialized Form
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<T> type)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<T> type, Configuration configuration)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType)
constructor insteadprotected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Binding<X,Y> binding)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Configuration configuration, Binding<X,Y> binding)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)
constructor instead.protected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Configuration configuration, Converter<X,T> converter)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)
constructor instead.protected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Configuration configuration, Converter<Y,T> converter, Binding<X,Y> binding)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)
constructor instead.protected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Converter<X,T> converter)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Converter<Y,T> converter, Binding<X,Y> binding)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<T> type)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<X> type, Binding<X,Y> binding)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<X> type, Converter<X,T> converter)
Create an empty array recordprotected
ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<X> type, Converter<Y,T> converter, Binding<X,Y> binding)
Create an empty array record
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description void
add(int index, T element)
boolean
add(T e)
boolean
addAll(int index, java.util.Collection<? extends T> c)
boolean
addAll(java.util.Collection<? extends T> c)
void
attach(Configuration c)
Attach this object to a newConfiguration
.void
clear()
Configuration
configuration()
boolean
contains(java.lang.Object o)
boolean
containsAll(java.util.Collection<?> c)
protected DSLContext
create()
Deprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()
andConfiguration.dsl()
instead.void
detach()
Detach this object from its currentConfiguration
.boolean
equals(java.lang.Object o)
java.lang.String
format()
Get a simple formatted representation of this result.java.lang.String
format(int maxRecords)
Get a simple formatted representation of this result.void
format(java.io.OutputStream stream)
LikeFormattable.format()
, but the data is output onto anOutputStream
.void
format(java.io.OutputStream stream, int maxRecords)
LikeFormattable.format(int)
, but the data is output onto anOutputStream
.void
format(java.io.OutputStream stream, TXTFormat format)
LikeFormattable.format(TXTFormat)
, but the data is output onto anOutputStream
.void
format(java.io.Writer writer)
LikeFormattable.format()
, but the data is output onto aWriter
.void
format(java.io.Writer writer, int maxRecords)
LikeFormattable.format(int)
, but the data is output onto aWriter
.void
format(java.io.Writer writer, TXTFormat format)
LikeFormattable.format(TXTFormat)
, but the data is output onto aWriter
.java.lang.String
format(TXTFormat format)
Get a simple formatted representation of this result.java.lang.String
formatChart()
void
formatChart(java.io.OutputStream stream)
LikeFormattable.formatChart()
, but the data is output onto anOutputStream
.void
formatChart(java.io.OutputStream stream, ChartFormat format)
LikeFormattable.formatChart(ChartFormat)
, but the data is output onto anOutputStream
.void
formatChart(java.io.Writer writer)
LikeFormattable.formatChart()
, but the data is output onto aWriter
.void
formatChart(java.io.Writer writer, ChartFormat format)
LikeFormattable.formatChart(ChartFormat)
, but the data is output onto aWriter
.java.lang.String
formatChart(ChartFormat format)
java.lang.String
formatCSV()
Get a simple formatted representation of this result as CSV.java.lang.String
formatCSV(boolean header)
Get a simple formatted representation of this result as CSV.java.lang.String
formatCSV(boolean header, char delimiter)
Get a simple formatted representation of this result as CSV.java.lang.String
formatCSV(boolean header, char delimiter, java.lang.String nullString)
Get a simple formatted representation of this result as CSV.java.lang.String
formatCSV(char delimiter)
Get a simple formatted representation of this result as CSV.java.lang.String
formatCSV(char delimiter, java.lang.String nullString)
Get a simple formatted representation of this result as CSV.void
formatCSV(java.io.OutputStream stream)
LikeFormattable.formatCSV()
, but the data is output onto anOutputStream
.void
formatCSV(java.io.OutputStream stream, boolean header)
LikeFormattable.formatCSV(boolean)
, but the data is output onto anOutputStream
.void
formatCSV(java.io.OutputStream stream, boolean header, char delimiter)
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto anOutputStream
.void
formatCSV(java.io.OutputStream stream, boolean header, char delimiter, java.lang.String nullString)
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto anOutputStream
.void
formatCSV(java.io.OutputStream stream, char delimiter)
LikeFormattable.formatCSV(char)
, but the data is output onto anOutputStream
.void
formatCSV(java.io.OutputStream stream, char delimiter, java.lang.String nullString)
LikeFormattable.formatCSV(char, String)
, but the data is output onto anOutputStream
.void
formatCSV(java.io.OutputStream stream, CSVFormat format)
LikeFormattable.formatCSV(CSVFormat)
, but the data is output onto anOutputStream
.void
formatCSV(java.io.Writer writer)
LikeFormattable.formatCSV()
, but the data is output onto aWriter
.void
formatCSV(java.io.Writer writer, boolean header)
LikeFormattable.formatCSV(boolean)
, but the data is output onto aWriter
.void
formatCSV(java.io.Writer writer, boolean header, char delimiter)
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto aWriter
.void
formatCSV(java.io.Writer writer, boolean header, char delimiter, java.lang.String nullString)
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto aWriter
.void
formatCSV(java.io.Writer writer, char delimiter)
LikeFormattable.formatCSV(char)
, but the data is output onto aWriter
.void
formatCSV(java.io.Writer writer, char delimiter, java.lang.String nullString)
LikeFormattable.formatCSV(char, String)
, but the data is output onto aWriter
.void
formatCSV(java.io.Writer writer, CSVFormat format)
LikeFormattable.formatCSV(CSVFormat)
, but the data is output onto aWriter
.java.lang.String
formatCSV(CSVFormat format)
Get a simple formatted representation of this result as CSV.java.lang.String
formatHTML()
Get a simple formatted representation of this result as HTML.void
formatHTML(java.io.OutputStream stream)
LikeFormattable.formatHTML()
, but the data is output onto anOutputStream
.void
formatHTML(java.io.Writer writer)
LikeFormattable.formatHTML()
, but the data is output onto aWriter
.java.lang.String
formatInsert()
Get this result as a set ofINSERT
statements.void
formatInsert(java.io.OutputStream stream)
LikeFormattable.formatInsert()
, but the data is output onto anOutputStream
.void
formatInsert(java.io.OutputStream stream, Table<?> table, Field<?>... f)
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.void
formatInsert(java.io.Writer writer)
LikeFormattable.formatInsert()
, but the data is output onto aWriter
.void
formatInsert(java.io.Writer writer, Table<?> table, Field<?>... fields)
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anWriter
.java.lang.String
formatInsert(Table<?> table, Field<?>... f)
Get this result as a set ofINSERT
statements.java.lang.String
formatJSON()
Get a simple formatted representation of this result as a JSON array of array.void
formatJSON(java.io.OutputStream stream)
LikeFormattable.formatJSON()
, but the data is output onto anOutputStream
.void
formatJSON(java.io.OutputStream stream, JSONFormat format)
LikeFormattable.formatJSON(JSONFormat)
, but the data is output onto anOutputStream
.void
formatJSON(java.io.Writer writer)
LikeFormattable.formatJSON()
, but the data is output onto aWriter
.void
formatJSON(java.io.Writer writer, JSONFormat format)
LikeFormattable.formatJSON(JSONFormat)
, but the data is output onto aWriter
.java.lang.String
formatJSON(JSONFormat format)
Get a simple formatted representation of this result as a JSON data structure, according to the format.java.lang.String
formatXML()
Get this result formatted as XML.void
formatXML(java.io.OutputStream stream)
LikeFormattable.formatXML()
, but the data is output onto anOutputStream
.void
formatXML(java.io.OutputStream stream, XMLFormat format)
LikeFormattable.formatXML(XMLFormat)
, but the data is output onto anOutputStream
.void
formatXML(java.io.Writer writer)
LikeFormattable.formatXML()
, but the data is output onto aWriter
.void
formatXML(java.io.Writer writer, XMLFormat format)
LikeFormattable.formatXML(XMLFormat)
, but the data is output onto aWriter
.java.lang.String
formatXML(XMLFormat format)
Get this result formatted as XML.T[]
get()
Deprecated.T
get(int index)
DataType<?>
getArrayType()
Get the data type of the array.Catalog
getCatalog()
Get the record type's catalog.DataType<T>
getDataType()
Get the data type of the array's base type.java.util.List<T>
getList()
Deprecated.java.lang.String
getName()
Get the unqualified name of the array type.Package
getPackage()
Get the UDT package.Schema
getSchema()
Get the record type's schema.int
hashCode()
int
indexOf(java.lang.Object o)
org.w3c.dom.Document
intoXML()
Get this result as XML.<H extends org.xml.sax.ContentHandler>
HintoXML(H handler)
Get this result as XML using a SAXContentHandler
.<H extends org.xml.sax.ContentHandler>
HintoXML(H handler, XMLFormat format)
Get this result as XML using a SAXContentHandler
.org.w3c.dom.Document
intoXML(XMLFormat format)
Get this result as XML.boolean
isEmpty()
boolean
isSQLUsable()
Whether this data type can be used from SQL statements.java.util.Iterator<T>
iterator()
int
lastIndexOf(java.lang.Object o)
java.util.ListIterator<T>
listIterator()
java.util.ListIterator<T>
listIterator(int index)
T
remove(int index)
boolean
remove(java.lang.Object o)
boolean
removeAll(java.util.Collection<?> c)
boolean
retainAll(java.util.Collection<?> c)
T
set(int index, T element)
void
set(java.sql.Array array)
Deprecated.void
set(java.util.Collection<? extends T> collection)
Deprecated.void
set(T... array)
Deprecated.void
setList(java.util.List<? extends T> list)
Deprecated.int
size()
java.util.List<T>
subList(int fromIndex, int toIndex)
java.lang.Object[]
toArray()
<Z> Z[]
toArray(Z[] a)
java.lang.String
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
-
-
-
-
Constructor Detail
-
ArrayRecordImpl
@Deprecated protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<T> type, Configuration configuration)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType)
constructor insteadCreate an empty array record
-
ArrayRecordImpl
@Deprecated protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Configuration configuration, Converter<X,T> converter)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)
constructor instead.Create an empty array record
-
ArrayRecordImpl
@Deprecated protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Configuration configuration, Binding<X,Y> binding)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)
constructor instead.Create an empty array record
-
ArrayRecordImpl
@Deprecated protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Configuration configuration, Converter<Y,T> converter, Binding<X,Y> binding)
Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)
constructor instead.Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<T> type)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<T> type)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Converter<X,T> converter)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<X> type, Converter<X,T> converter)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Binding<X,Y> binding)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, Package pkg, java.lang.String name, DataType<X> type, Binding<X,Y> binding)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, java.lang.String name, DataType<X> type, Converter<Y,T> converter, Binding<X,Y> binding)
Create an empty array record
-
-
Method Detail
-
get
@Deprecated public final T[] get()
Deprecated.Description copied from interface:ArrayRecord
Get the contained array.- Specified by:
get
in interfaceArrayRecord<T>
-
getList
@Deprecated public final java.util.List<T> getList()
Deprecated.Description copied from interface:ArrayRecord
Get the contained array as aList
.- Specified by:
getList
in interfaceArrayRecord<T>
-
set
@Deprecated public final void set(T... array)
Deprecated.Description copied from interface:ArrayRecord
Set the contained array.- Specified by:
set
in interfaceArrayRecord<T>
-
set
@Deprecated public final void set(java.sql.Array array) throws java.sql.SQLException
Deprecated.Description copied from interface:ArrayRecord
Set the contained array.- Specified by:
set
in interfaceArrayRecord<T>
- Throws:
java.sql.SQLException
-
set
@Deprecated public final void set(java.util.Collection<? extends T> collection)
Deprecated.Description copied from interface:ArrayRecord
Set the contained array as aList
.- Specified by:
set
in interfaceArrayRecord<T>
-
setList
@Deprecated public final void setList(java.util.List<? extends T> list)
Deprecated.Description copied from interface:ArrayRecord
Set the contained array as aList
.- Specified by:
setList
in interfaceArrayRecord<T>
-
getCatalog
public final Catalog getCatalog()
Description copied from interface:ArrayRecord
Get the record type's catalog.- Specified by:
getCatalog
in interfaceArrayRecord<T>
-
getSchema
public final Schema getSchema()
Description copied from interface:ArrayRecord
Get the record type's schema.- Specified by:
getSchema
in interfaceArrayRecord<T>
-
getPackage
public final Package getPackage()
Description copied from interface:ArrayRecord
Get the UDT package.- Specified by:
getPackage
in interfaceArrayRecord<T>
-
isSQLUsable
public final boolean isSQLUsable()
Description copied from interface:ArrayRecord
Whether this data type can be used from SQL statements.- Specified by:
isSQLUsable
in interfaceArrayRecord<T>
-
getName
public final java.lang.String getName()
Description copied from interface:ArrayRecord
Get the unqualified name of the array type.- Specified by:
getName
in interfaceArrayRecord<T>
-
getDataType
public final DataType<T> getDataType()
Description copied from interface:ArrayRecord
Get the data type of the array's base type.- Specified by:
getDataType
in interfaceArrayRecord<T>
-
getArrayType
public final DataType<?> getArrayType()
Description copied from interface:ArrayRecord
Get the data type of the array.- Specified by:
getArrayType
in interfaceArrayRecord<T>
-
toString
public java.lang.String toString()
- Overrides:
toString
in classjava.lang.Object
-
size
public final int size()
-
isEmpty
public final boolean isEmpty()
-
contains
public final boolean contains(java.lang.Object o)
-
iterator
public final java.util.Iterator<T> iterator()
-
toArray
public final java.lang.Object[] toArray()
-
toArray
public final <Z> Z[] toArray(Z[] a)
-
add
public final boolean add(T e)
-
remove
public final boolean remove(java.lang.Object o)
-
containsAll
public final boolean containsAll(java.util.Collection<?> c)
-
addAll
public final boolean addAll(java.util.Collection<? extends T> c)
-
addAll
public final boolean addAll(int index, java.util.Collection<? extends T> c)
- Specified by:
addAll
in interfacejava.util.List<T>
-
removeAll
public final boolean removeAll(java.util.Collection<?> c)
-
retainAll
public final boolean retainAll(java.util.Collection<?> c)
-
clear
public final void clear()
-
equals
public final boolean equals(java.lang.Object o)
-
hashCode
public final int hashCode()
-
indexOf
public final int indexOf(java.lang.Object o)
- Specified by:
indexOf
in interfacejava.util.List<T>
-
lastIndexOf
public final int lastIndexOf(java.lang.Object o)
- Specified by:
lastIndexOf
in interfacejava.util.List<T>
-
listIterator
public final java.util.ListIterator<T> listIterator()
- Specified by:
listIterator
in interfacejava.util.List<T>
-
listIterator
public final java.util.ListIterator<T> listIterator(int index)
- Specified by:
listIterator
in interfacejava.util.List<T>
-
subList
public final java.util.List<T> subList(int fromIndex, int toIndex)
- Specified by:
subList
in interfacejava.util.List<T>
-
format
public final void format(java.io.Writer writer, TXTFormat format)
Description copied from interface:Formattable
LikeFormattable.format(TXTFormat)
, but the data is output onto aWriter
.- Specified by:
format
in interfaceFormattable
-
formatHTML
public final void formatHTML(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.formatHTML()
, but the data is output onto aWriter
.- Specified by:
formatHTML
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer, CSVFormat format)
Description copied from interface:Formattable
LikeFormattable.formatCSV(CSVFormat)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatJSON
public final void formatJSON(java.io.Writer writer, JSONFormat format)
Description copied from interface:Formattable
LikeFormattable.formatJSON(JSONFormat)
, but the data is output onto aWriter
.- Specified by:
formatJSON
in interfaceFormattable
-
formatXML
public final void formatXML(java.io.Writer writer, XMLFormat format)
Description copied from interface:Formattable
LikeFormattable.formatXML(XMLFormat)
, but the data is output onto aWriter
.- Specified by:
formatXML
in interfaceFormattable
-
formatChart
public final void formatChart(java.io.Writer writer, ChartFormat format)
Description copied from interface:Formattable
LikeFormattable.formatChart(ChartFormat)
, but the data is output onto aWriter
.- Specified by:
formatChart
in interfaceFormattable
-
formatInsert
public final void formatInsert(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.formatInsert()
, but the data is output onto aWriter
.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
public final void formatInsert(java.io.Writer writer, Table<?> table, Field<?>... fields)
Description copied from interface:Formattable
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anWriter
.- Specified by:
formatInsert
in interfaceFormattable
-
intoXML
public final org.w3c.dom.Document intoXML(XMLFormat format)
Description copied from interface:Formattable
Get this result as XML.- Specified by:
intoXML
in interfaceFormattable
- See Also:
Formattable.formatXML()
, http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
intoXML
public final <H extends org.xml.sax.ContentHandler> H intoXML(H handler, XMLFormat format) throws org.xml.sax.SAXException
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:
org.xml.sax.SAXException
- See Also:
Formattable.formatXML()
, http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
attach
public final void attach(Configuration c)
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
public final Configuration configuration()
Description copied from interface:Attachable
- Specified by:
configuration
in interfaceAttachable
-
create
@Deprecated protected final DSLContext create()
Deprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()
andConfiguration.dsl()
instead.This method is used in generated code!
-
format
public final java.lang.String 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
public final java.lang.String format(int maxRecords)
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
public final java.lang.String format(TXTFormat 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
public final void format(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.format()
, but the data is output onto anOutputStream
.- Specified by:
format
in interfaceFormattable
-
format
public final void format(java.io.OutputStream stream, int maxRecords)
Description copied from interface:Formattable
LikeFormattable.format(int)
, but the data is output onto anOutputStream
.- Specified by:
format
in interfaceFormattable
-
format
public final void format(java.io.OutputStream stream, TXTFormat format)
Description copied from interface:Formattable
LikeFormattable.format(TXTFormat)
, but the data is output onto anOutputStream
.- Specified by:
format
in interfaceFormattable
-
format
public final void format(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.format()
, but the data is output onto aWriter
.- Specified by:
format
in interfaceFormattable
-
format
public final void format(java.io.Writer writer, int maxRecords)
Description copied from interface:Formattable
LikeFormattable.format(int)
, but the data is output onto aWriter
.- Specified by:
format
in interfaceFormattable
-
formatCSV
public final java.lang.String 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
public final java.lang.String formatCSV(boolean header)
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
public final void formatCSV(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.formatCSV()
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.OutputStream stream, boolean header)
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.formatCSV()
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer, boolean header)
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final java.lang.String formatCSV(char delimiter)
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
public final java.lang.String formatCSV(boolean header, char delimiter)
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
public final void formatCSV(java.io.OutputStream stream, char delimiter)
Description copied from interface:Formattable
LikeFormattable.formatCSV(char)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.OutputStream stream, boolean header, char delimiter)
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer, char delimiter)
Description copied from interface:Formattable
LikeFormattable.formatCSV(char)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer, boolean header, char delimiter)
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final java.lang.String formatCSV(char delimiter, java.lang.String nullString)
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
public final java.lang.String formatCSV(boolean header, char delimiter, java.lang.String nullString)
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
public final java.lang.String formatCSV(CSVFormat format)
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
public final void formatCSV(java.io.OutputStream stream, char delimiter, java.lang.String nullString)
Description copied from interface:Formattable
LikeFormattable.formatCSV(char, String)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.OutputStream stream, boolean header, char delimiter, java.lang.String nullString)
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.OutputStream stream, CSVFormat format)
Description copied from interface:Formattable
LikeFormattable.formatCSV(CSVFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer, char delimiter, java.lang.String nullString)
Description copied from interface:Formattable
LikeFormattable.formatCSV(char, String)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatCSV
public final void formatCSV(java.io.Writer writer, boolean header, char delimiter, java.lang.String nullString)
Description copied from interface:Formattable
LikeFormattable.formatCSV(boolean, char, String)
, but the data is output onto aWriter
.- Specified by:
formatCSV
in interfaceFormattable
-
formatJSON
public final java.lang.String 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
public final java.lang.String formatJSON(JSONFormat format)
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:
JSONFormat
-
formatJSON
public final void formatJSON(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.formatJSON()
, but the data is output onto anOutputStream
.- Specified by:
formatJSON
in interfaceFormattable
-
formatJSON
public final void formatJSON(java.io.OutputStream stream, JSONFormat format)
Description copied from interface:Formattable
LikeFormattable.formatJSON(JSONFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatJSON
in interfaceFormattable
-
formatJSON
public final void formatJSON(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.formatJSON()
, but the data is output onto aWriter
.- Specified by:
formatJSON
in interfaceFormattable
-
formatXML
public final java.lang.String formatXML()
Description copied from interface:Formattable
Get this result formatted as XML.- Specified by:
formatXML
in interfaceFormattable
- See Also:
- http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
formatXML
public final java.lang.String formatXML(XMLFormat format)
Description copied from interface:Formattable
Get this result formatted as XML.- Specified by:
formatXML
in interfaceFormattable
- See Also:
- http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
formatXML
public final void formatXML(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.formatXML()
, but the data is output onto anOutputStream
.- Specified by:
formatXML
in interfaceFormattable
-
formatXML
public final void formatXML(java.io.OutputStream stream, XMLFormat format)
Description copied from interface:Formattable
LikeFormattable.formatXML(XMLFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatXML
in interfaceFormattable
-
formatXML
public final void formatXML(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.formatXML()
, but the data is output onto aWriter
.- Specified by:
formatXML
in interfaceFormattable
-
formatChart
public final java.lang.String formatChart()
- Specified by:
formatChart
in interfaceFormattable
-
formatChart
public final java.lang.String formatChart(ChartFormat format)
- Specified by:
formatChart
in interfaceFormattable
-
formatChart
public final void formatChart(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.formatChart()
, but the data is output onto anOutputStream
.- Specified by:
formatChart
in interfaceFormattable
-
formatChart
public final void formatChart(java.io.OutputStream stream, ChartFormat format)
Description copied from interface:Formattable
LikeFormattable.formatChart(ChartFormat)
, but the data is output onto anOutputStream
.- Specified by:
formatChart
in interfaceFormattable
-
formatChart
public final void formatChart(java.io.Writer writer)
Description copied from interface:Formattable
LikeFormattable.formatChart()
, but the data is output onto aWriter
.- Specified by:
formatChart
in interfaceFormattable
-
formatInsert
public final java.lang.String 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, theResult.fields()
are used for column names.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
public final void formatInsert(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.formatInsert()
, but the data is output onto anOutputStream
.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
public final java.lang.String formatInsert(Table<?> table, Field<?>... f)
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, theResult.fields()
are used, instead.- Specified by:
formatInsert
in interfaceFormattable
-
formatInsert
public final void formatInsert(java.io.OutputStream stream, Table<?> table, Field<?>... f)
Description copied from interface:Formattable
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.- Specified by:
formatInsert
in interfaceFormattable
-
formatHTML
public final java.lang.String 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
public final void formatHTML(java.io.OutputStream stream)
Description copied from interface:Formattable
LikeFormattable.formatHTML()
, but the data is output onto anOutputStream
.- Specified by:
formatHTML
in interfaceFormattable
-
intoXML
public final org.w3c.dom.Document intoXML()
Description copied from interface:Formattable
Get this result as XML.- Specified by:
intoXML
in interfaceFormattable
- See Also:
Formattable.formatXML()
, http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
intoXML
public final <H extends org.xml.sax.ContentHandler> H intoXML(H handler) throws org.xml.sax.SAXException
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:
org.xml.sax.SAXException
- See Also:
Formattable.formatXML()
, http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
-