summaryrefslogtreecommitdiff
path: root/internal/queries
diff options
context:
space:
mode:
Diffstat (limited to 'internal/queries')
-rw-r--r--internal/queries/queries.sql.go55
1 files changed, 55 insertions, 0 deletions
diff --git a/internal/queries/queries.sql.go b/internal/queries/queries.sql.go
index 1084cea..fb7f390 100644
--- a/internal/queries/queries.sql.go
+++ b/internal/queries/queries.sql.go
@@ -212,6 +212,41 @@ func (q *Queries) CreateTimeEntryWithTimes(ctx context.Context, arg CreateTimeEn
return i, err
}
+const editTimeEntry = `-- name: EditTimeEntry :exec
+update time_entry
+set
+ start_time = ?1,
+ end_time = ?2,
+ description = ?3,
+ client_id = ?4,
+ project_id = ?5,
+ billable_rate = ?6
+where id = ?7
+`
+
+type EditTimeEntryParams struct {
+ StartTime time.Time
+ EndTime sql.NullTime
+ Description sql.NullString
+ ClientID int64
+ ProjectID sql.NullInt64
+ HourlyRate sql.NullInt64
+ EntryID int64
+}
+
+func (q *Queries) EditTimeEntry(ctx context.Context, arg EditTimeEntryParams) error {
+ _, err := q.db.ExecContext(ctx, editTimeEntry,
+ arg.StartTime,
+ arg.EndTime,
+ arg.Description,
+ arg.ClientID,
+ arg.ProjectID,
+ arg.HourlyRate,
+ arg.EntryID,
+ )
+ return err
+}
+
const findClient = `-- name: FindClient :many
select c1.id, c1.name, c1.email, c1.billable_rate, c1.created_at from client c1 where c1.id = cast(?1 as integer)
union all
@@ -691,6 +726,26 @@ func (q *Queries) GetRecentTimeEntries(ctx context.Context, startTime time.Time)
return items, nil
}
+const getTimeEntryById = `-- name: GetTimeEntryById :one
+select id, start_time, end_time, description, client_id, project_id, billable_rate from time_entry
+where id = ?1
+`
+
+func (q *Queries) GetTimeEntryById(ctx context.Context, entryID int64) (TimeEntry, error) {
+ row := q.db.QueryRowContext(ctx, getTimeEntryById, entryID)
+ var i TimeEntry
+ err := row.Scan(
+ &i.ID,
+ &i.StartTime,
+ &i.EndTime,
+ &i.Description,
+ &i.ClientID,
+ &i.ProjectID,
+ &i.BillableRate,
+ )
+ return i, err
+}
+
const getTimesheetDataByClient = `-- name: GetTimesheetDataByClient :many
select
te.id as time_entry_id,