db

type Category struct {
	UUID       string `db:"id"`
	ParentUUID string `db:"parent_id"`

	Name        string `db:"name"`
	Description string `db:"description"`
}

type CategoryError error

type CategoryGetter interface {
	// Get retrieves a database category by UUID.
	Get(uuid string) (*Category, error)
	// GetTree returns a (sub)tree of categories starting at a given category
	// UUID.
	// At most `levels`  category tree levels. Level 0 means only the requested
	// node, level 1 the node and its children, level 2 the node, it's children
	// and it's grandchildren, etc.
	GetTree(rootUUID string, levels uint) (*CategoryNode, error)
	// New creates a new database category from an in-memroy category.  UUID
	// must be unset. ParentUUID should either point to an existing category
	// (if the category is a chuild category) or be blank (if the category
	// should be to-level).
	New(new *Category) (*Category, error)
	// Update saves a given category. All fields can be updated apart from the
	// current UUID.
	Update(cat *Category) error
	// Delete removes a category. It must not contain any child categories or
	// issues.
	Delete(uuid string) error
}

type CategoryNode struct {
	*Category

	Children []*CategoryNode
}

type Database interface {
	Migrate() error

	// Begin returns a database Session that must be commited, but can also be rolled back
	Begin(ctx context.Context) Session
	// Do returns a database Session that will automatically commit on every object access
	Do(ctx context.Context) Session
}

type ErrorConverter struct {
	// contains filtered or unexported fields
}

type Issue struct {
	// Constant columns
	ID       int64  `db:"id"`
	AuthorID string `db:"author_id"`
	Created  int64  `db:"created"`

	// Bumped when a new update is added
	LastUpdated int64 `db:"last_updated"`

	// Denormalized data
	Title      string `db:"title"`
	AssigneeID string `db:"assignee_id"`
	Type       int64  `db:"type"`
	Priority   int64  `db:"priority"`
	Status     int64  `db:"status"`
}

type IssueError error

type IssueFilter struct {
	// The filter passes when all the set fields match an issue.
	Author   string
	Assignee string
	Status   int64
}

type IssueFilterOpts struct {
	Start int64
	Count int64
}

type IssueGetHistoryOpts struct {
	Start int64
	Count int64
}

type IssueGetter interface {
	Get(id int64) (*Issue, error)
	Filter(filter IssueFilter, order IssueOrderBy, opts *IssueFilterOpts) ([]*Issue, error)
	GetHistory(id int64, opts *IssueGetHistoryOpts) ([]*IssueUpdate, error)
	New(new *Issue) (*Issue, error)
	Update(update *IssueUpdate) error
}

type IssueOrder int

type IssueOrderBy struct {
	Ascending bool
	By        IssueOrder
}

type IssueUpdate struct {
	IssueID  int64          `db:"issue_id"`
	UpdateID int64          `db:"id"`
	Created  int64          `db:"created"`
	AuthorID string         `db:"author_id"`
	Comment  sql.NullString `db:"comment"`

	Title      sql.NullString `db:"title"`
	AssigneeID sql.NullString `db:"assignee_id"`
	Type       sql.NullInt64  `db:"type"`
	Priority   sql.NullInt64  `db:"priority"`
	Status     sql.NullInt64  `db:"status"`
}

type Session interface {
	Category() CategoryGetter
	Issue() IssueGetter
	User() UserGetter
	Commit() error
	Rollback() error
}

type User struct {
	ID          string `db:"id"`
	Username    string `db:"username"`
	Preferences []byte `db:"preferences"`

	Email       sql.NullString `db:"email"`
	DisplayName sql.NullString `db:"display_name"`
}

type UserError error

type UserGetter interface {
	New(new *User) (*User, error)
	// ResolveUsername resolves a username to its UUID.
	ResolveUsername(username string) (uuid string, err error)
	Get(uuid string) (*User, error)
}