most features in TUI working, remaining unimplemented keybinds need a modal view

1 files changed, 6 insertions, 2 deletions

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;