def get(self): num_months = 3 now = datetime.datetime.now() assignment_query = Assignment.get_all() assignment_query.order("end_date") logging.info("it worked")
def populate(self): # country = self.request.get("country") # partner = self.request.get("partner") # project = self.request.get("project") # site = self.request.get("site") oneweek = datetime.timedelta(days=7) weeks = [ x[0] for x in self.calendar.monthdatescalendar(self.year, self.month) if x[0].month == self.month ] a_query = Assignment.get_all() #_all() a_query.filter("end_date >", weeks[0]) for week in weeks: a_query.filter("end_date >", week).order("end_date") # a_query = db.GqlQuery("SELECT * FROM Assignment WHERE start_date < :1 ORDER BY start_date, end_date DESC", week + oneweek) assignments = [a for a in a_query] assignments = filter(lambda a: week >= a.start_date.date(), assignments) # if country: # assignments = filter(lambda a: a.site.country == country, assignments) # if partner: # assignments = filter(lambda a: unicode(a.partner.key()) == unicode(partner), assignments) # if project: # assignments = filter(lambda a: unicode(a.project.key()) == unicode(project), assignments) # if site: # assignments = filter(lambda a: unicode(a.site.key()) == unicode(site), assignments) if len(assignments) > 0: # assignments = sorted(assignments, key=lambda a: a.site.country) assignments = sorted(assignments, key=lambda a: a.project.name) new_week = Week(week) new_week.setAssignments(assignments) self.addWeek(new_week)
def populate(self): # country = self.request.get("country") # partner = self.request.get("partner") # project = self.request.get("project") # site = self.request.get("site") oneweek = datetime.timedelta(days=7) weeks = [x[0] for x in self.calendar.monthdatescalendar(self.year, self.month) if x[0].month == self.month] a_query = Assignment.get_all()#_all() a_query.filter("end_date >", weeks[0]) for week in weeks: a_query.filter("end_date >", week).order("end_date") # a_query = db.GqlQuery("SELECT * FROM Assignment WHERE start_date < :1 ORDER BY start_date, end_date DESC", week + oneweek) assignments = [a for a in a_query] assignments = filter(lambda a: week >= a.start_date.date(), assignments) # if country: # assignments = filter(lambda a: a.site.country == country, assignments) # if partner: # assignments = filter(lambda a: unicode(a.partner.key()) == unicode(partner), assignments) # if project: # assignments = filter(lambda a: unicode(a.project.key()) == unicode(project), assignments) # if site: # assignments = filter(lambda a: unicode(a.site.key()) == unicode(site), assignments) if len(assignments) > 0: # assignments = sorted(assignments, key=lambda a: a.site.country) assignments = sorted(assignments, key=lambda a: a.project.name) new_week = Week(week) new_week.setAssignments(assignments) self.addWeek(new_week)