Struct sqlx::Pool

pub struct Pool<DB>(_)
 where
    DB: Database;

A pool of database connections.

Methods

impl<DB> Pool<DB> where
    DB: Database,
    <DB as Database>::Connection: Connection,
    <<DB as Database>::Connection as Executor>::Database == DB, 

pub async fn new(url: &'_ str) -> Result<Pool<DB>, Error>

Creates a connection pool with the default configuration.

pub fn builder() -> Builder<DB>

Returns a [Builder] to configure a new connection pool.

pub async fn acquire(&'_ self) -> Result<impl DerefMut, Error>

Retrieves a connection from the pool.

Waits for at most the configured connection timeout before returning an error.

pub fn try_acquire(&self) -> Option<impl DerefMut>

Attempts to retrieve a connection from the pool if there is one available.

Returns None immediately if there are no idle connections available in the pool.

pub async fn close(&'_ self)

Ends the use of a connection pool. Prevents any new connections and will close all active connections when they are returned to the pool.

Does not resolve until all connections are closed.

pub fn size(&self) -> u32

Returns the number of connections currently being managed by the pool.

pub fn idle(&self) -> usize

Returns the number of idle connections.

pub fn max_size(&self) -> u32

Returns the configured maximum pool size.

pub fn connect_timeout(&self) -> Duration

Returns the maximum time spent acquiring a new connection before an error is returned.

pub fn min_size(&self) -> u32

Returns the configured minimum idle connection count.

pub fn max_lifetime(&self) -> Option<Duration>

Returns the configured maximum connection lifetime.

pub fn idle_timeout(&self) -> Option<Duration>

Returns the configured idle connection timeout.

Trait Implementations

impl<DB> Clone for Pool<DB> where
    DB: Database, 

Returns a new Pool tied to the same shared connection pool.

fn clone(&self) -> Pool<DB>

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl<DB> Debug for Pool<DB> where
    DB: Database, 

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

Formats the value using the given formatter.

impl<DB> Executor for Pool<DB> where
    DB: Database, 

type Database = DB

fn send<'e, 'q>(
    &'e mut self,
    commands: &'q str
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + 'e + Send>> where
    'q: 'e, 

Send a raw SQL command to the database.

fn execute<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <DB as Database>::Arguments
) -> Pin<Box<dyn Future<Output = Result<u64, Error>> + 'e + Send>> where
    'q: 'e, 

Execute the query, returning the number of rows affected.

fn fetch<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <DB as Database>::Arguments
) -> Pin<Box<dyn Stream<Item = Result<<DB as Database>::Row, Error>> + 'e + Send>> where
    'q: 'e, 

Executes the query and returns a [Stream] of [Row].

fn fetch_optional<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <DB as Database>::Arguments
) -> Pin<Box<dyn Future<Output = Result<Option<<DB as Database>::Row>, Error>> + 'e + Send>> where
    'q: 'e, 

Executes the query and returns up to resulting record.

fn describe<'e, 'q>(
    &'e mut self,
    query: &'q str
) -> Pin<Box<dyn Future<Output = Result<Describe<<Pool<DB> as Executor>::Database>, Error>> + 'e + Send>> where
    'q: 'e, 

Analyze the SQL query and report the inferred bind parameter types and returned columns.

fn fetch_one<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <Self::Database as Database>::Arguments
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::Row, Error>> + 'e + Send>> where
    'q: 'e, 

Execute the query and return at most one resulting record.

impl<'_, DB> Executor for &'_ Pool<DB> where
    DB: Database, 

type Database = DB

fn send<'e, 'q>(
    &'e mut self,
    commands: &'q str
) -> Pin<Box<dyn Future<Output = Result<(), Error>> + 'e + Send>> where
    'q: 'e, 

Send a raw SQL command to the database.

fn execute<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <DB as Database>::Arguments
) -> Pin<Box<dyn Future<Output = Result<u64, Error>> + 'e + Send>> where
    'q: 'e, 

Execute the query, returning the number of rows affected.

fn fetch<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <DB as Database>::Arguments
) -> Pin<Box<dyn Stream<Item = Result<<DB as Database>::Row, Error>> + 'e + Send>> where
    'q: 'e, 

Executes the query and returns a [Stream] of [Row].

fn fetch_optional<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <DB as Database>::Arguments
) -> Pin<Box<dyn Future<Output = Result<Option<<DB as Database>::Row>, Error>> + 'e + Send>> where
    'q: 'e, 

Executes the query and returns up to resulting record.

fn describe<'e, 'q>(
    &'e mut self,
    query: &'q str
) -> Pin<Box<dyn Future<Output = Result<Describe<<&'_ Pool<DB> as Executor>::Database>, Error>> + 'e + Send>> where
    'q: 'e, 

Analyze the SQL query and report the inferred bind parameter types and returned columns.

fn fetch_one<'e, 'q>(
    &'e mut self,
    query: &'q str,
    args: <Self::Database as Database>::Arguments
) -> Pin<Box<dyn Future<Output = Result<<Self::Database as Database>::Row, Error>> + 'e + Send>> where
    'q: 'e, 

Execute the query and return at most one resulting record.