db

Documentation

Index

• func DateFilterableView(view string) bool
• func FindDBPath() (string, error)
• func ValidView(name string) bool
• type AmbiguousTaskError
  • func (e *AmbiguousTaskError) Error() string
• type DB
  • func NewFromSQL(sqlDB *sql.DB) *DB
  • func Open(path string) (*DB, error)
  • func (d *DB) Close() error
  • func (d *DB) FindAreaUUID(ref string) (string, error)
  • func (d *DB) FindTagUUID(ref string) (string, error)
  • func (d *DB) FindTasksByTitle(substr string) ([]model.Task, error)
  • func (d *DB) GetAuthToken() (string, error)
  • func (d *DB) GetChecklistItems(taskUUID string) ([]model.ChecklistItem, error)
  • func (d *DB) GetTask(uuidOrTitle string) (*model.Task, error)
  • func (d *DB) GetTaskByUUID(uuid string) (*model.Task, error)
  • func (d *DB) ListAreas() ([]model.Area, error)
  • func (d *DB) ListProjects(areaFilter string, includeCompleted bool) ([]model.Project, error)
  • func (d *DB) ListTags() ([]model.Tag, error)
  • func (d *DB) ListTasks(view string, opts TaskFilter) ([]model.Task, error)
  • func (d *DB) SearchTasks(query string) ([]model.Task, error)
• type TaskFilter

Functions

func DateFilterableView

func DateFilterableView(view string) bool

DateFilterableView reports whether --on/--from/--to apply to the view.

func FindDBPath

func FindDBPath() (string, error)

FindDBPath locates the Things3 SQLite database.

func ValidView

func ValidView(name string) bool

Types

type AmbiguousTaskError

type AmbiguousTaskError struct {
	Query   string
	Matches []model.Task
}

func (*AmbiguousTaskError) Error

func (e *AmbiguousTaskError) Error() string

type DB

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

func NewFromSQL

func NewFromSQL(sqlDB *sql.DB) *DB

NewFromSQL wraps an existing *sql.DB. Test-only; production code uses Open.

func Open

func Open(path string) (*DB, error)

Open opens a read-only connection to the Things3 database.

func (*DB) Close

func (d *DB) Close() error

func (*DB) FindAreaUUID

func (d *DB) FindAreaUUID(ref string) (string, error)

FindAreaUUID resolves an area reference (UUID or title) to its UUID, returning "" when no row matches.

func (*DB) FindTagUUID

func (d *DB) FindTagUUID(ref string) (string, error)

FindTagUUID resolves a tag reference (UUID or title) to its UUID, returning "" when no row matches.

func (*DB) FindTasksByTitle

func (d *DB) FindTasksByTitle(substr string) ([]model.Task, error)

func (*DB) GetAuthToken

func (d *DB) GetAuthToken() (string, error)

func (*DB) GetChecklistItems

func (d *DB) GetChecklistItems(taskUUID string) ([]model.ChecklistItem, error)

func (*DB) GetTask

func (d *DB) GetTask(uuidOrTitle string) (*model.Task, error)

func (*DB) GetTaskByUUID

func (d *DB) GetTaskByUUID(uuid string) (*model.Task, error)

func (*DB) ListAreas

func (d *DB) ListAreas() ([]model.Area, error)

func (*DB) ListProjects

func (d *DB) ListProjects(areaFilter string, includeCompleted bool) ([]model.Project, error)

func (*DB) ListTags

func (d *DB) ListTags() ([]model.Tag, error)

func (*DB) ListTasks

func (d *DB) ListTasks(view string, opts TaskFilter) ([]model.Task, error)

func (*DB) SearchTasks

func (d *DB) SearchTasks(query string) ([]model.Task, error)

type TaskFilter

type TaskFilter struct {
	Project string
	Area    string
	Tag     string

	On   *model.ThingsDate
	From *model.ThingsDate
	To   *model.ThingsDate
}