Documentation
¶
Overview ¶
Holds all what neccessary for odTimeTracker database - datatypes `Activity` and `Project` and functions for manipulating data.
Index ¶
- func InitStorage(path string) (db *sql.DB, err error)
- func RemoveActivity(db *sql.DB, id ...int64) (int, error)
- func RemoveProject(db *sql.DB, id ...int64) (int, error)
- func UpdateActivity(db *sql.DB, a Activity) (cnt int64, err error)
- func UpdateProject(db *sql.DB, p Project) (cnt int64, err error)
- type Activity
- func InsertActivity(db *sql.DB, pid int64, name string, desc string, tags string) (a Activity, err error)
- func SelectActivities(db *sql.DB, limit int) (activities []Activity, err error)
- func SelectActivityById(db *sql.DB, id ...int64) (a []Activity, err error)
- func SelectActivityRunning(db *sql.DB) (a Activity, err error)
- type Project
- func InsertProject(db *sql.DB, name string, desc string) (p Project, err error)
- func SelectProjectById(db *sql.DB, id ...int64) (p []Project, err error)
- func SelectProjectByName(db *sql.DB, name ...string) (projects []Project, err error)
- func SelectProjectWithTerm(db *sql.DB, term string) (projects []Project, err error)
- func SelectProjects(db *sql.DB, limit int) (p []Project, err error)
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func RemoveActivity ¶
Remove activity(-ies) with given Id(s) form the database.
func RemoveProject ¶
Remove project(s) with given Id(s) form the database.
func UpdateActivity ¶
Update activity in the database Return 1 if update was successfull otherwise 0.
Types ¶
type Activity ¶
type Activity struct {
ActivityId int64
ProjectId int64
Name string
Description string
Tags string
Started string
Stopped string
// contains filtered or unexported fields
}
Activity definition
func InsertActivity ¶
func InsertActivity(db *sql.DB, pid int64, name string, desc string, tags string) (a Activity, err error)
Insert new activity.
func SelectActivities ¶
Return activities.
func SelectActivityById ¶
Return activity(-ies) by given ID(s).
func SelectActivityRunning ¶
Return currently running activity.
func (*Activity) GetProject ¶
Get project associated with the activity.
func (*Activity) SetProject ¶
Set project associated with the activity.
func (*Activity) StartedTime ¶
Returns `Started` string as regular instance of `time.Time`.
type Project ¶
type Project struct {
ProjectId int64 // Numeric identifier of the project.
Name string // Name of the project.
Description string // Description of the project.
Created string // Datetime of creation of the project (formatted by RFC3339).
}
Project definition
func InsertProject ¶
Insert new project.
func SelectProjectById ¶
Return project(s) by given ID(s).
func SelectProjectByName ¶
Return single project by given name(s).
func SelectProjectWithTerm ¶
Return project(s) which names contains given term.
func SelectProjects ¶
Return projects.
Source Files