我一直在尝试向 Supabase 数据库运行一个查询,需要传递一种狗的品种,并返回有关它的指标,该品种在客户端定义。我能够让服务器端查询运行,但是值没有传递过去。
+page.svelte
export let metrics;
export let data;
const getAllDogs = async () => {
const { metrics: data } = load({ dog: dog_val });
metrics = data;
};
onMount(async () => {
getAllDogs();
})
+page.server.js
import supabase from "../../lib/db";
//Method to get all dog breeds
export const load = async ({dog}) => {
const getAllMetrics = async () => {
try {
let { data, error } = await supabase
.from("dogs")
.select(
"avg_size, avg_obedience, avg_compassion, avg_health, avg_cleanliness, avg_energy"
)
.eq("Breed", dog);
console.log(data)
console.log(dog)
return data;
} catch (e) {
console.error(e);
}
};
return {
metrics: getAllMetrics(dog)
}
};
load
参数,也不能明确调用该函数。请阅读有关加载数据的文档。 - H.B.