import sys
from pathlib import Path
sys.path.insert(0, str(Path(__file__).parents[3] / 'base_platform'))
from sqlalchemy import text
from app.db.session import SessionLocal

def seed_cases(tenant_id: int):
    db = SessionLocal()
    try:
        db.execute(text(f'SET search_path TO tenant_{tenant_id}, public'))
        print(f'✓ Tax cases seeded for tenant {tenant_id} (placeholder)')
        db.commit()
    except Exception as e:
        db.rollback()
        print(f'✗ Failed to seed cases for tenant {tenant_id}: {e}')
        raise
    finally:
        db.close()