Package org.h2.command.dml

Class ScriptCommand

java.lang.Object

org.h2.command.Prepared

org.h2.command.dml.ScriptBase

org.h2.command.dml.ScriptCommand

public class ScriptCommand
extends ScriptBase

This class represents the statement SCRIPT

Field Summary

Fields

Modifier and Type	Field	Description
private byte[]	buffer
private static java.util.Comparator<? super DbObject>	BY_NAME_COMPARATOR
private java.nio.charset.Charset	charset
private boolean	data
private boolean	drop
private byte[]	lineSeparator
private java.lang.String	lineSeparatorString
private int	lobBlockSize
private int	nextLobId
private boolean	passwords
private LocalResult	result
private java.util.Set<java.lang.String>	schemaNames
private boolean	settings
private boolean	simple
private java.util.Collection<Table>	tables
private boolean	tempLobTableCreated
private boolean	version
private boolean	withColumns

Fields inherited from class org.h2.command.dml.ScriptBase

out, reader

Fields inherited from class org.h2.command.Prepared

create, parameters, prepareAlways, session, sqlStatement, sqlTokens

Constructor Summary

Constructors

Constructor	Description
ScriptCommand(SessionLocal session)

Method Summary

Modifier and Type	Method	Description
private void	add(java.lang.String s, boolean insert)
private void	addDomain(Domain domain)
static java.io.InputStream	combineBlob(java.sql.Connection conn, int id)	Combine a BLOB.
static java.io.Reader	combineClob(java.sql.Connection conn, int id)	Combine a CLOB.
private LocalResult	createResult()
private void	dumpDomains(java.util.ArrayList<Schema> schemas)
private void	dumpRights(Database db)
private boolean	excludeSchema(Schema schema)
private boolean	excludeTable(Table table)
private int	generateInsertValues(int count, Table table)
private static java.sql.ResultSet	getLobStream(java.sql.Connection conn, java.lang.String column, int id)
int	getType()	Get the command type as defined in CommandInterface
boolean	isQuery()	Check if this object is a query.
ResultInterface	query(long maxrows)	Execute the query.
ResultInterface	queryMeta()	Get an empty result set containing the meta data.
private void	reset()
void	setCharset(java.nio.charset.Charset charset)
void	setData(boolean data)
void	setDrop(boolean drop)
void	setLobBlockSize(long blockSize)
void	setPasswords(boolean passwords)
void	setSchemaNames(java.util.Set<java.lang.String> schemaNames)
void	setSettings(boolean settings)
void	setSimple(boolean simple)
void	setTables(java.util.Collection<Table> tables)
void	setVersion(boolean version)
void	setWithColumns(boolean withColumns)
private static <T extends DbObject> T[]	sorted(java.util.Collection<T> collection, java.lang.Class<T> clazz)
private int	writeLobStream(Value v)

Methods inherited from class org.h2.command.dml.ScriptBase

closeIO, deleteStore, getFileName, isTransactional, needRecompile, openInput, openOutput, setCipher, setCompressionAlgorithm, setFileNameExpr, setPassword

Methods inherited from class org.h2.command.Prepared

checkCanceled, checkParameters, collectDependencies, getCteCleanups, getCurrentRowNumber, getObjectId, getParameters, getPersistedObjectId, getPlanSQL, getSession, getSimpleSQL, getSQL, getSQLTokens, isCacheable, isReadOnly, prepare, setCommand, setCteCleanups, setCurrentRowNumber, setParameterList, setPersistedObjectId, setPrepareAlways, setRow, setSession, setSQL, toString, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

BY_NAME_COMPARATOR

private static final java.util.Comparator<? super DbObject> BY_NAME_COMPARATOR

charset

private java.nio.charset.Charset charset

schemaNames

private java.util.Set<java.lang.String> schemaNames

tables

private java.util.Collection<Table> tables

passwords

private boolean passwords

data

private boolean data

settings

private boolean settings

drop

private boolean drop

simple

private boolean simple

withColumns

private boolean withColumns

version

private boolean version

result

private LocalResult result

lineSeparatorString

private java.lang.String lineSeparatorString

lineSeparator

private byte[] lineSeparator

buffer

private byte[] buffer

tempLobTableCreated

private boolean tempLobTableCreated

nextLobId

private int nextLobId

lobBlockSize

private int lobBlockSize

Constructor Detail

ScriptCommand

public ScriptCommand(SessionLocal session)

Method Detail

isQuery

public boolean isQuery()

Description copied from class: Prepared

Check if this object is a query.

Overrides:

isQuery in class Prepared

Returns:

true if it is

setSchemaNames

public void setSchemaNames(java.util.Set<java.lang.String> schemaNames)

setTables

public void setTables(java.util.Collection<Table> tables)

setData

public void setData(boolean data)

setPasswords

public void setPasswords(boolean passwords)

setSettings

public void setSettings(boolean settings)

setLobBlockSize

public void setLobBlockSize(long blockSize)

setDrop

public void setDrop(boolean drop)

queryMeta

public ResultInterface queryMeta()

Description copied from class: Prepared

Get an empty result set containing the meta data.

Specified by:

queryMeta in class Prepared

Returns:

the result set

createResult

private LocalResult createResult()

query

public ResultInterface query(long maxrows)

Description copied from class: Prepared

Execute the query.

Overrides:

query in class Prepared

Parameters:

maxrows - the maximum number of rows to return

Returns:

the result set

dumpDomains

private void dumpDomains(java.util.ArrayList<Schema> schemas)
                  throws java.io.IOException

Throws:

java.io.IOException

dumpRights

private void dumpRights(Database db)
                 throws java.io.IOException

Throws:

java.io.IOException

addDomain

private void addDomain(Domain domain)
                throws java.io.IOException

Throws:

java.io.IOException

sorted

private static <T extends DbObject> T[] sorted(java.util.Collection<T> collection,
                                               java.lang.Class<T> clazz)

generateInsertValues

private int generateInsertValues(int count,
                                 Table table)
                          throws java.io.IOException

Throws:

java.io.IOException

writeLobStream

private int writeLobStream(Value v)
                    throws java.io.IOException

Throws:

java.io.IOException

combineBlob

public static java.io.InputStream combineBlob(java.sql.Connection conn,
                                              int id)
                                       throws java.sql.SQLException

Combine a BLOB. This method is called from the script. When calling with id -1, the file is deleted.

Parameters:

conn - a connection

id - the lob id

Returns:

a stream for the combined data

Throws:

java.sql.SQLException - on failure

combineClob

public static java.io.Reader combineClob(java.sql.Connection conn,
                                         int id)
                                  throws java.sql.SQLException

Combine a CLOB. This method is called from the script.

Parameters:

conn - a connection

id - the lob id

Returns:

a reader for the combined data

Throws:

java.sql.SQLException - on failure

getLobStream

private static java.sql.ResultSet getLobStream(java.sql.Connection conn,
                                               java.lang.String column,
                                               int id)
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

reset

private void reset()

excludeSchema

private boolean excludeSchema(Schema schema)

excludeTable

private boolean excludeTable(Table table)

add

private void add(java.lang.String s,
                 boolean insert)
          throws java.io.IOException

Throws:

java.io.IOException

setSimple

public void setSimple(boolean simple)

setWithColumns

public void setWithColumns(boolean withColumns)

setVersion

public void setVersion(boolean version)

setCharset

public void setCharset(java.nio.charset.Charset charset)

getType

public int getType()

Description copied from class: Prepared

Get the command type as defined in CommandInterface

Specified by:

getType in class Prepared

Returns:

the statement type