It appears that the test suite depends on pysqlite2. Is this a hard requirement? I only have postgres here and I'd like to be able to run the test suite without modifying it. This is what I get when I try to run the tests using a fresh checkout from SVN:
$ python test/alltests.py --db postgres Traceback (most recent call last): File "test/alltests.py", line 18, in ? testbase.runTests(suite()) File "test/alltests.py", line 13, in suite alltests.addTest(suite.suite()) File "test/engine/alltests.py", line 19, in suite mod = __import__(name) File "test/engine/pool.py", line 4, in ? from pysqlite2 import dbapi2 as sqlite ImportError: No module named pysqlite2 So I modified test/alltests.py to exclude the "engine" test suite which allowed me to at least run test/alltests.py, but I still get a bunch of failures and errors mostly due to sqlite dependencies. Here's the error output: ====================================================================== ERROR: testadapt (sql.testtypes.AdaptTest) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/test/sql/ testtypes.py", line 43, in testadapt e3 = url.URL('sqlite').get_module().dialect() File "./lib/sqlalchemy/databases/sqlite.py", line 138, in __init__ self.supports_cast = (vers(sqlite.sqlite_version) >= vers("3.2.3")) AttributeError: 'NoneType' object has no attribute 'sqlite_version' ====================================================================== ERROR: testcast (sql.select.SelectTest) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/test/sql/ select.py", line 561, in testcast check_results(sqlite.dialect(), ['NUMERIC(10, 2)', 'NUMERIC(12, 9)', 'DATE', 'TEXT', 'VARCHAR(20)'], '?') File "./lib/sqlalchemy/databases/sqlite.py", line 138, in __init__ self.supports_cast = (vers(sqlite.sqlite_version) >= vers("3.2.3")) AttributeError: 'NoneType' object has no attribute 'sqlite_version' ====================================================================== ERROR: testtextbinds (sql.select.SelectTest) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/test/sql/ select.py", line 312, in testtextbinds dialect = sqlite.dialect() File "./lib/sqlalchemy/databases/sqlite.py", line 138, in __init__ self.supports_cast = (vers(sqlite.sqlite_version) >= vers("3.2.3")) AttributeError: 'NoneType' object has no attribute 'sqlite_version' ====================================================================== ERROR: test_lazy_backref (orm.lazytest1.LazyTest) ---------------------------------------------------------------------- Traceback (most recent call last): File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/test/orm/ lazytest1.py", line 106, in test_lazy_backref rel.info = info File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/attributes.py", line 26, in __set__ self.set(None, obj, value) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/attributes.py", line 190, in set ext.set(event or self, obj, value, old) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/attributes.py", line 446, in set getattr(child.__class__, self.key).append(event, child, obj) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/attributes.py", line 222, in append self.get(obj).append_with_event(value, event) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/attributes.py", line 137, in get l = InstrumentedList(self, obj, self._adapt_list(callable_()), init=False) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/orm/properties.py", line 400, in lazyload raise exceptions.InvalidRequestError("Parent instance %s is not bound to a Session, and no contextual session is established; lazy load operation of attribute '%s' cannot proceed" % (instance.__class__, self.key)) InvalidRequestError: Parent instance <class 'orm.lazytest1.Information'> is not bound to a Session, and no contextual session is established; lazy load operation of attribute 'rels' cannot proceed ====================================================================== FAIL: Doctest: sqlalchemy.ext.sqlsoup ---------------------------------------------------------------------- Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 2152, in runTest raise self.failureException(self.format_failure(new.getvalue())) AssertionError: Failed doctest test for sqlalchemy.ext.sqlsoup File "./lib/sqlalchemy/ext/sqlsoup.py", line 0, in sqlsoup ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 12, in sqlalchemy.ext.sqlsoup Failed example: e = create_engine('sqlite:///:memory:') Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[1]>", line 1, in ? e = create_engine('sqlite:///:memory:') File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/engine/__init__.py", line 92, in create_engine return strategy.create(*args, **kwargs) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/engine/strategies.py", line 34, in create dialect = module.dialect(**args) File "./lib/sqlalchemy/databases/sqlite.py", line 138, in __init__ self.supports_cast = (vers(sqlite.sqlite_version) >= vers ("3.2.3")) AttributeError: 'NoneType' object has no attribute 'sqlite_version' ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 13, in sqlalchemy.ext.sqlsoup Failed example: for sql in _testsql: e.execute(sql) #doctest: +ELLIPSIS Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[2]>", line 1, in ? for sql in _testsql: e.execute(sql) #doctest: +ELLIPSIS NameError: name 'e' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 18, in sqlalchemy.ext.sqlsoup Failed example: db = SqlSoup('sqlite:///:memory:') Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[4]>", line 1, in ? db = SqlSoup('sqlite:///:memory:') File "./lib/sqlalchemy/ext/sqlsoup.py", line 304, in __init__ metadata = BoundMetaData(*args, **kwargs) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/schema.py", line 865, in __init__ self._engine = sqlalchemy.create_engine(engine_or_url, **kwargs) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/engine/__init__.py", line 92, in create_engine return strategy.create(*args, **kwargs) File "/Users/dmiller/Code/PyOE/resources/lib/SQLAlchemy/lib/ sqlalchemy/engine/strategies.py", line 34, in create dialect = module.dialect(**args) File "./lib/sqlalchemy/databases/sqlite.py", line 138, in __init__ self.supports_cast = (vers(sqlite.sqlite_version) >= vers ("3.2.3")) AttributeError: 'NoneType' object has no attribute 'sqlite_version' ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 21, in sqlalchemy.ext.sqlsoup Failed example: db = SqlSoup(BoundMetaData(e)) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[5]>", line 1, in ? db = SqlSoup(BoundMetaData(e)) NameError: name 'e' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 31, in sqlalchemy.ext.sqlsoup Failed example: users = db.users.select() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[6]>", line 1, in ? users = db.users.select() NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 32, in sqlalchemy.ext.sqlsoup Failed example: users.sort() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[7]>", line 1, in ? users.sort() NameError: name 'users' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 33, in sqlalchemy.ext.sqlsoup Failed example: users Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[8]>", line 1, in ? users NameError: name 'users' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 37, in sqlalchemy.ext.sqlsoup Failed example: db.users.select(order_by=[db.users.c.name]) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[9]>", line 1, in ? db.users.select(order_by=[db.users.c.name]) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 41, in sqlalchemy.ext.sqlsoup Failed example: users[0].email Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[10]>", line 1, in ? users[0].email NameError: name 'users' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 46, in sqlalchemy.ext.sqlsoup Failed example: db.users.selectone_by(name='Bhargan Basepair') Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[11]>", line 1, in ? db.users.selectone_by(name='Bhargan Basepair') NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 72, in sqlalchemy.ext.sqlsoup Failed example: user = _ Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[12]>", line 1, in ? user = _ NameError: name '_' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 73, in sqlalchemy.ext.sqlsoup Failed example: user.email = '[EMAIL PROTECTED]' Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[13]>", line 1, in ? user.email = '[EMAIL PROTECTED]' NameError: name 'user' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 74, in sqlalchemy.ext.sqlsoup Failed example: db.flush() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[14]>", line 1, in ? db.flush() NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 82, in sqlalchemy.ext.sqlsoup Failed example: book_id = db.books.selectfirst(db.books.c.title=='Regional Variation in Moss').id Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[15]>", line 1, in ? book_id = db.books.selectfirst(db.books.c.title=='Regional Variation in Moss').id NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 83, in sqlalchemy.ext.sqlsoup Failed example: db.loans.insert(book_id=book_id, user_name=user.name) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[16]>", line 1, in ? db.loans.insert(book_id=book_id, user_name=user.name) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 85, in sqlalchemy.ext.sqlsoup Failed example: db.flush() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[17]>", line 1, in ? db.flush() NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 87, in sqlalchemy.ext.sqlsoup Failed example: loan = db.loans.selectone_by(book_id=2, user_name='Bhargan Basepair') Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[18]>", line 1, in ? loan = db.loans.selectone_by(book_id=2, user_name='Bhargan Basepair') NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 88, in sqlalchemy.ext.sqlsoup Failed example: db.delete(loan) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[19]>", line 1, in ? db.delete(loan) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 89, in sqlalchemy.ext.sqlsoup Failed example: db.flush() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[20]>", line 1, in ? db.flush() NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 96, in sqlalchemy.ext.sqlsoup Failed example: db.loans.insert(book_id=book_id, user_name=user.name) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[21]>", line 1, in ? db.loans.insert(book_id=book_id, user_name=user.name) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 98, in sqlalchemy.ext.sqlsoup Failed example: db.flush() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[22]>", line 1, in ? db.flush() NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 99, in sqlalchemy.ext.sqlsoup Failed example: db.loans.delete(db.loans.c.book_id==2) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[23]>", line 1, in ? db.loans.delete(db.loans.c.book_id==2) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 103, in sqlalchemy.ext.sqlsoup Failed example: db.loans.update(db.loans.c.book_id==2, book_id=1) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[24]>", line 1, in ? db.loans.update(db.loans.c.book_id==2, book_id=1) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 104, in sqlalchemy.ext.sqlsoup Failed example: db.loans.select_by(db.loans.c.book_id==1) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[25]>", line 1, in ? db.loans.select_by(db.loans.c.book_id==1) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 117, in sqlalchemy.ext.sqlsoup Failed example: join1 = db.join(db.users, db.loans, isouter=True) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[26]>", line 1, in ? join1 = db.join(db.users, db.loans, isouter=True) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 118, in sqlalchemy.ext.sqlsoup Failed example: join1.select_by(name='Joe Student') Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[27]>", line 1, in ? join1.select_by(name='Joe Student') NameError: name 'join1' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 123, in sqlalchemy.ext.sqlsoup Failed example: join2 = db.join(join1, db.books) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[28]>", line 1, in ? join2 = db.join(join1, db.books) NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 124, in sqlalchemy.ext.sqlsoup Failed example: join2.select() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[29]>", line 1, in ? join2.select() NameError: name 'join2' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 129, in sqlalchemy.ext.sqlsoup Failed example: db.with_labels(join1).select() Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[30]>", line 1, in ? db.with_labels(join1).select() NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 141, in sqlalchemy.ext.sqlsoup Failed example: rp = db.engine.execute('select name, email from users order by name') Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[31]>", line 1, in ? rp = db.engine.execute('select name, email from users order by name') NameError: name 'db' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 142, in sqlalchemy.ext.sqlsoup Failed example: for name, email in rp.fetchall(): print name, email Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[32]>", line 1, in ? for name, email in rp.fetchall(): print name, email NameError: name 'rp' is not defined ---------------------------------------------------------------------- File "./lib/sqlalchemy/ext/sqlsoup.py", line 154, in sqlalchemy.ext.sqlsoup Failed example: db.users.select(db.users.c.classname==None, order_by= [db.users.c.name]) Exception raised: Traceback (most recent call last): File "/Library/Frameworks/Python.framework/Versions/2.4//lib/ python2.4/doctest.py", line 1243, in __run compileflags, 1) in test.globs File "<doctest sqlalchemy.ext.sqlsoup[33]>", line 1, in ? db.users.select(db.users.c.classname==None, order_by= [db.users.c.name]) NameError: name 'db' is not defined ---------------------------------------------------------------------- Ran 286 tests in 59.169s Thanks. ~ Daniel ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users