Statement(mapping=None, *, ignore_unknown_fields=False, **kwargs)
A single DML statement.
Attributes
Name | Description |
sql |
str
Required. The DML string. |
params |
google.protobuf.struct_pb2.Struct
Parameter names and values that bind to placeholders in the DML string. A parameter placeholder consists of the ``@`` character followed by the parameter name (for example, ``@firstName``). Parameter names can contain 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="" a="" sql="" statement="" with="" unbound="" parameters.=""> |
param_types |
Mapping[str, google.cloud.spanner_v1.types.Type]
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.ExecuteBatchDmlRequest.Statement.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. |
Inheritance
builtins.object > proto.message.Message > StatementClasses
ParamTypesEntry
ParamTypesEntry(mapping=None, *, ignore_unknown_fields=False, **kwargs)
The abstract base class for a message.
Name | Description |
kwargs |
dict
Keys and values corresponding to the fields of the message. |
mapping |
Union[dict, `.Message`]
A dictionary or message to be used to determine the values for this message. |
ignore_unknown_fields |
Optional(bool)
If True, do not raise errors for unknown fields. Only applied if |