diff options
| author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-17 17:40:49 +0200 |
|---|---|---|
| committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-17 17:40:49 +0200 |
| commit | 650053446d18424500ae6330b5ad0da81fa86373 (patch) | |
| tree | 248fc9099a3acb7308621af6fba90dea1d99b852 /sql | |
| parent | e6e3f258c519fdef01d1654a50b15335b57c4153 (diff) | |
| download | gosten-650053446d18424500ae6330b5ad0da81fa86373.tar.gz gosten-650053446d18424500ae6330b5ad0da81fa86373.tar.bz2 gosten-650053446d18424500ae6330b5ad0da81fa86373.zip | |
SQL: Fetch * instead of specific columns for simplicity
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/categories.sql | 2 | ||||
| -rw-r--r-- | sql/rexps.sql | 2 | ||||
| -rw-r--r-- | sql/sexps.sql | 2 |
3 files changed, 3 insertions, 3 deletions
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 |