Struct Conn

pub struct Conn(/* private fields */);

Mysql connection.

Implementations

impl Conn

pub fn server_version(&self) -> (u16, u16, u16)

Returns version number reported by the server.

pub fn connection_id(&self) -> u32

Returns connection identifier.

pub fn affected_rows(&self) -> u64

Returns number of rows affected by the last query.

pub fn last_insert_id(&self) -> u64

Returns last insert id of the last query.

Returns zero if there was no last insert id.

pub fn warnings(&self) -> u16

Returns number of warnings, reported by the server.

pub fn info_ref(&self) -> &[u8]

Info, reported by the server.

Will be empty if not defined.

pub fn info_str(&self) -> Cow<'_, str>

Info, reported by the server.

Will be empty if not defined.

pub fn session_state_changes(&self) -> Result<Vec<SessionStateInfo<'_>>>

pub fn new<T, E>(opts: T) -> Result<Conn>

where Opts: TryFrom<T, Error = E>, Error: From<E>,

Creates new Conn.

pub fn reset(&mut self) -> Result<()>

Tries to reset the connection.

This function will try to invoke COM_RESET_CONNECTION with a fall back to COM_CHANGE_USER on older servers.

Warning

There is a long-standing bug in mysql 5.6 that kills this functionality in presence of connection attributes (see Bug #92954).

Note

Re-executes Opts::get_init.

pub fn change_user(&mut self, opts: ChangeUserOpts) -> Result<()>

Executes COM_CHANGE_USER.

This might be used as an older and slower alternative to COM_RESET_CONNECTION that works on MySql prior to 5.7.3 (MariaDb prior ot 10.2.4).

Note

• Using non-default opts for a pooled connection is discouraging.
• Connection options will be updated permanently.

Warning

There is a long-standing bug in mysql 5.6 that kills this functionality in presence of connection attributes (see Bug #92954).

pub fn ping(&mut self) -> Result<(), Error>

Executes COM_PING on Conn. Return true on success or false on error.

pub fn select_db(&mut self, schema: &str) -> Result<(), Error>

Executes COM_INIT_DB on Conn.

pub fn start_transaction(&mut self, tx_opts: TxOpts) -> Result<Transaction<'_>>

Starts new transaction with provided options. readonly is only available since MySQL 5.6.5.

pub fn set_local_infile_handler(&mut self, handler: Option<LocalInfileHandler>)

Sets a callback to handle requests for local files. These are caused by using LOAD DATA LOCAL INFILE queries. The callback is passed the filename, and a Writeable object to receive the contents of that file. Specifying None will reset the handler to the one specified in the Opts for this connection.

pub fn no_backslash_escape(&self) -> bool

Trait Implementations

impl AsMut<Conn> for PooledConn

fn as_mut(&mut self) -> &mut Conn

Converts this type into a mutable reference of the (usually inferred) input type.

impl AsRawFd for Conn

fn as_raw_fd(&self) -> RawFd

Extracts the raw file descriptor.

impl AsRef<Conn> for PooledConn

fn as_ref(&self) -> &Conn

Converts this type into a shared reference of the (usually inferred) input type.

impl Debug for Conn

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Drop for Conn

fn drop(&mut self)

Executes the destructor for this type.

impl Queryable for Conn

fn query_iter<T: AsRef<str>>( &mut self, query: T, ) -> Result<QueryResult<'_, '_, '_, Text>>

Performs text query.

fn prep<T: AsRef<str>>(&mut self, query: T) -> Result<Statement>

Prepares the given query as a prepared statement.

fn close(&mut self, stmt: Statement) -> Result<()>

This function will close the given statement on the server side.

fn exec_iter<S, P>( &mut self, stmt: S, params: P, ) -> Result<QueryResult<'_, '_, '_, Binary>>

where S: AsStatement, P: Into<Params>,

Executes the given stmt with the given params.

fn query<T, Q>(&mut self, query: Q) -> Result<Vec<T>>

where Q: AsRef<str>, T: FromRow,

Performs text query and collects the first result set.

fn query_opt<T, Q>( &mut self, query: Q, ) -> Result<Vec<StdResult<T, FromRowError>>>

where Q: AsRef<str>, T: FromRow,

Same as Queryable::query but useful when you not sure what your schema is.

fn query_first<T, Q>(&mut self, query: Q) -> Result<Option<T>>

where Q: AsRef<str>, T: FromRow,

Performs text query and returns the first row of the first result set.

fn query_first_opt<T, Q>( &mut self, query: Q, ) -> Result<Option<StdResult<T, FromRowError>>>

where Q: AsRef<str>, T: FromRow,

Same as Queryable::query_first but useful when you not sure what your schema is.

fn query_map<T, F, Q, U>(&mut self, query: Q, f: F) -> Result<Vec<U>>

where Q: AsRef<str>, T: FromRow, F: FnMut(T) -> U,

Performs text query and maps each row of the first result set.

fn query_map_opt<T, F, Q, U>(&mut self, query: Q, f: F) -> Result<Vec<U>>

where Q: AsRef<str>, T: FromRow, F: FnMut(StdResult<T, FromRowError>) -> U,

Same as Queryable::query_map but useful when you not sure what your schema is.

fn query_fold<T, F, Q, U>(&mut self, query: Q, init: U, f: F) -> Result<U>

where Q: AsRef<str>, T: FromRow, F: FnMut(U, T) -> U,

Performs text query and folds the first result set to a single value.

fn query_fold_opt<T, F, Q, U>(&mut self, query: Q, init: U, f: F) -> Result<U>

where Q: AsRef<str>, T: FromRow, F: FnMut(U, StdResult<T, FromRowError>) -> U,

Same as Queryable::query_fold but useful when you not sure what your schema is.

fn query_drop<Q>(&mut self, query: Q) -> Result<()>

where Q: AsRef<str>,

Performs text query and drops the query result.

fn exec_batch<S, P, I>(&mut self, stmt: S, params: I) -> Result<()>

where Self: Sized, S: AsStatement, P: Into<Params>, I: IntoIterator<Item = P>,

Prepares the given statement, and executes it with each item in the given params iterator.

fn exec<T, S, P>(&mut self, stmt: S, params: P) -> Result<Vec<T>>

where S: AsStatement, P: Into<Params>, T: FromRow,

Executes the given stmt and collects the first result set.

fn exec_opt<T, S, P>( &mut self, stmt: S, params: P, ) -> Result<Vec<StdResult<T, FromRowError>>>

where S: AsStatement, P: Into<Params>, T: FromRow,

Same as Queryable::exec but useful when you not sure what your schema is.

fn exec_first<T, S, P>(&mut self, stmt: S, params: P) -> Result<Option<T>>

where S: AsStatement, P: Into<Params>, T: FromRow,

Executes the given stmt and returns the first row of the first result set.

fn exec_first_opt<T, S, P>( &mut self, stmt: S, params: P, ) -> Result<Option<StdResult<T, FromRowError>>>

where S: AsStatement, P: Into<Params>, T: FromRow,

Same as Queryable::exec_first but useful when you not sure what your schema is.

fn exec_map<T, S, P, F, U>( &mut self, stmt: S, params: P, f: F, ) -> Result<Vec<U>>

where S: AsStatement, P: Into<Params>, T: FromRow, F: FnMut(T) -> U,

Executes the given stmt and maps each row of the first result set.

fn exec_map_opt<T, S, P, F, U>( &mut self, stmt: S, params: P, f: F, ) -> Result<Vec<U>>

where S: AsStatement, P: Into<Params>, T: FromRow, F: FnMut(StdResult<T, FromRowError>) -> U,

Same as Queryable::exec_map but useful when you not sure what your schema is.

fn exec_fold<T, S, P, U, F>( &mut self, stmt: S, params: P, init: U, f: F, ) -> Result<U>

where S: AsStatement, P: Into<Params>, T: FromRow, F: FnMut(U, T) -> U,

Executes the given stmt and folds the first result set to a single value.

fn exec_fold_opt<T, S, P, U, F>( &mut self, stmt: S, params: P, init: U, f: F, ) -> Result<U>

where S: AsStatement, P: Into<Params>, T: FromRow, F: FnMut(U, StdResult<T, FromRowError>) -> U,

Same as Queryable::exec_fold but useful when you not sure what your schema is.

fn exec_drop<S, P>(&mut self, stmt: S, params: P) -> Result<()>

where S: AsStatement, P: Into<Params>,

Executes the given stmt and drops the result.