import sys
import sqlite3
import MySQLdb
SQLite#
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#
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 -
SQL -
MySQL