package Mysqlx.Prepare

Get desktop application:
View/edit binary Protocol Buffers messages

* Deallocate already prepared statement @startuml client -> server: Deallocate alt Success client <- server: Ok else Failure client <- server: Error end @enduml @returns @ref Mysqlx::Ok or @ref Mysqlx::Error

• required uint32 stmt_id = 1

  * client side assigned statement id, must be already prepared

* Execute already prepared statement @startuml client -> server: Execute alt Success ... Resultsets... client <- server: StmtExecuteOk else Failure client <- server: Error end @enduml @returns @ref Mysqlx::Ok

Used in: Cursor.Open.OneOfMessage

• required uint32 stmt_id = 1

  * client side assigned statement id, must be already prepared

• repeated Datatypes.Any args = 2

  * Arguments to bind to the prepared statement

• optional bool compact_metadata = 3

  * send only type information for @ref Mysqlx::Resultset::ColumnMetaData, skipping names and others

* Prepare a new statement @startuml client -> server: Prepare alt Success client <- server: Ok else Failure client <- server: Error end @enduml @returns @ref Mysqlx::Ok or @ref Mysqlx::Error

• required uint32 stmt_id = 1

  * client side assigned statement id, which is going to identify the result of preparation

• required Prepare.OneOfMessage stmt = 2

  * defines one of following messages to be prepared: Crud::Find, Crud::Insert, Crud::Delete, Crud::Upsert, Sql::StmtExecute

Used in: Prepare

• required OneOfMessage.Type type = 1

• optional Crud.Find find = 2

• optional Crud.Insert insert = 3

• optional Crud.Update update = 4

• optional Crud.Delete delete = 5

• optional Sql.StmtExecute stmt_execute = 6

Determine which of optional fields was set by the client (Workaround for missing "oneof" keyword in pb2.5)

Used in: OneOfMessage

• FIND = 0

• INSERT = 1

• UPDATE = 2

• DELETE = 4

• STMT = 5