Changeset 2725
- Timestamp:
- 10/29/07 18:37:51 (1 year ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
wantedpagesplugin/trunk/wanted_pages/wanted_pages.py
r2167 r2725 14 14 exclude_re = re.compile(EXCLUDE) 15 15 16 wiki_sql = "SELECT name, text FROM wiki ORDER BY version "16 wiki_sql = "SELECT name, text FROM wiki ORDER BY version DESC" 17 17 ticket_sql= """SELECT id, description FROM ticket 18 18 UNION … … 56 56 texts = [] # list of referrer link, wiki-able text tuples 57 57 wantedPages = {} # referrers indexed by page 58 wikiPages = [] # list of wikiPages seen 58 59 db = self.env.get_db_cnx() 59 60 60 for name, text in exec_wiki_sql(db): 61 self.index[name] = name 62 texts.append(('[wiki:%s]' % name, text)) 61 for name, text in exec_wiki_sql(db): # query is ordered by latest version first 62 if name not in wikiPages: 63 wikiPages.append(name) 64 self.index[name] = name 65 texts.append(('[wiki:%s]' % name, text)) 63 66 64 67 for id, text in exec_ticket_sql(db):
