Class Statement (3.42.0)

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="" +="">` It is an error to execute a SQL statement with unbound parameters.
`param_types`	`MutableMapping[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.

Classes

ParamTypesEntry(mapping=None, *, ignore_unknown_fields=False, **kwargs)

The abstract base class for a message.

Parameters
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 `mapping` is a mapping type or there are keyword parameters.