Struct sqlx::AnyConnection

pub struct AnyConnection(_);

A connection to any SQLx database.

The database driver used is determined by the scheme of the connection url.

postgres://postgres@localhost/test
sqlite://a.sqlite

Implementations

impl AnyConnection

pub fn kind(&self) -> AnyKind

Trait Implementations

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

type Database = Any

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

fn acquire(
    self
) -> Pin<Box<dyn Future<Output = Result<<&'c mut AnyConnection as Acquire<'c>>::Connection, Error>> + Send + 'c, Global>>

fn begin(
    self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'c, Any>, Error>> + Send + 'c, Global>>

impl Connection for AnyConnection

type Database = Any

type Options = AnyConnectOptions

fn close(
    self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send + 'static, Global>>

Explicitly close this database connection.

fn ping(
    &mut self
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + Send, Global>>

Checks if a connection to the database is still valid.

fn begin(
    &mut self
) -> Pin<Box<dyn Future<Output = Result<Transaction<'_, <AnyConnection as Connection>::Database>, Error>> + Send, Global>> where
    AnyConnection: Sized, 

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

fn cached_statements_size(&self) -> usize

The number of statements currently cached in the connection.

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.

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.

fn connect(
    url: &str
) -> Pin<Box<dyn Future<Output = Result<Self, Error>> + Send + 'static, Global>>

Establish a new database connection.

fn connect_with(
    options: &Self::Options
) -> Pin<Box<dyn Future<Output = Result<Self, Error>> + Send, Global>>

Establish a new database connection with the provided options.

impl Debug for AnyConnection

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

Formats the value using the given formatter.

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

type Database = Any

fn fetch_many<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Stream<Item = Result<Either<AnyQueryResult, AnyRow>, Error>> + Send + 'e, Global>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, <&'c mut AnyConnection as Executor<'c>>::Database>, 

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

fn fetch_optional<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Future<Output = Result<Option<AnyRow>, Error>> + Send + 'e, Global>> where
    'q: 'e,
    'c: 'e,
    E: 'q + Execute<'q, <&'c mut AnyConnection as Executor<'c>>::Database>, 

Execute the query and returns at most one row.

fn prepare_with<'e, 'q>(
    self,
    sql: &'q str,
    _parameters: &[AnyTypeInfo]
) -> Pin<Box<dyn Future<Output = Result<AnyStatement<'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.

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.

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.

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.

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.

fn fetch_one<'e, 'q, E>(
    self,
    query: E
) -> Pin<Box<dyn Future<Output = 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 returns exactly one row.

fn prepare<'e, 'q>(
    self,
    query: &'q str
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as HasStatement<'q>>::Statement, Error>> + Send + 'e, Global>> where
    'q: 'e,
    'c: 'e, 

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

impl From<MssqlConnection> for AnyConnection

fn from(conn: MssqlConnection) -> AnyConnection

Converts to this type from the input type.

impl From<MySqlConnection> for AnyConnection

fn from(conn: MySqlConnection) -> AnyConnection

Converts to this type from the input type.

impl From<PgConnection> for AnyConnection

fn from(conn: PgConnection) -> AnyConnection

Converts to this type from the input type.

impl From<SqliteConnection> for AnyConnection

fn from(conn: SqliteConnection) -> AnyConnection

Converts to this type from the input type.

impl Migrate for AnyConnection

fn ensure_migrations_table(
    &mut self
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send, Global>>

fn version(
    &mut self
) -> Pin<Box<dyn Future<Output = Result<Option<(i64, bool)>, MigrateError>> + Send, Global>>

👎 Deprecated

fn dirty_version(
    &mut self
) -> Pin<Box<dyn Future<Output = Result<Option<i64>, MigrateError>> + Send, Global>>

fn validate<'e, 'm>(
    &'e mut self,
    migration: &'m Migration
) -> Pin<Box<dyn Future<Output = Result<(), MigrateError>> + Send + 'm, Global>> where
    'e: 'm, 

👎 Deprecated

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

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,