database

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

type Category struct {
	Id          int64
	Parent      sql.NullInt64
	Owner       sql.NullInt64
	Name        string
	Description string
	Active      bool
}

type Database interface {
	GetOperations() Operations
	Close() error
}

type Entry struct {
	Id          int64
	UserId      int64
	VentureId   int64
	CategoryId  int64
	StartTime   time.Time
	Duration    time.Duration
	Chargeable  sql.NullBool
	Description sql.NullString
}

type Feature struct {
	Id   int64
	Name string
}

type FeatureRole struct {
	Id        int64
	FeatureId int64
	RoleId    int64
}

type Operations interface {
	Begin() error
	Commit() error
	Rollback() error

	CreateUser(*User) error
	UpdateUser(*User) error

	GetUsers(func(*User) bool) ([]*User, error)
	GetUserById(int64) (*User, error)
	GetUserByInitals(string) (*User, error)

	CreateRole(*Role) error
	GetRoleById(int64) (*Role, error)
	UpdateRole(*Role) error
	GetRoles(func(*Role) bool) ([]*Role, error)

	CreateVenture(*Venture) error
	GetVentureById(int64) (*Venture, error)
	UpdateVenture(*Venture) error
	GetVentures(func(*Venture) bool) ([]*Venture, error)

	AddUserRoleToVenture(*UserRole, sql.NullInt64) error
	RemoveUserRoleFromVenture(int64) error
	GetVentureUserRoles(func(*UserRole) bool, sql.NullInt64) ([]*UserRole, error)

	CreateCategory(*Category) error
	UpdateCategory(*Category) error
	GetCategoryById(id int64) (*Category, error)
	GetCategories(func(*Category) bool) ([]*Category, error)

	CreateEntry(*Entry) error
	UpdateEntry(*Entry) error
	DeleteEntry(int64) error

	GetEntryById(int64) (*Entry, error)
	GetEntriesByUserId(int64) ([]*Entry, error)
	GetEntriesByVentureId(int64) ([]*Entry, error)

	CreateFeature(*Feature) error
	UpdateFeature(*Feature) error
	DeleteFeature(int64) error
	GetFeatures(func(*Feature) bool) ([]*Feature, error)
	GetFeatureById(int64) (*Feature, error)
	GetFeatureByName(string) (*Feature, error)

	CreateFeatureRole(*FeatureRole) error
	UpdateFeatureRole(*FeatureRole) error
	DeleteFeatureRole(int64) error
	GetFeatureRoles(func(*FeatureRole) bool) ([]*FeatureRole, error)
	GetFeatureRolesByRole(func(*FeatureRole) bool, int64) ([]*FeatureRole, error)
	GetFeatureRoleById(int64) (*FeatureRole, error)
}

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

type Role struct {
	Id          int64
	Parent      sql.NullInt64
	Name        string
	Description string
	Active      bool
}

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

type User struct {
	Id       int64
	Forename string
	Surname  string
	Initials string
	Active   bool
	Admin    bool
	Secret   []byte
}

type UserRole struct {
	Id     int64
	UserId int64
	RoleId int64
}

type Venture struct {
	Id          int64
	Name        string
	Description string
	Active      bool
}