converting unit tests to sqlalchemy

[travis]

Many unit tests depend on mysql & mysqldb. If we're going to support users' use of an arbitrary database backend, these tests should be updated to use sqlalchemy so that non-mysql users can run alltests.

I'm setting this outside of my sqlalchemy conversion scope because these tests are quite extensive and require significant effort beyond the already significant commitment to support sqlalchemy in the core.