teal

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"`
	Author     []string `json:"author"`
	ISBN       string   `json:"isbn" db:"isbn"`
	NumOfPages int      `json:"num_of_pages" db:"numofpages"`
	Rating     int      `json:"rating" db:"rating"`
	State      string   `json:"state" db:"state,type:state"`

	Description NullString `json:"description,omitempty"`
	Notes       NullString `json:"notes,omitempty"`
	Review      NullString `json:"review,omitempty"`
	Series      NullString `json:"series,omitempty"`
	Genre       []string   `json:"genre,omitempty"`
	Tag         []string   `json:"tag,omitempty"`

	DateCompleted sql.NullTime `json:"-" db:"datecompleted"`

	DateAdded   sql.NullTime `json:"-" db:"dateadded"`
	DateUpdated sql.NullTime `json:"-" db:"dateupdated"`
}

type BookFilters struct {
	Title  string
	Author string
	Genre  string
	Tag    string
	Series string
	Filters
}

type Category struct {
	ID          int    `json:"id"`
	Name        string `json:"name"`
	Books       []Book `json:"books,omitempty"`
	DateAdded   string `json:"-"`
	DateUpdated string `json:"-"`
}

type CategoryService interface {
	GetCategories() ([]*Category, error)
	GetCategory(id int) (*Category, error)
	CreateCategory(b *Category) error
	UpdateCategory(id int) error
	DeleteCategory(id int) error
}

type Filters struct {
	AfterId      int
	PageSize     int
	Sort         string
	SortSafeList []string
}

type Genre struct {
	ID          int64  `json:"id"`
	Name        string `json:"name"`
	DateAdded   string `json:"-"`
	DateUpdated string `json:"-"`
}

type InputUser struct {
	Name     string
	Username string
	Password string
	Role     string
}

type NullString struct {
	sql.NullString
}

type Series struct {
	ID          int    `json:"id"`
	Name        string `json:"name"`
	DateAdded   string `json:"-"`
	DateUpdated string `json:"-"`
}

type Tag struct {
	ID          int64  `json:"id"`
	Name        string `json:"name"`
	DateAdded   string `json:"-"`
	DateUpdated string `json:"-"`
}

type User struct {
	ID             int64        `json:"id"`
	Name           string       `json:"name"`
	Username       string       `json:"username"`
	HashedPassword []byte       `json:"-"`
	Role           string       `json:"role" db:"type:role"`
	LastLogin      sql.NullTime `json:"-"`
	DateAdded      time.Time    `json:"-"`
}