dummy-tables.sql

-- Create 300 dummy tables with RLS enabled and a default select policy each
DO $$
DECLARE
  i INT;
  table_name TEXT;
BEGIN
  FOR i IN 1..300 LOOP
    table_name := format('dummy_table_%s', i);

    EXECUTE format($sql$
      CREATE TABLE IF NOT EXISTS %I (
        id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
        description TEXT
      );
    $sql$, table_name);

    EXECUTE format('ALTER TABLE %I ENABLE ROW LEVEL SECURITY;', table_name);

    -- Create policy to allow authenticated users to select
    EXECUTE format($sql$
      CREATE POLICY select_authenticated ON %I
      FOR SELECT
      TO authenticated
      USING (true);
    $sql$, table_name);
  END LOOP;
END
$$;