Spaces:
Build error
Build error
File size: 1,204 Bytes
f8ff91f 7515f43 fdaf912 b6915e6 fdaf912 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 |
export const revalidate = 10;
import { createClient } from '@supabase/supabase-js';
import { NextRequest, NextResponse } from "next/server";
// GET request to retrieve the collections data from the database
export async function GET(request: NextRequest) {
// Create a new Supabase client
const supabase = createClient(
process.env.SUPABASE_URL ?? '',
process.env.SUPABASE_SERVICE_ROLE_KEY ?? '',
{ db: { schema: 'public' } },
);
// Retrieve the collections requests data from the database
const { data: collections, error: collErr } = await supabase
.from('collections')
.select(`
collection_id,
id,
display_name,
description,
is_public,
created_at,
users (
id,
name,
email
)
`);
if (collErr) {
console.error('Error fetching collections data from database:', collErr.message);
return NextResponse.json({ error: collErr.message }, { status: 500 });
}
// console.log('Collections:', collections);
return NextResponse.json({ collections: collections });
}
|