Changeset 624
- Timestamp:
- 04/06/06 01:54:37 (3 years ago)
- Files:
-
- wikirenamescript/0.9/RenamePage.py (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
wikirenamescript/0.9/RenamePage.py
r456 r624 69 69 # Get a list of all wiki pages containing links to the old page 70 70 if debug: print "Trying to fix links" 71 sql = 'SELECT w1.version,w1.name,w1.text' + sqlbase + 'AND w1.text like \'%%[wiki:%s %%\''% oldname71 sql = 'SELECT w1.version,w1.name,w1.text' + sqlbase + "AND w1.text like '%%[wiki:%s%%'" % oldname 72 72 cursor.execute(sql) 73 73 74 74 # Rewrite all links to the old page, such as to point to the new page 75 75 for row in cursor: 76 newtext = sre.sub('\[wiki:%s '%oldname,'[wiki:%s'%newname,row[2])76 newtext = sre.sub('\[wiki:%s'%oldname,'[wiki:%s'%newname,row[2]) 77 77 cursor.execute('UPDATE wiki SET text=%s WHERE name=%s AND version=%s', (newtext,row[1],row[0])) 78 78
