debug-posts.js

// Debug script to check posts with location data
// Run this in the browser console on the map page to debug

console.log("🔍 DEBUG: Checking posts with location data...");

// Function to check posts in database
async function debugPosts() {
  // Import supabase (this should work if run in browser console on the app)
  const { supabase } = window;
  
  if (!supabase) {
    console.error("Supabase not available. Make sure you're on the VacayShare app page.");
    return;
  }

  console.log("📊 Checking all posts...");
  
  // Get all posts
  const { data: allPosts, error: allError } = await supabase
    .from('posts')
    .select('*');
    
  console.log("All posts:", allPosts, allError);
  
  // Get posts with location data
  const { data: postsWithLocation, error: locError } = await supabase
    .from('posts')
    .select(`
      id,
      created_at,
      caption,
      rating,
      location_name,
      latitude,
      longitude,
      visit_date,
      user_id,
      profiles:user_id (
        username,
        full_name,
        avatar_url
      )
    `)
    .not('latitude', 'is', null)
    .not('longitude', 'is', null);
    
  console.log("Posts with location:", postsWithLocation, locError);
  
  // Check follows
  const user = await supabase.auth.getUser();
  if (user.data?.user) {
    const { data: follows, error: followError } = await supabase
      .from('follows')
      .select('*')
      .eq('follower_id', user.data.user.id);
      
    console.log("Current user follows:", follows, followError);
  }
}

// Run the debug
debugPosts().then(() => {
  console.log("✅ Debug complete! Check the logs above.");
}).catch(error => {
  console.error("❌ Debug failed:", error);
});