db

package

v0.0.0-...-bd67ee7 Latest Latest Go to latest Published: Dec 22, 2023 License: GPL-3.0 Imports: 10 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.

View Source

var ConnectionFactoryMap = map[string]DbHandleFactory{
	"sqlite3": &SqliteHandler{},
}

func Close(db DbHandle)

func FindCompanyById(handle DbHandle, companyId int) (*model.Company, error)

func FindCompanyByName(handle DbHandle, companyName string) ([]model.Company, error)

func FindContextEligibleTrackerTypes(handle DbHandle) ([]model.TrackerType, error)

func FindTitleById(handle DbHandle, titleId int) (*model.Title, error)

func FindTitleByName(handle DbHandle, title string, companyId int) ([]model.Title, error)

func FindTrackerTypes(handle DbHandle) ([]model.TrackerType, error)

func InitializeDb(handle DbHandle)

func InsertActivityEvent(handle DbHandle, action model.Action, trackerTypeId int, title string) (int, error)

func NamedQuery[T any](
	handle DbHandle,
	dot *dotsql.DotSql,
	binder func(*T) []any,
	query string,
	args ...any) (error, []T)

func SeedDb(handle DbHandle)

type DbHandle interface {
	Db() *sql.DB
	Version() string
	Create()
}

func Run(config config.Config) DbHandle

type DbHandleFactory interface {
	Connect(config.Config) DbHandle
}

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

Extension of DbHandler struct

func (f SqliteDbHandle) Create()

func (f SqliteDbHandle) Db() *sql.DB

func (f SqliteDbHandle) DbPath() string

func (f SqliteDbHandle) Version() string

type SqliteHandler struct{}

func (f SqliteHandler) Connect(config config.Config) DbHandle