dusk

type Author struct {
	Id   int64  `json:"id"`
	Name string `json:"name"`
}

type Book struct {
	Id       int64       `json:"id" db:"id"`
	Title    string      `json:"title" db:"title"`
	Subtitle null.String `json:"subtitle,omitempty" db:"subtitle"`

	// many to many (one-way)
	Author []string `json:"author"`
	Tag    []string `json:"tag,omitempty"`

	// one to many
	Isbn10 []string `json:"isbn,omitempty"`
	Isbn13 []string `json:"isbn13,omitempty"`

	NumOfPages int        `json:"num_of_pages" db:"numOfPages"`
	Progress   int        `json:"progress" db:"progress"`
	Rating     int        `json:"rating" db:"rating"`
	Status     ReadStatus `json:"status" db:"status"`

	Publisher     null.String `json:"publisher" db:"publisher"`
	DatePublished null.Time   `json:"date_published" db:"datePublished"`

	Series      null.String `json:"series,omitempty" db:"series"`
	Description null.String `json:"description,omitempty" db:"description"`
	Notes       null.String `json:"notes,omitempty" db:"notes"`

	// files
	// one to many
	Formats []string    `json:"formats,omitempty"`
	Cover   null.String `json:"cover,omitempty" db:"cover"`

	DateStarted   null.Time `json:"date_started" db:"dateStarted"`
	DateCompleted null.Time `json:"date_completed" db:"dateCompleted"`
	DateAdded     null.Time `json:"date_added" db:"dateAdded"`
}

type Books []*Book

type ReadStatus int

type Series struct {
	Id   int64  `json:"id"`
	Name string `json:"name" db:"name"`
}

type Store interface {
	GetBook(id int64) (*Book, error)
	GetAllBooks(filters *filters.Book) (*page.Page[Book], error)
	CreateBook(b *Book) (*Book, error)
	UpdateBook(id int64, b *Book) (*Book, error)
	DeleteBook(id int64) error

	GetAuthor(id int64) (*Author, error)
	GetAuthorsFromBook(id int64) ([]Author, error)
	GetAllAuthors(filters *filters.Search) (*page.Page[Author], error)
	GetAllBooksFromAuthor(id int64, filters *filters.Book) (*page.Page[Book], error)
	CreateAuthor(a *Author) (*Author, error)
	UpdateAuthor(id int64, a *Author) (*Author, error)
	DeleteAuthor(id int64) error

	GetTag(id int64) (*Tag, error)
	GetTagsFromBook(id int64) ([]Tag, error)
	GetAllTags(filters *filters.Search) (*page.Page[Tag], error)
	GetAllBooksFromTag(id int64, filters *filters.Book) (*page.Page[Book], error)
	CreateTag(t *Tag) (*Tag, error)
	UpdateTag(id int64, t *Tag) (*Tag, error)
	DeleteTag(id int64) error
}

type Tag struct {
	Id   int64  `json:"id"`
	Name string `json:"name"`
}