MySQL Connectivity With Python - Endgame (
Page 7 of 7 )
A number of other methods come bundled with the MySQLdb class - here's a brief list of the more interesting ones:
connection.begin() - start a transaction
connection.apilevel() - returns the current DB API level
connection.conv() - set type conversion options between MySQL and Python
connection.commit() - commit a transaction
connection.rollback() - roll back a transaction
And that's about all for the moment. In this article, I showed you how to configure and install the Python MySQLdb module, and use it to hook your Python scripts up to a MySQL database. I demonstrated the different techniques available for iterating over a resultset, showed you the basics of using variable placeholders and prepared queries, and illustrated some of the ancillary methods available in the module.
While this tutorial should get you and running with Python and MySQL, you shouldn't stop reading right away. Here are a few links worth checking out:
The MySQLdb project page on SourceForge, at
http://sourceforge.net/projects/mysql-pythonThe Python home page, at
http://www.python.org/The MySQL home page, at
http://www.mysql.com/Till next time...be good!
Note: All examples in this article have been tested on Linux/i586 with Python 1.5.2, MySQL 3.23 and MySQLdb 0.9.2. Examples are illustrative only, and are not meant for a production environment. Melonfire provides no warranties or support for the source code described in this article. YMMV!