Ok. But my project is nothing more than the default one + the Pet
class.
I generated my project with tg-admin quickstart -i -t tgbig and just
added the Pet class and the line referring the SingleJoin stuff...
I think it's a problem of my installation. I'll try with another
distro.
I will open the ticket though.
thanx
On Nov 1, 6:38 pm, "Jorge Vargas" <[EMAIL PROTECTED]> wrote:
> On 11/1/06, miya <[EMAIL PROTECTED]> wrote:
>
>
>
> > Python 2.4.3 (#2, Oct 6 2006, 07:52:30)
> > [GCC 4.0.3 (Ubuntu 4.0.3-1ubuntu5)] on linux2
> > Type "help", "copyright", "credits" or "license" for more information.
> > (CustomShell)
> > >>> u = User.get(1)
> > >>> Pet(name='something',surname='somethingelse', color='black',owner=u)
> > <Pet 1L name=u'something' surname=u'somethingelse' color=u'black'
> > ownerID=1L>
> > >>> p =Pet(name='something',surname='somethingelse', color='black',owner=u)
> > >>> p
> > <Pet 2L name=u'something' surname=u'somethingelse' color=u'black'
> > ownerID=1L>
> > >>> p
> > <Pet 2L name=u'something' surname=u'somethingelse' color=u'black'
> > ownerID=1L>ok that's good we know the problem is with catwalk
>
>
>
> > //
> > -----------------------------------------------------------------------------
>
> > but then, when I try to use catwalk...I cannot select neither the user
> > nor the Pet...
>
> > this is what the logs says:
>
> > when I select Pet.
> > // -----------------------------
>
> > "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/mysql/mysqlconnection.py",
> > line 73, in _executeRetry
> > myquery = unicode(query, self.encoding)
> > TypeError: decoding Unicode is not supportedthat is actually an issue with
> > mysql please make sure your using the
> lastest version of the driver, your my.cfg file has unicode enable for
> the db. the're a couple of threads about this.> //
> -----------------------------
>
> > when I select User
>
> > // --------------------------------
> > raise AttributeError("%s instance has no attribute '%s'" %
> > (self.soClass.__name__, attr))
> > AttributeError: Pet instance has no attribute 'tgID'
>
> > // ----------------------that one is really weird I believe it has
> > something to do with the
> SingleJoin, can you please open a ticket you will have to register an
> account (this is to reduce
> spam)http://trac.turbogears.org/turbogears/newticket
>
> if you can please isolate the problem and post your current project,
> as a tar file so we can take a look at it more closely.
>
> > really lost. I cannot believe that this doesn't happen to you.
> > I'm using Kubuntu Dapper...does it matter?don't think so
>
>
>
> > Muchas Gracias!
>
> con gusto
>
> > On Nov 1, 3:29 pm, "Jorge Vargas" <[EMAIL PROTECTED]> wrote:
> > > On 11/1/06, miya <[EMAIL PROTECTED]> wrote:
>
> > > > Ok. Did that and it doesn't work either...
>
> > > > Now it says ...
>
> > > > raise AttributeError("%s instance has no attribute '%s'" %
> > > > (self.soClass.__name__, attr))
> > > > AttributeError: Pet instance has no attribute 'tgID'
> > > > Request Headers:
> > > > COOKIE: tg-visit=07ad5cd8a247b08a9df1a3d2acdcebd944aaa657umm catwalk
> > > > issues with identity are supposed to be solve.
>
> > > can you please try that with the console this seems to be a catwalk issue.
>
> > > $ tg-admin shell
>
> > > >>> u=User.get(1) #ur first user
> > > >>> Pet(name='something',surname='somethingelse',color='black',userid=u)also
> > > >>> you don't need the sqlmeta for pet that is there because of the
> > > comment in the User table, also the tg_* tables are "reserved" for
> > > internal use although currently only those 3 exists.
>
> > > and why userid, why not something more OOP like owner?
>
> > > > The model.py
> > > > //
> > > > ------------------------------------------------------------------------------------
>
> > > > class Pet(SQLObject):
> > > > class sqlmeta:
> > > > table = 'tg_pet'
> > > > name = UnicodeCol(length = 40)
> > > > surname = UnicodeCol(length = 40)
> > > > color = UnicodeCol(length = 40)
> > > > userid = ForeignKey("User")
>
> > > > class User(SQLObject):
> > > > """
> > > > Reasonably basic User definition. Probably would want additional
> > > > attributes.
> > > > """
> > > > # names like "Group", "Order" and "User" are reserved words in SQL
> > > > # so we set the name to something safe for SQL
> > > > class sqlmeta:
> > > > table = "tg_user"
>
> > > > user_name = UnicodeCol(length=16, alternateID=True,
> > > > alternateMethodName="by_user_name")
> > > > email_address = UnicodeCol(length=255, alternateID=True,
> > > > alternateMethodName="by_email_address")
> > > > display_name = UnicodeCol(length=255)
> > > > password = UnicodeCol(length=40)
> > > > created = DateTimeCol(default=datetime.now)
>
> > > > myPet = SingleJoin("Pet")
>
> > > > # groups this user belongs to
> > > > groups = RelatedJoin("Group", intermediateTable="user_group",
> > > > joinColumn="user_id", otherColumn="group_id")
>
> > > > //
> > > > ------------------------------------------------------------------------------------
>
> > > > I'm using mysql and the latest version of TG.
>
> > > > It doesn't work with MultipleJoin either... I tried relatedJoin and it
> > > > worked.
>
> > > > I'm really _really_ lost.
> > > > <desperately crying for help ;(>
>
> > > > On Nov 1, 12:55 pm, "Jorge Vargas" <[EMAIL PROTECTED]> wrote:
> > > > > everything seems ok expect this line
>
> > > > > myPet = SingleJoin("Pet", joinColumn = "user_id")
>
> > > > > the default join col is user_id, maybe Catwalk is doing something
> > > > > wrong like trying to set it twice, can you try without the joinColumn
> > > > > param
>
> > > > > On 11/1/06, miya <[EMAIL PROTECTED]> wrote:
>
> > > > > > Hello people!, I'm having trouble with singlejoin and SO. Nothing
> > > > > > too
> > > > > > complicated, just doing an example to see how to use TG.
>
> > > > > > The example that fails on me is this one...
> > > > > > The idea is that One user can have One Pet. So it's a one-to-one
> > > > > > relationship. As far as I know its a singleJoin.
>
> > > > > > The thing is that when I'm using catwalk to insert my data,
> > > > > > suddendly,
> > > > > > the insert user tab stops responding...I look at the logs and this
> > > > > > is
> > > > > > what I see.
>
> > > > > > //
> > > > > > ---------------------------------------------------------------------------------------------
>
> > > > > > 2006-11-01 10:18:40,329 turbogears.identity INFO Identity is
> > > > > > available...
> > > > > > 127.0.0.1 - - [01/Nov/2006:10:18:40] "GET
> > > > > > /catwalk/browse?object_name=User HTTP/1.1" 302 161 "" "Mozilla/5.0
> > > > > > (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20060921
> > > > > > Ubuntu/dapper-security Firefox/1.5.0.7"
> > > > > > 2006-11-01 10:18:40,342 turbogears.identity DEBUG Retrieving
> > > > > > identity
> > > > > > for visit: 68e36dab0194b37f098561b44aad3285d637c9d6
> > > > > > 2006-11-01 10:18:40,343 turbogears.identity INFO Identity is
> > > > > > available...
> > > > > > 2006-11-01 10:18:40,344 turbogears.database DEBUG Starting SQLObject
> > > > > > transaction
> > > > > > 2006-11-01 10:18:40,346 turbogears.controllers DEBUG Calling
> > > > > > <function
> > > > > > index at 0xb745d614> with
> > > > > > *((<turbogears.toolbox.catwalk.browse.Browse
> > > > > > object at 0xb7467e6c>, u'User')), **({'start': 0, 'filters': '',
> > > > > > 'context': '', 'page_size': 10})
> > > > > > 01/Nov/2006:10:18:40 HTTP INFO Page handler: <bound method
> > > > > > Browse.index
> > > > > > of <turbogears.toolbox.catwalk.browse.Browse object at 0xb7467e6c>>
> > > > > > Traceback (most recent call last):
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/CherryPy-2.2.1-py2.4.egg/cherrypy/_cphttptools.py",
> > > > > > line 105, in _run
> > > > > > self.main()
> > > > > > File
> > > > > > "/usr/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
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/controllers.py",
> > > > > > line 326, in expose
> > > > > > output = database.run_with_transaction(
> > > > > > File "<string>", line 5, in run_with_transaction
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/database.py",
> > > > > > line 246, in so_rwt
> > > > > > retval = func(*args, **kw)
> > > > > > File "<string>", line 5, in _expose
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/controllers.py",
> > > > > > line 343, in <lambda>
> > > > > > mapping, fragment, args, kw)))
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/controllers.py",
> > > > > > line 367, in _execute_func
> > > > > > output = errorhandling.try_call(func, *args, **kw)
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/errorhandling.py",
> > > > > > line 71, in try_call
> > > > > > return func(self, *args, **kw)
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-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
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/toolbox/catwalk/browse.py",
> > > > > > line 124, in rows_for_model
> > > > > > relations = self.relation_values(object_name,rows)
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/toolbox/catwalk/browse.py",
> > > > > > line 166, in relation_values
> > > > > > where=AND(
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/TurboGears-1.0b1-py2.4.egg/turbogears/toolbox/catwalk/browse.py",
> > > > > > line 196, in join_foreign_key
> > > > > > return getattr(column.otherClass.q,foreign_key)
> > > > > > File
> > > > > > "/usr/lib/python2.4/site-packages/SQLObject-0.7.1dev_r1860-py2.4.egg/sqlobject/sqlbuilder.py",
> > > > > > line 356, in __getattr__
> > > > > > raise AttributeError("%s instance has no attribute '%s'" %
> > > > > > (self.soClass.__name__, attr))
> > > > > > AttributeError: Pet instance has no attribute 'userID'
> > > > > > Request Headers:
> > > > > > COOKIE: tg-visit=68e36dab0194b37f098561b44aad3285d637c9d6...
>
> read more ยป
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
