CREATE OR REPLACE FUNCTION add_token_table(token_name text)
returns void as $$ 
BEGIN
   execute format(
     'create table', token_name, '(hexBalance text)'
   );
END
$$ language plpgsql

create function create_listing_liked_notification (receiver_id uuid, liker_id uuid, listing_id uuid)
returns void
language plpgsql
as $$
declare
  new_notification_id bigint;
begin
  insert into notifications ("receiverId", "actorId")
  values (receiver_id, liker_id)
  returning id into new_notification_id;
  insert into listingNotifications("notificationType", "notificationId", "listingId")
  values (1, new_notification_id, listing_id)
end;
$$;

create or replace function createticket("auth" text, "ticketname" text, "issuetype" text, "devicetype" text ,"issuedetails" text, "priority" text)
returns void
language plpgsql
security definer set search_path = public
as $$
BEGIN
  IF  (checkifauth(auth)) THEN
    insert into public.tickets (id, ticketname, issuetype, devicetype, issuedetails,priority)
     values (new.id,new.ticketname,new.issuetype,new.devicetype,new.issuedetails,new.priority);
  END IF;
  END;
$$

BEGIN
  IF EXISTS (select authkey from public.userprofile where authkey::text = auth) THEN
  return true;
  else return false;
  END IF;
  END;

select createticket('0d06829a-d271-4dde-b69a-6d16a2254143','test','test','test','test','test');

messages

rooms

rooms

CREATE TABLE rooms (
    id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    user_id_one uuid NOT NULL REFERENCES users(user_id) ON DELETE CASCADE,
    user_id_two uuid NOT NULL REFERENCES users(user_id) ON DELETE CASCADE
);

messages

CREATE TABLE messages (
    id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    from_user_id uuid NOT NULL REFERENCES users(user_id) ON DELETE CASCADE,
    message text NOT NULL,
    room_id integer NOT NULL REFERENCES rooms(id) ON DELETE CASCADE,
    create_time timestamp with time zone NOT NULL DEFAULT now(),
    message_id uuid NOT NULL UNIQUE
);

SELECT

from_user_id

to_user_id

SELECT m.room_id
 FROM messages m
          JOIN rooms r ON r.id = m.room_id
 WHERE user_id_one = '8dd172ba-7cfc-4c43-a427-601e505709f6'
    OR user_id_two = '8dd172ba-7cfc-4c43-a427-601e505709f6'

room_id

CREATE FUNCTION get_rooms_with_user_id(p_user_id uuid)

inviteUserByEmail

service_role

SUPABASE_SERVICE_ROLE_KEY

javascript
const { data: user, error } = await supabaseClient.auth.api.inviteUserByEmail(
    email,
  );

const { data, error } = await supabase.storage
    .from("mybucket")
    .upload("public/avatar1.png", req.body.file);

{
  statusCode: '401',
  error: 'Invalid JWT',
  message: 'new row violates row-level security policy for table "objects"'
}

-- 1. Allow public access to any files in the "public" bucket
create policy "Public Access"
on storage.objects for select
using ( bucket_id = 'mybucket' );

select notifications.id, notifications.status, notifications."receiverId", notifications."notificationObjectId"
from 
  notifications
left join 
  "notificationObjects" on notifications."notificationObjectId" = "notificationObjects".id;

(uid() = id)

code: '42501',
  details: null,
  hint: null,
  message: 'new row violates row-level security policy for table "tickets"'

export async function createTicket(ticketdata:any) {
  const { data, error } = await supabase
  .from('tickets')
  .insert([
    { devicetype: ticketdata.deviceType },
    { issuedetails:  ticketdata.issueDetails },
    { issuetype: ticketdata.issueType },
    { priority: ticketdata.priority },
    { ticketname:  ticketdata.ticketName },
  ], { returning: 'minimal' }, { upsert: true })
  if (error) console.error(error)
  else console.log(data)
}

const { data: total } = await supabase
        .from("tasks")
        .select("id", { count: "exact", head: true });
      console.log(total);

js
const { data, error } = await supabase
  .from('users')
  .upsert({ column_1: 'data1', column_2: 'data2' }, { onConflict: 'column_1' })

supabase.from().select().not('column', is, null)

{
  "component": "api",
  "error": "Unable to find email with Azure provider",
  "level": "error",
  "method": "GET",
  "msg": "500: Error getting user email from external provider",
  "path": "/callback",
  "referer": "",
  "remote_addr": "212.95.23.44",
  "time": "2022-09-14T11:33:53Z",
  "timestamp": "2022-09-14T11:33:52Z"
}