DB中のURLをTeXのリスト形式にして出力

convert_table.py

#!/usr/bin/env python
# -*- coding:utf-8 -*-
import sys
import MySQLdb

con = MySQLdb.connect(db='webpage_test',user='',passwd='',
        use_unicode=True,charset='utf8')
cur = con.cursor()

first = int(sys.argv[1])
num = int(sys.argv[2])
cur.execute('select url from webpage_test limit %d,%d' % (first,num))
rows = cur.fetchall()

for row in rows:
    url = row[0].replace('&',r'\&').replace('%',r'\%').replace('_',r'\_')
    print r'\item',url