CREATE MATERIALIZED VIEW "public"."PricePlan" AS
    SELECT price.id, product.name
    FROM "stripe"."prices" AS price
    JOIN "stripe"."products" AS product ON product.id = price.product
    WITH DATA;

CREATE OR REPLACE VIEW "public"."Subscription" AS
    SELECT sub.*, product.name AS plan_name
    FROM "stripe"."subscriptions" AS sub 
    JOIN "public"."PricePlan" AS product ON product.id = sub.attrs->'plan'->>'id';

CREATE OR REPLACE FUNCTION get_user_subscription() RETURNS setof "public"."Subscription" AS $$
    SELECT * FROM "public"."Subscription"
    WHERE customer = auth.uid()::text
$$ LANGUAGE SQL STABLE SECURITY DEFINER;

CREATE OR REPLACE FUNCTION get_user_subscription() RETURNS setof "public"."Subscription" AS $$
declare user_id text := auth.uid()::text;
begin
    return query SELECT * FROM "public"."Subscription"
    WHERE customer = user_id; 
  end;
$$ LANGUAGE plpgsql SECURITY DEFINER;