Python GQL查询无效

Question

    ID = int(data_key)
    results = db.GqlQuery("SELECT * FROM PatientMeds WHERE patientinfo_ID='ID'")

我哪里做错了...

谢谢..

Answer 1

你也可以使用更“符合Python风格”的模型API：

from path.to.your.models import PatientMeds
results = PatientMeds.all().filter('patientinfo_ID =', int(data_key))

Answer 2

使用一个参数（示例可以参考1和2）：

ID = int(data_key)
results = db.GqlQuery("SELECT * FROM PatientMeds WHERE patientinfo_ID=:1", ID)
# or
results = db.GqlQuery("SELECT * FROM PatientMeds WHERE patientinfo_ID=:id", id=ID)