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 /model/sexps.sql.go | |
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 'model/sexps.sql.go')
-rw-r--r-- | model/sexps.sql.go | 27 |
1 files changed, 14 insertions, 13 deletions
diff --git a/model/sexps.sql.go b/model/sexps.sql.go index 8a54443..33b9f57 100644 --- a/model/sexps.sql.go +++ b/model/sexps.sql.go @@ -7,36 +7,37 @@ package model import ( "context" - - "github.com/jackc/pgx/v5/pgtype" ) const getSingleExpenses = `-- name: GetSingleExpenses :many -SELECT id, description +SELECT id, description, expense, date, corr_month, category_id, user_id FROM single_expenses WHERE user_id = $1 ` -type GetSingleExpensesRow struct { - ID int64 - Description pgtype.Text -} - // GetSingleExpenses // -// SELECT id, description +// SELECT id, description, expense, date, corr_month, category_id, user_id // FROM single_expenses // WHERE user_id = $1 -func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]GetSingleExpensesRow, error) { +func (q *Queries) GetSingleExpenses(ctx context.Context, userID int32) ([]SingleExpense, error) { rows, err := q.db.Query(ctx, getSingleExpenses, userID) if err != nil { return nil, err } defer rows.Close() - var items []GetSingleExpensesRow + var items []SingleExpense for rows.Next() { - var i GetSingleExpensesRow - if err := rows.Scan(&i.ID, &i.Description); err != nil { + var i SingleExpense + if err := rows.Scan( + &i.ID, + &i.Description, + &i.Expense, + &i.Date, + &i.CorrMonth, + &i.CategoryID, + &i.UserID, + ); err != nil { return nil, err } items = append(items, i) |