Spaces:
Paused
Paused
| from sqlalchemy import Column, Integer, String, LargeBinary, DateTime, Text, ForeignKey | |
| from sqlalchemy.orm import declarative_base | |
| from sqlalchemy.orm import relationship | |
| from datetime import datetime | |
| from app.core.config import settings | |
| from app.database.connection import engine | |
| from sqlalchemy.dialects.postgresql import UUID | |
| import uuid | |
| Base=declarative_base() | |
| class Patient(Base): | |
| __tablename__ = "patients" | |
| id = Column(Integer, primary_key=True, index=True) | |
| username = Column(String(100), index=True, nullable=False) | |
| email = Column(String(255), unique=True, index=True, nullable=False) | |
| password_hash = Column(String(60), nullable=False) # bcrypt/argon2 hash only, never plaintext | |
| city = Column(String(100), nullable=True) | |
| state = Column(String(100), nullable=True) | |
| country = Column(String(100), nullable=True) | |
| tumor_type = Column(String(100), nullable=False) | |
| # MRI stored in Cloudinary/object storage, not in the DB | |
| mri_image_url = Column(String(500), nullable=True) | |
| mri_image_public_id = Column(String(255), nullable=True) # e.g. Cloudinary public_id, for deletion/updates | |
| # One thread per patient for persistent conversational context | |
| user_chat_thread = Column(UUID(as_uuid=True), default=uuid.uuid4, unique=True, index=True, nullable=False) | |
| created_at = Column(DateTime, default=datetime.utcnow, nullable=False) | |
| updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow, nullable=False) | |
| async def create_tables(): | |
| async with engine.begin() as conn: | |
| await conn.run_sync(Base.metadata.create_all) | |
| import asyncio | |
| # if __name__ == "__main__": | |
| # asyncio.run(create_tables()) | |
| # print("Tables created successfully") | |