postgres

type Book struct {
	ID          int64                     `db:"id"`
	ISBN        pgtype.Text               `db:"isbn"`
	URL         pgtype.Text               `db:"url"`
	Title       pgtype.Text               `db:"title"`
	Image       pgtype.Text               `db:"image"`
	Description pgtype.Text               `db:"description"`
	Authors     pgtype.Array[pgtype.Text] `db:"authors"`
	Publisher   pgtype.Text               `db:"publisher"`
	Properties  map[string]string         `db:"properties"`
	CreatedAt   pgtype.Timestamp          `db:"created_at"`
	UpdatedAt   pgtype.Timestamp          `db:"updated_at"`
}

type DB interface {
	Begin(ctx context.Context) (pgx.Tx, error)
	Exec(ctx context.Context, sql string, arguments ...any) (commandTag pgconn.CommandTag, err error)
	Query(ctx context.Context, sql string, args ...any) (pgx.Rows, error)
	QueryRow(ctx context.Context, sql string, args ...any) pgx.Row
}

type Fields = map[string]any

type UpsertBookParams struct {
	ISBN        string
	URL         string
	Title       string
	Image       string
	Description string
	Authors     []string
	Publisher   string
	Properties  map[string]string
}