com.exasol.sql.dml.insert

Class Insert

java.lang.Object

com.exasol.sql.AbstractFragment

com.exasol.sql.dml.insert.Insert

All Implemented Interfaces:

InsertFragment, Fragment, SqlStatement

public class Insert
extends AbstractFragment
implements SqlStatement, InsertFragment

This class implements an SQL Insert statement

Field Summary

Fields inherited from class com.exasol.sql.AbstractFragment

root

Constructor Summary

Constructors

Constructor and Description
Insert(String tableName) Create a new instance of an Insert statement

Method Summary

Modifier and Type	Method and Description
void	accept(InsertVisitor visitor) Accept a visitor (e.g.
protected void	createInsertValueInstanceIfItDoesNotExist()
Insert	field(String... names) Define fields into which should be inserted
String	getTableName() Get the name of the table into which data should be inserted
Insert	valuePlaceholder() Add an unnamed value placeholder to the value list (this is useful for prepared statements)
Insert	valuePlaceholders(int amount) Add a given number unnamed value placeholder to the value list (this is useful for prepared statements)
Insert	values(int... values) Insert a list of integer values
Insert	values(String... values) Insert a list of string values
Insert	valueTable(ValueTable table) Insert a value table

Methods inherited from class com.exasol.sql.AbstractFragment

getRoot

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.exasol.sql.Fragment

getRoot

Constructor Detail

Insert

public Insert(String tableName)

Create a new instance of an Insert statement

Parameters:

tableName - name of the table into which the data should be inserted

Method Detail

field

public Insert field(String... names)

Define fields into which should be inserted

Parameters:

names - field names

Returns:

this for fluent programming

createInsertValueInstanceIfItDoesNotExist

protected void createInsertValueInstanceIfItDoesNotExist()

getTableName

public String getTableName()

Get the name of the table into which data should be inserted

Returns:

table name

valueTable

public Insert valueTable(ValueTable table)

Insert a value table

Parameters:

table - value table to be inserted

Returns:

this for fluent programming

values

public Insert values(String... values)

Insert a list of string values

Parameters:

values - string values to be inserted

Returns:

this for fluent programming

values

public Insert values(int... values)

Insert a list of integer values

Parameters:

values - integer values to be inserted

Returns:

this for fluent programming

valuePlaceholder

public Insert valuePlaceholder()

Add an unnamed value placeholder to the value list (this is useful for prepared statements)

Returns:

this for fluent programming

valuePlaceholders

public Insert valuePlaceholders(int amount)

Add a given number unnamed value placeholder to the value list (this is useful for prepared statements)

Parameters:

amount - number of placeholders to be added

Returns:

this for fluent programming

accept

public void accept(InsertVisitor visitor)

Description copied from interface: InsertFragment

Accept a visitor (e.g. a renderer or validator)

Specified by:

accept in interface InsertFragment

Parameters:

visitor - visitor to accept