Struct sqlx::MySqlConnection
source · [−]pub struct MySqlConnection { /* private fields */ }
mysql
only.Expand description
A connection to a MySQL database.
Trait Implementations
sourceimpl<'c> Acquire<'c> for &'c mut MySqlConnection
impl<'c> Acquire<'c> for &'c mut MySqlConnection
type Database = MySql
type Connection = &'c mut <MySql as Database>::Connection
fn acquire(
self
) -> Pin<Box<dyn Future<Output = Result<<&'c mut MySqlConnection as Acquire<'c>>::Connection, Error>> + Send + 'c, Global>>
fn begin(
self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'c, MySql>, Error>> + Send + 'c, Global>>
sourceimpl Connection for MySqlConnection
impl Connection for MySqlConnection
type Database = MySql
type Options = MySqlConnectOptions
sourcefn close(
self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send + 'static, Global>>
fn close(
self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send + 'static, Global>>
Explicitly close this database connection. Read more
sourcefn ping(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send, Global>>
fn ping(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send, Global>>
Checks if a connection to the database is still valid.
sourcefn cached_statements_size(&self) -> usize
fn cached_statements_size(&self) -> usize
The number of statements currently cached in the connection.
sourcefn clear_cached_statements(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send, Global>>
fn clear_cached_statements(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send, Global>>
Removes all statements from the cache, closing them on the server if needed. Read more
sourcefn begin(
&mut self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'_, <MySqlConnection as Connection>::Database>, Error>> + Send, Global>> where
MySqlConnection: Sized,
fn begin(
&mut self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'_, <MySqlConnection as Connection>::Database>, Error>> + Send, Global>> where
MySqlConnection: Sized,
Begin a new transaction or establish a savepoint within the active transaction. Read more
sourcefn transaction<'a, F, R, E>(
&'a mut self,
callback: F
) -> Pin<Box<dyn Future<Output = Result<R, E>> + Send + 'a, Global>> where
F: 'a + for<'c> FnOnce(&'c mut Transaction<'_, Self::Database>) -> Pin<Box<dyn Future<Output = Result<R, E>> + Send + 'c, Global>> + Send + Sync,
R: Send,
E: From<Error> + Send,
fn transaction<'a, F, R, E>(
&'a mut self,
callback: F
) -> Pin<Box<dyn Future<Output = Result<R, E>> + Send + 'a, Global>> where
F: 'a + for<'c> FnOnce(&'c mut Transaction<'_, Self::Database>) -> Pin<Box<dyn Future<Output = Result<R, E>> + Send + 'c, Global>> + Send + Sync,
R: Send,
E: From<Error> + Send,
Execute the function inside a transaction. Read more
sourceimpl Debug for MySqlConnection
impl Debug for MySqlConnection
sourceimpl<'c> Executor<'c> for &'c mut MySqlConnection
impl<'c> Executor<'c> for &'c mut MySqlConnection
type Database = MySql
sourcefn fetch_many<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Stream<Item = Result<Either<MySqlQueryResult, MySqlRow>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, <&'c mut MySqlConnection as Executor<'c>>::Database>,
fn fetch_many<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Stream<Item = Result<Either<MySqlQueryResult, MySqlRow>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, <&'c mut MySqlConnection as Executor<'c>>::Database>,
Execute multiple queries and return the generated results as a stream from each query, in a stream. Read more
sourcefn fetch_optional<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Future<Output = Result<Option<MySqlRow>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, <&'c mut MySqlConnection as Executor<'c>>::Database>,
fn fetch_optional<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Future<Output = Result<Option<MySqlRow>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, <&'c mut MySqlConnection as Executor<'c>>::Database>,
Execute the query and returns at most one row.
sourcefn prepare_with<'e, 'q>(
self,
sql: &'q str,
_parameters: &'e [MySqlTypeInfo]
) -> Pin<Box<dyn Future<Output = Result<MySqlStatement<'q>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
fn prepare_with<'e, 'q>(
self,
sql: &'q str,
_parameters: &'e [MySqlTypeInfo]
) -> Pin<Box<dyn Future<Output = Result<MySqlStatement<'q>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
Prepare the SQL query, with parameter type information, to inspect the type information about its parameters and results. Read more
sourcefn execute<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::QueryResult, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
fn execute<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::QueryResult, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
Execute the query and return the total number of rows affected.
sourcefn execute_many<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::QueryResult, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
fn execute_many<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::QueryResult, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
Execute multiple queries and return the rows affected from each query, in a stream.
sourcefn fetch<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::Row, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
fn fetch<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Stream<Item = Result<<Self::Database as Database>::Row, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
Execute the query and return the generated results as a stream.
sourcefn fetch_all<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Future<Output = Result<Vec<<Self::Database as Database>::Row, Global>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
fn fetch_all<'e, 'q, E>(
self,
query: E
) -> Pin<Box<dyn Future<Output = Result<Vec<<Self::Database as Database>::Row, Global>, Error>> + Send + 'e, Global>> where
'q: 'e,
'c: 'e,
E: 'q + Execute<'q, Self::Database>,
Execute the query and return all the generated results, collected into a Vec
.
sourceimpl From<MySqlConnection> for AnyConnection
impl From<MySqlConnection> for AnyConnection
sourcefn from(conn: MySqlConnection) -> AnyConnection
fn from(conn: MySqlConnection) -> AnyConnection
Converts to this type from the input type.
sourceimpl Migrate for MySqlConnection
impl Migrate for MySqlConnection
fn ensure_migrations_table(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send, Global>>
sourcefn version(
&mut self
) -> Pin<Box<dyn Future<Output = Result<Option<(i64, bool)>, MigrateError>> + Send, Global>>
fn version(
&mut self
) -> Pin<Box<dyn Future<Output = Result<Option<(i64, bool)>, MigrateError>> + Send, Global>>
fn dirty_version(
&mut self
) -> Pin<Box<dyn Future<Output = Result<Option<i64>, MigrateError>> + Send, Global>>
fn list_applied_migrations(
&mut self
) -> Pin<Box<dyn Future<Output = Result<Vec<AppliedMigration, Global>, MigrateError>> + Send, Global>>
fn lock(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send, Global>>
fn unlock(
&mut self
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send, Global>>
sourcefn validate<'e, 'm>(
&'e mut self,
migration: &'m Migration
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send + 'm, Global>> where
'e: 'm,
fn validate<'e, 'm>(
&'e mut self,
migration: &'m Migration
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send + 'm, Global>> where
'e: 'm,
fn apply<'e, 'm>(
&'e mut self,
migration: &'m Migration
) -> Pin<Box<dyn Future<Output = Result<Duration, MigrateError>> + Send + 'm, Global>> where
'e: 'm,
fn revert<'e, 'm>(
&'e mut self,
migration: &'m Migration
) -> Pin<Box<dyn Future<Output = Result<Duration, MigrateError>> + Send + 'm, Global>> where
'e: 'm,
Auto Trait Implementations
impl RefUnwindSafe for MySqlConnection
impl Send for MySqlConnection
impl Sync for MySqlConnection
impl Unpin for MySqlConnection
impl UnwindSafe for MySqlConnection
Blanket Implementations
sourceimpl<T> BorrowMut<T> for T where
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
const: unstable · sourcefn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more