[{TableOfContents }]

!! Header

%%prettify 
{{{
import sys
import sqlite3
import MySQLdb
}}}
/%


!! SQLite

%%prettify 
{{{
try:
    sqlite_conn = sqlite3.connect('database.sqlite')
    sqlite_conn.row_factory = sqlite3.Row
    sqlite_conn.text_factory = str
except NameError, ex:
    print 'Could not connect to database: %s' % str(ex)
    sys.exit()
except Exception, ex:
    print 'Unexpected error: %s : %s' % (str(type(ex)), ex)
    sys.exit()
sqlite_cursor = sqlite_conn.cursor()
print 'Connected to sqlite'
}}}
/%

!! MySQL

%%prettify 
{{{
try:
    mysql_conn = MySQLdb.connect(host='localhost', 
        db='db_name', user='username', passwd='password',
        cursorclass=MySQLdb.cursors.DictCursor, 
        use_unicode=True, charset='utf8')
except NameError, ex:
    print 'Could not connect to database: %s' % str(ex)
    sys.exit()
except Exception, ex:
    print 'Unexpected error: %s : %s' % (str(type(ex)), ex)
    sys.exit()
mysql_cursor = mysql_conn.cursor()
print 'Connected to MySQL'
}}}
/%

----
[Python | CategoryArchived.Computing.Lang.Python] - [SQL | CategoryArchived.Computing.DB.SQL] - [MySQL | CategoryArchived.Computing.DB.SQL.MySQL]