Quickly format strings for searchstring in the mysql client

bookwormFormat.py

"""
This uses a fake sprintf style construction to handle easily resetting searchstrings without rebuilding the whole database.

Anything in a string like this:
%(blah blah)s

will be broken out in mysql as a literal.

By default, this assumes you only need the "catalog" field: things will get strange if you try to use any non-unique fields.



"""

import re
import MySQLdb

format="""<img src="http://chroniclingamerica.loc.gov/lccn/%(paper)s/%(FROM_DAYS(publish_day))s)/ed-%(edition)s/seq-1/thumbnail.jpg"</img> <a href="http://chroniclingamerica.loc.gov/lccn/%(paper)s/%(FROM_DAYS(publish_day))s/ed-%(edition)s/seq-1">Read online</a>"""

def CreateSearchstring(format):
    format = MySQLdb.escape_string(format)
    lit = 'CONCAT("' + re.sub(r"%\((.*?)\)s",r'",\1,"',format) + '")'
    return "UPDATE catalog SET catalog.searchstring=%s;" %lit