-- data/schemas/users.sql
CREATE TABLE public.users (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  full_name TEXT,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT now(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT now(),
  scent_profile JSONB,
  preferences JSONB
);

-- Add indexes for common query patterns
CREATE INDEX users_email_idx ON public.users (email);

-- Add RLS policies
ALTER TABLE public.users ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Users can view their own data" ON public.users
  FOR SELECT USING (auth.uid() = id);
  
CREATE POLICY "Users can update their own data" ON public.users
  FOR UPDATE USING (auth.uid() = id);

// data/models/user.model.ts
import { Database } from './supabase.types';

export interface User {
  id: string;
  email: string;
  fullName: string | null;
  createdAt: string;
  updatedAt: string;
  scentProfile: ScentProfile | null;
  preferences: UserPreferences | null;
}

export interface ScentProfile {
  favoriteNotes: string[];
  intensity: number;
  preferences: {
    floral: number;
    woody: number;
    citrus: number;
    oriental: number;
    fresh: number;
  };
}

export interface UserPreferences {
  theme: 'light' | 'dark' | 'system';
  notifications: boolean;
  newsletter: boolean;
}

// Type-safe helper to convert from DB model to application model
export function fromDBUser(
  dbUser: Database['public']['Tables']['users']['Row']
): User {
  return {
    id: dbUser.id,
    email: dbUser.email,
    fullName: dbUser.full_name,
    createdAt: dbUser.created_at,
    updatedAt: dbUser.updated_at,
    scentProfile: dbUser.scent_profile,
    preferences: dbUser.preferences
  };
}

-- infra/supabase/migrations/20240401000000_create_users_table.sql
CREATE TABLE public.users (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  email TEXT UNIQUE NOT NULL,
  full_name TEXT,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT now(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT now()
);

-- infra/supabase/migrations/20240402000000_add_scent_profile.sql
ALTER TABLE public.users ADD COLUMN scent_profile JSONB;
ALTER TABLE public.users ADD COLUMN preferences JSONB;

// packages/supabase-client/src/index.ts
import { createClient } from '@supabase/supabase-js';
import type { Database } from '@repo/types';

let supabaseInstance: ReturnType<typeof createClient> | null = null;

export function getSupabaseClient() {
  if (!supabaseInstance) {
    const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL;
    const supabaseKey = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY;
    
    if (!supabaseUrl || !supabaseKey) {
      throw new Error('Missing Supabase environment variables');
    }
    
    supabaseInstance = createClient<Database>(supabaseUrl, supabaseKey);
  }
  
  return supabaseInstance;
}

export function getSupabaseServerClient() {
  const supabaseUrl = process.env.NEXT_PUBLIC_SUPABASE_URL;
  const supabaseServiceKey = process.env.SUPABASE_SERVICE_ROLE_KEY;
  
  if (!supabaseUrl || !supabaseServiceKey) {
    throw new Error('Missing Supabase environment variables for server client');
  }
  
  return createClient<Database>(supabaseUrl, supabaseServiceKey);
}