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
|
mod common;
use anyhow::Result;
use common::test_context::TestContext;
use diesel::prelude::{Insertable, Queryable};
use diesel::{
sql_query, Connection, ExpressionMethods, QueryDsl, RunQueryDsl, Selectable, SelectableHelper,
SqliteConnection,
};
use schist_models::DatetimeUtc;
use schist_traits::Nowlike;
diesel::table! {
datetime_utc_test (id) {
id -> Integer,
datetime_utc -> Text,
}
}
#[derive(Insertable, Queryable, Selectable, Clone)]
#[diesel(table_name = datetime_utc_test)]
pub struct DatetimeUtcTest {
pub id: i32,
pub datetime_utc: DatetimeUtc,
}
fn new_test_context() -> Result<TestContext> {
let test_context = TestContext::new();
let connection = &mut SqliteConnection::establish(&test_context.db_url)?;
let query = "CREATE TABLE datetime_utc_test(id INTEGER PRIMARY KEY, datetime_utc TEXT);";
sql_query(query).execute(connection)?;
Ok(test_context)
}
fn insert_datetime_utc(
id: i32,
datetime_utc: &DatetimeUtc,
connection: &mut SqliteConnection,
) -> Result<usize> {
let model = DatetimeUtcTest {
id,
datetime_utc: datetime_utc.clone(),
};
let num_rows_inserted = diesel::insert_into(datetime_utc_test::dsl::datetime_utc_test)
.values(&[model])
.execute(connection)?;
Ok(num_rows_inserted)
}
fn get_datetime_utc(id: i32, connection: &mut SqliteConnection) -> Result<DatetimeUtcTest> {
let datetime_utc: Vec<DatetimeUtcTest> = datetime_utc_test::dsl::datetime_utc_test
.select(DatetimeUtcTest::as_select())
.filter(datetime_utc_test::id.eq(id))
.load(connection)?;
Ok(datetime_utc[0].clone())
}
#[test]
fn when_insert_datetime_utc_and_select_then_returns_original_value() -> Result<()> {
let datetime_utc = DatetimeUtc::now();
let test_context = new_test_context()?;
let connection = &mut SqliteConnection::establish(&test_context.db_url)?;
let num_rows_inserted = insert_datetime_utc(0, &datetime_utc, connection)?;
assert_eq!(num_rows_inserted, 1);
let datetime_utc_returned = get_datetime_utc(0, connection)?;
assert_eq!(datetime_utc_returned.datetime_utc, datetime_utc);
Ok(())
}
|
