rcssdy
01/09/2022, 7:30 PMconst { error, data } = await supabase.from("jobs").select("*");
return { data };
isn't grabbing any data from the specified table (it's set up and has a single row of data)
my supabase client is all set up correctly, I'm currently using it for authentication - so I'm not 100% sure as to why it's not returning any results, any help would be appreciated!jensen
01/09/2022, 8:09 PMconst { error, data } = await supabase.from("jobs").select("*");
return { data };
isn't grabbing any data from the specified table (it's set up and has a single row of data)
my supabase client is all set up correctly, I'm currently using it for authentication - so I'm not 100% sure as to why it's not returning any results, any help would be appreciated!jensen
01/09/2022, 8:09 PMnull
, then what is the value of error
?jensen
01/09/2022, 8:09 PMrcssdy
01/09/2022, 8:10 PMjensen
01/09/2022, 8:10 PMjensen
01/09/2022, 8:11 PMjensen
01/09/2022, 8:13 PMrcssdy
01/09/2022, 8:14 PMjensen
01/09/2022, 8:14 PMrcssdy
01/09/2022, 8:15 PMimport { createClient } from "@supabase/supabase-js";
import { getSession } from "./session.server";
const supabaseUrl = process.env.SUPABASE_URL;
const supabaseKey = process.env.SUPABASE_ANON_KEY;
export const supabase = createClient(supabaseUrl, supabaseKey);
rcssdy
01/09/2022, 8:15 PMrcssdy
01/09/2022, 8:15 PMjensen
01/09/2022, 8:15 PMjensen
01/09/2022, 8:17 PMrcssdy
01/09/2022, 8:17 PMimport { useState } from "react";
import { Form, LoaderFunction, useLoaderData } from "remix";
import { supabase } from "~/utils/db.server";
import JobList from "./JobList";
export const loader: LoaderFunction = async ({ request }) => {
// const [loading, setLoading] = useState(false);
const { error, data } = await supabase.from("jobs").select();
return { data };
};
export default function JobSearch() {
const jobs = useLoaderData();
console.log(jobs);
...
rcssdy
01/09/2022, 8:17 PM.select()
jensen
01/09/2022, 8:18 PMjobs
is { data: undefined }
jensen
01/09/2022, 8:18 PMrcssdy
01/09/2022, 8:18 PMjensen
01/09/2022, 8:18 PMjensen
01/09/2022, 8:18 PMjensen
01/09/2022, 8:19 PMrcssdy
01/09/2022, 8:19 PMrcssdy
01/09/2022, 8:20 PMrcssdy
01/09/2022, 8:21 PMconsole.log
jobs, it comes out as undefinedrcssdy
01/09/2022, 8:22 PMjobs
is a brand new table, with one row of datajensen
01/09/2022, 8:23 PMerror
var. When we can see that it is null, we can determine what side the issue is on.jensen
01/09/2022, 8:23 PMrcssdy
01/09/2022, 8:25 PMrcssdy
01/09/2022, 8:25 PMrcssdy
01/09/2022, 8:25 PMrcssdy
01/09/2022, 8:25 PMjensen
01/09/2022, 8:25 PMjensen
01/09/2022, 8:25 PMrcssdy
01/09/2022, 8:26 PMjensen
01/09/2022, 8:26 PMrcssdy
01/09/2022, 8:26 PMjensen
01/09/2022, 8:27 PMrcssdy
01/09/2022, 8:28 PMjensen
01/09/2022, 8:28 PMjensen
01/09/2022, 8:28 PMjensen
01/09/2022, 8:28 PMjensen
01/09/2022, 8:28 PMrcssdy
01/09/2022, 8:29 PMjensen
01/09/2022, 8:29 PMjensen
01/09/2022, 8:29 PMjensen
01/09/2022, 8:29 PMrcssdy
01/09/2022, 8:30 PMrcssdy
01/09/2022, 8:30 PMjensen
01/09/2022, 8:31 PMrcssdy
01/09/2022, 8:31 PMjensen
01/09/2022, 8:31 PMrcssdy
01/09/2022, 8:31 PMjensen
01/09/2022, 8:32 PM