def getRecentChanges(self, req, since):
""" Get list of changed pages since timestamp """
since = to_timestamp(since)
db = self.env.get_db_cnx()
cursor = db.cursor()
cursor.execute('SELECT name, max(time), author, version FROM wiki'
' WHERE time >= %s GROUP BY name ORDER BY max(time) DESC', (since,))
result = []
for name, time, author, version in cursor:
result.append(self._page_info(name, time, author, version))
return result
def getRecentChanges(self, req, since):
"""Returns a list of IDs of tickets that have changed since timestamp."""
since = to_timestamp(since)
db = self.env.get_db_cnx()
cursor = db.cursor()
cursor.execute('SELECT id FROM ticket'
' WHERE changetime >= %s', (since,))
result = []
for row in cursor:
result.append(int(row[0]))
return result
def getRecentChanges(self, req, since):
""" Get list of changed pages since timestamp """
since = to_timestamp(since)
db = self.env.get_db_cnx()
cursor = db.cursor()
cursor.execute(
'SELECT name, max(time), author, version FROM wiki'
' WHERE time >= %s GROUP BY name ORDER BY max(time) DESC',
(since, ))
result = []
for name, time, author, version in cursor:
result.append(self._page_info(name, time, author, version))
return result
