[Tutor] Python with MySQL ?

[John Purser]

A year of so ago I had a major data conversion project to deal with and used
python, mysql, and the resources listed below to "get 'er done" (my abject
apologies to the non-American readers who will not get that reference).  It
was very quick to get real results with this toolset.

John Purser

-----Original Message-----
From: tutor-bounces at python.org [mailto:tutor-bounces at python.org] On Behalf
Of Danny Yoo
Sent: Tuesday, January 11, 2005 10:56
To: Mark Kels
Cc: tutor at python.org
Subject: Re: [Tutor] Python with MySQL ?



On Tue, 11 Jan 2005, Mark Kels wrote:

> How can I send SQL querys to a MySQL database with a python-CGI program ?

Hi Mark,


You'll want to grab a "Python DB API" module for MySQL.  The best one I've
seen for MySQL is 'MySQLdb':

    http://sourceforge.net/projects/mysql-python

and you should probably grab that for your system.  It should come with
some examples to help you get started.


Python.org has a section on Python's database support:

    http://www.python.org/topics/database/

with some documentation.  There used to be a tutorial linked from Linux
Journal there, but it's now restricted to subscribers!  *grrrr*



Here's an example program just to see how the pieces fit together:

###
import MySQLdb
connection = MySQLdb.connect(db="magic", user="dyoo",
                             password="abracadabra")
cursor = connection.cursor()
cursor.execute("""select name from cards where
                  tournament_type = 'restricted'""")
for (name,) in cursor.fetchall():
    print name
cursor.close()
connection.close()
###


I hope this helps you get started!

_______________________________________________
Tutor maillist  -  Tutor at python.org
http://mail.python.org/mailman/listinfo/tutor