Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Python and SQL / the DB API and Gadfly

Posted by admin (Graham Ellis), 13 April 2004
Python supports connections to numerous SQL databases - have a look at the Special Interests Group section on http://www.python.org to find out about the Python DB API.

Gadfly is a pure Python SQL database handler that's great for learning and small tasks ... I've been sorting out the "wood from the trees" today and have two short example programs - one of which initialised Gadfly and sets up tables, the other which looks at the data storded via a select command:

Code:
import sys
import gadfly

conn = gadfly.gadfly()
conn.startup("demo","datadir")

th = conn.cursor()
th.execute("Create table people (id integer, name varchar)");

th.execute("Insert into people(id, name) values (1,'Graham')");
th.execute("Insert into people(id, name) values (2,'Lisa')");
th.execute("Insert into people(id, name) values (3,'Charlie')");
conn.commit()


and

Code:
import sys
import gadfly

conn = gadfly.gadfly("demo","datadir")

th = conn.cursor()

th.execute("select * from people")
for x in th.fetchall():
    print x




This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho