Function TaskBySessionID

internal/flowdb/db.go:757–763

TaskBySessionID returns the task bound to the given Claude session UUID, or sql.ErrNoRows if none. The partial unique index on tasks(session_id) WHERE session_id IS NOT NULL guarantees at most one row. Empty sid is treated as "no binding" and returns ErrNoRows without hitting the DB.

(db *sql.DB, sid string)

// one row. Empty sid is treated as "no binding" and returns ErrNoRows
// without hitting the DB.
func TaskBySessionID(db *sql.DB, sid string) (*Task, error) {
	if sid == "" {
		return nil, sql.ErrNoRows
	}
	row := db.QueryRow("SELECT "+TaskCols+" FROM tasks WHERE session_id = ? LIMIT 1", sid)
	return ScanTask(row)
}

func ListTasks(db *sql.DB, filter TaskFilter) ([]*Task, error) {
	var where []string