database

package

v0.0.0-...-f04b571 Latest Latest Go to latest Published: May 23, 2023 License: MIT Imports: 12 Imported by: 0

Details

This section is empty.

View Source

var (
	ErrFileAlreadyExists = errors.New("file already exists in storage")
	ErrFilesNotFound     = errors.New("couldn't find files")
)

View Source

var ErrCouldNotDeleteFile = errors.New("could not delete file")

func InsertFile(ctx context.Context, tx *sqlx.Tx, path string) error

func RenameLabel(ctx context.Context, tx *sqlx.Tx, oldName string, newName string) error

func UpsertLabel(ctx context.Context, tx *sqlx.Tx, name string, color string) error

func WithDatabase(ctx context.Context, db *DB) context.Context

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

func FromContext(ctx context.Context) (*DB, error)

func New(ctx context.Context) (*DB, error)

func (m *DB) AddFilesAndLinks(ctx context.Context, filepaths []string, labelNames []string) error

func (m *DB) AddLabel(ctx context.Context, name string, color string) (*Label, error)

func (m *DB) Close() error

func (m *DB) DeleteFiles(ctx context.Context, paths []string) error

func (m *DB) DeleteLabel(ctx context.Context, name string) error

func (m *DB) GetAllLabels() ([]Label, error)

func (m *DB) GetFileLabels(path string) ([]Label, error)

func (m *DB) GetFiles(keywords []string) ([]File, error)

func (m *DB) GetFilesByLabels(labels []string) ([]File, error)

func (m *DB) GetFilesFiltered(pattern string, pathPrefix string) ([]File, error)

func (m *DB) GetFilesFilteredWithLabels(labels []string, pattern string, pathPrefix string) ([]File, error)

func (m *DB) GetSimilarLabel(name string) *Label

func (m *DB) LabelExists(name string) bool

func (m *DB) UpdateLabel(ctx context.Context, name string, newName string, newColor string) error

type File struct {
	Id      int64  `db:"id"`
	Path    string `db:"path"`
	Deleted bool
}

type Label struct {
	Id    int64  `db:"id"`
	Name  string `db:"name"`
	Color string `db:"color"`
}

Path	Synopsis
schema