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 supported
>
that 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
> > > > > Content-Length:
> > > > > ACCEPT-CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
> > > > > USER-AGENT: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7)
> > > > > Gecko/20060921 Ubuntu/dapper-security Firefox/1.5.0.7
> > > > > 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 - - [01/Nov/2006:10:18:40] "GET
> > > > > /catwalk/browse/?object_name=User HTTP/1.1" 500 3182 "" "Mozilla/5.0
> > > > > (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20060921
> > > > > Ubuntu/dapper-security Firefox/1.5.0.7"
> > > > > //
> > > > > ---------------------------------------------------------------------------------------------
> >
> > > > > the most important thing that I can see is this line:
> >
> > > > > ################
> >
> > > > > raise AttributeError("%s instance has no attribute '%s'" %
> > > > > (self.soClass.__name__, attr))
> > > > > AttributeError: Pet instance has no attribute 'userID'
> >
> > > > > ################
> >
> > > > > and I just don't get it... :(
> >
> > > > > models.py
> >
> > > > > //
> > > > > ------------------------------------------------------------------------------------------------------
> >
> > > > > from datetime import datetime
> >
> > > > > from sqlobject import *
> >
> > > > > from turbogears import identity
> > > > > from turbogears.database import PackageHub
> >
> > > > > hub = PackageHub("singlejoin")
> > > > > __connection__ = hub
> >
> > > > > # class YourDataClass(SQLObject):
> > > > > # pass
> >
> > > > > 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", joinColumn = "user_id")
> >
> > > > > # groups this user belongs to
> > > > > groups =...
> >
> > 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
-~----------~----~----~----~------~----~------~--~---
