Query Functions

import { createClient } from '@/lib/supabase/client';
import type { AnimeEntry, Review, CustomList, Comment, ReviewVote } from '@/types/database';

const supabase = createClient();

const entries = await getAnimeEntries(user.id);
// Returns array of anime entries

const entry = await getAnimeEntry(user.id, 1535);
if (entry) {
  console.log(`Status: ${entry.status}`);
}

const newEntry = await upsertAnimeEntry({
  user_id: user.id,
  anime_id: 1535,
  title: 'Death Note',
  title_english: 'Death Note',
  status: 'watching',
  episodes_watched: 5,
  score: 9,
  tags: ['psychological', 'thriller'],
  favorite: true,
  rewatch_count: 0,
  genres: ['Mystery', 'Thriller'],
  episodes: 37,
  type: 'TV'
});

await deleteAnimeEntry(user.id, 1535);

// Get all published reviews for an anime
const reviews = await getReviews(1535, undefined, 'published');

// Get user's draft reviews
const drafts = await getReviews(undefined, user.id, 'draft');

// Get recent published reviews (limited)
const recent = await getReviews(undefined, undefined, 'published', 10);

const review = await getReview('550e8400-e29b-41d4-a716-446655440000');

const userReview = await getUserReview(user.id, 1535);
if (userReview) {
  console.log(`Rating: ${userReview.rating}/10`);
}

// Create new draft review
const draft = await upsertReview({
  user_id: user.id,
  anime_id: 1535,
  rating: 9,
  story_rating: 10,
  animation_rating: 8,
  sound_rating: 9,
  character_rating: 9,
  enjoyment_rating: 10,
  title: 'A Psychological Masterpiece',
  body: 'Death Note is an exceptional thriller...',
  spoilers: false,
  watch_status: 'completed',
  episodes_watched: 37,
  tags: ['psychological', 'must-watch'],
  pros: 'Brilliant mind games and character development',
  cons: 'Second half slightly weaker',
  recommendation: 'highly-recommend',
  status: 'draft'
});

// Publish existing review
const published = await upsertReview({
  ...draft,
  id: draft.id,
  status: 'published'
});

await deleteReview(review.id);

// Vote review as helpful
await voteReview(review.id, user.id, true);

// Change vote to not helpful
await voteReview(review.id, user.id, false);

const vote = await getUserReviewVote(review.id, user.id);
if (vote) {
  console.log(vote.helpful ? 'Voted helpful' : 'Voted not helpful');
}

const comments = await getComments(review.id);
// Filter top-level comments
const topLevel = comments.filter(c => !c.parent_id);
// Filter replies to a comment
const replies = comments.filter(c => c.parent_id === comment.id);

// Create top-level comment
const comment = await createComment({
  review_id: review.id,
  user_id: user.id,
  parent_id: null,
  content: 'Great review! I totally agree about the second half.'
});

// Create reply
const reply = await createComment({
  review_id: review.id,
  user_id: user.id,
  parent_id: comment.id,
  content: 'Thanks for reading!'
});

const updated = await updateComment(
  comment.id,
  'Great review! I totally agree about the character development.'
);

await deleteComment(comment.id);
// Comment remains in database but won't appear in queries

const lists = await getCustomLists(user.id);
lists.forEach(list => {
  console.log(`${list.name}: ${list.custom_list_entries.length} anime`);
});

const list = await createCustomList({
  user_id: user.id,
  name: 'Best Psychological Anime',
  description: 'Mind-bending anime that make you think',
  is_public: true
});

const updated = await updateCustomList(list.id, {
  name: 'Top Psychological Thrillers',
  is_public: true
});

await deleteCustomList(list.id);

await addAnimeToList(list.id, 1535); // Add Death Note

await removeAnimeFromList(list.id, 1535);

try {
  const entries = await getAnimeEntries(user.id);
  // Process entries
} catch (error) {
  console.error('Failed to fetch anime entries:', error);
  // Show user-friendly error message
}

import { useEffect, useState } from 'react';
import { useAuth } from '@/contexts/AuthContext';
import { getAnimeEntries, upsertAnimeEntry } from '@/lib/supabase/queries';
import type { AnimeEntry } from '@/types/database';

export default function AnimeList() {
  const { user } = useAuth();
  const [entries, setEntries] = useState<AnimeEntry[]>([]);
  const [loading, setLoading] = useState(true);

  useEffect(() => {
    if (user) {
      loadEntries();
    }
  }, [user]);

  async function loadEntries() {
    try {
      const data = await getAnimeEntries(user.id);
      setEntries(data);
    } catch (error) {
      console.error('Error loading entries:', error);
    } finally {
      setLoading(false);
    }
  }

  return (
    <div>
      {loading ? 'Loading...' : entries.map(entry => (
        <div key={entry.id}>{entry.title}</div>
      ))}
    </div>
  );
}