async function getOne() {
    const { data, error } = await supabaseClient.functions.invoke("contact", {
        method: "GET",
        body: JSON.stringify({ id: "23" }),
    });
    console.log(data, error);
}

avatar_url

null

full_name

const User =async()=>{
    const {data:{user}} =  await supabase.auth.getUser()
    if(user){
        const { data:files } = await supabase
        .from('category')
        .select().eq('user',user.id)
        console.log(files)
        if(files){
          console.log(files)
          const posts = []
        for (const file of files) {
          const { data:post } = await supabase.storage.from('files').createSignedUrl(file.vname, 3600000, {
            transform: {
              width: 200,
              height: 200,},
            })
         if(post){
            posts.push(post)
          // const diwn = await supabase.from('category').select().eq('vname',file.name)
          setDownload(posts)
          // setDfiles(diwn)
        }
         
        }
      }

supabase init --debug

Error: Project already initialized. Remove supabase\config.toml to reinitialize.

.vscode

let client = SupabaseClient(supabaseURL: URL(string: "myurl")!, supabaseKey: "my-api-key")
    
    func getAllLeagues() {
        let query = client.database.from("Leagues").select(columns: "id").single();
        Task {
            do {
                let response: [League] = try await query.execute().value
                print(response)
            } catch {
                print(error)
            }
        }
    }

supabase.auth.admin.createUser

global.headers

supabase-auth-token

const User =async()=>{
    const {data:{user}} =  await supabase.auth.getUser()
    if(user){
        const { data:files } = await supabase
        .from('category')
        .select().eq('user',user.id)

        if(files){
          const posts = []
        for (const file of files) {
          const { data:post } = await supabase.storage.from('files').createSignedUrl(file.vname, 3600000, {
            transform: {
              width: 200,
              height: 200,},
            })
         if(post){
            posts.push(post)
          setDownload(posts)
        }
         
        }
      }
      
     
    }
  }

UPDATE weather SET temp_lo = temp_lo+1, temp_hi = temp_lo+15, prcp = DEFAULT

js
import {ref} from 'vue'
const supabase  = useSupabaseClient()

const firstName = ref('')
const lastName = ref('')
const email = ref('') 
const password = ref('')

async function register() {
  const {data, error} = supabase.auth.signUp({
    email: email.value,
    password: password.value,
    //additional user data
    options: {
      data: {
        first_name: firstName,
        last_name: lastName
      }
    }
  })
}

const user = useSupabaseUser()

onMounted(()=>{
    watchEffect(()=>{
        if(user.value){
            navigateTo('/profile')
        }
    })
})

js
//unimportant (auth middleware)
definePageMeta({
    middleware: [
        'auth'
    ]
})

//THE PROBLEM
const user = useSupabaseUser() //user object (It's OK)
const name = user.value.user_metadata.first_name //undefined
//user_metadata alone works too

create table images (
    id integer not null generated by default as identity primary key,
    owner_id references auth.users on delete cascade not null,
    updated_at timestamp with time zone,
    image_url text not null,
    location text,
    camera text,
    aperture text,
    shutter text,
    iso text,
  );

alter table images
  enable row level security;

-- Create a policy to allow anyone to insert into the images table
create policy "images are viewable by everyone." on images
  for select using (true);
  
-- Create policy for anyone to inert images
create policy "Anyone can insert new images." on images 
  for insert using (true);

-- Create a policy to allow only owners to update their own images
create policy "Owner can update their own images." on images
  for update using (auth.uid() = owner_id);

-- Set up Storage!
insert into storage.buckets (id, name)
  values ('image_bucket', 'image_bucket');

-- Set up access controls for storage.
-- See https://supabase.com/docs/guides/storage#policy-examples for more details.
create policy "Images are publicly accessible." on storage.objects
  for select using (bucket_id = 'image_bucket');

create policy "Anyone can upload an image." on storage.objects
  for insert with check (bucket_id = 'image_bucket');

supabase db remote commit

const dataUrls = formData.getAll('files')
  
    const imageUuidList = [];
    const promises = [];
    
    for (const file of dataUrls) {
        const imageId = uuid();
        imageUuidList.push(imageId);
        // Upload the File object to Supabase Storage
        promises.push(supabase.storage.from("listing_images").upload(imageId, decode(file), {
            contentType: 'image/*'
          })
        );
    }

let selectedImages: string[] = [];
    let selectedBlobs: string[] = [];
    let files: FileList;

    async function onChangeHandler(e: Event) {
    if (selectedImages.length + files.length > 6) {
        alert('You can only upload a maximum of 6 images.');
        return;
    }
    const file = files.item(0);
    if (file != null) {
        const reader = new FileReader();
        reader.readAsDataURL(file);
        reader.onload = (event) => {
            if(!event.target) return;
            const image = event.target.result as string;
            selectedImages.push(image);
            const data = image.split(',');
            
            selectedBlobs.push(data[1]);
            selectedBlobs = selectedBlobs.slice();
            selectedImages = selectedImages.slice();
        };
        
    }
    }

full_name

first_name

last_name

export const supabase = createClient<Database>(supabaseUrl, supabaseAnonKey);

export interface Database {
    public: {
        Tables: {
...

tsx
        const supabaseAccessToken = await session.getToken({
            template: 'Supabase'
        });

        const supabase = await supabaseClient(supabaseAccessToken);

        const { data } = await supabase
        .from('purchase')
        .eq('id', referenceNumber)
        .select()

sql
create table
  public.orders (
    id uuid not null,
    status public.order_status not null,
    city text not null,
    postal_code text not null,
    address text not null,
    customer_email text not null,
    created_at timestamp with time zone null default now(),
    constraint orders_2_pkey primary key (id)
  ) tablespace pg_default;

sql
create table
  public.order_products (
    order_id uuid not null,
    product_id uuid not null,
    quantity integer not null,
    price double precision not null,
    constraint order_products_pkey primary key (order_id, product_id),
    constraint order_products_order_id_fkey foreign key (order_id) references orders (id),
    constraint order_products_product_id_fkey foreign key (product_id) references products (id)
  ) tablespace pg_default;

Searched for a foreign key relationship between 'profiles' and 'users' in the schema 'public', but no matches were found.

dart
await Supabase.instance.client.rest
        .from('profiles')
        .select<PostgrestList>('*, users(*)')

profiles

user_id

users