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

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.
void	drop()	Drop the database object and all contained objects.
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

getFullyQualifiedName, getName, isOwned

Methods inherited from class java.lang.Object

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

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

drop

public void drop()

Description copied from interface: DatabaseObject

Drop the database object and all contained objects.