Mercurial > hg > MPIWGWeb

comparison MPIWGStaff.py @ 59:d452fff7c52e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
getLastArrivals changed
author dwinter
date Thu, 02 May 2013 10:14:52 +0200
parents 84879a3f91a6
children 63184d71c014 2ad8aa9d306c
comparison
equal deleted inserted replaced
58:09900782c855 59:d452fff7c52e
1139 return [] 1139 return []
1140 1140
1141 def getLastArrivals(self,limit=None): 1141 def getLastArrivals(self,limit=None):
1142 """getlast arrivals""" 1142 """getlast arrivals"""
1143 if not limit: 1143 if not limit:
1144 selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from DESC" 1144 selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' and date_from < CURRENT_DATE order by date_from DESC"
1145 else: 1145 else:
1146 selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' order by date_from DESC limit %s"%limit 1146 selectStr="select * from personal_www_list_web where publish_the_data = 'yes' and is_scholar='yes' and date_from < CURRENT_DATE order by date_from DESC limit %s"%limit
1147 1147
1148 res=self.members.executeZSQL(selectStr) 1148 res=self.members.executeZSQL(selectStr)
1149 1149
1150 return res 1150 return res
1151 1151