From 65e2ed65775d64afbc6065a3b4ac1069020093ca Mon Sep 17 00:00:00 2001 From: T Date: Tue, 5 Aug 2025 12:36:30 -0600 Subject: most features in TUI working, remaining unimplemented keybinds need a modal view --- internal/queries/queries.sql.go | 16 +++++++++++++--- 1 file changed, 13 insertions(+), 3 deletions(-) (limited to 'internal/queries/queries.sql.go') 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') -- cgit v1.2.3