summaryrefslogtreecommitdiff
path: root/schist_models/tests/datetime_utc.rs
diff options
context:
space:
mode:
authorJoe Carstairs <jcarstairs@scottlogic.com>2025-07-28 13:22:53 +0100
committerJoe Carstairs <jcarstairs@scottlogic.com>2025-07-28 13:30:27 +0100
commit2361adeb0ca77904138e3466d51c2f44cf6df613 (patch)
treef6e7192908f99fab62061913d8a1e9d2b918414b /schist_models/tests/datetime_utc.rs
parentc7ed1e61ce2218be0b9e60577454124c4e43a366 (diff)
Tidier folders
Diffstat (limited to 'schist_models/tests/datetime_utc.rs')
-rw-r--r--schist_models/tests/datetime_utc.rs62
1 files changed, 0 insertions, 62 deletions
diff --git a/schist_models/tests/datetime_utc.rs b/schist_models/tests/datetime_utc.rs
deleted file mode 100644
index 27182ff..0000000
--- a/schist_models/tests/datetime_utc.rs
+++ /dev/null
@@ -1,62 +0,0 @@
-mod common;
-
-use anyhow::Result;
-use common::test_context::TestContext;
-use diesel::{sql_query, Connection, ExpressionMethods, QueryDsl, RunQueryDsl, Selectable, SelectableHelper, SqliteConnection};
-use diesel::prelude::{Insertable, Queryable};
-use schist_models::datetime_utc::DatetimeUtc;
-use schist_traits::nowlike::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(())
-}