Package com.exasol.dbbuilder.dialects.exasol

Class ExasolImmediateDatabaseObjectWriter

java.lang.Object

com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

com.exasol.dbbuilder.dialects.exasol.ExasolImmediateDatabaseObjectWriter

All Implemented Interfaces:

DatabaseObjectWriter

public class ExasolImmediateDatabaseObjectWriter
extends AbstractImmediateDatabaseObjectWriter

Database object writer that writes objects to the database immediately.

Field Summary

Fields inherited from class com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

connection

Constructor Summary

Constructors

Constructor	Description
ExasolImmediateDatabaseObjectWriter(Connection connection, ExasolObjectConfiguration configuration)	Create a new instance of an ExasolImmediateDatabaseObjectWriter.

Method Summary

Modifier and Type	Method	Description
void	drop(ConnectionDefinition connectionDefinition)	Drop a Connection.
void	drop(Script script)	Drop a script.
void	drop(UdfScript udfScript)	Drop a UDF script
void	drop(VirtualSchema virtualSchema)	Drop a Virtual Schema.
void	drop(Schema schema)	Drop a schema.
int	execute(Script script, Object... parameterValues)	Execute a script.
List<List<Object>>	executeQuery(Script script, Object... parameterValues)	Execute a script returning a table.
protected String	getQuotedColumnName(String columnName)	Get a quoted column name.
void	write(AdapterScript adapterScript)	Create an adapter script for a Virtual Schema.
void	write(ConnectionDefinition definition)	Create a connection definition.
void	write(Script script)	Create a script in the database.
void	write(UdfScript udfScript)	Write an UdfScript to the Exasol database.
void	write(VirtualSchema virtualSchema)	Write a virtual schema to the database.
void	write(User user)	Create a user in the database.
void	write(User user, GlobalPrivilege... privileges)	Grant system privileges to a user.

Methods inherited from class com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

createCommaSeparatedObjectPrivilegeList, createCommaSeparatedSystemPrivilegeList, drop, drop, executeSqlFile, truncate, write, write, write, write, writeToObject

Methods inherited from class java.lang.Object

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

Constructor Detail

ExasolImmediateDatabaseObjectWriter

public ExasolImmediateDatabaseObjectWriter(Connection connection,
                                           ExasolObjectConfiguration configuration)

Create a new instance of an ExasolImmediateDatabaseObjectWriter.

Parameters:

connection - JDBC connection

configuration - global ExasolObjectConfiguration

Method Detail

write

public void write(AdapterScript adapterScript)

Create an adapter script for a Virtual Schema.

Parameters:

adapterScript - the adapter script to be created

write

public void write(ConnectionDefinition definition)

Create a connection definition.

Parameters:

definition - connection definition to be created

drop

public void drop(ConnectionDefinition connectionDefinition)

Drop a Connection.

Parameters:

connectionDefinition - to drop

getQuotedColumnName

protected String getQuotedColumnName(String columnName)

Description copied from class: AbstractImmediateDatabaseObjectWriter

Get a quoted column name.

Specified by:

getQuotedColumnName in class AbstractImmediateDatabaseObjectWriter

Parameters:

columnName - name of a column

Returns:

quoted column name

write

public void write(Script script)

Create a script in the database.

Parameters:

script - script to be written

drop

public void drop(Script script)

Drop a script.

Parameters:

script - to drop

write

public void write(UdfScript udfScript)

Write an UdfScript to the Exasol database.

Parameters:

udfScript - UDF script to write

drop

public void drop(UdfScript udfScript)

Drop a UDF script

Parameters:

udfScript - script to drop

write

public void write(User user)

Description copied from interface: DatabaseObjectWriter

Create a user in the database.

Parameters:

user - to be created

write

public void write(User user,
                  GlobalPrivilege... privileges)

Description copied from interface: DatabaseObjectWriter

Grant system privileges to a user.

Parameters:

user - user who gets the privileges

privileges - privileges to be assigned

write

public void write(VirtualSchema virtualSchema)

Write a virtual schema to the database.

Parameters:

virtualSchema - Virtual Schema to write

drop

public void drop(VirtualSchema virtualSchema)

Drop a Virtual Schema.

Parameters:

virtualSchema - Virtual Schema to drop.

drop

public void drop(Schema schema)

Description copied from interface: DatabaseObjectWriter

Drop a schema.

Parameters:

schema - to drop

execute

public int execute(Script script,
                   Object... parameterValues)

Execute a script.

Implementation note: This method does not use prepared statements but string concatenation, since Exasol currently does not support prepared statements for script execution (see https://www.exasol.com/support/browse/IDEA-42).

Parameters:

script - script to execute

parameterValues - script parameters

Returns:

row count

executeQuery

public List<List<Object>> executeQuery(Script script,
                                       Object... parameterValues)

Execute a script returning a table.

Parameters:

script - script to execute

parameterValues - script parameters

Returns:

table