com.gpudb.protocol

Class DeleteRecordsRequest

java.lang.Object

com.gpudb.protocol.DeleteRecordsRequest

All Implemented Interfaces:

org.apache.avro.generic.GenericContainer, org.apache.avro.generic.IndexedRecord

public class DeleteRecordsRequest
extends Object
implements org.apache.avro.generic.IndexedRecord

A set of parameters for GPUdb.deleteRecords(DeleteRecordsRequest).

Deletes record(s) matching the provided criteria from the given table. The record selection criteria can either be one or more expressions (matching multiple records), a single record identified by record_id options, or all records when using delete_all_records. Note that the three selection criteria are mutually exclusive. This operation cannot be run on a collection or a view. The operation is synchronous meaning that a response will not be available until the request is completely processed and all the matching records are deleted.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DeleteRecordsRequest.Options Optional parameters.

Constructor Summary

Constructors

Constructor and Description
DeleteRecordsRequest() Constructs a DeleteRecordsRequest object with default parameters.
DeleteRecordsRequest(String tableName, List<String> expressions, Map<String,String> options) Constructs a DeleteRecordsRequest object with the specified parameters.

Method Summary

Modifier and Type	Method and Description
boolean	equals(Object obj)
Object	get(int index) This method supports the Avro framework and is not intended to be called directly by the user.
static org.apache.avro.Schema	getClassSchema() This method supports the Avro framework and is not intended to be called directly by the user.
List<String>	getExpressions()
Map<String,String>	getOptions()
org.apache.avro.Schema	getSchema() This method supports the Avro framework and is not intended to be called directly by the user.
String	getTableName()
int	hashCode()
void	put(int index, Object value) This method supports the Avro framework and is not intended to be called directly by the user.
DeleteRecordsRequest	setExpressions(List<String> expressions)
DeleteRecordsRequest	setOptions(Map<String,String> options)
DeleteRecordsRequest	setTableName(String tableName)
String	toString()

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

DeleteRecordsRequest

public DeleteRecordsRequest()

Constructs a DeleteRecordsRequest object with default parameters.

DeleteRecordsRequest

public DeleteRecordsRequest(String tableName,
                            List<String> expressions,
                            Map<String,String> options)

Constructs a DeleteRecordsRequest object with the specified parameters.

Parameters:

tableName - Name of the table from which to delete records. The set must be a currently existing table and not a collection or a view.

expressions - A list of the actual predicates, one for each select; format should follow the guidelines provided here. Specifying one or more expressions is mutually exclusive to specifying record_id in the options.

options - Optional parameters.

• GLOBAL_EXPRESSION: An optional global expression to reduce the search space of the expressions. The default value is ''.
• RECORD_ID: A record ID identifying a single record, obtained at the time of insertion of the record or by calling GPUdb.getRecordsFromCollectionRaw(GetRecordsFromCollectionRequest) with the *return_record_ids* option. This option cannot be used to delete records from replicated tables.
• DELETE_ALL_RECORDS: If set to true, all records in the table will be deleted. If set to false, then the option is effectively ignored. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.

The default value is an empty Map.

Method Detail

getClassSchema

public static org.apache.avro.Schema getClassSchema()

This method supports the Avro framework and is not intended to be called directly by the user.

Returns:

the schema for the class.

getTableName

public String getTableName()

Returns:

Name of the table from which to delete records. The set must be a currently existing table and not a collection or a view.

setTableName

public DeleteRecordsRequest setTableName(String tableName)

Parameters:

tableName - Name of the table from which to delete records. The set must be a currently existing table and not a collection or a view.

Returns:

this to mimic the builder pattern.

getExpressions

public List<String> getExpressions()

Returns:

A list of the actual predicates, one for each select; format should follow the guidelines provided here. Specifying one or more expressions is mutually exclusive to specifying record_id in the options.

setExpressions

public DeleteRecordsRequest setExpressions(List<String> expressions)

Parameters:

expressions - A list of the actual predicates, one for each select; format should follow the guidelines provided here. Specifying one or more expressions is mutually exclusive to specifying record_id in the options.

Returns:

this to mimic the builder pattern.

getOptions

public Map<String,String> getOptions()

Returns:

Optional parameters.

• GLOBAL_EXPRESSION: An optional global expression to reduce the search space of the expressions. The default value is ''.
• RECORD_ID: A record ID identifying a single record, obtained at the time of insertion of the record or by calling GPUdb.getRecordsFromCollectionRaw(GetRecordsFromCollectionRequest) with the *return_record_ids* option. This option cannot be used to delete records from replicated tables.
• DELETE_ALL_RECORDS: If set to true, all records in the table will be deleted. If set to false, then the option is effectively ignored. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.

The default value is an empty Map.

setOptions

public DeleteRecordsRequest setOptions(Map<String,String> options)

Parameters:

options - Optional parameters.

• GLOBAL_EXPRESSION: An optional global expression to reduce the search space of the expressions. The default value is ''.
• RECORD_ID: A record ID identifying a single record, obtained at the time of insertion of the record or by calling GPUdb.getRecordsFromCollectionRaw(GetRecordsFromCollectionRequest) with the *return_record_ids* option. This option cannot be used to delete records from replicated tables.
• DELETE_ALL_RECORDS: If set to true, all records in the table will be deleted. If set to false, then the option is effectively ignored. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.

The default value is an empty Map.

Returns:

this to mimic the builder pattern.

getSchema

public org.apache.avro.Schema getSchema()

This method supports the Avro framework and is not intended to be called directly by the user.

Specified by:

getSchema in interface org.apache.avro.generic.GenericContainer

Returns:

the schema object describing this class.

get

public Object get(int index)

This method supports the Avro framework and is not intended to be called directly by the user.

Specified by:

get in interface org.apache.avro.generic.IndexedRecord

Parameters:

index - the position of the field to get

Returns:

value of the field with the given index.

Throws:

IndexOutOfBoundsException

put

public void put(int index,
                Object value)

This method supports the Avro framework and is not intended to be called directly by the user.

Specified by:

put in interface org.apache.avro.generic.IndexedRecord

Parameters:

index - the position of the field to set

value - the value to set

Throws:

IndexOutOfBoundsException

equals

public boolean equals(Object obj)

Overrides:

equals in class Object

toString

public String toString()

Overrides:

toString in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object