peert/protastim - Change AIIZ4C23TLEAYG6VANDZHCAFTBDBAHUJUASCG4IYSVBBMN25DCGAC

Add working on to retrieve what is currently being worked on

Created by peert yesterday at 11:01

AIIZ4C23TLEAYG6VANDZHCAFTBDBAHUJUASCG4IYSVBBMN25DCGAC

Dependencies

[2] 56QWUWDTDMQN2GECHJG2MLTGEAQXFU67DI6P4PH4EYDENWRZKW2QC

In channels

main

Change contents

Insertion in internal/sql/query/time_entry.sql at line 23 [2.39]

[2.770]


-- name: WorkingOnWithName :one
SELECT time_entries.start_at, time_entries.task_id, tasks.name
FROM time_entries
JOIN tasks ON tasks.id = time_entries.task_id
WHERE end_at IS NULL;

Insertion in internal/database/time_entry.sql.go at line 173 [2.1711]

[2.5946]

	return i, err
}
const workingOnWithName = `-- name: WorkingOnWithName :one
SELECT time_entries.start_at, time_entries.task_id, tasks.name
FROM time_entries
JOIN tasks ON tasks.id = time_entries.task_id
WHERE end_at IS NULL
`
type WorkingOnWithNameRow struct {
	StartAt time.Time
	TaskID  int64
	Name    string
}
func (q *Queries) WorkingOnWithName(ctx context.Context) (WorkingOnWithNameRow, error) {
	row := q.db.QueryRowContext(ctx, workingOnWithName)
	var i WorkingOnWithNameRow
	err := row.Scan(&i.StartAt, &i.TaskID, &i.Name)