Databases
StackOverflow2013
Postsdbo
POVoteHandler in Google App Engine
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVoteHandler in Google App Engine
    primarykey
    data
    text
    <p>I am trying to have this function limit a user to only one vote per image. However it currently lets all votes through. If I change "if existing_vote != 0:" to "if existing_vote == 0:" it lets no votes through. Thoughts? </p> <p>class VoteHandler(webapp.RequestHandler):</p> <pre><code>def get(self): #See if logged in self.Session = Session() if not 'userkey' in self.Session: doRender( self, 'base/index.html', {'error' : 'Please login to vote'}) return #If user hasn't voted - if user doesn't have a vote on that image object key = self.request.get('photo_id') vurl = models.Image.get_by_id(int(key)) #pull current site vote total &amp; add 1 existing_vote = models.Vote.all().filter('user=', self.Session['userkey']).filter('photo=',vurl).count() if existing_vote != 0: self.redirect('/', { }) else: newvote = models.Vote(user=self.Session['userkey'], url=vurl) vurl.votes += 1 vurl.put() logging.info('Adding a vote') #Create a new Vote object newvote = models.Vote(user=self.Session['userkey'], url=vurl) newvote.put() self.redirect('/', { }) </code></pre> <p>For the Models:</p> <p><strong>class User(db.Model):</strong></p> <p>account = db.StringProperty()</p> <p>password = db.StringProperty()</p> <p>name = db.StringProperty()</p> <p>created = db.DateTimeProperty(auto_now=True)</p> <p><strong>class Image(db.Model):</strong></p> <p>user = db.ReferenceProperty(User)</p> <p>photo_key = db.BlobProperty()</p> <p>website = db.StringProperty()</p> <p>text = db.StringProperty()</p> <p>created = db.DateTimeProperty(auto_now=True)</p> <p>votes = db.IntegerProperty(default=1)</p> <p><strong>class Vote(db.Model):</strong></p> <p>user = db.ReferenceProperty(User) #See if voted on this site yet</p> <p>photo = db.ReferenceProperty(Image) #To apply vote to right URL</p> <p>upvote = db.IntegerProperty(default=1)</p> <p>created = db.DateTimeProperty(auto_now=True) </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEmile
    1. USEmile
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POVoteHandler in Google App Engine
      1. USductionist
      1. VTFavorite
    2. VO
      singulars
      1. POVoteHandler in Google App Engine
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POVoteHandler in Google App Engine
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhat does the count equal? Add a logging statement and try to figure out what this is actually returning: existing_vote = models.Vote.all().filter('user=', self.Session['userkey']).filter('photo=',vurl).count() A better implementation would be to create a vote class as a child object of the User in an entity group with the photoId as a key. Off topic, but do you mind me asking why you implemented your own User class instead of using Google Accounts or OpenID?
      singulars
      1. POVoteHandler in Google App Engine
      1. USIkai Lan
    2. CO1. Logs show existing_vote = 0 2. n00b here, and was going off tutorial in a book that created a User class...
      singulars
      1. POVoteHandler in Google App Engine
      1. USEmile
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload