From 65e2ed65775d64afbc6065a3b4ac1069020093ca Mon Sep 17 00:00:00 2001
From: T <t@tjp.lol>
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/queries.sql')

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

