diff options
Diffstat (limited to 'src/db/payments.rs')
| -rw-r--r-- | src/db/payments.rs | 9 |
1 files changed, 4 insertions, 5 deletions
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<i64> { 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 |