Struct mysql::Conn

pub struct Conn(_);

Mysql connection.

Implementations

impl Conn

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: Into<Opts>>(opts: T) -> Result<Conn>

Creates new Conn.

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

Resets MyConn (drops state then reconnects).

pub fn ping(&mut self) -> bool

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

pub fn select_db(&mut self, schema: &str) -> bool

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

pub fn get_binlog_stream(
    self,
    request: BinlogRequest<'_>
) -> Result<BinlogStream>

Turns this connection into a binlog stream.

You can use SHOW BINARY LOGS to get the current logfile and position from the master. If the request’s filename is empty, the server will send the binlog-stream of the first known binlog.

Trait Implementations

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>>

Perfoms 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 signel 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.