auth.signUp

/settings

curl

apiKey

Authorization: Bearer ...

/auth/v1/magictoken

sb-access-token

apiKey

Authorization

service_role

apiKey

export type PresenceState = { [key: string]: Presence[] }

PresenceState

Presence[]

return supabase
    .from('table1')
    .select(`*`)
    .eq('account', account)

return supabase
    .from('table1')
    .select(`*`)
    .eq('account', account)
    .eq('2ndThing', 2ndThing)

js
const getCoingeckoData = async () => {
  const { data: tokens, error } = await supabase.from('tokens').select('*');
  const ids = tokens.map((token) => token.coingecko_id);
  console.log(ids); \\ [ 'kounotori', null, 'shield-protocol-token', 'saitama-inu' ]

  const { data: price } = await CoinGeckoClient.simple.price({
    ids: ids,
    vs_currencies: 'usd,eth',
    include_market_cap: true,
    include_24hr_vol: true,
    include_24hr_change: true,
    include_last_updated_at: false
  });

  ids.forEach(async (id) => {
    const { data, error } = await supabase.from('tokens')
      .update({
        usd: formatCurrency(price[id].usd, 'usd', 'en'),
        eth: formatCurrency(price[id].eth, 'eth', 'en').substring(1)
      }).eq('coingecko_id', id);
  });
};

js
const testFunction = async () => {
    let userId

    supabase.auth.onAuthStateChange((event, session) => {
        if (event == 'SIGNED_IN'){
            userId = session.user.id;
            console.log("auth state has changed", userId);
        }
    });

    return userId;
};

console.log('id',await testFunction());

supabase/tables/table_name.sql

\i supabase/tables/table_name.sql

Error: Error starting database: supabase/tables/table_name.sql: No such file or directory

supabase start

export async function getProspectFileList(): Promise<any> {
  const { data, error } = await supabaseClient.storage
    .from('prospects')
    .list();
  if (error) return error.message;
  console.log("got the data", data);
  return data;
}

prospects

users
- id
- ...

posts
- id
- author (fk to users.id)
- ...

likes
- pid (fk to posts.id)
- uid (fk to users.id)
(PK = pid + uid)

sql
(role() = 'authenticated'::text) AND (uid = uid() AND pid.author = uid())

Error adding policy: failed to create pg.policies: missing FROM-clause entry for table "pid"

js
userDetails() {
  return supabase
  .from('muni_users')
  .select('*')
  .eq('user_id', supabase.auth.user().id);
},

js
export async function load() {
  const { data: muni_user, error: bleh } = await db.users.userDetails();
  console.log(muni_user)
};

text
Cannot read properties of null (reading 'id')
TypeError: Cannot read properties of null (reading 'id')

begin
  insert into public.profiles (id, username, avatar_url)
  values (new.id, new.raw_user_meta_data->>'username', new.raw_user_meta_data->>'avatar_url');
  return new;
end;

{
  code: '42883',
  details: null,
  hint: 'No operator matches the given name and argument types. You might need to add explicit type casts.',
  message: 'operator does not exist: text = bigint'
}

let { data, error } = await supabase
    .from('new-follows')
    .select('username,follow_by,twit_id')
    .eq('follow_by', 239518063);

let { data, error } = await supabase
    .from('new-follows')
    .select('username,follow_by,twit_id')
    .eq('follow_by', '239518063');

accounts

account manager

published_status

account managers

{{ .Token }}

type: 'magiclink'

type: 'signup'

60000

6

ts
const { data, error } = await supabaseClient.auth.signInWithOtp({ email })
// {"data": {"session": null, "user": null}, "error": null}

const { data, error } = await supabaseClient.auth.verifyOtp({ email, token, type: 'signup' })
// {"data": {"session": null, "user": null}, "error": [AuthApiError: Token has expired or is invalid]}