- java.lang.Object
-
- org.jooq.impl.ArrayRecordImpl<T>
-
- All Implemented Interfaces:
Serializable,Iterable<T>,Collection<T>,List<T>,ArrayRecord<T>,Attachable,Formattable
@Pro @Internal public class ArrayRecordImpl<T> extends 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 protectedArrayRecordImpl(Schema schema, String name, DataType<T> type)Create an empty array recordprotectedArrayRecordImpl(Schema schema, String name, DataType<T> type, Configuration configuration)Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType)constructor insteadprotectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Binding<X,Y> binding)Create an empty array recordprotectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Configuration configuration, Binding<X,Y> binding)Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)constructor instead.protectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Configuration configuration, Converter<X,T> converter)Deprecated.- 3.4.0 - [#3126] - Use theArrayRecordImpl(Schema, String, DataType, Converter)constructor instead.protectedArrayRecordImpl(Schema schema, 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.protectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Converter<X,T> converter)Create an empty array recordprotectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Converter<Y,T> converter, Binding<X,Y> binding)Create an empty array recordprotectedArrayRecordImpl(Schema schema, Package pkg, String name, DataType<T> type)Create an empty array recordprotectedArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, Binding<X,Y> binding)Create an empty array recordprotectedArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, Converter<X,T> converter)Create an empty array recordprotectedArrayRecordImpl(Schema schema, Package pkg, 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 voidadd(int index, T element)booleanadd(T e)booleanaddAll(int index, Collection<? extends T> c)booleanaddAll(Collection<? extends T> c)voidattach(Configuration c)Attach this object to a newConfiguration.voidclear()Configurationconfiguration()booleancontains(Object o)booleancontainsAll(Collection<?> c)protected DSLContextcreate()Deprecated.- 3.11.0 - [#6720] [#6721] - UseAttachable.configuration()andConfiguration.dsl()instead.voiddetach()Detach this object from its currentConfiguration.booleanequals(Object o)Stringformat()Get a simple formatted representation of this result.Stringformat(int maxRecords)Get a simple formatted representation of this result.voidformat(OutputStream stream)LikeFormattable.format(), but the data is output onto anOutputStream.voidformat(OutputStream stream, int maxRecords)LikeFormattable.format(int), but the data is output onto anOutputStream.voidformat(OutputStream stream, TXTFormat format)LikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.voidformat(Writer writer)LikeFormattable.format(), but the data is output onto aWriter.voidformat(Writer writer, int maxRecords)LikeFormattable.format(int), but the data is output onto aWriter.voidformat(Writer writer, TXTFormat format)LikeFormattable.format(TXTFormat), but the data is output onto aWriter.Stringformat(TXTFormat format)Get a simple formatted representation of this result.StringformatChart()voidformatChart(OutputStream stream)LikeFormattable.formatChart(), but the data is output onto anOutputStream.voidformatChart(OutputStream stream, ChartFormat format)LikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.voidformatChart(Writer writer)LikeFormattable.formatChart(), but the data is output onto aWriter.voidformatChart(Writer writer, ChartFormat format)LikeFormattable.formatChart(ChartFormat), but the data is output onto aWriter.StringformatChart(ChartFormat format)StringformatCSV()Get a simple formatted representation of this result as CSV.StringformatCSV(boolean header)Get a simple formatted representation of this result as CSV.StringformatCSV(boolean header, char delimiter)Get a simple formatted representation of this result as CSV.StringformatCSV(boolean header, char delimiter, String nullString)Get a simple formatted representation of this result as CSV.StringformatCSV(char delimiter)Get a simple formatted representation of this result as CSV.StringformatCSV(char delimiter, String nullString)Get a simple formatted representation of this result as CSV.voidformatCSV(OutputStream stream)LikeFormattable.formatCSV(), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, boolean header)LikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, boolean header, char delimiter)LikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, boolean header, char delimiter, String nullString)LikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, char delimiter)LikeFormattable.formatCSV(char), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, char delimiter, String nullString)LikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.voidformatCSV(OutputStream stream, CSVFormat format)LikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.voidformatCSV(Writer writer)LikeFormattable.formatCSV(), but the data is output onto aWriter.voidformatCSV(Writer writer, boolean header)LikeFormattable.formatCSV(boolean), but the data is output onto aWriter.voidformatCSV(Writer writer, boolean header, char delimiter)LikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.voidformatCSV(Writer writer, boolean header, char delimiter, String nullString)LikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.voidformatCSV(Writer writer, char delimiter)LikeFormattable.formatCSV(char), but the data is output onto aWriter.voidformatCSV(Writer writer, char delimiter, String nullString)LikeFormattable.formatCSV(char, String), but the data is output onto aWriter.voidformatCSV(Writer writer, CSVFormat format)LikeFormattable.formatCSV(CSVFormat), but the data is output onto aWriter.StringformatCSV(CSVFormat format)Get a simple formatted representation of this result as CSV.StringformatHTML()Get a simple formatted representation of this result as HTML.voidformatHTML(OutputStream stream)LikeFormattable.formatHTML(), but the data is output onto anOutputStream.voidformatHTML(Writer writer)LikeFormattable.formatHTML(), but the data is output onto aWriter.StringformatInsert()Get this result as a set ofINSERTstatements.voidformatInsert(OutputStream stream)LikeFormattable.formatInsert(), but the data is output onto anOutputStream.voidformatInsert(OutputStream stream, Table<?> table, Field<?>... f)LikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.voidformatInsert(Writer writer)LikeFormattable.formatInsert(), but the data is output onto aWriter.voidformatInsert(Writer writer, Table<?> table, Field<?>... fields)LikeFormattable.formatInsert(Table, Field...), but the data is output onto anWriter.StringformatInsert(Table<?> table, Field<?>... f)Get this result as a set ofINSERTstatements.StringformatJSON()Get a simple formatted representation of this result as a JSON array of array.voidformatJSON(OutputStream stream)LikeFormattable.formatJSON(), but the data is output onto anOutputStream.voidformatJSON(OutputStream stream, JSONFormat format)LikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.voidformatJSON(Writer writer)LikeFormattable.formatJSON(), but the data is output onto aWriter.voidformatJSON(Writer writer, JSONFormat format)LikeFormattable.formatJSON(JSONFormat), but the data is output onto aWriter.StringformatJSON(JSONFormat format)Get a simple formatted representation of this result as a JSON data structure, according to the format.StringformatXML()Get this result formatted as XML.voidformatXML(OutputStream stream)LikeFormattable.formatXML(), but the data is output onto anOutputStream.voidformatXML(OutputStream stream, XMLFormat format)LikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.voidformatXML(Writer writer)LikeFormattable.formatXML(), but the data is output onto aWriter.voidformatXML(Writer writer, XMLFormat format)LikeFormattable.formatXML(XMLFormat), but the data is output onto aWriter.StringformatXML(XMLFormat format)Get this result formatted as XML.T[]get()Deprecated.Tget(int index)DataType<?>getArrayType()Get the data type of the array.CataloggetCatalog()Get the record type's catalog.DataType<T>getDataType()Get the data type of the array's base type.List<T>getList()Deprecated.StringgetName()Get the unqualified name of the array type.PackagegetPackage()Get the UDT package.SchemagetSchema()Get the record type's schema.inthashCode()intindexOf(Object o)DocumentintoXML()Get this result as XML.<H extends ContentHandler>
HintoXML(H handler)Get this result as XML using a SAXContentHandler.<H extends ContentHandler>
HintoXML(H handler, XMLFormat format)Get this result as XML using a SAXContentHandler.DocumentintoXML(XMLFormat format)Get this result as XML.booleanisEmpty()booleanisSQLUsable()Whether this data type can be used from SQL statements.Iterator<T>iterator()intlastIndexOf(Object o)ListIterator<T>listIterator()ListIterator<T>listIterator(int index)Tremove(int index)booleanremove(Object o)booleanremoveAll(Collection<?> c)booleanretainAll(Collection<?> c)Tset(int index, T element)voidset(Array array)Deprecated.voidset(Collection<? extends T> collection)Deprecated.voidset(T... array)Deprecated.voidsetList(List<? extends T> list)Deprecated.intsize()List<T>subList(int fromIndex, int toIndex)Object[]toArray()<Z> Z[]toArray(Z[] a)StringtoString()-
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 Detail
-
ArrayRecordImpl
@Deprecated protected ArrayRecordImpl(Schema schema, 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, 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, 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, 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, String name, DataType<T> type)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, Package pkg, String name, DataType<T> type)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, String name, DataType<X> type, Converter<X,T> converter)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, Converter<X,T> converter)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, String name, DataType<X> type, Binding<X,Y> binding)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, Binding<X,Y> binding)
Create an empty array record
-
ArrayRecordImpl
protected ArrayRecordImpl(Schema schema, 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:ArrayRecordGet the contained array.- Specified by:
getin interfaceArrayRecord<T>
-
getList
@Deprecated public final List<T> getList()
Deprecated.Description copied from interface:ArrayRecordGet the contained array as aList.- Specified by:
getListin interfaceArrayRecord<T>
-
set
@Deprecated public final void set(T... array)
Deprecated.Description copied from interface:ArrayRecordSet the contained array.- Specified by:
setin interfaceArrayRecord<T>
-
set
@Deprecated public final void set(Array array) throws SQLException
Deprecated.Description copied from interface:ArrayRecordSet the contained array.- Specified by:
setin interfaceArrayRecord<T>- Throws:
SQLException
-
set
@Deprecated public final void set(Collection<? extends T> collection)
Deprecated.Description copied from interface:ArrayRecordSet the contained array as aList.- Specified by:
setin interfaceArrayRecord<T>
-
setList
@Deprecated public final void setList(List<? extends T> list)
Deprecated.Description copied from interface:ArrayRecordSet the contained array as aList.- Specified by:
setListin interfaceArrayRecord<T>
-
getCatalog
public final Catalog getCatalog()
Description copied from interface:ArrayRecordGet the record type's catalog.- Specified by:
getCatalogin interfaceArrayRecord<T>
-
getSchema
public final Schema getSchema()
Description copied from interface:ArrayRecordGet the record type's schema.- Specified by:
getSchemain interfaceArrayRecord<T>
-
getPackage
public final Package getPackage()
Description copied from interface:ArrayRecordGet the UDT package.- Specified by:
getPackagein interfaceArrayRecord<T>
-
isSQLUsable
public final boolean isSQLUsable()
Description copied from interface:ArrayRecordWhether this data type can be used from SQL statements.- Specified by:
isSQLUsablein interfaceArrayRecord<T>
-
getName
public final String getName()
Description copied from interface:ArrayRecordGet the unqualified name of the array type.- Specified by:
getNamein interfaceArrayRecord<T>
-
getDataType
public final DataType<T> getDataType()
Description copied from interface:ArrayRecordGet the data type of the array's base type.- Specified by:
getDataTypein interfaceArrayRecord<T>
-
getArrayType
public final DataType<?> getArrayType()
Description copied from interface:ArrayRecordGet the data type of the array.- Specified by:
getArrayTypein interfaceArrayRecord<T>
-
size
public final int size()
-
isEmpty
public final boolean isEmpty()
-
contains
public final boolean contains(Object o)
-
toArray
public final Object[] toArray()
-
toArray
public final <Z> Z[] toArray(Z[] a)
-
add
public final boolean add(T e)
-
remove
public final boolean remove(Object o)
-
containsAll
public final boolean containsAll(Collection<?> c)
- Specified by:
containsAllin interfaceCollection<T>- Specified by:
containsAllin interfaceList<T>
-
addAll
public final boolean addAll(Collection<? extends T> c)
-
addAll
public final boolean addAll(int index, Collection<? extends T> c)
-
removeAll
public final boolean removeAll(Collection<?> c)
-
retainAll
public final boolean retainAll(Collection<?> c)
-
clear
public final void clear()
-
equals
public final boolean equals(Object o)
-
hashCode
public final int hashCode()
-
lastIndexOf
public final int lastIndexOf(Object o)
- Specified by:
lastIndexOfin interfaceList<T>
-
listIterator
public final ListIterator<T> listIterator()
- Specified by:
listIteratorin interfaceList<T>
-
listIterator
public final ListIterator<T> listIterator(int index)
- Specified by:
listIteratorin interfaceList<T>
-
format
public final void format(Writer writer, TXTFormat format)
Description copied from interface:FormattableLikeFormattable.format(TXTFormat), but the data is output onto aWriter.- Specified by:
formatin interfaceFormattable
-
formatHTML
public final void formatHTML(Writer writer)
Description copied from interface:FormattableLikeFormattable.formatHTML(), but the data is output onto aWriter.- Specified by:
formatHTMLin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer, CSVFormat format)
Description copied from interface:FormattableLikeFormattable.formatCSV(CSVFormat), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatJSON
public final void formatJSON(Writer writer, JSONFormat format)
Description copied from interface:FormattableLikeFormattable.formatJSON(JSONFormat), but the data is output onto aWriter.- Specified by:
formatJSONin interfaceFormattable
-
formatXML
public final void formatXML(Writer writer, XMLFormat format)
Description copied from interface:FormattableLikeFormattable.formatXML(XMLFormat), but the data is output onto aWriter.- Specified by:
formatXMLin interfaceFormattable
-
formatChart
public final void formatChart(Writer writer, ChartFormat format)
Description copied from interface:FormattableLikeFormattable.formatChart(ChartFormat), but the data is output onto aWriter.- Specified by:
formatChartin interfaceFormattable
-
formatInsert
public final void formatInsert(Writer writer)
Description copied from interface:FormattableLikeFormattable.formatInsert(), but the data is output onto aWriter.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
public final void formatInsert(Writer writer, Table<?> table, Field<?>... fields)
Description copied from interface:FormattableLikeFormattable.formatInsert(Table, Field...), but the data is output onto anWriter.- Specified by:
formatInsertin interfaceFormattable
-
intoXML
public final Document intoXML(XMLFormat format)
Description copied from interface:FormattableGet this result as XML.- Specified by:
intoXMLin interfaceFormattable- See Also:
Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
intoXML
public final <H extends ContentHandler> H intoXML(H handler, XMLFormat format) throws SAXException
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:
Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
attach
public final void attach(Configuration c)
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
public final Configuration configuration()
Description copied from interface:Attachable- Specified by:
configurationin 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 String 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
public final String format(int maxRecords)
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
public final String format(TXTFormat 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
public final void format(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.format(), but the data is output onto anOutputStream.- Specified by:
formatin interfaceFormattable
-
format
public final void format(OutputStream stream, int maxRecords)
Description copied from interface:FormattableLikeFormattable.format(int), but the data is output onto anOutputStream.- Specified by:
formatin interfaceFormattable
-
format
public final void format(OutputStream stream, TXTFormat format)
Description copied from interface:FormattableLikeFormattable.format(TXTFormat), but the data is output onto anOutputStream.- Specified by:
formatin interfaceFormattable
-
format
public final void format(Writer writer)
Description copied from interface:FormattableLikeFormattable.format(), but the data is output onto aWriter.- Specified by:
formatin interfaceFormattable
-
format
public final void format(Writer writer, int maxRecords)
Description copied from interface:FormattableLikeFormattable.format(int), but the data is output onto aWriter.- Specified by:
formatin interfaceFormattable
-
formatCSV
public final String 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
public final String formatCSV(boolean header)
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
public final void formatCSV(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(OutputStream stream, boolean header)
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer)
Description copied from interface:FormattableLikeFormattable.formatCSV(), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer, boolean header)
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final String formatCSV(char delimiter)
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
public final String formatCSV(boolean header, char delimiter)
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
public final void formatCSV(OutputStream stream, char delimiter)
Description copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(OutputStream stream, boolean header, char delimiter)
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer, char delimiter)
Description copied from interface:FormattableLikeFormattable.formatCSV(char), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer, boolean header, char delimiter)
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final String formatCSV(char delimiter, String nullString)
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
public final String formatCSV(boolean header, char delimiter, String nullString)
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
public final String formatCSV(CSVFormat format)
Description copied from interface:FormattableGet a simple formatted representation of this result as CSV.- Specified by:
formatCSVin interfaceFormattable- Returns:
- The formatted result
-
formatCSV
public final void formatCSV(OutputStream stream, char delimiter, String nullString)
Description copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(OutputStream stream, boolean header, char delimiter, String nullString)
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(OutputStream stream, CSVFormat format)
Description copied from interface:FormattableLikeFormattable.formatCSV(CSVFormat), but the data is output onto anOutputStream.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer, char delimiter, String nullString)
Description copied from interface:FormattableLikeFormattable.formatCSV(char, String), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatCSV
public final void formatCSV(Writer writer, boolean header, char delimiter, String nullString)
Description copied from interface:FormattableLikeFormattable.formatCSV(boolean, char, String), but the data is output onto aWriter.- Specified by:
formatCSVin interfaceFormattable
-
formatJSON
public final String 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
public final String formatJSON(JSONFormat format)
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:
JSONFormat
-
formatJSON
public final void formatJSON(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto anOutputStream.- Specified by:
formatJSONin interfaceFormattable
-
formatJSON
public final void formatJSON(OutputStream stream, JSONFormat format)
Description copied from interface:FormattableLikeFormattable.formatJSON(JSONFormat), but the data is output onto anOutputStream.- Specified by:
formatJSONin interfaceFormattable
-
formatJSON
public final void formatJSON(Writer writer)
Description copied from interface:FormattableLikeFormattable.formatJSON(), but the data is output onto aWriter.- Specified by:
formatJSONin interfaceFormattable
-
formatXML
public final String formatXML()
Description copied from interface:FormattableGet this result formatted as XML.- Specified by:
formatXMLin interfaceFormattable- See Also:
- http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
formatXML
public final String formatXML(XMLFormat format)
Description copied from interface:FormattableGet this result formatted as XML.- Specified by:
formatXMLin interfaceFormattable- See Also:
- http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
formatXML
public final void formatXML(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto anOutputStream.- Specified by:
formatXMLin interfaceFormattable
-
formatXML
public final void formatXML(OutputStream stream, XMLFormat format)
Description copied from interface:FormattableLikeFormattable.formatXML(XMLFormat), but the data is output onto anOutputStream.- Specified by:
formatXMLin interfaceFormattable
-
formatXML
public final void formatXML(Writer writer)
Description copied from interface:FormattableLikeFormattable.formatXML(), but the data is output onto aWriter.- Specified by:
formatXMLin interfaceFormattable
-
formatChart
public final String formatChart()
- Specified by:
formatChartin interfaceFormattable
-
formatChart
public final String formatChart(ChartFormat format)
- Specified by:
formatChartin interfaceFormattable
-
formatChart
public final void formatChart(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto anOutputStream.- Specified by:
formatChartin interfaceFormattable
-
formatChart
public final void formatChart(OutputStream stream, ChartFormat format)
Description copied from interface:FormattableLikeFormattable.formatChart(ChartFormat), but the data is output onto anOutputStream.- Specified by:
formatChartin interfaceFormattable
-
formatChart
public final void formatChart(Writer writer)
Description copied from interface:FormattableLikeFormattable.formatChart(), but the data is output onto aWriter.- Specified by:
formatChartin interfaceFormattable
-
formatInsert
public final String 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, theResult.fields()are used for column names.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
public final void formatInsert(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.formatInsert(), but the data is output onto anOutputStream.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
public final String formatInsert(Table<?> table, Field<?>... f)
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, theResult.fields()are used, instead.- Specified by:
formatInsertin interfaceFormattable
-
formatInsert
public final void formatInsert(OutputStream stream, Table<?> table, Field<?>... f)
Description copied from interface:FormattableLikeFormattable.formatInsert(Table, Field...), but the data is output onto anOutputStream.- Specified by:
formatInsertin interfaceFormattable
-
formatHTML
public final String 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
public final void formatHTML(OutputStream stream)
Description copied from interface:FormattableLikeFormattable.formatHTML(), but the data is output onto anOutputStream.- Specified by:
formatHTMLin interfaceFormattable
-
intoXML
public final Document intoXML()
Description copied from interface:FormattableGet this result as XML.- Specified by:
intoXMLin interfaceFormattable- See Also:
Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
intoXML
public final <H extends ContentHandler> H intoXML(H handler) throws SAXException
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:
Formattable.formatXML(), http://www.jooq.org/xsd/jooq-export-3.10.0.xsd
-
-