entry edit and delete

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,