Cokaps016
05/25/2023, 3:40 AMJason Creviston
05/25/2023, 12:04 PMreturn tableData
or just use the store in whatever page you need it.
What kind of data is this? Would it have user data?Cokaps016
05/25/2023, 12:12 PMJason Creviston
05/25/2023, 12:16 PMCokaps016
05/26/2023, 2:45 AMts
import { writable } from 'svelte/store';
import { supabase } from '$lib/supabaseClient';
// import Type {Database} from '../DatabaseDefinitions.d.ts'
// TODO: DATABASE Type
// let supabaseData: object[] = writable([]);
let supabaseData = writable([]);
if (!supabaseData) {
const { data: data, error } = await supabase.from('main').select('*');
data.sort((a: any, b: any) => b.id - a.id);
supabaseData = data;
// console.log('1:', supabaseData);
// console.log('2:', data);
}
export { supabaseData };
ts
import { supabase } from '$lib/supabaseClient';
import type { PageServerLoad } from './$types';
import { supabaseData } from '$lib/supabaseData';
export const load: PageServerLoad = async ({ locals: { getSession } }) => {
const session = await getSession();
console.log(session);
let dates;
console.log(dates);
supabaseData.subscribe((value) => {
dates = value ?? [];
});
console.log(dates);
// const { data: data, error } = await supabase.from('main').select('*');
return {
dates,
session:
session &&
(session.user.email == 'sb@gmail.com' ||
session.user.email == 'some@gmail.com' ||
session.user.email == 's@gmail.com'),
// lhsData: dataLHS ?? [],
};
// if (session) {
// throw redirect(303, '/account');
// }
// return { url: url.origin };
};
Jason Creviston
05/26/2023, 10:26 AMCokaps016
05/26/2023, 11:24 AMJason Creviston
05/26/2023, 11:36 AMsupabaseData.set(data)
. https://svelte.dev/docs#run-time-svelte-store-writable
I was thinking you can just do const { data, error } = await supabase.from('main').select('*');
, without the data:
https://supabase.com/docs/reference/javascript/selectCokaps016
05/26/2023, 4:47 PM1:
or 2:
as well)Jason Creviston
05/26/2023, 7:00 PMsupabaseData.ts
even runs. You're just exporting the store.
What you might consider is moving your Supabase query to your +page.server.ts
- at least for a test.if (!$supabaseData) { ... }
so that it checks for a value - although I'm not sure if that would be true
or false
with an empty array.true
in a check like if (supabaseData)
, because the store exists. However, when you check $supabaseData
, it checks against the store's value, if any.Cokaps016
05/27/2023, 2:18 AM