diff options
Diffstat (limited to 'model/users.sql.sqlite.go')
-rw-r--r-- | model/users.sql.sqlite.go | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/model/users.sql.sqlite.go b/model/users.sql.sqlite.go new file mode 100644 index 0000000..75fdf33 --- /dev/null +++ b/model/users.sql.sqlite.go @@ -0,0 +1,95 @@ +//go:build sqlite + +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.25.0 +// source: users.sql + +package model + +import ( + "context" +) + +const getUserById = `-- name: GetUserById :one +SELECT id, name, pwd, description + FROM users + WHERE id = ? +` + +// GetUserById +// +// SELECT id, name, pwd, description +// FROM users +// WHERE id = ? +func (q *Queries) GetUserById(ctx context.Context, id int64) (User, error) { + row := q.db.QueryRowContext(ctx, getUserById, id) + var i User + err := row.Scan( + &i.ID, + &i.Name, + &i.Pwd, + &i.Description, + ) + return i, err +} + +const getUserByName = `-- name: GetUserByName :one +SELECT id, name, pwd, description + FROM users + WHERE name = ? +` + +// GetUserByName +// +// SELECT id, name, pwd, description +// FROM users +// WHERE name = ? +func (q *Queries) GetUserByName(ctx context.Context, name string) (User, error) { + row := q.db.QueryRowContext(ctx, getUserByName, name) + var i User + err := row.Scan( + &i.ID, + &i.Name, + &i.Pwd, + &i.Description, + ) + return i, err +} + +const getUsers = `-- name: GetUsers :many +SELECT id, name, pwd, description + FROM users +` + +// GetUsers +// +// SELECT id, name, pwd, description +// FROM users +func (q *Queries) GetUsers(ctx context.Context) ([]User, error) { + rows, err := q.db.QueryContext(ctx, getUsers) + if err != nil { + return nil, err + } + defer rows.Close() + var items []User + for rows.Next() { + var i User + if err := rows.Scan( + &i.ID, + &i.Name, + &i.Pwd, + &i.Description, + ); err != nil { + return nil, err + } + items = append(items, i) + } + if err := rows.Close(); err != nil { + return nil, err + } + if err := rows.Err(); err != nil { + return nil, err + } + return items, nil +} |