public final class ExecuteSqlRequest extends GeneratedMessageV3 implements ExecuteSqlRequestOrBuilder
The request for [ExecuteSql][google.spanner.v1.Spanner.ExecuteSql] and [ExecuteStreamingSql][google.spanner.v1.Spanner.ExecuteStreamingSql].Protobuf type
google.spanner.v1.ExecuteSqlRequest
Modifier and Type | Class and Description |
---|---|
static class |
ExecuteSqlRequest.Builder
The request for [ExecuteSql][google.spanner.v1.Spanner.ExecuteSql] and
[ExecuteStreamingSql][google.spanner.v1.Spanner.ExecuteStreamingSql].
|
static class |
ExecuteSqlRequest.QueryMode
Mode in which the statement must be processed.
|
static class |
ExecuteSqlRequest.QueryOptions
Query optimizer configuration.
|
static interface |
ExecuteSqlRequest.QueryOptionsOrBuilder |
GeneratedMessageV3.BuilderParent, GeneratedMessageV3.ExtendableBuilder<MessageType extends GeneratedMessageV3.ExtendableMessage,BuilderType extends GeneratedMessageV3.ExtendableBuilder<MessageType,BuilderType>>, GeneratedMessageV3.ExtendableMessage<MessageType extends GeneratedMessageV3.ExtendableMessage>, GeneratedMessageV3.ExtendableMessageOrBuilder<MessageType extends GeneratedMessageV3.ExtendableMessage>, GeneratedMessageV3.FieldAccessorTable, GeneratedMessageV3.UnusedPrivateParameter
AbstractMessageLite.InternalOneOfEnum
Modifier and Type | Field and Description |
---|---|
static int |
PARAM_TYPES_FIELD_NUMBER |
static int |
PARAMS_FIELD_NUMBER |
static int |
PARTITION_TOKEN_FIELD_NUMBER |
static int |
QUERY_MODE_FIELD_NUMBER |
static int |
QUERY_OPTIONS_FIELD_NUMBER |
static int |
REQUEST_OPTIONS_FIELD_NUMBER |
static int |
RESUME_TOKEN_FIELD_NUMBER |
static int |
SEQNO_FIELD_NUMBER |
static int |
SESSION_FIELD_NUMBER |
static int |
SQL_FIELD_NUMBER |
static int |
TRANSACTION_FIELD_NUMBER |
alwaysUseFieldBuilders, unknownFields
memoizedSize
memoizedHashCode
Modifier and Type | Method and Description |
---|---|
boolean |
containsParamTypes(String key)
It is not always possible for Cloud Spanner to infer the right SQL type
from a JSON value.
|
boolean |
equals(Object obj) |
static ExecuteSqlRequest |
getDefaultInstance() |
ExecuteSqlRequest |
getDefaultInstanceForType() |
static Descriptors.Descriptor |
getDescriptor() |
Struct |
getParams()
Parameter names and values that bind to placeholders in the SQL string.
|
StructOrBuilder |
getParamsOrBuilder()
Parameter names and values that bind to placeholders in the SQL string.
|
Map<String,Type> |
getParamTypes()
Deprecated.
|
int |
getParamTypesCount()
It is not always possible for Cloud Spanner to infer the right SQL type
from a JSON value.
|
Map<String,Type> |
getParamTypesMap()
It is not always possible for Cloud Spanner to infer the right SQL type
from a JSON value.
|
Type |
getParamTypesOrDefault(String key,
Type defaultValue)
It is not always possible for Cloud Spanner to infer the right SQL type
from a JSON value.
|
Type |
getParamTypesOrThrow(String key)
It is not always possible for Cloud Spanner to infer the right SQL type
from a JSON value.
|
Parser<ExecuteSqlRequest> |
getParserForType() |
ByteString |
getPartitionToken()
If present, results will be restricted to the specified partition
previously created using PartitionQuery().
|
ExecuteSqlRequest.QueryMode |
getQueryMode()
Used to control the amount of debugging information returned in
[ResultSetStats][google.spanner.v1.ResultSetStats].
|
int |
getQueryModeValue()
Used to control the amount of debugging information returned in
[ResultSetStats][google.spanner.v1.ResultSetStats].
|
ExecuteSqlRequest.QueryOptions |
getQueryOptions()
Query optimizer configuration to use for the given query.
|
ExecuteSqlRequest.QueryOptionsOrBuilder |
getQueryOptionsOrBuilder()
Query optimizer configuration to use for the given query.
|
RequestOptions |
getRequestOptions()
Common options for this request.
|
RequestOptionsOrBuilder |
getRequestOptionsOrBuilder()
Common options for this request.
|
ByteString |
getResumeToken()
If this request is resuming a previously interrupted SQL statement
execution, `resume_token` should be copied from the last
[PartialResultSet][google.spanner.v1.PartialResultSet] yielded before the interruption.
|
long |
getSeqno()
A per-transaction sequence number used to identify this request.
|
int |
getSerializedSize() |
String |
getSession()
Required.
|
ByteString |
getSessionBytes()
Required.
|
String |
getSql()
Required.
|
ByteString |
getSqlBytes()
Required.
|
TransactionSelector |
getTransaction()
The transaction to use.
|
TransactionSelectorOrBuilder |
getTransactionOrBuilder()
The transaction to use.
|
UnknownFieldSet |
getUnknownFields() |
int |
hashCode() |
boolean |
hasParams()
Parameter names and values that bind to placeholders in the SQL string.
|
boolean |
hasQueryOptions()
Query optimizer configuration to use for the given query.
|
boolean |
hasRequestOptions()
Common options for this request.
|
boolean |
hasTransaction()
The transaction to use.
|
protected GeneratedMessageV3.FieldAccessorTable |
internalGetFieldAccessorTable() |
protected MapField |
internalGetMapField(int number) |
boolean |
isInitialized() |
static ExecuteSqlRequest.Builder |
newBuilder() |
static ExecuteSqlRequest.Builder |
newBuilder(ExecuteSqlRequest prototype) |
ExecuteSqlRequest.Builder |
newBuilderForType() |
protected ExecuteSqlRequest.Builder |
newBuilderForType(GeneratedMessageV3.BuilderParent parent) |
protected Object |
newInstance(GeneratedMessageV3.UnusedPrivateParameter unused) |
static ExecuteSqlRequest |
parseDelimitedFrom(InputStream input) |
static ExecuteSqlRequest |
parseDelimitedFrom(InputStream input,
ExtensionRegistryLite extensionRegistry) |
static ExecuteSqlRequest |
parseFrom(byte[] data) |
static ExecuteSqlRequest |
parseFrom(byte[] data,
ExtensionRegistryLite extensionRegistry) |
static ExecuteSqlRequest |
parseFrom(ByteBuffer data) |
static ExecuteSqlRequest |
parseFrom(ByteBuffer data,
ExtensionRegistryLite extensionRegistry) |
static ExecuteSqlRequest |
parseFrom(ByteString data) |
static ExecuteSqlRequest |
parseFrom(ByteString data,
ExtensionRegistryLite extensionRegistry) |
static ExecuteSqlRequest |
parseFrom(CodedInputStream input) |
static ExecuteSqlRequest |
parseFrom(CodedInputStream input,
ExtensionRegistryLite extensionRegistry) |
static ExecuteSqlRequest |
parseFrom(InputStream input) |
static ExecuteSqlRequest |
parseFrom(InputStream input,
ExtensionRegistryLite extensionRegistry) |
static Parser<ExecuteSqlRequest> |
parser() |
ExecuteSqlRequest.Builder |
toBuilder() |
void |
writeTo(CodedOutputStream output) |
canUseUnsafe, computeStringSize, computeStringSizeNoTag, emptyBooleanList, emptyDoubleList, emptyFloatList, emptyIntList, emptyLongList, getAllFields, getDescriptorForType, getField, getOneofFieldDescriptor, getRepeatedField, getRepeatedFieldCount, hasField, hasOneof, isStringEmpty, makeExtensionsImmutable, mergeFromAndMakeImmutableInternal, mutableCopy, mutableCopy, mutableCopy, mutableCopy, mutableCopy, newBooleanList, newBuilderForType, newDoubleList, newFloatList, newIntList, newLongList, parseDelimitedWithIOException, parseDelimitedWithIOException, parseUnknownField, parseUnknownFieldProto3, parseWithIOException, parseWithIOException, parseWithIOException, parseWithIOException, serializeBooleanMapTo, serializeIntegerMapTo, serializeLongMapTo, serializeStringMapTo, writeReplace, writeString, writeStringNoTag
findInitializationErrors, getInitializationErrorString, hashBoolean, hashEnum, hashEnumList, hashFields, hashLong, toString
addAll, addAll, checkByteStringIsUtf8, toByteArray, toByteString, writeDelimitedTo, writeTo
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
findInitializationErrors, getAllFields, getDescriptorForType, getField, getInitializationErrorString, getOneofFieldDescriptor, getRepeatedField, getRepeatedFieldCount, hasField, hasOneof
toByteArray, toByteString, writeDelimitedTo, writeTo
public static final int SESSION_FIELD_NUMBER
public static final int TRANSACTION_FIELD_NUMBER
public static final int SQL_FIELD_NUMBER
public static final int PARAMS_FIELD_NUMBER
public static final int PARAM_TYPES_FIELD_NUMBER
public static final int RESUME_TOKEN_FIELD_NUMBER
public static final int QUERY_MODE_FIELD_NUMBER
public static final int PARTITION_TOKEN_FIELD_NUMBER
public static final int SEQNO_FIELD_NUMBER
public static final int QUERY_OPTIONS_FIELD_NUMBER
public static final int REQUEST_OPTIONS_FIELD_NUMBER
protected Object newInstance(GeneratedMessageV3.UnusedPrivateParameter unused)
newInstance
in class GeneratedMessageV3
public final UnknownFieldSet getUnknownFields()
getUnknownFields
in interface MessageOrBuilder
getUnknownFields
in class GeneratedMessageV3
public static final Descriptors.Descriptor getDescriptor()
protected MapField internalGetMapField(int number)
internalGetMapField
in class GeneratedMessageV3
protected GeneratedMessageV3.FieldAccessorTable internalGetFieldAccessorTable()
internalGetFieldAccessorTable
in class GeneratedMessageV3
public String getSession()
Required. The session in which the SQL query should be performed.
string session = 1 [(.google.api.field_behavior) = REQUIRED, (.google.api.resource_reference) = { ... }
getSession
in interface ExecuteSqlRequestOrBuilder
public ByteString getSessionBytes()
Required. The session in which the SQL query should be performed.
string session = 1 [(.google.api.field_behavior) = REQUIRED, (.google.api.resource_reference) = { ... }
getSessionBytes
in interface ExecuteSqlRequestOrBuilder
public boolean hasTransaction()
The transaction to use. For queries, if none is provided, the default is a temporary read-only transaction with strong concurrency. Standard DML statements require a read-write transaction. To protect against replays, single-use transactions are not supported. The caller must either supply an existing transaction ID or begin a new transaction. Partitioned DML requires an existing Partitioned DML transaction ID.
.google.spanner.v1.TransactionSelector transaction = 2;
hasTransaction
in interface ExecuteSqlRequestOrBuilder
public TransactionSelector getTransaction()
The transaction to use. For queries, if none is provided, the default is a temporary read-only transaction with strong concurrency. Standard DML statements require a read-write transaction. To protect against replays, single-use transactions are not supported. The caller must either supply an existing transaction ID or begin a new transaction. Partitioned DML requires an existing Partitioned DML transaction ID.
.google.spanner.v1.TransactionSelector transaction = 2;
getTransaction
in interface ExecuteSqlRequestOrBuilder
public TransactionSelectorOrBuilder getTransactionOrBuilder()
The transaction to use. For queries, if none is provided, the default is a temporary read-only transaction with strong concurrency. Standard DML statements require a read-write transaction. To protect against replays, single-use transactions are not supported. The caller must either supply an existing transaction ID or begin a new transaction. Partitioned DML requires an existing Partitioned DML transaction ID.
.google.spanner.v1.TransactionSelector transaction = 2;
getTransactionOrBuilder
in interface ExecuteSqlRequestOrBuilder
public String getSql()
Required. The SQL string.
string sql = 3 [(.google.api.field_behavior) = REQUIRED];
getSql
in interface ExecuteSqlRequestOrBuilder
public ByteString getSqlBytes()
Required. The SQL string.
string sql = 3 [(.google.api.field_behavior) = REQUIRED];
getSqlBytes
in interface ExecuteSqlRequestOrBuilder
public boolean hasParams()
Parameter names and values that bind to placeholders in the SQL string. A parameter placeholder consists of the `@` character followed by the parameter name (for example, `@firstName`). Parameter names must conform to the naming requirements of identifiers as specified at https://cloud.google.com/spanner/docs/lexical#identifiers. Parameters can appear anywhere that a literal value is expected. The same parameter name can be used more than once, for example: `"WHERE id > @msg_id AND id < @msg_id + 100"` It is an error to execute a SQL statement with unbound parameters.
.google.protobuf.Struct params = 4;
hasParams
in interface ExecuteSqlRequestOrBuilder
public Struct getParams()
Parameter names and values that bind to placeholders in the SQL string. A parameter placeholder consists of the `@` character followed by the parameter name (for example, `@firstName`). Parameter names must conform to the naming requirements of identifiers as specified at https://cloud.google.com/spanner/docs/lexical#identifiers. Parameters can appear anywhere that a literal value is expected. The same parameter name can be used more than once, for example: `"WHERE id > @msg_id AND id < @msg_id + 100"` It is an error to execute a SQL statement with unbound parameters.
.google.protobuf.Struct params = 4;
getParams
in interface ExecuteSqlRequestOrBuilder
public StructOrBuilder getParamsOrBuilder()
Parameter names and values that bind to placeholders in the SQL string. A parameter placeholder consists of the `@` character followed by the parameter name (for example, `@firstName`). Parameter names must conform to the naming requirements of identifiers as specified at https://cloud.google.com/spanner/docs/lexical#identifiers. Parameters can appear anywhere that a literal value is expected. The same parameter name can be used more than once, for example: `"WHERE id > @msg_id AND id < @msg_id + 100"` It is an error to execute a SQL statement with unbound parameters.
.google.protobuf.Struct params = 4;
getParamsOrBuilder
in interface ExecuteSqlRequestOrBuilder
public int getParamTypesCount()
ExecuteSqlRequestOrBuilder
It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type `BYTES` and values of type `STRING` both appear in [params][google.spanner.v1.ExecuteSqlRequest.params] as JSON strings. In these cases, `param_types` can be used to specify the exact SQL type for some or all of the SQL statement parameters. See the definition of [Type][google.spanner.v1.Type] for more information about SQL types.
map<string, .google.spanner.v1.Type> param_types = 5;
getParamTypesCount
in interface ExecuteSqlRequestOrBuilder
public boolean containsParamTypes(String key)
It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type `BYTES` and values of type `STRING` both appear in [params][google.spanner.v1.ExecuteSqlRequest.params] as JSON strings. In these cases, `param_types` can be used to specify the exact SQL type for some or all of the SQL statement parameters. See the definition of [Type][google.spanner.v1.Type] for more information about SQL types.
map<string, .google.spanner.v1.Type> param_types = 5;
containsParamTypes
in interface ExecuteSqlRequestOrBuilder
@Deprecated public Map<String,Type> getParamTypes()
getParamTypesMap()
instead.getParamTypes
in interface ExecuteSqlRequestOrBuilder
public Map<String,Type> getParamTypesMap()
It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type `BYTES` and values of type `STRING` both appear in [params][google.spanner.v1.ExecuteSqlRequest.params] as JSON strings. In these cases, `param_types` can be used to specify the exact SQL type for some or all of the SQL statement parameters. See the definition of [Type][google.spanner.v1.Type] for more information about SQL types.
map<string, .google.spanner.v1.Type> param_types = 5;
getParamTypesMap
in interface ExecuteSqlRequestOrBuilder
public Type getParamTypesOrDefault(String key, Type defaultValue)
It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type `BYTES` and values of type `STRING` both appear in [params][google.spanner.v1.ExecuteSqlRequest.params] as JSON strings. In these cases, `param_types` can be used to specify the exact SQL type for some or all of the SQL statement parameters. See the definition of [Type][google.spanner.v1.Type] for more information about SQL types.
map<string, .google.spanner.v1.Type> param_types = 5;
getParamTypesOrDefault
in interface ExecuteSqlRequestOrBuilder
public Type getParamTypesOrThrow(String key)
It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of type `BYTES` and values of type `STRING` both appear in [params][google.spanner.v1.ExecuteSqlRequest.params] as JSON strings. In these cases, `param_types` can be used to specify the exact SQL type for some or all of the SQL statement parameters. See the definition of [Type][google.spanner.v1.Type] for more information about SQL types.
map<string, .google.spanner.v1.Type> param_types = 5;
getParamTypesOrThrow
in interface ExecuteSqlRequestOrBuilder
public ByteString getResumeToken()
If this request is resuming a previously interrupted SQL statement execution, `resume_token` should be copied from the last [PartialResultSet][google.spanner.v1.PartialResultSet] yielded before the interruption. Doing this enables the new SQL statement execution to resume where the last one left off. The rest of the request parameters must exactly match the request that yielded this token.
bytes resume_token = 6;
getResumeToken
in interface ExecuteSqlRequestOrBuilder
public int getQueryModeValue()
Used to control the amount of debugging information returned in [ResultSetStats][google.spanner.v1.ResultSetStats]. If [partition_token][google.spanner.v1.ExecuteSqlRequest.partition_token] is set, [query_mode][google.spanner.v1.ExecuteSqlRequest.query_mode] can only be set to [QueryMode.NORMAL][google.spanner.v1.ExecuteSqlRequest.QueryMode.NORMAL].
.google.spanner.v1.ExecuteSqlRequest.QueryMode query_mode = 7;
getQueryModeValue
in interface ExecuteSqlRequestOrBuilder
public ExecuteSqlRequest.QueryMode getQueryMode()
Used to control the amount of debugging information returned in [ResultSetStats][google.spanner.v1.ResultSetStats]. If [partition_token][google.spanner.v1.ExecuteSqlRequest.partition_token] is set, [query_mode][google.spanner.v1.ExecuteSqlRequest.query_mode] can only be set to [QueryMode.NORMAL][google.spanner.v1.ExecuteSqlRequest.QueryMode.NORMAL].
.google.spanner.v1.ExecuteSqlRequest.QueryMode query_mode = 7;
getQueryMode
in interface ExecuteSqlRequestOrBuilder
public ByteString getPartitionToken()
If present, results will be restricted to the specified partition previously created using PartitionQuery(). There must be an exact match for the values of fields common to this message and the PartitionQueryRequest message used to create this partition_token.
bytes partition_token = 8;
getPartitionToken
in interface ExecuteSqlRequestOrBuilder
public long getSeqno()
A per-transaction sequence number used to identify this request. This field makes each request idempotent such that if the request is received multiple times, at most one will succeed. The sequence number must be monotonically increasing within the transaction. If a request arrives for the first time with an out-of-order sequence number, the transaction may be aborted. Replays of previously handled requests will yield the same response as the first execution. Required for DML statements. Ignored for queries.
int64 seqno = 9;
getSeqno
in interface ExecuteSqlRequestOrBuilder
public boolean hasQueryOptions()
Query optimizer configuration to use for the given query.
.google.spanner.v1.ExecuteSqlRequest.QueryOptions query_options = 10;
hasQueryOptions
in interface ExecuteSqlRequestOrBuilder
public ExecuteSqlRequest.QueryOptions getQueryOptions()
Query optimizer configuration to use for the given query.
.google.spanner.v1.ExecuteSqlRequest.QueryOptions query_options = 10;
getQueryOptions
in interface ExecuteSqlRequestOrBuilder
public ExecuteSqlRequest.QueryOptionsOrBuilder getQueryOptionsOrBuilder()
Query optimizer configuration to use for the given query.
.google.spanner.v1.ExecuteSqlRequest.QueryOptions query_options = 10;
getQueryOptionsOrBuilder
in interface ExecuteSqlRequestOrBuilder
public boolean hasRequestOptions()
Common options for this request.
.google.spanner.v1.RequestOptions request_options = 11;
hasRequestOptions
in interface ExecuteSqlRequestOrBuilder
public RequestOptions getRequestOptions()
Common options for this request.
.google.spanner.v1.RequestOptions request_options = 11;
getRequestOptions
in interface ExecuteSqlRequestOrBuilder
public RequestOptionsOrBuilder getRequestOptionsOrBuilder()
Common options for this request.
.google.spanner.v1.RequestOptions request_options = 11;
getRequestOptionsOrBuilder
in interface ExecuteSqlRequestOrBuilder
public final boolean isInitialized()
isInitialized
in interface MessageLiteOrBuilder
isInitialized
in class GeneratedMessageV3
public void writeTo(CodedOutputStream output) throws IOException
writeTo
in interface MessageLite
writeTo
in class GeneratedMessageV3
IOException
public int getSerializedSize()
getSerializedSize
in interface MessageLite
getSerializedSize
in class GeneratedMessageV3
public boolean equals(Object obj)
equals
in interface Message
equals
in class AbstractMessage
public int hashCode()
hashCode
in interface Message
hashCode
in class AbstractMessage
public static ExecuteSqlRequest parseFrom(ByteBuffer data) throws InvalidProtocolBufferException
InvalidProtocolBufferException
public static ExecuteSqlRequest parseFrom(ByteBuffer data, ExtensionRegistryLite extensionRegistry) throws InvalidProtocolBufferException
InvalidProtocolBufferException
public static ExecuteSqlRequest parseFrom(ByteString data) throws InvalidProtocolBufferException
InvalidProtocolBufferException
public static ExecuteSqlRequest parseFrom(ByteString data, ExtensionRegistryLite extensionRegistry) throws InvalidProtocolBufferException
InvalidProtocolBufferException
public static ExecuteSqlRequest parseFrom(byte[] data) throws InvalidProtocolBufferException
InvalidProtocolBufferException
public static ExecuteSqlRequest parseFrom(byte[] data, ExtensionRegistryLite extensionRegistry) throws InvalidProtocolBufferException
InvalidProtocolBufferException
public static ExecuteSqlRequest parseFrom(InputStream input) throws IOException
IOException
public static ExecuteSqlRequest parseFrom(InputStream input, ExtensionRegistryLite extensionRegistry) throws IOException
IOException
public static ExecuteSqlRequest parseDelimitedFrom(InputStream input) throws IOException
IOException
public static ExecuteSqlRequest parseDelimitedFrom(InputStream input, ExtensionRegistryLite extensionRegistry) throws IOException
IOException
public static ExecuteSqlRequest parseFrom(CodedInputStream input) throws IOException
IOException
public static ExecuteSqlRequest parseFrom(CodedInputStream input, ExtensionRegistryLite extensionRegistry) throws IOException
IOException
public ExecuteSqlRequest.Builder newBuilderForType()
newBuilderForType
in interface Message
newBuilderForType
in interface MessageLite
public static ExecuteSqlRequest.Builder newBuilder()
public static ExecuteSqlRequest.Builder newBuilder(ExecuteSqlRequest prototype)
public ExecuteSqlRequest.Builder toBuilder()
toBuilder
in interface Message
toBuilder
in interface MessageLite
protected ExecuteSqlRequest.Builder newBuilderForType(GeneratedMessageV3.BuilderParent parent)
newBuilderForType
in class GeneratedMessageV3
public static ExecuteSqlRequest getDefaultInstance()
public static Parser<ExecuteSqlRequest> parser()
public Parser<ExecuteSqlRequest> getParserForType()
getParserForType
in interface Message
getParserForType
in interface MessageLite
getParserForType
in class GeneratedMessageV3
public ExecuteSqlRequest getDefaultInstanceForType()
getDefaultInstanceForType
in interface MessageLiteOrBuilder
getDefaultInstanceForType
in interface MessageOrBuilder
Copyright © 2022 Google LLC. All rights reserved.