pgsql

package

v0.0.0-...-d3bb3ff Latest Latest Go to latest Published: Oct 14, 2022 License: Apache-2.0 Imports: 8 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 PGStorage struct {
	// contains filtered or unexported fields
}

PGStorage implements Storage with Postgres database

func NewStorage(ctx context.Context, host string) (*PGStorage, error)

NewStorage constructs new PGStorage

func (s *PGStorage) AddTasks(ctx context.Context, tasks []*models.Task) ([]*models.Task, error)

AddTasks adds task to DB

func (s *PGStorage) ArchivateTasks(ctx context.Context, tasks []*models.Task) error

ArchivateTasks sets tasks as archived (soft delete)

func (s *PGStorage) GetClosedTasks(ctx context.Context) ([]*models.Task, error)

GetClosedTasks gets tasks by numeric term from table

func (s *PGStorage) GetTaskByID(ctx context.Context, id int64) (*models.Task, error)

GetTaskByID gets task by id

func (s *PGStorage) GetTasksByTerm(ctx context.Context, term *models.Term) ([]*models.Task, error)

GetTasksByTerm gets tasks by numeric term from table

func (s *PGStorage) GetTasksByTermAndLimits(ctx context.Context, term *models.Term, limit uint64, offset uint64) ([]*models.Task, error)

GetTasksByTermAndLimits gets tasks with limit and offset

func (s *PGStorage) UpdateTask(ctx context.Context, task *models.Task) (*models.Task, error)

UpdateTask sets editable task fields

func (s *PGStorage) UpdateTaskStatus(ctx context.Context, id int64, closedAt *time.Time, reason string) (*models.Task, error)

UpdateTaskStatus changes task 'closed_at' fiels