atmoquest/internal/db/migrations/ at d18f7dc9012bfa6c4eef3c32cb9e00a16de55748 · vvill.dev/atmoquest

001_init.sql

feat(event): step 5 — public scan-to-checkin flow - port internal/event (Record/CreateInput/Cache/Get/Put/LookupByQRToken/IsOngoing) - port internal/checkin (Put + Current) - features/event/{handlers,routes}.go: EventScan, EventQR, EventScanCheckin, EventFlushLocal - features/event/pages/event.templ: EventScanView landing page - wire TargetCurrentEvent + also-checkin into features/connect: * Connect handler queries checkin.Current + event.Get to populate event chip * ConnectConfirm re-validates claimed event_uri server-side then writes checkin * connection record carries event_uri when also-checkin is honored - router: register event.SetupRoutes after connect routes (all unauthed responses match step 4 pattern): - GET /e/{token} -> 404 unknown / 200 landing - GET /e/{token}/qr.svg -> 404 unknown / SVG - POST /e/{token}/checkin -> 302 /signin (unauthed) / 303 /?checkedin=1 - POST /event/flush-local -> 302 /signin (unauthed) / 200 JSON admin event CRUD intentionally deferred to step 6. tests: internal/event + internal/checkin pass.

3 months ago

002_oauth.sql

feat(event): step 5 — public scan-to-checkin flow - port internal/event (Record/CreateInput/Cache/Get/Put/LookupByQRToken/IsOngoing) - port internal/checkin (Put + Current) - features/event/{handlers,routes}.go: EventScan, EventQR, EventScanCheckin, EventFlushLocal - features/event/pages/event.templ: EventScanView landing page - wire TargetCurrentEvent + also-checkin into features/connect: * Connect handler queries checkin.Current + event.Get to populate event chip * ConnectConfirm re-validates claimed event_uri server-side then writes checkin * connection record carries event_uri when also-checkin is honored - router: register event.SetupRoutes after connect routes (all unauthed responses match step 4 pattern): - GET /e/{token} -> 404 unknown / 200 landing - GET /e/{token}/qr.svg -> 404 unknown / SVG - POST /e/{token}/checkin -> 302 /signin (unauthed) / 303 /?checkedin=1 - POST /event/flush-local -> 302 /signin (unauthed) / 200 JSON admin event CRUD intentionally deferred to step 6. tests: internal/event + internal/checkin pass.

3 months ago

003_pending_connections.sql

feat(event): step 5 — public scan-to-checkin flow - port internal/event (Record/CreateInput/Cache/Get/Put/LookupByQRToken/IsOngoing) - port internal/checkin (Put + Current) - features/event/{handlers,routes}.go: EventScan, EventQR, EventScanCheckin, EventFlushLocal - features/event/pages/event.templ: EventScanView landing page - wire TargetCurrentEvent + also-checkin into features/connect: * Connect handler queries checkin.Current + event.Get to populate event chip * ConnectConfirm re-validates claimed event_uri server-side then writes checkin * connection record carries event_uri when also-checkin is honored - router: register event.SetupRoutes after connect routes (all unauthed responses match step 4 pattern): - GET /e/{token} -> 404 unknown / 200 landing - GET /e/{token}/qr.svg -> 404 unknown / SVG - POST /e/{token}/checkin -> 302 /signin (unauthed) / 303 /?checkedin=1 - POST /event/flush-local -> 302 /signin (unauthed) / 200 JSON admin event CRUD intentionally deferred to step 6. tests: internal/event + internal/checkin pass.

3 months ago

004_events_checkins.sql

