summaryrefslogtreecommitdiff
path: root/internal/queries
diff options
context:
space:
mode:
authorT <t@tjp.lol>2025-08-05 12:36:30 -0600
committerT <t@tjp.lol>2025-08-06 12:13:11 -0600
commit65e2ed65775d64afbc6065a3b4ac1069020093ca (patch)
treef94fabfed5be2d2622429ebc7c8af1bf51085824 /internal/queries
parent665bd389a0a1c8adadcaa1122e846cc81f5ead31 (diff)
most features in TUI working, remaining unimplemented keybinds need a modal view
Diffstat (limited to 'internal/queries')
-rw-r--r--internal/queries/queries.sql.go16
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')