如何在SQLAlchemy中使用interween子句

2024-10-04 05:23:02 发布

您现在位置:Python中文网/ 问答频道 /正文

我的模型是

class RidesModel(db.Model):
__tablename__ = "rides"

ride_id = db.Column(db.Integer, primary_key=True)

start_address = db.Column(db.String())
end_address = db.Column(db.String())
ride_datetime = db.Column(db.DateTime(), nullable=False)
ride_by = db.Column(db.String(), db.ForeignKey("users.email"), nullable=False)
ride_created_on = db.Column(db.DateTime(), nullable=False)


@classmethod
def find_by_email(cls, _email: str) -> "RidesModel":
    return cls.query.filter_by(ride_by=_email).all()

@classmethod
def find_between_dates(cls, _email: str, dt1, dt2) -> "RidesModel":
    return cls.query.filter_by(
            ride_by=_email,
            ride_datetime.between(dt1, dt2)

    ).all()

mthod find_by_email工作正常,但find_between_dates给出了一个错误 这是行不通的。我在控制台中发现错误

m_rides.py", line 42
    ride_datetime.between(dt1, dt2)
    ^
SyntaxError: positional argument follows keyword argument

pyCharm说"Positional argument after keyword argument"

谁能帮帮我吗


Tags: falsedbdatetimestringbyemailcolumnbetween