当实体明显存在于数据中时，GAE返回Nonetype

Question

当用户创建一个新事件时，他们输入“事件名称”和“事件时间”，并从下拉列表中选择位置。然后从匹配位置的PlaceModel实例检索事件的纬度和经度。你知道吗

问题是，当我要查找的PlaceModel实例存在时，localhost返回Nonetype。你知道吗

我的模型：

class PlaceModel(db.Model):
    place_name = db.StringProperty(required = True)
    place_lat = db.StringProperty(required = True)
    place_long = db.StringProperty(required = True)
    def render(self):
        return render_str("placemodel.html", p = self)

class EventModel(db.Model):
    event_place = db.ReferenceProperty(PlaceModel)

    event_name = db.StringProperty(required = True)
    event_time = db.StringProperty(required = True)
    def render(self):
        return render_str("eventmodel.html", e = self)

html：

<select name = "place_name">
{% for place in allplaces %}
    <option name = "place_name" value = {{place_name}}> {{place.place_name}}</option>
{%endfor%}
</select>

Python：

class NewEvent(Handler):
   def get(self):
        if self.user:
            allplaces = PlaceModel.all()
            self.render("newevent.html", allplaces = allplaces)
        else:
            self.redirect("/signup")

   def post(self):
        event_name = self.request.get("event_name")
        event_time = self.request.get("event_time")
        place_name = self.request.get_all("place_name")

        if event_name and event_time and place_name:
            place_lat = PlaceModel.gql("where place_name = :place_name", place_name = place_name).get().place_lat
            place_long = PlaceModel.gql("where place_name = :place_name", place_name = place_name).get().place_long

            event_place = PlaceModel(parent = place_key(), 
                            place_name = place_name, place_lat = place_lat, place_long = place_long)

            event = EventModel(parent = event_key(),
                    event_name = event_name, event_time = event_time, 
                    event_place = event_place)

            event.put()
            stat = "your event has been recorded"
            self.render('newevent.html', stat = stat)
        else:
            allplaces = PlaceModel.all()

            error = "fill in all the boxes"
            self.render("newevent.html", error = error, allplaces = allplaces,
                        event_name = event_name, event_time = event_time)

怎么了？？为什么gql返回nonetype？你知道吗

编辑： 错误日志的（后半部分）：

File "/Users/yingjiefu/Documents/munchkin/munchkin.py", line 195, in post
    place_lat = PlaceModel.gql("where place_name = :place_name", place_name = place_name).get().place_lat
AttributeError: 'NoneType' object has no attribute 'place_lat'

编辑：现在可以了！你知道吗

Python：

class NewEvent(Handler):
   def get(self):
        if self.user:
            allplaces = PlaceModel.all()
            self.render("newevent.html", allplaces = allplaces)
        else:
            self.redirect("/signup")

   def post(self):
        event_name = self.request.get("event_name")
        event_time = self.request.get("event_time")
        place_name = self.request.get("place_name")

        if event_name and event_time and place_name:
            place = PlaceModel.all().filter("place_name", place_name).get()
            place_lat = place.place_lat
            place_long = place.place_long


            event = EventModel(parent = event_key(),
                    event_name = event_name, event_time = event_time, 
                    event_place = place)

            event.put()
            stat = "your event has been recorded"
            allplaces = PlaceModel.all()
            self.render('newevent.html', stat = stat, allplaces = allplaces)
        else:
            allplaces = PlaceModel.all()

            error = "fill in all the boxes"
            self.render("newevent.html", error = error, allplaces = allplaces,
                        event_name = event_name, event_time = event_time)

html：

<select name = "place_name" >
{% for place in allplaces %}
    <option value = "{{ place.place_name }}">{{ place.place_name }}</option>
{% endfor %}
</select>

Answer 1

这段代码有很多问题。你知道吗

我认为主要的问题在于如何定义选项中的值。不仅不能用引号将其括起来，实际上还使用了一个不存在的变量：place_name。应该是这样的：

<option name="place_name" value="{{place_name}}">{{place.place_name}}</option>

其次，在从请求中提取place_name值时使用get_all()。据我所知，它返回一个列表，因此在GQL的占位符中有多个值。您应该使用get()，就像您对其他变量所做的那样。你知道吗

第三，与你的问题无关，但为什么你要做两次完全相同的查询？那要花你两倍的钱，没有理由。获取一次并将其存储在变量中：

place = PlaceModel.gql("where place_name = :place_name", place_name=place_name).get()
place_lat = place.place_lat
place_long = place.place_long

（我甚至不会问您为什么要使用GQL而不是普通的查询语法，后者要短得多：PlaceModel.all().filter('place_name', place_name)-您确实意识到它们都被转换为相同的RPC调用，而且GQL在任何方面都不比模型版本更“原生”）你知道吗