Struct sqlx_core::mysql::MySqlConnection

pub struct MySqlConnection { /* fields omitted */ }

A connection to a MySQL database.

Trait Implementations

impl<'c> Acquire<'c> for &'c mut MySqlConnection

type Database = MySql

type Connection = &'c mut <MySql as Database>::Connection

fn acquire(self) -> BoxFuture<'c, Result<Self::Connection, Error>>

fn begin(self) -> BoxFuture<'c, Result<Transaction<'c, MySql>, Error>>

impl Connection for MySqlConnection

type Database = MySql

type Options = MySqlConnectOptions

fn close(self) -> BoxFuture<'static, Result<(), Error>>

Explicitly close this database connection.

fn ping(&mut self) -> BoxFuture<'_, Result<(), Error>>

Checks if a connection to the database is still valid.

fn cached_statements_size(&self) -> usize

The number of statements currently cached in the connection.

fn clear_cached_statements(&mut self) -> BoxFuture<'_, Result<(), Error>>

Removes all statements from the cache, closing them on the server if needed.

fn begin(
    &mut self
) -> BoxFuture<'_, Result<Transaction<'_, Self::Database>, Error>> where
    Self: Sized, 

Begin a new transaction or establish a savepoint within the active transaction.

fn transaction<'a, F, R, E>(
    &'a mut self,
    callback: F
) -> BoxFuture<'a, Result<R, E>> where
    for<'c> F: FnOnce(&'c mut Transaction<'_, Self::Database>) -> BoxFuture<'c, Result<R, E>> + 'a + Send + Sync,
    Self: Sized,
    R: Send,
    E: From<Error> + Send, 

Execute the function inside a transaction.

fn connect(url: &str) -> BoxFuture<'static, Result<Self, Error>> where
    Self: Sized, 

Establish a new database connection.

fn connect_with(options: &Self::Options) -> BoxFuture<'_, Result<Self, Error>> where
    Self: Sized, 

Establish a new database connection with the provided options.

impl Debug for MySqlConnection

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

Formats the value using the given formatter.

impl<'c> Executor<'c> for &'c mut MySqlConnection

type Database = MySql

fn fetch_many<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxStream<'e, Result<Either<MySqlQueryResult, MySqlRow>, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute multiple queries and return the generated results as a stream from each query, in a stream.

fn fetch_optional<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxFuture<'e, Result<Option<MySqlRow>, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute the query and returns at most one row.

fn prepare_with<'e, 'q: 'e>(
    self,
    sql: &'q str,
    _parameters: &'e [MySqlTypeInfo]
) -> BoxFuture<'e, Result<MySqlStatement<'q>, Error>> where
    'c: 'e, 

Prepare the SQL query, with parameter type information, to inspect the type information about its parameters and results.

fn execute<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxFuture<'e, Result<<Self::Database as Database>::QueryResult, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute the query and return the total number of rows affected.

fn execute_many<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxStream<'e, Result<<Self::Database as Database>::QueryResult, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute multiple queries and return the rows affected from each query, in a stream.

fn fetch<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxStream<'e, Result<<Self::Database as Database>::Row, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute the query and return the generated results as a stream.

fn fetch_all<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxFuture<'e, Result<Vec<<Self::Database as Database>::Row>, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute the query and return all the generated results, collected into a Vec.

fn fetch_one<'e, 'q: 'e, E: 'q>(
    self,
    query: E
) -> BoxFuture<'e, Result<<Self::Database as Database>::Row, Error>> where
    'c: 'e,
    E: Execute<'q, Self::Database>, 

Execute the query and returns exactly one row.

fn prepare<'e, 'q: 'e>(
    self,
    query: &'q str
) -> BoxFuture<'e, Result<<Self::Database as HasStatement<'q>>::Statement, Error>> where
    'c: 'e, 

Prepare the SQL query to inspect the type information of its parameters and results.

impl Migrate for MySqlConnection

fn ensure_migrations_table(&mut self) -> BoxFuture<'_, Result<(), MigrateError>>

fn version(
    &mut self
) -> BoxFuture<'_, Result<Option<(i64, bool)>, MigrateError>>

👎 Deprecated

fn dirty_version(&mut self) -> BoxFuture<'_, Result<Option<i64>, MigrateError>>

fn list_applied_migrations(
    &mut self
) -> BoxFuture<'_, Result<Vec<AppliedMigration>, MigrateError>>

fn lock(&mut self) -> BoxFuture<'_, Result<(), MigrateError>>

fn unlock(&mut self) -> BoxFuture<'_, Result<(), MigrateError>>

fn validate<'e: 'm, 'm>(
    &'e mut self,
    migration: &'m Migration
) -> BoxFuture<'m, Result<(), MigrateError>>

👎 Deprecated

fn apply<'e: 'm, 'm>(
    &'e mut self,
    migration: &'m Migration
) -> BoxFuture<'m, Result<Duration, MigrateError>>

fn revert<'e: 'm, 'm>(
    &'e mut self,
    migration: &'m Migration
) -> BoxFuture<'m, Result<Duration, MigrateError>>