grpcexercises/consuldemo/pkg/db/user/query.sql.go

// Code generated by sqlc. DO NOT EDIT.
// versions:
//   sqlc v1.20.0
// source: query.sql

package user

import (
	"context"
	"database/sql"
)

const createUser = `-- name: CreateUser :execresult
INSERT INTO grpcstudy.user (username, mobile, email, password) VALUES (?, ?, ?, ?)
`

type CreateUserParams struct {
	Username string
	Mobile   string
	Email    string
	Password []byte
}

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (sql.Result, error) {
	return q.db.ExecContext(ctx, createUser,
		arg.Username,
		arg.Mobile,
		arg.Email,
		arg.Password,
	)
}

const getUserById = `-- name: GetUserById :one
SELECT id, username, mobile, email, created_at, modified_at, password FROM grpcstudy.user WHERE id = ? LIMIT 1
`

func (q *Queries) GetUserById(ctx context.Context, id uint32) (GrpcstudyUser, error) {
	row := q.db.QueryRowContext(ctx, getUserById, id)
	var i GrpcstudyUser
	err := row.Scan(
		&i.ID,
		&i.Username,
		&i.Mobile,
		&i.Email,
		&i.CreatedAt,
		&i.ModifiedAt,
		&i.Password,
	)
	return i, err
}

const getUserByMobile = `-- name: GetUserByMobile :one
SELECT id, username, mobile, email, created_at, modified_at, password FROM grpcstudy.user WHERE mobile = ? LIMIT 1
`

func (q *Queries) GetUserByMobile(ctx context.Context, mobile string) (GrpcstudyUser, error) {
	row := q.db.QueryRowContext(ctx, getUserByMobile, mobile)
	var i GrpcstudyUser
	err := row.Scan(
		&i.ID,
		&i.Username,
		&i.Mobile,
		&i.Email,
		&i.CreatedAt,
		&i.ModifiedAt,
		&i.Password,
	)
	return i, err
}

const getUserByUsername = `-- name: GetUserByUsername :one
SELECT id, username, mobile, email, created_at, modified_at, password FROM grpcstudy.user WHERE username = ? LIMIT 1
`

func (q *Queries) GetUserByUsername(ctx context.Context, username string) (GrpcstudyUser, error) {
	row := q.db.QueryRowContext(ctx, getUserByUsername, username)
	var i GrpcstudyUser
	err := row.Scan(
		&i.ID,
		&i.Username,
		&i.Mobile,
		&i.Email,
		&i.CreatedAt,
		&i.ModifiedAt,
		&i.Password,
	)
	return i, err
}

const listUsers = `-- name: ListUsers :many
SELECT id, username, mobile, email, created_at, modified_at, password FROM grpcstudy.user ORDER BY id DESC LIMIT ? OFFSET ?
`

type ListUsersParams struct {
	Limit  int32
	Offset int32
}

func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]GrpcstudyUser, error) {
	rows, err := q.db.QueryContext(ctx, listUsers, arg.Limit, arg.Offset)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []GrpcstudyUser
	for rows.Next() {
		var i GrpcstudyUser
		if err := rows.Scan(
			&i.ID,
			&i.Username,
			&i.Mobile,
			&i.Email,
			&i.CreatedAt,
			&i.ModifiedAt,
			&i.Password,
		); 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
}