seed.sql

seed.sql

${onlineHost}

Pool

--unstable

Unstable API 'Deno.connect'. The --unstable flag must be provided.

-- supabase/seed.sql
CREATE SCHEMA foobar;

-- TODO: create a user? any other context for security?

-- Add permissions
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA foobar TO bar, baz; -- Are all these needed? Is this good/bad practice?
ALTER DEFAULT PRIVILEGES IN SCHEMA foobar GRANT ALL ON TABLES TO foo, bar;
ALTER DEFAULT PRIVILEGES IN SCHEMA foobar GRANT ALL ON FUNCTIONS TO foo, bar;
ALTER DEFAULT PRIVILEGES IN SCHEMA foobar GRANT ALL ON SEQUENCES TO foo, bar;
-- ...

CREATE TABLE my_table (
  id serial PRIMARY KEY,
  name text NOT NULL
);
--- etc.

js
.upload(`${currentUser.id}/${imageName.value}.${extension.value}`, fileInput.value, {
    cacheControl: '3600',
    upsert: false
  })

ts
import { corsHeaders } from "../_shared/cors.ts"
import { serve } from "https://deno.land/std@0.168.0/http/server.ts"

serve(async (req: Request) => {
    if (req.method === "OPTIONS") {
        return new Response("ok", { headers: corsHeaders })
    }
    let timerId: number | undefined;
    console.log("Serving request")
    const body = new ReadableStream({
        start: (controller) => {
            timerId = setInterval(() => {
                console.log("Sending data")
                controller.enqueue(new TextEncoder().encode("data: hello\r\n\r\n"));
            }, 1000);
        },
        cancel(){
            if (typeof timerId === "number") {
                clearInterval(timerId);
            }
        }
    })

    return new Response(
        body,
        {
            headers: {
                ...corsHeaders,
                "Content-Type": "text/event-stream"
            }
        }
    )
})

js
# My Query
query {
  countriesCollection(first: 1) {
    edges {
      node {
        ...CountryFragment
      }
    }
  }
}

fragment CountryFragment on countries {
  country_code
  country_name
  currency_code
  flag
  id
}

# Response
{
  "data": {
    "countriesCollection": {
      "edges": []
    }
  }
}

sql
select graphql.resolve($$
    {
      countriesCollection(first: 1) {
        edges {
          node {
            country_code
            country_name
            currency_code
            flag
            id
          }
        }
      }
    }
$$);

sql
UPDATE events_odds_api
  SET home_team_id = (
    SELECT id
    FROM teams
    WHERE (CASE WHEN events_odds_api.sport = 'mma_mixed_martial_arts' or events_odds_api.sport = 'soccer_uefa_champs_league'
                THEN name
                ELSE CONCAT(name, ' ', mascot)
          END) = events_odds_api.home_team
    LIMIT 1
  )
  WHERE home_team_id IS NULL;

events_odds_api

teams

away_team_id

home_team_id

name

CONCAT(name, ' ',mascot)

createClient

supabase.auth.getUser()

invalid claim: missing sub claim

null

2.21.0

/realtime/v1/websocket

WebSocket connection to 'wss://<our supabase project code>.supabase.co/realtime/v1/websocket?apikey=xxxxxxxxxxxxxx&vsn=1.0.0' failed: