I am trying to test a controller that does a db operation when called:

import unittest
import turbogears
from turbogears import testutil
from re_search.controllers import Root
import cherrypy
import types

cherrypy.root = Root()

class TestPages(unittest.TestCase):
    def setUp(self):
        turbogears.startup.startTurboGears()

    def tearDown(self):
        """Tests for apps using identity need to stop CP/TG after each
test to
        stop the VisitManager thread.
        See http://trac.turbogears.org/turbogears/ticket/1217 for
details.
        """
        turbogears.startup.stopTurboGears()

    def test_get_score(self):
        "the index method should return a string called now"
        import types
        result = testutil.call(cherrypy.root.score_page, "http://
www.java2s.com/Code/Python/Dictionary/Dictionaryhaskeymethod.htm")

    def test_indextitle(self):
        "The indexpage should have the right title"
        testutil.createRequest("/")
        response = cherrypy.response.body[0].lower()
        assert "<title>welcome to turbogears</title>" in response

I keep getting the following stack trace:

Traceback (most recent call last):
  File "C:/workspace/re_search/re_search/tests\test_controllers.py",
line 24, in test_get_score
    result = testutil.call(cherrypy.root.score_page, "http://
www.java2s.com/Code/Python/Dictionary/Dictionaryhaskeymethod.htm")
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\testutil.py", line 138, in call
    output, response = call_with_request(method, DummyRequest(),
*args, **kw)
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\testutil.py", line 151, in call_with_request
    output = method(*args, **kw)
  File "<string>", line 3, in score_page
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\controllers.py", line 344, in expose
    *args, **kw)
  File "<string>", line 5, in run_with_transaction
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\database.py", line 316, in so_rwt
    retval = func(*args, **kw)
  File "<string>", line 5, in _expose
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\controllers.py", line 359, in <lambda>
    mapping, fragment, args, kw)))
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\controllers.py", line 386, in _execute_func
    output = errorhandling.try_call(func, *args, **kw)
  File "c:\python25\lib\site-packages\TurboGears-1.0.4b1-py2.5.egg
\turbogears\errorhandling.py", line 72, in try_call
    return func(self, *args, **kw)
  File "C:\workspace\re_search\re_search\controllers.py", line 60, in
score_page
    page_stats = process_page(url)
  File "C:\workspace\re_search\re_search\page_utilities.py", line 35,
in process_page
    store_page(page_stats)
  File "C:\workspace\re_search\re_search\storage_utils.py", line 7, in
store_page
    page_data = Page_Data(url=page_stats["url"],
last_modified=page_stats["last_modified_time"],
information_content=page_stats["score"],
number_images=page_stats["number_images"],
number_scripts=page_stats["number_scripts"],
number_flash=page_stats["number_flash"])
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\declarative.py", line 98, in _wrapper
    return fn(self, *args, **kwargs)
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\main.py", line 1218, in __init__
    self._create(id, **kw)
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\main.py", line 1249, in _create
    self._SO_finishCreate(id)
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\main.py", line 1273, in _SO_finishCreate
    id, names, values)
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\dbconnection.py", line 849, in queryInsertID
    self._connection, soInstance, id, names, values)
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\sqlite\sqliteconnection.py", line 217, in _queryInsertID
    self._executeRetry(conn, c, q)
  File "c:\python25\lib\site-packages\SQLObject-0.9.1-py2.5.egg
\sqlobject\sqlite\sqliteconnection.py", line 183, in _executeRetry
    raise OperationalError(ErrorMessage(e))
OperationalError: no such table: page__data

1.) I have test.cfg setup to use mysql:

2.) The tables most certainly do exist in mysql.

I have no idea why it is trying to do this in sqlite, I am not sure
what else to change.

Thanks

James


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to