-
Notifications
You must be signed in to change notification settings - Fork 19
/
pool.rs
37 lines (30 loc) · 995 Bytes
/
pool.rs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
//! Connection manager implementation for MySQL connections.
//!
//! See [`MySqlConnectionManager`].
use mysql::{error::Error, prelude::*, Conn, Opts, OptsBuilder};
/// An [`r2d2`] connection manager for [`mysql`] connections.
#[derive(Clone, Debug)]
pub struct MySqlConnectionManager {
params: Opts,
}
impl MySqlConnectionManager {
/// Constructs a new MySQL connection manager from `params`.
pub fn new(params: OptsBuilder) -> MySqlConnectionManager {
MySqlConnectionManager {
params: Opts::from(params),
}
}
}
impl r2d2::ManageConnection for MySqlConnectionManager {
type Connection = Conn;
type Error = Error;
fn connect(&self) -> Result<Conn, Error> {
Conn::new(self.params.clone())
}
fn is_valid(&self, conn: &mut Conn) -> Result<(), Error> {
conn.query("SELECT version()").map(|_: Vec<String>| ())
}
fn has_broken(&self, conn: &mut Conn) -> bool {
self.is_valid(conn).is_err()
}
}