import { createClient } from '@supabase/supabase-js';
import { single, collection } from './supabase';
import { supabase } from '$lib/config/config';

import type { Topic } from '$lib/data/types';

const client = createClient(supabase.url, supabase.key);

export const topic = (id: string, withPosts = false) =>
	single<Topic>(
		client
			.from('topics')
			.select(
				withPosts
					? `*, 
    forum: forums (*),
    tags: topic_tags (*),
    posts (
      *,
      author:author_id (*)
    )
  `
					: '*'
			)
			.eq('id', id),
		null
	);
export const topicsForTag = (id: string) =>
	collection<Topic>(
		client
			.from('topics')
			.select(
				`
    *,tags!inner(*)
  `
			)
			.eq('tags.tag', id),
		[]
	);