all of the offending tests, if you add a decorator above them which
says:
@testbase.supported('sqlite')
it should cause those tests only to be run with --db sqlite or
default, not --db postgres. can you give that a try ?
also, with sqlsoup, i had a stub module in test/ext/ to handle it but
Jonathan removed it in place of a straight doctest invocation in test/
ext/alltests.py. so some "sqlite" conditional logic should be added
to test/ext/alltests.py as well.
I see one test, orm.lazytest.LazyTest1, which seems to be
legitimately failing; that test passes with postgres on my end.
On Aug 21, 2006, at 12:06 PM, dmiller wrote:
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
