password_list_detail_repository.go

package repository

import (
	"context"
	"github.com/aivyss/password-manager/pwmErr"
	"github.com/jmoiron/sqlx"
)

type PasswordListDetailRepository interface {
	Insert(ctx context.Context, passwordListKey int, detail string) error
}

func (r *passwordListDetailRepository) Insert(ctx context.Context, passwordListKey int, detail string) error {
	if _, err := GetStatement(ctx, r.insertDetailByPasswordListKey).ExecContext(ctx, map[string]any{
		"passwordListKey": passwordListKey,
		"description":     detail,
	}); err != nil {
		return pwmErr.InsertDB
	}

	return nil
}

type passwordListDetailRepository struct {
	db                            *sqlx.DB
	insertDetailByPasswordListKey *sqlx.NamedStmt
}

func NewPasswordListDetailRepository(db *sqlx.DB) (PasswordListDetailRepository, error) {
	insertDetailByPasswordListKey, err := db.PrepareNamed(InsertDetailByPasswordListKey)
	if err != nil {
		return nil, err
	}
	return &passwordListDetailRepository{
		db:                            db,
		insertDetailByPasswordListKey: insertDetailByPasswordListKey,
	}, nil
}