version: "2"
sql:
 - engine: "postgresql"
 queries: "store/sql/queries.sql"
 schema: "store/sql/schemas.sql"
 gen:
 go:
 package: "store"
 out: "store"
 sql_package: "pgx/v5"
 emit_json_tags: true
 json_tags_case_style: "camel"
 emit_interface: true
 emit_pointers_for_null_types: true

CREATE TABLE IF NOT EXISTS users (
		id SERIAL PRIMARY KEY,
		first_name TEXT NOT NULL,
		last_name TEXT NOT NULL,
		user_name TEXT NOT NULL,
		encrypted_password TEXT NOT NULL,
		created_at TIMESTAMP NOT NULL DEFAULT NOW()
	);

type User struct {
	ID int32 `json:"id"`
	FirstName string `json:"firstName"`
	LastName string `json:"lastName"`
	UserName string `json:"userName"`
	EncryptedPassword string `json:"encryptedPassword"`
	CreatedAt pgtype.Timestamp `json:"createdAt"`
}

-- name: AddUser :one
INSERT INTO users
(first_name, last_name, user_name, encrypted_password, created_at)
VALUES ($1, $2, $3, $4, $5)
RETURNING *;

const addUser = `-- name: AddUser :one
INSERT INTO users
(first_name, last_name, user_name, encrypted_password, created_at)
VALUES (1,ドル 2,ドル 3,ドル 4,ドル 5ドル)
RETURNING id, first_name, last_name, user_name, encrypted_password, created_at
`
type AddUserParams struct {
	FirstName string `json:"firstName"`
	LastName string `json:"lastName"`
	UserName string `json:"userName"`
	EncryptedPassword string `json:"encryptedPassword"`
	CreatedAt pgtype.Timestamp `json:"createdAt"`
}
func (q *Queries) AddUser(ctx context.Context, arg AddUserParams) (User, error) {
	row := q.db.QueryRow(ctx, addUser,
		arg.FirstName,
		arg.LastName,
		arg.UserName,
		arg.EncryptedPassword,
		arg.CreatedAt,
	)
	var i User
	err := row.Scan(
		&i.ID,
		&i.FirstName,
		&i.LastName,
		&i.UserName,
		&i.EncryptedPassword,
		&i.CreatedAt,
	)
	return i, err
}

func (c *UserController) Add(w http.ResponseWriter, r *http.Request) error {
	utils.LogRequest(r)
	addUserReq := &models.AddUserRequest{}
	if err := utils.DecodeAndWrite(r, addUserReq); err != nil {
		return fmt.Errorf("%w", err)
	}
	newUser, _ := models.NewUser(
		addUserReq.FirstName,
		addUserReq.LastName,
		addUserReq.UserName,
		addUserReq.Password,
	)
	addedUser, err := c.store.AddUser(r.Context(), *newUser)
	fmt.Printf("%+v", newUser)
	if err != nil {
		utils.WriteJSON(w, http.StatusInternalServerError, err) /* go always errors here because of course, `created_at` is invalid */
	}
	return utils.WriteJSON(w, http.StatusOK, addedUser)
}