diff options
Diffstat (limited to 'internal/queries/queries.sql.go')
| -rw-r--r-- | internal/queries/queries.sql.go | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/internal/queries/queries.sql.go b/internal/queries/queries.sql.go index f5cf70f..1084cea 100644 --- a/internal/queries/queries.sql.go +++ b/internal/queries/queries.sql.go @@ -656,12 +656,12 @@ func (q *Queries) GetProjectByNameAndClient(ctx context.Context, arg GetProjectB const getRecentTimeEntries = `-- name: GetRecentTimeEntries :many select id, start_time, end_time, description, client_id, project_id, billable_rate from time_entry +where start_time >= ?1 order by start_time desc -limit ?1 ` -func (q *Queries) GetRecentTimeEntries(ctx context.Context, limitCount int64) ([]TimeEntry, error) { - rows, err := q.db.QueryContext(ctx, getRecentTimeEntries, limitCount) +func (q *Queries) GetRecentTimeEntries(ctx context.Context, startTime time.Time) ([]TimeEntry, error) { + rows, err := q.db.QueryContext(ctx, getRecentTimeEntries, startTime) if err != nil { return nil, err } @@ -1020,6 +1020,16 @@ func (q *Queries) ListAllProjects(ctx context.Context) ([]ListAllProjectsRow, er return items, nil } +const removeTimeEntry = `-- name: RemoveTimeEntry :exec +delete from time_entry +where id = ?1 +` + +func (q *Queries) RemoveTimeEntry(ctx context.Context, entryID int64) error { + _, err := q.db.ExecContext(ctx, removeTimeEntry, entryID) + return err +} + const stopTimeEntry = `-- name: StopTimeEntry :one update time_entry set end_time = datetime('now', 'utc') |