package event

import (
	"context"
	"database/sql"
)

// ListAll returns all cached events, ordered by start_time DESC.
// Used for the connections-list filter dropdown.
func ListAll(ctx context.Context, db *sql.DB) ([]Record, error) {
	rows, err := db.QueryContext(ctx, `
		SELECT uri, name, start_time, end_time, location,
		       geofence_lat, geofence_lng, geofence_radius, organizer_did,
		       expected_attendees, links
		FROM events
		ORDER BY start_time DESC
	`)
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var out []Record
	for rows.Next() {
		rec, err := scanRow(rows)
		if err != nil {
			return nil, err
		}
		out = append(out, rec)
	}
	return out, rows.Err()
}

// QRTokenForURI returns the qr_token for an event URI. Returns "" if not found.
func QRTokenForURI(ctx context.Context, db *sql.DB, uri string) string {
	var token string
	_ = db.QueryRowContext(ctx, `SELECT qr_token FROM events WHERE uri = ?`, uri).Scan(&token)
	return token
}