#
# BackLinks plugin for Trac
# Version: 5.0
#
# Author: Trapanator trap@trapanator.com
# Website: http://www.trapanator.com/blog/archives/category/trac
# License: GPL 3.0
#
from StringIO import StringIO
def execute(hdf, args, env):
	db = env.get_db_cnx()
	cursor = db.cursor()
	thispage = None
	if args:
		thispage = args.replace('\'', '\'\'')
	else:
		thispage = hdf.getValue('wiki.page_name', '')
	sql = 'SELECT w1.name FROM wiki w1, ' + \
		  '(SELECT name, MAX(version) AS VERSION FROM WIKI GROUP BY NAME) w2 ' + \
		  'WHERE w1.version = w2.version AND w1.name = w2.name '
	if thispage:
			sql += 'AND (w1.text LIKE \'%%[wiki:%s %%\' ' % (unicode(thispage, "utf-8").encode ("utf-8"))
			sql += 'OR w1.text LIKE \'%%[wiki:%s]%%\')' % (unicode (thispage, "utf-8").encode ("utf-8"))
	cursor.execute(sql)
	buf = StringIO()
	buf.write('<hr style="width: 10%; padding: 0; margin: 2em 0 1em 0;"/>')
	buf.write('Pages linking to %s:\n' % (unicode (thispage, "utf-8")))
	buf.write('<ul>')
	while 1:
		row = cursor.fetchone()
		if row == None:
			break
		s2 = unicode (thispage, "utf-8")
		if row[0] == s2:
			pass
		else:
			buf.write('<li><a href="%s">' % env.href.wiki(row[0]))
			buf.write(row[0])
			buf.write('</a></li>\n')
	buf.write('</ul>')
	return buf.getvalue()