models.py

# coding: utf-8
from google.appengine.ext import db

from datetime import date, datetime

# HOrario de verão
timezone = 2

#Horario Normal
#timezone = 3

def por_count(item):
    return item.get('count','')

class RegistraCafe(db.Model):

  user = db.UserProperty()
  date_creation = db.DateTimeProperty()

  @classmethod
  def getAll(self, limit=0):
    filter = db.GqlQuery("SELECT * FROM RegistraCafe ORDER BY date_creation DESC")

    return filter #RegistraCafe.all() #.fetch(100)

  @classmethod
  def getJaFez(self):
      now = datetime.now()

      if now.hour-timezone < 12:
          start_date = datetime(now.year,now.month,now.day,0,0,0)
          end_date = datetime(now.year,now.month,now.day,12,0,0)
      else:
          start_date = datetime(now.year,now.month,now.day,12,0,0)
          end_date = datetime(now.year,now.month,now.day,23,59,0)


      #result = RegistraCafe.all().filter("date_creation >=", start_date).filter("date_creation <=", end_date)
      result = db.GqlQuery("SELECT * FROM RegistraCafe WHERE date_creation >= :1  AND date_creation <= :2 ", start_date,end_date)

      return result.count()

  @classmethod
  def getQuantidadeCafe(self):
      dados = self.getAll()

      L = []
      for item in dados:
        D = {}
        #result =  RegistraCafe.all().filter('user =',item.user)
        result = db.GqlQuery("SELECT * FROM RegistraCafe WHERE user = :1 ",item.user)

        email = item.user.email()
        D['user_email'] = email

        if email == 'mauriciosousa@liberiun.com':
            D['count'] = 70 + result.count()
        elif email == 'denisraison@liberiun.com':
            D['count'] = 63 + result.count()
        elif email == 'jeffersonramal@liberiun.com':
            D['count'] = 59 + result.count()
        elif email == 'matheusfranca@liberiun.com':
            D['count'] = 51 + result.count()
        elif email == 'cesaraugusto@liberiun.com':
            D['count'] = 45 + result.count()
        elif email == 'talitaaquino@liberiun.com':
            D['count'] = 13 + result.count()
        elif email == 'edgarbruno@liberiun.com':
            D['count'] = 45 + result.count()

        else:
            D['count'] = result.count()

        if not D in L:
            L.append(D)

      return sorted(L, key=por_count,reverse=True)


  @property
  def dateTimeText(self):
    return self.date_creation.strftime("%d.%m.%Y  - %H:%M")


  @property
  def userName(self):
    return self.user.email()