File size: 16,104 Bytes
22087d0 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 | import hmac
import hashlib
import json
from fastapi import APIRouter, Depends, HTTPException, Header, BackgroundTasks, Request
from pydantic import BaseModel
from typing import Dict, Optional
from datetime import datetime, timezone
import os
import concurrent.futures
from core.utils.auth_utils import verify_and_get_user_id_from_jwt
from core.utils.logger import logger
from core.utils.config import config
from core.billing.subscriptions import free_tier_service
from core.utils.suna_default_agent_service import SunaDefaultAgentService
from core.services.supabase import DBConnection
from core.services.email import email_service
# Main setup router (prefix="/setup")
router = APIRouter(prefix="/setup", tags=["setup"])
webhook_router = APIRouter(tags=["webhooks"])
# ============================================================================
# Models
# ============================================================================
class WebhookResponse(BaseModel):
"""Response model for webhook endpoints"""
success: bool
message: str
class SupabaseWebhookPayload(BaseModel):
"""Payload from Supabase webhook on auth.users insert"""
type: str
table: str
record: dict
schema: str
old_record: Optional[dict] = None
# ============================================================================
# Webhook Security
# ============================================================================
def verify_webhook_secret(x_webhook_secret: str = Header(...)):
"""Verify the webhook secret from Supabase using constant-time comparison."""
expected_secret = os.getenv('SUPABASE_WEBHOOK_SECRET')
if not expected_secret:
logger.error("SUPABASE_WEBHOOK_SECRET not configured")
raise HTTPException(status_code=500, detail="Webhook secret not configured")
# Use constant-time comparison to prevent timing attacks
if not hmac.compare_digest(x_webhook_secret.encode('utf-8'), expected_secret.encode('utf-8')):
logger.warning("Invalid webhook secret received")
raise HTTPException(status_code=401, detail="Invalid webhook secret")
return True
# ============================================================================
# Helper Functions
# ============================================================================
async def initialize_user_account(account_id: str, email: Optional[str] = None, user_record: Optional[dict] = None) -> Dict:
try:
logger.info(f"[SETUP] Initializing account for {account_id}")
# Use singleton - already initialized at startup
db = DBConnection()
user_name = None
if user_record and email:
user_name = _extract_user_name(user_record, email)
from core.notifications.notification_service import notification_service
logger.info(f"[SETUP] Sending welcome email to {email} with name {user_name}")
try:
await notification_service.send_welcome_email(account_id)
except Exception as ex:
logger.error(f"[SETUP] Error sending welcome notification: {ex}")
if email and user_name:
_send_welcome_email_async(email, user_name)
result = await free_tier_service.auto_subscribe_to_free_tier(account_id, email)
if not result.get('success'):
error_msg = result.get('error') or result.get('message', 'Unknown error')
if 'Already subscribed' in error_msg or 'already' in error_msg.lower():
logger.info(f"[SETUP] User {account_id} already has subscription, proceeding with agent install")
else:
logger.error(f"[SETUP] Failed to create free tier for {account_id}: {error_msg}")
return {
'success': False,
'message': f"Failed to initialize free tier: {error_msg}",
'error': error_msg
}
logger.info(f"[SETUP] Installing Suna agent for {account_id}")
try:
suna_service = SunaDefaultAgentService(db)
agent_id = await suna_service.install_suna_agent_for_user(account_id)
if not agent_id:
logger.warning(f"[SETUP] Failed to install Suna agent for {account_id}")
except Exception as e:
logger.error(f"[SETUP] Error installing Suna agent for {account_id}: {e}")
agent_id = None
if user_record:
raw_user_metadata = user_record.get('raw_user_meta_data', {})
referral_code = raw_user_metadata.get('referral_code')
logger.info(f"[SETUP] User metadata: {raw_user_metadata}")
logger.info(f"[SETUP] Referral code from metadata: {referral_code}")
if referral_code:
logger.info(f"[SETUP] Processing referral code for {account_id}: {referral_code}")
try:
from core.referrals.service import ReferralService
referral_service = ReferralService(db)
referrer_id = await referral_service.validate_referral_code(referral_code)
logger.info(f"[SETUP] Validated referral code {referral_code} -> referrer_id: {referrer_id}")
if referrer_id and referrer_id != account_id:
referral_result = await referral_service.process_referral(
referrer_id=referrer_id,
referred_account_id=account_id,
referral_code=referral_code
)
if referral_result.get('success'):
logger.info(
f"[SETUP] ✅ Referral processed: {referrer_id} referred {account_id}, "
f"awarded {referral_result.get('credits_awarded')} credits"
)
else:
logger.warning(f"[SETUP] Failed to process referral: {referral_result.get('message')}")
else:
logger.warning(
f"[SETUP] Invalid referral code or self-referral: {referral_code}, "
f"referrer_id={referrer_id}, new_user_id={account_id}"
)
except Exception as ref_error:
logger.error(f"[SETUP] Error processing referral: {ref_error}", exc_info=True)
logger.info(f"[SETUP] ✅ Account initialization complete for {account_id}")
return {
'success': True,
'message': 'Account initialized successfully',
'subscription_id': result.get('subscription_id'),
'agent_id': agent_id
}
except Exception as e:
logger.error(f"[SETUP] Error initializing account {account_id}: {e}")
return {
'success': False,
'message': str(e),
'error': str(e)
}
def _extract_user_name(user_record: dict, email: str) -> str:
"""Extract user name from metadata or email"""
raw_user_metadata = user_record.get('raw_user_meta_data', {})
return (
raw_user_metadata.get('full_name') or
raw_user_metadata.get('name') or
email.split('@')[0].replace('.', ' ').replace('_', ' ').replace('-', ' ').title()
)
def _send_welcome_email_async(email: str, user_name: str):
"""Send welcome email asynchronously (non-blocking)"""
try:
return email_service.send_welcome_email(
user_email=email,
user_name=user_name
)
except Exception as e:
logger.error(f"Failed to send welcome email to {email}: {e}")
return None
# ============================================================================
# API Endpoints
# ============================================================================
@router.post("/initialize")
async def initialize_account(
account_id: str = Depends(verify_and_get_user_id_from_jwt)
):
# Use singleton - already initialized at startup
db = DBConnection()
client = await db.client
email = None
user_record = None
try:
user_response = await client.auth.admin.get_user_by_id(account_id)
if user_response and hasattr(user_response, 'user') and user_response.user:
user = user_response.user
email = user.email
user_record = {
'id': user.id,
'email': user.email,
'raw_user_meta_data': user.user_metadata or {}
}
except Exception as e:
logger.warning(f"[SETUP] Could not fetch user for initialization: {e}")
result = await initialize_user_account(account_id, email, user_record)
if not result.get('success'):
raise HTTPException(status_code=500, detail=result.get('message', 'Failed to initialize account'))
return result
# ============================================================================
# Webhook Endpoints
# ============================================================================
@webhook_router.post("/webhooks/user-created", response_model=WebhookResponse)
async def handle_user_created_webhook(
payload: SupabaseWebhookPayload,
_: bool = Depends(verify_webhook_secret)
):
"""
Webhook endpoint called by Supabase database trigger when a new user is created.
This webhook is triggered automatically by a database trigger (trigger_welcome_email)
when a new row is inserted into auth.users table. The trigger makes an HTTP POST
request to this endpoint using pg_net.
This webhook automatically:
1. Initializes account (free tier subscription + Suna agent)
2. Sends welcome email
All initialization happens automatically on the backend, eliminating
the need for client-side initialization calls.
"""
try:
# Validate payload
if payload.type != "INSERT" or payload.table != "users":
return WebhookResponse(
success=False,
message="Invalid webhook payload"
)
user_record = payload.record
user_id = user_record.get('id')
email = user_record.get('email')
if not user_id:
logger.warning("User created webhook received without user ID")
return WebhookResponse(
success=False,
message="No user ID in user record"
)
if not email:
logger.warning("User created webhook received without email")
return WebhookResponse(
success=False,
message="No email in user record"
)
logger.info(f"🎉 New user signup: {email} (ID: {user_id})")
account_id = user_id
init_result = await initialize_user_account(account_id, email, user_record)
if init_result.get('success'):
logger.info(
f"✅ Account initialized for {email}: "
f"subscription={init_result.get('subscription_id')}, "
f"agent={init_result.get('agent_id')}"
)
else:
error_msg = init_result.get('message', 'Unknown error')
logger.error(f"⚠️ Account initialization failed for {email}: {error_msg}")
return WebhookResponse(
success=True,
message=f"User created webhook processed. Initialization: {'success' if init_result.get('success') else 'failed'}"
)
except Exception as e:
logger.error(f"Error handling user created webhook: {str(e)}")
return WebhookResponse(
success=False,
message=str(e)
)
# ============================================================================
# Vercel Analytics Drain Webhook
# ============================================================================
def verify_vercel_signature(payload: bytes, signature: str, secret: str) -> bool:
"""Verify Vercel Log Drain signature (HMAC-SHA1)."""
if not secret:
return False
expected = hmac.new(secret.encode(), payload, hashlib.sha1).hexdigest()
return hmac.compare_digest(expected, signature)
@webhook_router.post("/webhooks/vercel-drain")
async def receive_vercel_drain(
request: Request,
x_vercel_signature: Optional[str] = Header(None, alias="x-vercel-signature")
):
"""
Webhook endpoint for Vercel Analytics drains.
Receives pageview events and stores device IDs for unique visitor counting.
"""
body = await request.body()
# Verify signature if secret is configured
drain_secret = config.VERCEL_DRAIN_SECRET
if drain_secret:
if not x_vercel_signature:
raise HTTPException(status_code=401, detail="Missing signature")
if not verify_vercel_signature(body, x_vercel_signature, drain_secret):
raise HTTPException(status_code=401, detail="Invalid signature")
try:
# Parse the payload - Vercel sends NDJSON (newline-delimited JSON)
payload_str = body.decode('utf-8')
# Log payload length and sample
logger.debug(f"Vercel drain payload: {payload_str}")
# Parse all lines
parsed_items = []
for line in payload_str.strip().split('\n'):
if line:
parsed_items.append(json.loads(line))
# Flatten: each line could be a dict (single event) or list (array of events)
events = []
for item in parsed_items:
if isinstance(item, list):
events.extend(item)
elif isinstance(item, dict):
events.append(item)
db = DBConnection()
client = await db.client
# Process each event
processed = 0
skipped = 0
for event in events:
if not isinstance(event, dict):
continue
# Only track pageview events
if event.get('eventType') != 'pageview':
skipped += 1
continue
# Use deviceId for unique visitor tracking (it's numeric, convert to string)
raw_device_id = event.get('deviceId')
if raw_device_id is None:
continue
device_id = str(raw_device_id)
if not device_id:
continue
# Get timestamp and convert to date
timestamp = event.get('timestamp') or event.get('time') or event.get('ts')
if timestamp:
if isinstance(timestamp, (int, float)):
dt = datetime.fromtimestamp(timestamp / 1000, tz=timezone.utc)
else:
dt = datetime.fromisoformat(str(timestamp).replace('Z', '+00:00'))
event_date = dt.strftime('%Y-%m-%d')
else:
event_date = datetime.now(timezone.utc).strftime('%Y-%m-%d')
# Upsert the pageview (add device_id to array if not exists)
await client.rpc('upsert_vercel_pageview', {
'p_date': event_date,
'p_device_id': device_id
}).execute()
processed += 1
logger.info(f"Vercel drain: {processed} pageviews processed, {skipped} non-pageview skipped, {len(events)} total events")
return {"status": "ok", "processed": processed}
except json.JSONDecodeError as e:
logger.error(f"Failed to parse Vercel drain payload: {e}")
raise HTTPException(status_code=400, detail="Invalid JSON payload")
except Exception as e:
logger.error(f"Failed to process Vercel drain: {e}", exc_info=True)
raise HTTPException(status_code=500, detail="Failed to process events")
|