jason-lynx
10/14/2021, 7:05 AMuser
10/14/2021, 7:06 AMjason-lynx
10/14/2021, 7:07 AMuser
10/14/2021, 7:08 AMjason-lynx
10/14/2021, 7:10 AMsignIn
should also work?user
10/14/2021, 7:10 AMuser
10/14/2021, 7:10 AMuser
10/14/2021, 7:10 AMjason-lynx
10/14/2021, 7:10 AMHarryET
10/14/2021, 8:43 AMuser
10/14/2021, 8:44 AMuser
10/14/2021, 8:44 AMHarryET
10/14/2021, 8:45 AMuser
10/14/2021, 8:45 AMHarryET
10/14/2021, 8:45 AMuser
10/14/2021, 8:45 AMFelixTran
10/14/2021, 9:12 AMproducts
, categories
and a table product_category
. How i can query products
that contain any given category_id
.
I have my foreign keys set up correctly.
This is my code. (it doesn't work)
js
let category_id = 2
await supabase.from('products')
.select(`
*,
brand: brands(
*
),
categories(
*
)
`)
.filter('categories.id','cs', category_id)
FelixTran
10/14/2021, 10:34 AMjs
.filter('product_category.category_id', 'eq', category_id)
Dinnerb0ne
10/14/2021, 11:10 AMDinnerb0ne
10/14/2021, 11:10 AMDinnerb0ne
10/14/2021, 11:37 AMsilentworks
10/14/2021, 12:11 PMoptions
key, just pass it a javascript object, please paste code instead of a screenshot as it will be easier to assist that way.Johann
10/14/2021, 12:41 PMsudo killall windows
10/14/2021, 12:49 PMsilentworks
10/14/2021, 1:02 PMDeleted User
10/14/2021, 5:53 PMHarryET
10/14/2021, 7:56 PMHarryET
10/14/2021, 7:57 PMHarryET
10/14/2021, 7:57 PMts
import type { Session, User } from '@supabase/gotrue-js';
import { createContext, useEffect, useState } from 'react'
import { useAuthStateChange, useClient } from 'react-supabase'
const initialState: {session?: Session, user?: User} = { session: null, user: null }
export const AuthContext = createContext(initialState)
type AuthProviderProps = {};
export const AuthProvider: React.FC<AuthProviderProps> = ({ children }) => {
const client = useClient()
const [state, setState] = useState(initialState)
useEffect(() => {
const session = client.auth.session()
setState({ session, user: session?.user ?? null })
}, [])
useAuthStateChange((event, session) => {
console.log(`Supbase auth event: ${event}`, session)
setState({ session, user: session?.user ?? null })
})
return <AuthContext.Provider value={state}>{children}</AuthContext.Provider>
}
HarryET
10/14/2021, 7:57 PMts
import { AuthContext } from '../components/authProvider';
import { useContext } from 'react';
export const useAuth = () => {
const context = useContext(AuthContext)
if (context === undefined)
throw Error('useAuth must be used within AuthProvider')
return context
}