Class: Google::Spanner::V1::ExecuteBatchDmlRequest::Statement
- Inherits:
-
Object
- Object
- Google::Spanner::V1::ExecuteBatchDmlRequest::Statement
- Defined in:
- lib/google/cloud/spanner/v1/doc/google/spanner/v1/spanner.rb
Overview
A single DML statement.
Instance Attribute Summary collapse
-
#param_types ⇒ Hash{String => Google::Spanner::V1::Type}
It is not always possible for Cloud Spanner to infer the right SQL type from a JSON value.
-
#params ⇒ Google::Protobuf::Struct
The DML string can contain parameter placeholders.
-
#sql ⇒ String
Required.
Instance Attribute Details
#param_types ⇒ Hash{String => Google::Spanner::V1::Type}
Returns 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 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 for more information
about SQL types.
282 |
# File 'lib/google/cloud/spanner/v1/doc/google/spanner/v1/spanner.rb', line 282 class Statement; end |
#params ⇒ Google::Protobuf::Struct
Returns The DML string can contain parameter placeholders. A parameter
placeholder consists of '@'
followed by the parameter
name. Parameter names consist of any combination of letters,
numbers, and underscores.
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 an SQL statement with unbound parameters.
Parameter values are specified using params
, which is a JSON
object whose keys are parameter names, and whose values are the
corresponding parameter values.
282 |
# File 'lib/google/cloud/spanner/v1/doc/google/spanner/v1/spanner.rb', line 282 class Statement; end |
#sql ⇒ String
Returns Required. The DML string.
282 |
# File 'lib/google/cloud/spanner/v1/doc/google/spanner/v1/spanner.rb', line 282 class Statement; end |