feat(event): step 5 — public scan-to-checkin flow - port internal/event (Record/CreateInput/Cache/Get/Put/LookupByQRToken/IsOngoing) - port internal/checkin (Put + Current) - features/event/{handlers,routes}.go: EventScan, EventQR, EventScanCheckin, EventFlushLocal - features/event/pages/event.templ: EventScanView landing page - wire TargetCurrentEvent + also-checkin into features/connect: * Connect handler queries checkin.Current + event.Get to populate event chip * ConnectConfirm re-validates claimed event_uri server-side then writes checkin * connection record carries event_uri when also-checkin is honored - router: register event.SetupRoutes after connect routes (all unauthed responses match step 4 pattern): - GET /e/{token} -> 404 unknown / 200 landing - GET /e/{token}/qr.svg -> 404 unknown / SVG - POST /e/{token}/checkin -> 302 /signin (unauthed) / 303 /?checkedin=1 - POST /event/flush-local -> 302 /signin (unauthed) / 200 JSON admin event CRUD intentionally deferred to step 6. tests: internal/event + internal/checkin pass.

3 months ago

005_admin_users_badges.sql

feat(event): step 5 — public scan-to-checkin flow - port internal/event (Record/CreateInput/Cache/Get/Put/LookupByQRToken/IsOngoing) - port internal/checkin (Put + Current) - features/event/{handlers,routes}.go: EventScan, EventQR, EventScanCheckin, EventFlushLocal - features/event/pages/event.templ: EventScanView landing page - wire TargetCurrentEvent + also-checkin into features/connect: * Connect handler queries checkin.Current + event.Get to populate event chip * ConnectConfirm re-validates claimed event_uri server-side then writes checkin * connection record carries event_uri when also-checkin is honored - router: register event.SetupRoutes after connect routes (all unauthed responses match step 4 pattern): - GET /e/{token} -> 404 unknown / 200 landing - GET /e/{token}/qr.svg -> 404 unknown / SVG - POST /e/{token}/checkin -> 302 /signin (unauthed) / 303 /?checkedin=1 - POST /event/flush-local -> 302 /signin (unauthed) / 200 JSON admin event CRUD intentionally deferred to step 6. tests: internal/event + internal/checkin pass.

3 months ago

006_connection_notes.sql

Add connections template and notes with note download

3 months ago

007_badge_definitions.sql

Add badges

3 months ago

008_pending_event_uri.sql

Update designs

3 months ago

009_privacy_toggles.sql

Add tests, badges, favicon, etc.

3 months ago

010_new_badge_definitions.sql

Add tests, badges, favicon, etc.

3 months ago

011_event_badges_per_type.sql

Add tests, badges, favicon, etc.

3 months ago

012_badge_message_and_host.sql

Add tests, badges, favicon, etc.

3 months ago

013_event_summary_cache.sql

Add summary view at the end of an event and allow event updating

3 months ago

014_device_tokens.sql

Add summary view at the end of an event and allow event updating

3 months ago

015_users_user_type.sql

Add local account support

3 months ago

016_local_connections.sql

Add local account support

3 months ago

017_account_links.sql

Add local account support

3 months ago

018_user_profile.sql

Add local account support

3 months ago

019_pending_local_connections.sql

Group B+C: Local→ATProto reciprocity and badge awards B: Local→ATProto connection reciprocity - New migration 019_pending_local_connections.sql for pending local reciprocal connections - Add Queue.EnqueueLocal() for local-initiated pending connections - Update Connect handler to detect local viewers via ResolveIdentity - Add connectLocalToATProto method for local→ATProto connection flow - Update ConnectFlushLocal to support both local and ATProto viewers - Add self-connect guard for ATProto viewers connecting to linked local IDs - Migrate pending_local_connections during graduation in LinkLocalToATProto C: Badge awards for local users - Add AwardLocal() for writing badge awards to local SQLite cache - Add AwardConnectionMilestonesLocal() variant - Award badges in ConnectLocal, ConnectFlushLocal, EventScanCheckin, EventFlushLocal - Add checkin.CurrentForLocal() for string DID lookups

3 months ago

020_drop_local_connections_fk.sql

Bugfixes to make sure all connection flows work and routes properly

2 months ago

021_local_account_fields.sql

Make local users enter an email and display name to create

2 months ago

Configure Feed

Configure Feed