trails-cool/trails
1
1
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
trails/openspec/changes/account-export/tasks.md
Ullrich Schäfer 5dd4968626 docs+openspec: prior-art research (Organic Maps, Endurain, wanderer) and 15 proposals 
Add docs/inspirations.md as the durable record of the 2026-07-05/06
prior-art research — per-project learnings with source paths, canonical
credit lines, and the changes each spawned — and extend the
acknowledgment lists in philosophy.md/architecture.md (Organic Maps,
Endurain, wanderer).

New OpenSpec changes (proposal/design/specs/tasks each):
- Organic Maps: elevation-profile-hardening, gpx-parser-robustness,
  hiking-time-estimate, poi-index, hiking-foot-profile
- Endurain: account-export, activity-duplicate-review,
  fit-parsing-hardening, activity-locations, self-hosting-guide,
  activity-privacy-controls
- wanderer: federation-hardening, link-share-tokens
- credits-page (user-visible acknowledgments)

Updated in-flight changes with wanderer prior-art sections:
route-federation, route-discovery.

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
2026-07-06 07:23:00 +02:00

1.6 KiB
Raw Permalink Blame History

1. Schema & job plumbing

  • 1.1 Add export_jobs table to packages/db (id, user_id FK cascade, status, artifact_key, error, created_at, expires_at) + migration
  • 1.2 Add account-export job type to @trails-cool/jobs and a daily sweep job that deletes expired artifacts + rows

2. Export generation

  • 2.1 Implement the export assembler: batched queries per table (explicit column allowlists), streaming ZIP writer, layout per design (routes/, activities/, media/, *.json, manifest.json with formatVersion 1)
  • 2.2 Stream media files from Garage into the archive; tolerate missing media gracefully
  • 2.3 Upload artifact to storage under exports/ with expiry metadata; mark job complete; fire "export ready" notification (existing notification pattern)
  • 2.4 Unit tests: allowlists exclude token columns; manifest counts match; a synthetic large dataset stays within a memory budget; one-active-job constraint

3. UI & download

  • 3.1 Settings surface: "Export my data" with request button, in-progress state, ready-with-expiry state (i18n en/de)
  • 3.2 Owner-only download route streaming the artifact from storage; reject non-owners; 404 after expiry
  • 3.3 E2E: request export on a seeded account → notification → download → assert archive contents (GPX count, manifest, no token fields)

4. Docs

  • 4.1 Write docs/export-format.md (format version 1: layout + manifest schema)
  • 4.2 Update privacy documentation: export exists, what it contains, expiry

5. Verification

  • 5.1 Run pnpm typecheck && pnpm lint && pnpm test && pnpm test:e2e