Directory search application

Jain Contacts Campaign System
==================================
Schema: public.jain_contacts (bigserial id)
Columns: id, name, mobile, email, email_contact, address,
city, pincode, state, company, salary,
work_experience, level, created_at

WHAT IS NEW IN v3
------------------
- Engine matches actual Supabase schema (no generated columns)
- All segment filtering done via Supabase query (not Python)
- contact_id stored as text (bigserial -> text compatible)
- AI Enrichment panel in jain_search.html:
Select contacts -> click "Enrich with AI"
Choose free OpenRouter model (no cost, no card)
Get: Professional Summary, Outreach Message,
Company Insights, Lead Score, Interest Tags
Export enriched results as CSV

SETUP ORDER
-----------
1. Run jain_campaigns_schema_v3.sql in Supabase SQL Editor

2. Import contacts (if not done):
pip install supabase python-dotenv
python import_jain_v2.py --file merged_deduped.csv --limit 500

3. Install and run locally:
pip install -r requirements.txt
python jain_engine_v3.py
Test: http://localhost:5001/health

4. Open HTML files:
jain_search.html - Search + AI Enrichment
jain_campaign_v2.html - Launch campaigns
jain_dashboard_v2.html - Monitor live pipeline

DEPLOY TO PYTHONANYWHERE (FREE, ALWAYS ON)
------------------------------------------
1. pythonanywhere.com -> Create free Beginner account
2. Files tab -> Upload: jain_engine_v3.py + requirements.txt
3. Consoles -> Bash:
mkvirtualenv --python=/usr/bin/python3.11 jain-venv
pip install -r requirements.txt
4. Web tab -> Add new web app -> Manual -> Python 3.11
5. Source code: /home/YOUR_USERNAME
Virtualenv: jain-venv
6. Click WSGI file link -> delete all -> paste wsgi_pythonanywhere.py
Edit YOUR_USERNAME and all credentials -> Save
7. Reload -> test:
https://YOUR_USERNAME.pythonanywhere.com/health

DEPLOY TO RENDER/RAILWAY (FREE)
--------------------------------
1. Push these files to a GitHub repo:
jain_engine_v3.py, requirements.txt, Procfile, runtime.txt
2. Connect repo to Railway or Render
3. Add environment variables from wsgi_pythonanywhere.py
4. Deploy -> get URL like https://jain-engine.up.railway.app

AI ENRICHMENT (in jain_search.html)
--------------------------------------
1. Search and find contacts
2. Select contacts using checkboxes
3. Click "Enrich with AI" button
4. Enter OpenRouter API key (free at openrouter.ai - no card)
5. Choose model (Llama 3.3 70B recommended)
6. Select enrichment types
7. Click "Enrich Selected Contacts"
8. Results show inline per contact
9. Click "Export Enriched CSV" to download

SEGMENTS
--------
email_ready - email not null
whatsapp - mobile not null
both - email + mobile
professionals - company + email
senior - Manager/Director/VP level
with_salary - salary not null
experienced - work_experience not null
maharashtra - Maharashtra state
delhi - Delhi state
rajasthan - Rajasthan state
gujarat - Gujarat state
mp - Madhya Pradesh state
all_contacts - everyone