US-02: Data Access Layer and Supabase Integration (reportApi.js) #2

New issue

Closed

opened 2026-09-23 17:42:52 +00:00 by gabogg · 2 comments

gabogg commented

2026-09-23 17:42:52 +00:00

Owner

User Story

As a developer, I need a centralized data access module that interacts with the Supabase client to execute CRUD operations on daily reports and fetch historical dates.

Acceptance Criteria

Supabase client initialized from Vite environment variables (, ).
function returning the current date in local format.
to retrieve a specific shift record.
to load Day and Night shifts in parallel.
executing an atomic UPSERT on .
returning unique dates with existing reports in the database.

## User Story As a developer, I need a centralized data access module that interacts with the Supabase client to execute CRUD operations on daily reports and fetch historical dates. ## Acceptance Criteria - [ ] Supabase client initialized from Vite environment variables (, ). - [ ] function returning the current date in local format. - [ ] to retrieve a specific shift record. - [ ] to load Day and Night shifts in parallel. - [ ] executing an atomic UPSERT on . - [ ] returning unique dates with existing reports in the database.

gabogg changed title from ~~US-02: Capa de Acceso a Datos y Conexión Supabase (reportApi.js)~~ to US-02: Data Access Layer and Supabase Integration (reportApi.js)

2026-09-23 17:46:10 +00:00

gabogg added the

ready-for-agent

mvp

database

labels

2026-09-23 18:10:25 +00:00

gabogg referenced this issue

2026-09-23 18:25:30 +00:00

feat(db): establish database schema, RLS policies, and data access layer (US-01, US-02) #12

gabogg commented

2026-09-23 18:25:39 +00:00