const blockObject = blockArray.map((index) => ({
    name: `Training block ${index + 1}`,
    program_id: programId,
    user_id: currentUser?.id,
    state: 1,
    index: index + 1,
  }));

const createBlocks = async () => {
    const { data, error } = await supabase
      .from('blocks')
      .insert([...blockObject]);

    createDaysPerBlock(data);

    return data;
  };

const createDaysPerBlock = async (trainingBlocks) => {
    const days = trainingBlocks.map(async (block) => {
      const dayObject = dayArray.map((index) => ({
        name: `Day ${index + 1}`,
        block_id: block.block_id,
        index: index + 1,
        program_id: programId,
      }));

      const { data, error } = await supabase
        .from('block_day')
        .insert([...dayObject]);

      return data;
    });

    const result = await Promise.all(days);
    return result;
  };

dart
    return _client
        .from(_conversationTable) //
        .select('''
            id,
            sender:profile(*)&profile.user_id=sender_id,
            receiver:profile(*)&profile.user_id=receiver_id,
            item:item_id(*),
            created_at
          ''')
        .eq('id', conversationId)
        .limit(1)
        .single()
        .execute()

auth.uid()

exists (
  select 1
  from condos
  where auth.uid() = condos.admin_id
)

js
  const { data, error } = await schoologyUsers.select().eq("email", email);
  if (!data) throw error;
  const user = data[0];

data

error

// console.log("client", client);
    // get users
    client
        .from("User")
        .select("*")
        .then(({ data, error }) => {
            console.log("data", data);
            console.log("error", error);
        });

supabase.auth.setSession

supabase/gotrue

create table countries {
id: uuid();
name: string;
}

create table cities {
id: uuid();
name: string;
counry_id: uuid references countries(id)
}

CREATE VIEW cities_fts
SELECT 
cities.id as city_id,
cities.country_id as county_id, to_tsvector('english', concat_ws(' ', cities.name, country.name )) AS fts
FROM countries, cities
WHERE (cities.country_id = countries.id);

.from('custom_view').select(*, counties(*))

.from('custom_view').select(*, cities(*))

custom_view

cities

cities.id

cities.county_id

js
    const fetchPlayers = async () => {
      const { data, error } = await supabase
      .from('export')
      .select('data')
      .limit(1)
      .order('inserted_at', { ascending: false })

      if (error) {
        setFetchError('Could not fetch')
        setPlayers(null)
        console.log(error)
      }
      if (data) {
        console.log(data)
        console.log(jsonB)
        setPlayers(data)
        setFetchError(null)
      }
    }

- ./volumes/db/data:/var/lib/postgresql/data

supabase-db

2022-10-06 12:19:52.986 UTC [1] FATAL:  data directory "/var/lib/postgresql/data" has wrong ownership

The server must be started by the user that owns the data directory.

chmod -R 777 docker/volumes/db/data