def get_news_list(self, request):
items = []
#
# DB QUERIES
#
# TODAY
today = datetime.datetime.now()
yesterday = today - datetime.timedelta(days=1)
# EVENTS
events_query = DBEvent.query_entries()
events_query = events_query.order(DBEvent.date)
events_query_results = events_query.filter(DBEvent.date >= yesterday).fetch(request.maxResults)
# TOP: 1 St Event
for entity in events_query_results[:1]:
items.append(entity.to_news_message())
clubs_query = DBClub.query(DBClub.open_days==request.openDay)
clubs_query = clubs_query.order(-DBClub.rating)
clubs_query_results = clubs_query.fetch(request.maxResults)
# 4 OPEN CLUBS TODAY
for entity in clubs_query_results[:4]:
items.append(entity.to_news_message())
#
# Layer Clubs / News ( Prototype Sequence )
#
if len(events_query_results) > 1:
for index in range(1,len(events_query_results)):
items.append(events_query_results[index].to_news_message())
if len(clubs_query_results) > 4:
for index in range(4,len(clubs_query_results)):
items.append(clubs_query_results[index].to_news_message())
return NewsList(items=items)
def insert_club_entry(self, request):
entity = DBClub.put_from_message(request)
return entity.to_message()
def get_club_list(self, request):
query = DBClub.query_entries()
query = query.order(-DBClub.rating).order(DBClub.cover)
items = [entity.to_message() for entity in query.fetch(request.maxResults)]
return ClubList(items=items)
