diff options
Diffstat (limited to '')
| -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) |