GoogleApi.Spanner.V1.Model.Statement (google_api_spanner v0.48.0)
View SourceA single DML statement.
Attributes
-
paramTypes
(type:%{optional(String.t) => GoogleApi.Spanner.V1.Model.Type.t}
, default:nil
) - It isn't always possible for Cloud Spanner to infer the right SQL type from a JSON value. For example, values of typeBYTES
and values of typeSTRING
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. -
params
(type:map()
, default:nil
) - 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's an error to execute a SQL statement with unbound parameters. -
sql
(type:String.t
, default:nil
) - Required. The DML string.
Summary
Functions
Unwrap a decoded JSON object into its complex fields.
Types
@type t() :: %GoogleApi.Spanner.V1.Model.Statement{ paramTypes: %{optional(String.t()) => GoogleApi.Spanner.V1.Model.Type.t()} | nil, params: map() | nil, sql: String.t() | nil }