File size: 1,002 Bytes
c3bf538 c6fb015 c3bf538 c6fb015 c3bf538 |
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 |
# from sqlalchemy import Column, String, JSON
# from sqlalchemy.dialects.postgresql import UUID
# import uuid
# from core.database import Base
# class AnalysisJob(Base):
# __tablename__ = "analysis_jobs"
# id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
# ticker = Column(String, nullable=False, index=True)
# status = Column(String, default="PENDING", nullable=False)
# result = Column(JSON, nullable=True)
from sqlalchemy import Column, String, JSON, DateTime
from sqlalchemy.dialects.postgresql import UUID
import uuid
from core.database import Base
from datetime import datetime
class AnalysisJob(Base):
__tablename__ = "analysis_jobs"
id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
ticker = Column(String, nullable=False, index=True)
status = Column(String, default="PENDING", nullable=False)
result = Column(JSON, nullable=True)
created_at = Column(DateTime, default=datetime.utcnow, nullable=False) |