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.Script

All Implemented Interfaces:

DatabaseObject

public class Script
extends AbstractSchemaChild

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.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.
int	execute(Object... parameterValues)	Execute the script ignoring potential return values.
List<List<Object>>	executeQuery(Object... parameterValues)	Execute a script returning a table.
String	getContent()	Get the script content (i.e.
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.AbstractSchemaChild

getParent, hasParent

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

getFullyQualifiedName, getName, isOwned

Methods inherited from class java.lang.Object

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

Method Detail

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

getContent

public String getContent()

Get the script content (i.e. the implementation).

Returns:

script content

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

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