summaryrefslogtreecommitdiff
path: root/internal/database/queries.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/database/queries.sql')
-rw-r--r--internal/database/queries.sql15
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;