db

package

v0.0.0-...-24bdf07 Latest Latest Go to latest Published: Nov 17, 2021 License: MIT Imports: 12 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

This section is empty.

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

func NewDatabase(c *config.Config, logger logrus.FieldLogger) (*Database, error)

Initializes a new Database object, creates the file is does not exis and fills the schema

func (db *Database) Close()

func (db *Database) DeleteDoneTasks() error

func (db *Database) DeleteTask(id int) error

func (db *Database) GetAllTasks() ([]*models.Task, error)

Selects all the tasks from the database

func (db *Database) GetTaskByID(id int) (*models.Task, error)

func (db *Database) GetTasksWithFilter(limit, offset int, orderby, t string) ([]*models.Task, error)

func (db *Database) InsertTask(t models.NewTaskRequest) (int64, error)

Inserting a new task into the sqlite databas

func (db *Database) SearchTasks(query, orderby, t string) ([]*models.Task, error)

func (db *Database) UpdateDone(id int, done bool) error