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