From 650053446d18424500ae6330b5ad0da81fa86373 Mon Sep 17 00:00:00 2001 From: René 'Necoro' Neumann Date: Thu, 17 Oct 2024 17:40:49 +0200 Subject: SQL: Fetch * instead of specific columns for simplicity --- sql/categories.sql | 2 +- sql/rexps.sql | 2 +- sql/sexps.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'sql') diff --git a/sql/categories.sql b/sql/categories.sql index e7d9579..2694adc 100644 --- a/sql/categories.sql +++ b/sql/categories.sql @@ -1,5 +1,5 @@ -- name: GetCategoriesOrdered :many -SELECT id, name +SELECT * FROM categories WHERE user_id = $1 ORDER BY name ASC; \ No newline at end of file diff --git a/sql/rexps.sql b/sql/rexps.sql index 87dc23f..e76c809 100644 --- a/sql/rexps.sql +++ b/sql/rexps.sql @@ -1,4 +1,4 @@ -- name: GetRecurExpenses :many -SELECT id, description, expense, duration, start, "end" +SELECT * FROM recur_expenses WHERE user_id = $1; \ No newline at end of file diff --git a/sql/sexps.sql b/sql/sexps.sql index 8279326..884e1f3 100644 --- a/sql/sexps.sql +++ b/sql/sexps.sql @@ -1,4 +1,4 @@ -- name: GetSingleExpenses :many -SELECT id, description +SELECT * FROM single_expenses WHERE user_id = $1; \ No newline at end of file -- cgit v1.2.3-70-g09d2