summaryrefslogtreecommitdiff
path: root/backend/core/tests/models/date_utc.rs
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
committerJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
commit1ae19eb3315c40e3f9062592c27fa76c11cf626c (patch)
tree09d9ce380795971f4b50e1d4b0ca3c57c9e1db1a /backend/core/tests/models/date_utc.rs
parent1a494937021561595d0fb29e26fb707aef9e55de (diff)
Renames workspace folder
Diffstat (limited to 'backend/core/tests/models/date_utc.rs')
-rw-r--r--backend/core/tests/models/date_utc.rs60
1 files changed, 0 insertions, 60 deletions
diff --git a/backend/core/tests/models/date_utc.rs b/backend/core/tests/models/date_utc.rs
deleted file mode 100644
index 40f8c36..0000000
--- a/backend/core/tests/models/date_utc.rs
+++ /dev/null
@@ -1,60 +0,0 @@
-use anyhow::Result;
-use budgeting_app_core::models::date_utc::DateUtc;
-use budgeting_app_core::traits::nowlike::Nowlike;
-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_utc_test (id) {
- id -> Integer,
- date_utc -> Text,
- }
-}
-
-#[derive(Insertable, Queryable, Selectable, Clone)]
-#[diesel(table_name = date_utc_test)]
-pub struct DateUtcTest {
- pub id: i32,
- pub date_utc: DateUtc,
-}
-
-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_utc_test(id INTEGER PRIMARY KEY, date_utc TEXT);";
- sql_query(query).execute(connection)?;
- Ok(test_context)
-}
-
-fn insert_date_utc(id: i32, date_utc: &DateUtc, connection: &mut SqliteConnection) -> Result<usize> {
- let model = DateUtcTest {
- id,
- date_utc: date_utc.clone(),
- };
- let num_rows_inserted = diesel::insert_into(date_utc_test::dsl::date_utc_test)
- .values(&[model])
- .execute(connection)?;
- Ok(num_rows_inserted)
-}
-
-fn get_date_utc(id: i32, connection: &mut SqliteConnection) -> Result<DateUtcTest> {
- let date_utc: Vec<DateUtcTest> = date_utc_test::dsl::date_utc_test
- .select(DateUtcTest::as_select())
- .filter(date_utc_test::id.eq(id))
- .load(connection)?;
- Ok(date_utc[0].clone())
-}
-
-#[test]
-fn when_insert_date_utc_and_select_then_returns_original_value() -> Result<()> {
- let date_utc = DateUtc::now();
- let test_context = new_test_context()?;
- let connection = &mut SqliteConnection::establish(&test_context.db_url)?;
- let num_rows_inserted = insert_date_utc(0, &date_utc, connection)?;
- assert_eq!(num_rows_inserted, 1);
- let date_utc_returned = get_date_utc(0, connection)?;
- assert_eq!(date_utc_returned.date_utc, date_utc);
- Ok(())
-}