Ummm it doesn't look like you even use controllers. So why don't you
try it without that import.
-Ian
On 4/18/07, Denny <[EMAIL PROTECTED]> wrote:
>
> Still no-go!!! 'nosetests' seems to fail while importing my
> 'research.controllers' module. It seems to want the database tables
> during that import. The below traceback is pointing to a function in
> my controllers.py which makes queries for data to be presented in a
> radio button list. Am I doing something fundamentally wrong??
>
> Here's the recent traceback!
>
> > nosetests
> E.
> ======================================================================
> ERROR: test module research.tests.test_controllers in /home/dthury/
> projects/Somerville/research
> ----------------------------------------------------------------------
> Traceback (most recent call last):
> File "/usr/lib/python2.4/site-packages/nose-0.9.2-py2.4.egg/nose/
> suite.py", line 51, in run
> self.setUp()
> File "/usr/lib/python2.4/site-packages/nose-0.9.2-py2.4.egg/nose/
> suite.py", line 200, in setUp
> self.module = _import(self.moduleName, [self.path], self.conf)
> File "/usr/lib/python2.4/site-packages/nose-0.9.2-py2.4.egg/nose/
> importer.py", line 101, in _import
> mod = load_module(fqname, fh, filename, desc)
>
> <--- below is from my code --->
>
> File "/home/dthury/projects/Somerville/research/research/tests/
> test_controllers.py", line 8, in ?
> from research.controllers import *
> File "/home/dthury/projects/Somerville/research/research/
> controllers.py", line 27, in ?
> class sandboxSelectionFields(widgets.WidgetsList):
> File "/home/dthury/projects/Somerville/research/research/
> controllers.py", line 28, in sandboxSelectionFields
> sandboxID = widgets.RadioButtonList(options=get_sandbox_options(),
> validator=validators.NotEmpty)
> File "/home/dthury/projects/Somerville/research/research/
> controllers.py", line 22, in get_sandbox_options
> for sandbox in sandbox_list:
>
> <--- The above line is referring to a line of code where I'm
> iterating over the results of a db query
> But this is done before the setUp function is run to create/
> load my test database!! --->
>
> File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> sqlobject/sresults.py", line 155, in __iter__
> return iter(list(self.lazyIter()))
> File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> sqlobject/sresults.py", line 163, in lazyIter
> return conn.iterSelect(self)
> File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> sqlobject/dbconnection.py", line 365, in iterSelect
> select, keepConnection=False)
> File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> sqlobject/dbconnection.py", line 705, in __init__
> self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
> File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> sqlobject/mysql/mysqlconnection.py", line 78, in _executeRetry
> return cursor.execute(myquery)
> File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line
> 137, in execute
> self.errorhandler(self, exc, value)
> File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
> 33, in defaulterrorhandler
> raise errorclass, errorvalue
> ProgrammingError: (1146, "Table 'research_test.sandboxes' doesn't
> exist")
>
> ----------------------------------------------------------------------
> Ran 1 test in 1.516s
>
> FAILED (errors=1)
>
>
> #--------------------------------------------------------------------------------
>
> On Apr 17, 8:35 pm, "Ian Wilson" <[EMAIL PROTECTED]> wrote:
> > The following setup will DROP and CREATE your database therefore
> > deleting all data in it before each test. You will need to populate
> > your data base with test data in the setUp method.
> >
> > import turbogears.testutil
> > import turbogears.database
> > import sqlobject
> >
> > turbogears.database.set_db_uri("notrans_mysql://researcher:[EMAIL
> > PROTECTED]:
> > 3306/research_test")
> >
> > import research.model
> > from research.controllers import *
> > from research.model import *
> > import cherrypy
> >
> > cherrypy.root = Root()
> >
> > class TestModel(turbogears.testutil.DBTest):
> >
> > model = research.model
> >
> > def setUp(self):
> > turbogears.testutil.DBTest.setUp(self)
> > #SETUP TEST DATA HERE
> >
> > def test_sandbox_controller():
> > result = testutil.call(cherrypy.root.play)
> > print 'play returned :', result
> > assert result == True
> >
> > ....
> >
> > On 4/17/07, Denny <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > > I don't understand what you're saying here!!??!! Can you be more
> > > specific about what needs to be done,
> > > may examples of what I may need to add to my testing code!?!! I'm not
> > > using SQLite, but MySQL.
> >
> > > My test.cfg contains:
> >
> > > sqlobject.dburi="notrans_mysql://researcher:[EMAIL PROTECTED]:
> > > 3306/research_test"
> >
> > > test-models.py seems to complete OK. but test-controllers.py is where
> > > my problem seems to be.
> > > If I manually create the required table in the above database,
> > > nosetests completes successfully, but
> > > the table has been deleted!!?!!
> >
> > > Below are the results of my latest nosetests run; and
> > > the contents of my test-controllers.py (which seems to be what's
> > > failing):
> >
> > > ======================================================================
> > > ERROR: test module research.tests.test_controllers in /home/dthury/
> > > projects/Somerville/research
> > > ----------------------------------------------------------------------
> > > Traceback (most recent call last):
> > > File "/usr/lib/python2.4/site-packages/nose-0.9.2-py2.4.egg/nose/
> > > suite.py", line 51, in run
> > > self.setUp()
> > > File "/usr/lib/python2.4/site-packages/nose-0.9.2-py2.4.egg/nose/
> > > suite.py", line 200, in setUp
> > > self.module = _import(self.moduleName, [self.path], self.conf)
> > > File "/usr/lib/python2.4/site-packages/nose-0.9.2-py2.4.egg/nose/
> > > importer.py", line 101, in _import
> > > mod = load_module(fqname, fh, filename, desc)
> > > File "/home/dthury/projects/Somerville/research/research/tests/
> > > test_controllers.py", line 2, in ?
> > > from research.controllers import *
> > > File "/home/dthury/projects/Somerville/research/research/
> > > controllers.py", line 26, in ?
> > > class sandboxSelectionFields(widgets.WidgetsList):
> > > File "/home/dthury/projects/Somerville/research/research/
> > > controllers.py", line 27, in sandboxSelectionFields
> > > sandboxID = widgets.RadioButtonList(options=get_sandbox_options(),
> > > validator=validators.NotEmpty)
> > > File "/home/dthury/projects/Somerville/research/research/
> > > controllers.py", line 21, in get_sandbox_options
> > > for sandbox in sandbox_list:
> > > File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> > > sqlobject/sresults.py", line 155, in __iter__
> > > return iter(list(self.lazyIter()))
> > > File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> > > sqlobject/sresults.py", line 163, in lazyIter
> > > return conn.iterSelect(self)
> > > File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> > > sqlobject/dbconnection.py", line 365, in iterSelect
> > > select, keepConnection=False)
> > > File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> > > sqlobject/dbconnection.py", line 705, in __init__
> > > self.dbconn._executeRetry(self.rawconn, self.cursor, self.query)
> > > File "/usr/lib/python2.4/site-packages/SQLObject-0.7.4-py2.4.egg/
> > > sqlobject/mysql/mysqlconnection.py", line 78, in _executeRetry
> > > return cursor.execute(myquery)
> > > File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line
> > > 137, in execute
> > > self.errorhandler(self, exc, value)
> > > File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line
> > > 33, in defaulterrorhandler
> > > raise errorclass, errorvalue
> > > ProgrammingError: (1146, "Table 'research_test.sandboxes' doesn't
> > > exist")
> >
> > > ----------------------------------------------------------------------
> > > Ran 1 test in 1.636s
> >
> > > FAILED (errors=1)
> >
> > > ==================================================
> > > ===================test controllers.py====================
> >
> > > from turbogears import testutil
> > > from research.controllers import *
> > > from research.model import *
> > > import cherrypy
> >
> > > cherrypy.root = Root()
> >
> > > def test_sandbox_controller():
> > > result = testutil.call(cherrypy.root.play)
> > > print 'play returned :', result
> > > assert result == True
> >
> > > def test_method():
> > > "the index method should return a string called now"
> > > import types
> > > result = testutil.call(cherrypy.root.index)
> > > print "Index method returned:", result
> >
> > > def test_indextitle():
> > > "The indexpage should have the right title"
> > > testutil.createRequest("/")
> > > print cherrypy.response.body[0]
> > > assert "<title>SNP Research System</title>" in
> > > cherrypy.response.body[0]
> >
> > > Thanks,
> > > Denny
> >
> > > On Apr 16, 4:13 pm, "Joost Moesker" <[EMAIL PROTECTED]> wrote:
> > > > The setup and tearDown methods on testutils.DBTest automatically
> > > > create and drop the database schema per testcase. For this to work
> > > > you need to set the model attribute of the class to reference your
> > > > model module. It's common to use an SQLite 'in memory' database for
> > > > unittests to speed-up the peformance.
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
