Make SQLAlchemy tests part of our testing process about pymssql

[GoogleCodeExporter]

Original comment by [email protected] on 8 Mar 2012 at 3:17

• Changed state: Accepted

[GoogleCodeExporter]

Doesn't the following work?

nosetests tests/test_sqlalchemy.py

For one possible piece in the puzzle of doing automated tests, see my addition 
of the `tox` testing tool at 
http://code.google.com/r/msabramo-pymssql/source/detail?r=33b738e293d9ebdab482df
bff679a1c1db6b338f

Original comment by [email protected] on 1 Dec 2012 at 6:08

[GoogleCodeExporter]

no, thats not what I'm getting at.  I want to run through the SA test suite 
using a mssql database with pymssql as the driver.  I have done it before, it 
takes a little manual adjusting and a few tests still fail.

Original comment by [email protected] on 4 Dec 2012 at 3:56

[GoogleCodeExporter]

How about something like this?

(py26.venv)marca@marca-mac:~/dev/hg-repos/pymssql$ cat
tests/run_sqlalchemy_tests.sh
#!/bin/sh

SQLALCHEMY_VERSION="0.8.0b2"
SQLALCHEMY_TAR_GZ_URL="http://pypi.python.org/packages/source/S/SQLAlchemy/SQLAl
chemy-${SQLALCHEMY_VERSION}.tar.gz"
SQLALCHEMY_TAR_GZ="SQLAlchemy-${SQLALCHEMY_VERSION}.tar.gz"
SQLALCHEMY_DIR="SQLAlchemy-${SQLALCHEMY_VERSION}"

DB_URI="$1"

if [ ! -d ${SQLALCHEMY_DIR} ]; then
if [ ! -f ${SQLALCHEMY_TAR_GZ} ]; then
wget ${SQLALCHEMY_TAR_GZ_URL}
tar xzf ${SQLALCHEMY_TAR_GZ}
fi
fi

( cd ${SQLALCHEMY_DIR} && python sqla_nose.py -v --dburi=${DB_URI} )

This is a shell script so it won't work on Windows without something like 
Cygwin, but it should work on other systems. If we wanted to run it on Windows 
too, I guess we could rewrite this in Python.

Original comment by [email protected] on 16 Jan 2013 at 12:51

[GoogleCodeExporter]

> This is a shell script so it won't work on Windows without something like 
Cygwin, but it should work on other systems. If we wanted to run it on Windows 
too, I guess we could rewrite this in Python.

This is better than nothing, but I would like to see it rewritten in Python.  
We support windows so running the SA test suite on Windows is something we 
should do as well.  A python script seems like the most flexible and familiar 
option here.  Since its python, you wouldn't have to call out to sql_nose.py 
either, just look at the logic they use and duplicate (or maybe even import & 
call).

Also, might be good if the DB_URI was taken from our test settings file.

Original comment by [email protected] on 16 Jan 2013 at 2:15

[GoogleCodeExporter]

OK, how about this?

https://gist.github.com/4710827

Original comment by [email protected] on 4 Feb 2013 at 11:49

[GoogleCodeExporter]

Yah, looks good.  I didn't run it, I'm assuming it works.  :)

Original comment by [email protected] on 5 Feb 2013 at 3:04

[GoogleCodeExporter]

Committed as: 
http://code.google.com/p/pymssql/source/detail?r=999d9dbe791b4907aeaf5fd75e84004
ef7b3e5e0

Randy, do you have time to give it a spin? It should be pretty quick if it 
works. :-)

Original comment by [email protected] on 5 Feb 2013 at 5:16

• Changed state: Fixed

[GoogleCodeExporter]

I'd love to...unfortunately, just trying to run our own tests is giving me a 
core dump.  Not sure what the deal is, I've tried cleaning and using the newest 
Cython.  Don't have time to troubleshoot that right now, but I'll to get to it 
in the next week or two.

Original comment by [email protected] on 6 Feb 2013 at 4:15