<center id="pz5tg"></center>
  1. <object id="pz5tg"></object>

    <code id="pz5tg"><small id="pz5tg"></small></code>

    #!c:/python25/python.exe
    from __future__ import with_statement
    import os
    import re
    import sqlite3
    import string
    
    def as_code (title):
      title = re.sub ("|".join ("\\%s" % i for i in string.punctuation), "", title.lower ())
      return "-".join (title.split ())
    
    db = sqlite3.connect ("books.db")
    for title, image in db.execute ("SELECT title, image FROM whatsnew"):
      if image:
        filename = os.path.join ("thumbnails", as_code (title) + ".jpg")
        print filename
        with open (filename, "wb") as f:
          f.write (image)
    
    11