com.datastax.driver.core.querybuilder

Class Insert

java.lang.Object

com.datastax.driver.core.Statement

com.datastax.driver.core.RegularStatement

com.datastax.driver.core.querybuilder.BuiltStatement

com.datastax.driver.core.querybuilder.Insert

public class Insert
extends BuiltStatement

A built INSERT statement.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Insert.Options The options of an INSERT statement.

Field Summary

Fields inherited from class com.datastax.driver.core.Statement

idempotent, NULL_PAYLOAD_VALUE

Method Summary

Modifier and Type	Method and Description
Insert	ifNotExists() Sets the 'IF NOT EXISTS' option for this INSERT statement.
Insert.Options	using() Returns the options for this INSERT statement.
Insert.Options	using(Using using) Adds a new options for this INSERT statement.
Insert	value(String name, Object value) Adds a column/value pair to the values inserted by this INSERT statement.
Insert	values(List<String> names, List<Object> values) Adds multiple column/value pairs to the values inserted by this INSERT statement.
Insert	values(String[] names, Object[] values) Adds multiple column/value pairs to the values inserted by this INSERT statement.

Methods inherited from class com.datastax.driver.core.querybuilder.BuiltStatement

escapeId, getKeyspace, getQueryString, getRoutingKey, getValues, hasValues, isIdempotent, setForceNoValues, toString

Methods inherited from class com.datastax.driver.core.Statement

disableTracing, enableTracing, getConsistencyLevel, getDefaultTimestamp, getFetchSize, getRetryPolicy, getSerialConsistencyLevel, isTracing, setConsistencyLevel, setDefaultTimestamp, setFetchSize, setIdempotent, setOutgoingPayload, setPagingState, setPagingStateUnsafe, setRetryPolicy, setSerialConsistencyLevel

Methods inherited from class java.lang.Object

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

Method Detail

value

public Insert value(String name,
                    Object value)

Adds a column/value pair to the values inserted by this INSERT statement.

Parameters:

name - the name of the column to insert/update.

value - the value to insert/update for name.

Returns:

this INSERT statement.

values

public Insert values(String[] names,
                     Object[] values)

Adds multiple column/value pairs to the values inserted by this INSERT statement.

Parameters:

names - a list of column names to insert/update.

values - a list of values to insert/update. The ith value in values will be inserted for the ith column in names.

Returns:

this INSERT statement.

Throws:

IllegalArgumentException - if names.length != values.length.

values

public Insert values(List<String> names,
                     List<Object> values)

Adds multiple column/value pairs to the values inserted by this INSERT statement.

Parameters:

names - a list of column names to insert/update.

values - a list of values to insert/update. The ith value in values will be inserted for the ith column in names.

Returns:

this INSERT statement.

Throws:

IllegalArgumentException - if names.size() != values.size().

using

public Insert.Options using(Using using)

Adds a new options for this INSERT statement.

Parameters:

using - the option to add.

Returns:

the options of this INSERT statement.

using

public Insert.Options using()

Returns the options for this INSERT statement.

Chain this with Insert.Options.and(Using) to add options.

Returns:

the options of this INSERT statement.

ifNotExists

public Insert ifNotExists()

Sets the 'IF NOT EXISTS' option for this INSERT statement.

An insert with that option will not succeed unless the row does not exist at the time the insertion is execution. The existence check and insertions are done transactionally in the sense that if multiple clients attempt to create a given row with this option, then at most one may succeed.

Please keep in mind that using this option has a non negligible performance impact and should be avoided when possible.

Returns:

this INSERT statement.