diff options
author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-02-11 23:46:54 +0100 |
---|---|---|
committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-02-11 23:46:54 +0100 |
commit | c6f5e375dbd6fd17a5c162ecc3ad6b633452afef (patch) | |
tree | 3c0c26d26e3f49a4083e264861f07bca903d390c /model/users.sql.mysql.go | |
parent | 934df3f098c33bcbb1493a420833817b80518020 (diff) | |
download | gosten-c6f5e375dbd6fd17a5c162ecc3ad6b633452afef.tar.gz gosten-c6f5e375dbd6fd17a5c162ecc3ad6b633452afef.tar.bz2 gosten-c6f5e375dbd6fd17a5c162ecc3ad6b633452afef.zip |
Include generated sql files
Diffstat (limited to '')
-rw-r--r-- | model/users.sql.mysql.go | 95 |
1 files changed, 95 insertions, 0 deletions
diff --git a/model/users.sql.mysql.go b/model/users.sql.mysql.go new file mode 100644 index 0000000..b16d388 --- /dev/null +++ b/model/users.sql.mysql.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 int32) (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 +} |