diff options
author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-11 22:47:16 +0200 |
---|---|---|
committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-11 22:47:39 +0200 |
commit | b46012f212a4302b4d1325d8fdf9634e7083e76a (patch) | |
tree | 095d00491c385c33674f5a0a11128a543a48c485 /model/rexps.sql.go | |
parent | e79d3d7163657f7a540530dddb319f984885e864 (diff) | |
download | gosten-b46012f212a4302b4d1325d8fdf9634e7083e76a.tar.gz gosten-b46012f212a4302b4d1325d8fdf9634e7083e76a.tar.bz2 gosten-b46012f212a4302b4d1325d8fdf9634e7083e76a.zip |
First draft of recurrent costs and categories
Diffstat (limited to 'model/rexps.sql.go')
-rw-r--r-- | model/rexps.sql.go | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/model/rexps.sql.go b/model/rexps.sql.go new file mode 100644 index 0000000..9b32c5b --- /dev/null +++ b/model/rexps.sql.go @@ -0,0 +1,59 @@ +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 +// source: rexps.sql + +package model + +import ( + "context" + + "github.com/jackc/pgx/v5/pgtype" +) + +const getRecurExpenses = `-- name: GetRecurExpenses :many +SELECT id, description, expense, duration, start, "end" + FROM recur_expenses + WHERE user_id = $1 +` + +type GetRecurExpensesRow struct { + ID int32 + Description pgtype.Text + Expense pgtype.Numeric + Duration pgtype.Interval + Start pgtype.Date + End pgtype.Date +} + +// GetRecurExpenses +// +// SELECT id, description, expense, duration, start, "end" +// FROM recur_expenses +// WHERE user_id = $1 +func (q *Queries) GetRecurExpenses(ctx context.Context, userID int32) ([]GetRecurExpensesRow, error) { + rows, err := q.db.Query(ctx, getRecurExpenses, userID) + if err != nil { + return nil, err + } + defer rows.Close() + var items []GetRecurExpensesRow + for rows.Next() { + var i GetRecurExpensesRow + if err := rows.Scan( + &i.ID, + &i.Description, + &i.Expense, + &i.Duration, + &i.Start, + &i.End, + ); err != nil { + return nil, err + } + items = append(items, i) + } + if err := rows.Err(); err != nil { + return nil, err + } + return items, nil +} |