Steve Holden wrote:
[...]
However, the code to extract the news is pretty simple. Here's the whole program, modulo newsreader wrapping. It would be shorter if I weren't stashing the extracted links it a relational database:
[...]
I see that, as is so often the case, I only told half the story, and you will be wondering what the "db" module does. The main answer is adapts the same logic to two different database modules in an attempt to build a little portability into the system (which may one day be open sourced).
The point is that MySQLdb requires a "%s" in queries to mark a substitutable parameter, whereas mxODBC requires a "?". In order to work around this difference the db module is imported by anything that uses the database. This makes it easier to migrate between different database technologies, though still far from painless, and allows testing by accessing a MySQL database directly and via ODBC as another option.
Significant strings have been modified to protect the innocent.
--------
#
# db.py: establish a database connection with
# the appropriate parameter style
#
try:
import MySQLdb as db
conn = db.connect(host="****", db="****",
user="****", passwd="****")
pmark = "%s"
print "Using MySQL"
except ImportError:
import mx.ODBC.Windows as db
conn = db.connect("****", user="****", password="****")
pmark = "?"
print "Using ODBC"
--------
regards
Steve
--
Steve Holden http://www.holdenweb.com/
Python Web Programming http://pydish.holdenweb.com/
Holden Web LLC +1 703 861 4237 +1 800 494 3119
--
http://mail.python.org/mailman/listinfo/python-list
