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/database/queries.sql | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'internal/database') diff --git a/internal/database/queries.sql b/internal/database/queries.sql index c68cdad..f46f426 100644 --- a/internal/database/queries.sql +++ b/internal/database/queries.sql @@ -300,8 +300,8 @@ where date(te.start_time) = date('now'); -- name: GetRecentTimeEntries :many select * from time_entry -order by start_time desc -limit @limit_count; +where start_time >= @start_time +order by start_time desc; -- name: UpdateActiveTimerDescription :exec update time_entry @@ -313,3 +313,7 @@ where id = ( order by start_time desc limit 1 ); + +-- name: RemoveTimeEntry :exec +delete from time_entry +where id = @entry_id; -- cgit v1.2.3