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
|
#[macro_use]
extern crate error_chain;
extern crate mysql;
mod errors {
use mysql;
error_chain! {
foreign_links {
MySql(mysql::error::Error);
}
}
}
use errors::*;
struct Purchaser<'a> {
name: &'a str,
email: &'a str,
secret: Option<&'a str>,
}
impl<'a> Purchaser<'a> {
fn new(name: &'a str, email: &'a str) -> Self {
Purchaser {
name: name,
email: email,
secret: None,
}
}
fn with_secret(mut self, secret: &'a str) -> Self {
self.secret = Some(secret);
self
}
fn insert(&self, cx: &mut mysql::Conn) -> Result<()> {
let mut tx = cx.start_transaction(
false, // consistent_snapshot
None, // isolation_level
None, // readonly
)?;
tx.prep_exec("
INSERT INTO purchasers
(name, email, secret)
VALUES
(?, ?, ?)",
(self.name, self.email, self.secret),
)?;
Ok(())
}
}
|
