Python GQL查询不工作

Question

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

我做错了什么。。。在

谢谢。。在

Answer 1

使用参数（示例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)

Answer 2

您还可以使用更“Pythonic”模型API：

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