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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
extern crate r2d2;
extern crate rusqlite;
use std::error::{self, Error as StdError};
use std::fmt;
use std::convert;
use rusqlite::{Connection, Error as RusqliteError, OpenFlags};
#[derive(Debug)]
pub enum Error {
Connect(RusqliteError),
}
impl convert::From<RusqliteError> for Error {
fn from(e: RusqliteError) -> Error {
Error::Connect(e)
}
}
impl fmt::Display for Error {
fn fmt(&self, fmt: &mut fmt::Formatter) -> fmt::Result {
write!(fmt, "{}: {}", self.description(), self.cause().unwrap())
}
}
impl error::Error for Error {
fn description(&self) -> &str {
match *self {
Error::Connect(_) => "Error opening a connection",
}
}
fn cause(&self) -> Option<&error::Error> {
match *self {
Error::Connect(ref err) => Some(err as &error::Error),
}
}
}
enum ConnectionConfig {
File(String, OpenFlags),
}
pub struct SqliteConnectionManager {
config: ConnectionConfig,
}
impl SqliteConnectionManager {
pub fn new(database: &str) -> Self {
Self::new_with_flags(database, OpenFlags::default())
}
pub fn new_with_flags(database: &str, flags: OpenFlags) -> Self {
SqliteConnectionManager { config: ConnectionConfig::File(database.to_string(), flags) }
}
}
impl r2d2::ManageConnection for SqliteConnectionManager {
type Connection = Connection;
type Error = Error;
fn connect(&self) -> Result<Connection, Error> {
match self.config {
ConnectionConfig::File(ref path, flags) => Connection::open_with_flags(path, flags),
}
.map_err(Into::into)
}
fn is_valid(&self, conn: &mut Connection) -> Result<(), Error> {
conn.execute_batch("").map_err(Into::into)
}
fn has_broken(&self, _: &mut Connection) -> bool {
false
}
}