diff options
Diffstat (limited to 'internal/database/queries.sql')
| -rw-r--r-- | internal/database/queries.sql | 8 |
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; |