Skip to content

Instantly share code, notes, and snippets.

@dbasics
dbasics / 006_rls_swaps_dates.sql
Created April 6, 2026 01:59
Escala - RLS checkins/swaps + fix datas abril
DROP POLICY IF EXISTS anon_read_checkins ON checkins;
CREATE POLICY anon_read_checkins ON checkins FOR SELECT USING (true);
DROP POLICY IF EXISTS auth_insert_checkins ON checkins;
CREATE POLICY auth_insert_checkins ON checkins FOR INSERT WITH CHECK (true);
DROP POLICY IF EXISTS auth_update_checkins ON checkins;
CREATE POLICY auth_update_checkins ON checkins FOR UPDATE USING (true);
DROP POLICY IF EXISTS auth_delete_checkins ON checkins;
CREATE POLICY auth_delete_checkins ON checkins FOR DELETE USING (true);
DROP POLICY IF EXISTS anon_read_swaps ON swaps;
CREATE POLICY anon_read_swaps ON swaps FOR SELECT USING (true);
@dbasics
dbasics / 005_checkins_rls.sql
Created April 6, 2026 01:14
Escala Multimidia - RLS checkins
DROP POLICY IF EXISTS anon_read_checkins ON checkins;
CREATE POLICY anon_read_checkins ON checkins FOR SELECT USING (true);
DROP POLICY IF EXISTS auth_insert_checkins ON checkins;
CREATE POLICY auth_insert_checkins ON checkins FOR INSERT WITH CHECK (true);
DROP POLICY IF EXISTS auth_update_checkins ON checkins;
CREATE POLICY auth_update_checkins ON checkins FOR UPDATE USING (true);
DROP POLICY IF EXISTS auth_delete_checkins ON checkins;
CREATE POLICY auth_delete_checkins ON checkins FOR DELETE USING (true);
@dbasics
dbasics / 004_import_abril_2026.sql
Created April 5, 2026 22:58
Escala Multimidia - SQL import abril 2026
DROP POLICY IF EXISTS anon_read_schedule_entries ON schedule_entries;
DROP POLICY IF EXISTS anon_read_schedule_meta ON schedule_meta;
DROP POLICY IF EXISTS anon_read_event_areas ON event_areas;
DROP POLICY IF EXISTS anon_read_unavailabilities ON unavailabilities;
CREATE POLICY anon_read_schedule_entries ON schedule_entries FOR SELECT USING (true);
CREATE POLICY anon_read_schedule_meta ON schedule_meta FOR SELECT USING (true);
CREATE POLICY anon_read_event_areas ON event_areas FOR SELECT USING (true);
CREATE POLICY anon_read_unavailabilities ON unavailabilities FOR SELECT USING (true);
DELETE FROM schedule_entries WHERE event_id IN (SELECT id FROM events WHERE month = 4 AND year = 2026);
DELETE FROM event_areas WHERE event_id IN (SELECT id FROM events WHERE month = 4 AND year = 2026);