class Goal(SQLModel, table=True):
id: int | None = Field(default=None, primary_key=True)
name: str = Field(default=None, unique=True)
- start_date: dt | None = Field(default=today())
+ start_date: dt | None = Field(default=dt.today())
complete_date: dt | None = Field(default=None)
vision_id: int | None = Field(default=None, foreign_key="vision.id")
notes: str | None = Field(default=None)
def get_current_goals(self):
'''List current goals'''
with Session(self.engine) as session:
- cmd = select(Goal).where(Goal.complete_date == None).where(Goal.start_date <= today())
- # cmd = select(Goal).where(Goal.complete_date == None)
- return session.exec(cmd).all()
+ cmd = select(Goal).where(Goal.complete_date == None).where(Goal.start_date <= dt.today())
+ results = session.exec(cmd).all()
+ logger.debug(f'Current goals: {results}')
+ return results
def get_done_goals(self):
'''List completed goals'''