Supabase Setup

create table topics (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references auth.users(id) on delete cascade,
  title text not null,
  query text not null,
  created_at timestamptz default now(),
  updated_at timestamptz default now()
);

create table posts (
  id uuid primary key default gen_random_uuid(),
  topic_id uuid references topics(id) on delete cascade not null,
  platform text not null, -- 'x', 'reddit', 'youtube', 'web', 'simulated'
  external_id text not null,
  author text,
  content text not null,
  posted_at timestamptz,
  fetched_at timestamptz default now(),
  sentiment text, -- 'positive', 'negative', 'mixed', 'neutral'
  primary_emotion text, -- 'joy', 'anger', 'sadness', 'fear', 'surprise', 'disgust'
  emotion_scores jsonb,
  unique(platform, external_id)
);

create table topic_stats (
  id uuid primary key default gen_random_uuid(),
  topic_id uuid references topics(id) on delete cascade not null unique,
  total_volume integer default 0,
  volume_change integer default 0,
  overall_sentiment text, -- 'positive', 'negative', 'mixed', 'neutral'
  crisis_level text, -- 'none', 'low', 'medium', 'high'
  volatility integer default 0,
  emotion_breakdown jsonb,
  top_phrases jsonb,
  ai_summary text,
  key_takeaways jsonb,
  computed_at timestamptz default now()
);

create table sentiment_timeline (
  id uuid primary key default gen_random_uuid(),
  topic_id uuid references topics(id) on delete cascade not null,
  timestamp timestamptz default now(),
  positive_pct integer,
  negative_pct integer,
  neutral_pct integer,
  volume integer
);

create table alerts (
  id uuid primary key default gen_random_uuid(),
  topic_id uuid references topics(id) on delete cascade not null,
  alert_type text not null, -- 'crisis_spike', 'volume_surge', 'sentiment_shift'
  message text not null,
  severity text, -- 'low', 'medium', 'high'
  created_at timestamptz default now(),
  acknowledged boolean default false
);

create index idx_posts_topic_id on posts(topic_id);
create index idx_posts_sentiment on posts(sentiment);
create index idx_posts_fetched_at on posts(fetched_at desc);
create index idx_sentiment_timeline_topic_id on sentiment_timeline(topic_id);
create index idx_sentiment_timeline_timestamp on sentiment_timeline(timestamp desc);
create index idx_alerts_topic_id on alerts(topic_id);

project_id = "owrqiailcuwlzxeekhms"

[functions.analyze-sentiment]
verify_jwt = false

[functions.fetch-twitter]
verify_jwt = false

[functions.fetch-youtube]
verify_jwt = false

[functions.analyze-topic]
verify_jwt = false

[functions.scheduled-monitor]
verify_jwt = false

[functions.generate-insights]
verify_jwt = false

[auth]
site_url = "http://localhost:5173"
email_confirm_by_default = false

# Required for all functions
supabase secrets set SUPABASE_URL=https://your-project.supabase.co
supabase secrets set SUPABASE_SERVICE_ROLE_KEY=your-service-role-key

# Required for fetch-twitter
supabase secrets set SCRAPE_DO_TOKEN=your-scrape-do-token

# Optional fallbacks
supabase secrets set PARALLEL_API_KEY=your-parallel-key
supabase secrets set YOUTUBE_API_KEY=your-youtube-key

# Required for AI features
supabase secrets set GEMINI_API_KEY=your-gemini-key

supabase secrets list

[auth]
site_url = "https://your-domain.com"
email_confirm_by_default = true
additional_redirect_urls = ["http://localhost:5173"]

-- Enable RLS
alter table topics enable row level security;

-- Users can view their own topics
create policy "Users can view own topics"
  on topics for select
  using (auth.uid() = user_id);

-- Users can insert their own topics
create policy "Users can create topics"
  on topics for insert
  with check (auth.uid() = user_id);

-- Users can update their own topics
create policy "Users can update own topics"
  on topics for update
  using (auth.uid() = user_id);

-- Users can delete their own topics
create policy "Users can delete own topics"
  on topics for delete
  using (auth.uid() = user_id);

# Tail logs for a specific function
supabase functions logs fetch-twitter --tail

# View recent logs
supabase functions logs analyze-sentiment --limit 100