summaryrefslogtreecommitdiff
path: root/backend/core/tests/models/date_time_utc.rs
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-10-30 07:27:13 +0000
committerJoe Carstairs <me@joeac.net>2024-10-30 08:50:45 +0000
commit828b9ae9f6217f7e5e97ec704134c786dd401bad (patch)
treec920b8874682e89ba05b6e1ca20275bfd5878d87 /backend/core/tests/models/date_time_utc.rs
parent6e9f0069f5d1e4cfbf7f9feb8536795a78c818f6 (diff)
Separates date_utc and datetime_utc
Diffstat (limited to 'backend/core/tests/models/date_time_utc.rs')
-rw-r--r--backend/core/tests/models/date_time_utc.rs59
1 files changed, 0 insertions, 59 deletions
diff --git a/backend/core/tests/models/date_time_utc.rs b/backend/core/tests/models/date_time_utc.rs
deleted file mode 100644
index 1f86968..0000000
--- a/backend/core/tests/models/date_time_utc.rs
+++ /dev/null
@@ -1,59 +0,0 @@
-use anyhow::Result;
-use budgeting_app_core::models::date_time_utc::DateTimeUtc;
-use diesel::{sql_query, Connection, ExpressionMethods, QueryDsl, RunQueryDsl, Selectable, SelectableHelper, SqliteConnection};
-use diesel::prelude::{Insertable, Queryable};
-
-use crate::common::test_context::TestContext;
-
-diesel::table! {
- date_time_utc_test (id) {
- id -> Integer,
- date_time_utc -> Text,
- }
-}
-
-#[derive(Insertable, Queryable, Selectable, Clone)]
-#[diesel(table_name = date_time_utc_test)]
-pub struct DateTimeUtcTest {
- pub id: i32,
- pub date_time_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 date_time_utc_test(id INTEGER PRIMARY KEY, date_time_utc TEXT);";
- sql_query(query).execute(connection)?;
- Ok(test_context)
-}
-
-fn insert_date_time_utc(id: i32, date_time_utc: &DateTimeUtc, connection: &mut SqliteConnection) -> Result<usize> {
- let model = DateTimeUtcTest {
- id,
- date_time_utc: date_time_utc.clone(),
- };
- let num_rows_inserted = diesel::insert_into(date_time_utc_test::dsl::date_time_utc_test)
- .values(&[model])
- .execute(connection)?;
- Ok(num_rows_inserted)
-}
-
-fn get_date_time_utc(id: i32, connection: &mut SqliteConnection) -> Result<DateTimeUtcTest> {
- let date_time_utc: Vec<DateTimeUtcTest> = date_time_utc_test::dsl::date_time_utc_test
- .select(DateTimeUtcTest::as_select())
- .filter(date_time_utc_test::id.eq(id))
- .load(connection)?;
- Ok(date_time_utc[0].clone())
-}
-
-#[test]
-fn when_insert_date_time_utc_and_select_then_returns_original_value() -> Result<()> {
- let date_time_utc = DateTimeUtc::now();
- let test_context = new_test_context()?;
- let connection = &mut SqliteConnection::establish(&test_context.db_url)?;
- let num_rows_inserted = insert_date_time_utc(0, &date_time_utc, connection)?;
- assert_eq!(num_rows_inserted, 1);
- let date_time_utc_returned = get_date_time_utc(0, connection)?;
- assert_eq!(date_time_utc_returned.date_time_utc.to_date_str(), date_time_utc.to_date_str());
- Ok(())
-}