#python-mysqldb

[sqldump]

Homebrew and Python-MySQL

To be able to pip install the python mysql library on OS X, you need mysql client installed locally. If you have no need for the full mysql package, here's how to get it working:

brew install mysql --client-only --universal pip install MySQL-python

[sqldump]

Django on Mac = FAIL

Django is awesome. Python is awesome. Mac OS is sort-of ok. So is MySQL. But geez, getting Python’s MySQL connector (MySQLdb) to play nice on the Mac OS made me start to lose my hair, bit by bit. Django needs this to be able to reach a MySQL server (which I wanted to use) to be able seamlessly run syncdb etc.

There are varied sets of sparse instructions all over the interwebs on how to get MySQL db to compile for Mac OS; some ask you to edit source files before compiling, some are out of date and nearly all of them just don’t work.

But…it’s a Mac…doesn’t it just work?! Apparently not. </end rant>

The solution, this time, came to me in the form of MacPorts. MacPorts is a brilliant system that is the closest replacement to aptitude, for someone coming from a more Ubuntu-esque background (and I guess its existence makes sense, what with FreeBSD ports and all). A few simple lines to get you going on this:

sudo port install py26-django # install django and dependencies sudo port select --set python python26 # set py26 as default sudo port install py26-mysql

Just to make sure these worked:

macbookpro:~ asdf$ python Python 2.6.6 (r266:84292, May 26 2011, 01:52:07) [GCC 4.2.1 (Apple Inc. build 5664)] on darwin Type "help", "copyright", "credits" or "license" for more information. >>> import MySQLdb >>> MySQLdb.version_info (1, 2, 3, 'final', 0) >>>

[sqldump]

MySQLdb - why you no INSERT data?!

I was using MySQLdb to interact with a MySQL db in Python. The script did some selects and some inserts, nothing fancy. All of a sudden, the selects are working, but the inserts refuse to stick! The script source hadn’t been touched, far as I could tell.

Despite my faith in git status, after meticulously going through each line of code (to ensure absence of PEBKAC), I determined that the script really hadn’t been touched.

Finally remembered, halfway through a new script, I had decided to switch the storage engine from MyISAM to InnoDB and therein, as the Bard would tell us, lies the rub. Python-MySQLdb needs an additional connection.commit() statement for all the inserts to actually go through to InnoDB!

connection = MySQLdb.connect( host = dbHost, user = dbUsername, passwd = dbPassword, db = dbSchema); cursor = connection.cursor() sql = "INSERT INTO ..." cursor.execute(sql) cursor.close()   # Extra step for InnoDB connection.commit()   connection.close()