db

package

v0.0.0-...-2f40297 Latest Latest Go to latest Published: Jul 9, 2025 License: MIT Imports: 9 Imported by: 0

Details

This section is empty.

This section is empty.

func GetStoragePath() (string, error)

GetStoragePath returns the calculated storage path for the database file. Exported

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

TaskDB holds the database connection. Exported type.

func OpenDB() (*TaskDB, error)

OpenDB establishes a connection and ensures the table exists. Exported

func (tdb *TaskDB) Close() error

Close closes the database connection. Exported

func (tdb *TaskDB) Delete(id uint) error

Delete removes a task by ID.

func (tdb *TaskDB) GetTask(id uint) (task.Task, error)

GetTask retrieves a single task by ID.

func (tdb *TaskDB) GetTasks() ([]task.Task, error)

GetTasks retrieves all tasks.

func (tdb *TaskDB) GetTasksByStatus(status string) ([]task.Task, error)

GetTasksByStatus retrieves tasks filtered by status.

func (tdb *TaskDB) Insert(name, project string) (task.Task, error)

Insert adds a new task.

func (tdb *TaskDB) Update(id uint, name *string, project *string, status *string) (task.Task, error)

Update modifies an existing task.