entry edit and delete

1 files changed, 15 insertions, 0 deletions

diff --git a/internal/database/queries.sql b/internal/database/queries.sql
index f46f426..8eda5f4 100644
--- a/internal/database/queries.sql
+++ b/internal/database/queries.sql
@@ -39,6 +39,10 @@ where end_time is null
 order by start_time desc
 limit 1;
 
+-- name: GetTimeEntryById :one
+select * from time_entry
+where id = @entry_id;
+
 -- name: StopTimeEntry :one
 update time_entry 
 set end_time = datetime('now', 'utc')
@@ -314,6 +318,17 @@ where id = (
 	limit 1
 );
 
+-- name: EditTimeEntry :exec
+update time_entry
+set
+	start_time = @start_time,
+	end_time = @end_time,
+	description = @description,
+	client_id = @client_id,
+	project_id = @project_id,
+	billable_rate = @hourly_rate
+where id = @entry_id;
+
 -- name: RemoveTimeEntry :exec
 delete from time_entry
 where id = @entry_id;