I am seeing wierd things in catwalk when I try to fill out my db for
testing purposes:

127.0.0.1 - - [08/Feb/2007:18:22:27] "GET /catwalk/browse?
object_name=SecLevel HTTP/1.1" 302 169 "http://localhost:7654/
catwalk/" "Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:
1.8.1.1) Gecko/20061204 Firefox/2.0.0.1"
2007-02-08 18:22:27,415 turbogears.database DEBUG Starting SQLObject
transaction2007-02-08 18:22:27,418 turbogears.controllers DEBUG
Calling <function index at 0x1ce49b0> with
*((<turbogears.toolbox.catwalk.browse.Browse object at 0x1cd2130>,
u'SecLevel')), **({'start': 0, 'filters': '', 'context': '',
'page_size': 10})
08/Feb/2007:18:22:27 HTTP INFO Page handler: <bound method
Browse.index of <turbogears.toolbox.catwalk.browse.Browse object at
0x1cd2130>>
Traceback (most recent call last):
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/
_cphttptools.py", line 105, in _run
    self.main()
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/
_cphttptools.py", line 254, in main
    body = page_handler(*virtual_path, **self.params)
  File "<string>", line 3, in index
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/
controllers.py", line 334, in expose    output =
database.run_with_transaction(
  File "<string>", line 5, in run_with_transaction
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/
database.py", line 302, in so_rwt
    retval = func(*args, **kw)
  File "<string>", line 5, in _expose
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/
controllers.py", line 351, in <lambda>
    mapping, fragment, args, kw)))
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/
controllers.py", line 378, in _execute_func
    output = errorhandling.try_call(func, *args, **kw)
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/
errorhandling.py", line 73, in try_call
    return func(self, *args, **kw)
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/toolbox/
catwalk/browse.py", line 24, in index
    total,rows =
self.rows_for_model(object_name,start,page_size,filters)
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/toolbox/
catwalk/browse.py", line 124, in rows_for_model
    relations = self.relation_values(object_name,rows)
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/toolbox/
catwalk/browse.py", line 144, in relation_values
    where=AND(
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/TurboGears-1.0.1-py2.4.egg/turbogears/toolbox/
catwalk/browse.py", line 197, in join_foreign_key
    return getattr(column.otherClass.q,foreign_key)
  File "/Library/Frameworks/Python.framework/Versions/2.4/lib/
python2.4/site-packages/SQLObject-0.8.0b2-py2.4.egg/sqlobject/
sqlbuilder.py", line 377, in __getattr__
    raise AttributeError("%s instance has no attribute '%s'" %
(self.soClass.__name__, attr))
AttributeError: Investment instance has no attribute 'secID'
Request Headers:
  REFERER: http://localhost:7654/catwalk/
  Content-Length:
  ACCEPT-CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  USER-AGENT: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US;
rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1
  CONNECTION: keep-alive
  HOST: localhost:7654
  ACCEPT: text/xml,application/xml,application/xhtml+xml,text/
html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  Remote-Addr: 127.0.0.1
  ACCEPT-LANGUAGE: en-us,en;q=0.5
  Content-Type:
  Remote-Host: 127.0.0.1
  ACCEPT-ENCODING: gzip,deflate
  KEEP-ALIVE: 300
127.0.0.1 - - [08/Feb/2007:18:22:27] "GET /catwalk/browse/?
object_name=SecLevel HTTP/1.1" 500 3720 "http://localhost:7654/
catwalk/" "Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:
1.8.1.1) Gecko/20061204 Firefox/2.0.0.1"


Here is my model:

from sqlobject import *
from datetime import datetime
from turbogears.database import PackageHub
from turbogears.identity.soprovider import TG_User, TG_Group,
TG_Permission

hub = PackageHub("phase2")
__connection__ = hub

class People(SQLObject):
    fName = StringCol()
    lName = StringCol()
    eMail = StringCol()
    pNum1 = StringCol()
    pNum2 = StringCol()
    street = StringCol()
    city = StringCol()
    zipcode = StringCol()
    investment = MultipleJoin('Investment')


class SecLevel(SQLObject):
        secLevel = StringCol()
        investment = MultipleJoin('Investment')


class Type(SQLObject):
    systype = StringCol()
    investment = MultipleJoin('Investment')



class Control(SQLObject):
    family = StringCol()
    num = StringCol()
    name = StringCol()
    desc = StringCol()
    status = RelatedJoin('Status')



class Implemented(SQLObject):
    implemented = StringCol()
    status = RelatedJoin('Status')


class Investment(SQLObject):
    name = StringCol()
    systype = ForeignKey('Type')
    sysOwner = ForeignKey('People')
    secOwner = ForeignKey('People')
    secLevel = ForeignKey('SecLevel')
    status = RelatedJoin('Status')



class Status(SQLObject):
        investment = RelatedJoin('Investment')
        implemented = RelatedJoin('Implemented')
        control = RelatedJoin('Control')



Any ideas??

Thanks!

Jeremy


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