From 406767e9eed613b5a1513ada772e4bfb78e46290 Mon Sep 17 00:00:00 2001 From: Joris Date: Sun, 3 Jan 2021 19:48:29 +0100 Subject: Let Sqlite provide a default created_at --- src/db/payments.rs | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'src/db/payments.rs') diff --git a/src/db/payments.rs b/src/db/payments.rs index 0197375..35e7f68 100644 --- a/src/db/payments.rs +++ b/src/db/payments.rs @@ -257,9 +257,9 @@ pub async fn create(pool: &SqlitePool, p: &payment::Create) -> Option { let res = sqlx::query( r#" INSERT INTO - payments(name, cost, user_id, category_id, date, frequency, created_at) + payments(name, cost, user_id, category_id, date, frequency) VALUES - (?, ?, ?, ?, ?, ?, datetime()) + (?, ?, ?, ?, ?, ?) "#, ) .bind(p.name.clone()) @@ -443,15 +443,14 @@ ON pub async fn create_monthly_payments(pool: &SqlitePool) -> () { let query = r#" INSERT INTO - payments(name, cost, user_id, category_id, date, frequency, created_at) + payments(name, cost, user_id, category_id, date, frequency) SELECT name, cost, user_id, category_id, date() AS date, - 'Punctual' AS frequency, - datetime() AS created_at + 'Punctual' AS frequency FROM payments WHERE -- cgit v1.2.3