Need to capture/fetch a date from mysql using a primary key

See more:

MySQL

Python

API

I want to fetch a date from mysql workbench according to a certain id (msisdn). But I don't know how to do it with SQLAlchemy with FastApi framework. msisdn is the primary key.

Models:

class PortabilidadInfo(Base):
      __tablename__ = "portabilidad"
      msisdn = Column(Integer, primary_key=True)
      operator_id = Column(Integer, nullable=True)
      last_port = Column(Date, default=datetime.now(), nullable=True)

Code:

portabilidad_msisdn = '56977095634'
         
date_info = session.query(PortabilidadInfo).filter(PortabilidadInfo.last_port, PortabilidadInfo.msisdn == portabilidad_msisdn).first()
print("FECHA BDD OBJ: ", date_info, type(date_info))

what i'm doing wrong?. Please help

What I have tried:

portabilidad_msisdn = '56977095634'
         
date_info = session.query(PortabilidadInfo).filter(PortabilidadInfo.last_port, PortabilidadInfo.msisdn == portabilidad_msisdn).first()
print("FECHA BDD OBJ: ", date_info, type(date_info))