Package com.exasol.dbbuilder.dialects.exasol

Class Script

java.lang.Object

com.exasol.dbbuilder.dialects.AbstractDatabaseObject

com.exasol.dbbuilder.dialects.AbstractSchemaChild

com.exasol.dbbuilder.dialects.exasol.AbstractScript

com.exasol.dbbuilder.dialects.exasol.Script

All Implemented Interfaces:

DatabaseObject, AutoCloseable

public class Script
extends AbstractScript

Exasol database (Lua) Script.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	Script.Builder	Builder for a Script.

Field Summary

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

content, writer

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

parentSchema

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

name, owned

Method Summary

Modifier and Type	Method	Description
static Script.Builder	builder(ExasolImmediateDatabaseObjectWriter writer, Schema parentSchema, String name)	Create a builder for a Script.
protected void	dropInternally()	This is called by AbstractDatabaseObject.drop() to actually execute the DROP statement.
int	execute(Object... parameterValues)	Execute the script ignoring potential return values.
List<List<Object>>	executeQuery(Object... parameterValues)	Execute a script returning a table.
List<ScriptParameter>	getParameters()	Get the script's parameters.
String	getType()	Get the type of the database object.
boolean	returnsTable()	Check if the script returns a table.

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

getContent

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

getParent, hasParent

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

drop, getFullyQualifiedName, getName, isOwned, markDeleted, verifyNotDeleted

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.exasol.dbbuilder.dialects.DatabaseObject

close

Method Detail

builder

public static Script.Builder builder(ExasolImmediateDatabaseObjectWriter writer,
                                     Schema parentSchema,
                                     String name)

Create a builder for a Script.

Parameters:

writer - data object writer

parentSchema - parent schema

name - name of the script

Returns:

builder

getType

public String getType()

Description copied from interface: DatabaseObject

Get the type of the database object.

Returns:

type of the database object

getParameters

public List<ScriptParameter> getParameters()

Get the script's parameters.

Returns:

parameters

returnsTable

public boolean returnsTable()

Check if the script returns a table.

Returns:

true if the script returns a table, false if it returns a row count.

execute

public int execute(Object... parameterValues)

Execute the script ignoring potential return values.

Parameters:

parameterValues - script parameters

Returns:

row count

executeQuery

public List<List<Object>> executeQuery(Object... parameterValues)

Execute a script returning a table.

Parameters:

parameterValues - script parameter values

Returns:

script result as table

dropInternally

protected void dropInternally()

Description copied from class: AbstractDatabaseObject

This is called by AbstractDatabaseObject.drop() to actually execute the DROP statement.

Specified by:

dropInternally in class AbstractDatabaseObject