从MySQL工作台数据库中捕获FastApi数据

Question

我正在尝试从我的MySQL工作台数据库中获取日期。但是我在终点站得到了一个“零”的结果。如何做到这一点呢？我正在尝试使用FastApi框架的ORM。

有人能帮我吗？

模型：

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)

代码：

  last_portability = row[7]     # 2022-04-03  06:00:00
  last_portability_obj = datetime.strptime(last_portability, '%Y-%m-%d %H:%M:%S')
  print("OBJ FECHA: ", last_portability_obj, type(last_portability_obj))
                        
  ## FETCH DATE DATA FROM DATABASE
  date_info = session.query(PortabilidadInfo).get(last_portability_obj)
  print("XXXXXX: ", date_info, type(date_info))

Answer 1

我找到了解决办法。我会复制下面的代码。

## BUSCO FECHA EN CSV ##
last_portability = row[7]     # 2022-04-03 06:00:00 'str'
print("FECHA CSV: ", last_portability, type(last_portability))

# FETCH DATE DATA FROM DATABASE
date_info = session.query(PortabilidadInfo).filter(
PortabilidadInfo.last_port == last_portability).first()
print("FECHA BDD: ", date_info, type(date_info))


TERMINAL: 

FECHA CSV:  2020-04-23 6:00:00 <class 'str'>

FECHA BDD:  <models.portabilidad.PortabilidadInfo object at 0x7fdc38cc3470> <class 'models.portabilidad.PortabilidadInfo'>