sqlobject-discuss

[SQLObject] Name of MultipleJoin attribute being ignored.

[David M. C. <da...@da...>]

I like to give my MultipleJoin columns the name 'children' to give a uniform
way to access the associated objects.  But SQLObject 0.6 ignores my class
attribute name:

  from sqlobject import *
  
  __connection__ = 'sqlite:///tmp/test.db'
  
  class Composer(SQLObject):
  
      name = StringCol()
      children = MultipleJoin('Work')
  
  class Work(SQLObject):
      
      composer = ForeignKey('Composer')
      title = StringCol()
  
  for klass in Composer, Work:
      klass.dropTable(ifExists=True)
      klass.createTable(ifNotExists=True)
  
  c = Composer(name='Beethoven, Ludwig van')
  w = Work(composer=c, title='Symphony No. 7')
  
  print c.works
  print c.children

This gives the result:

[<Work 1 composerID=1 title='Symphony No. 7'>]
Traceback (most recent call last):
  File "<stdin>", line 23, in ?
  AttributeError: 'Composer' object has no attribute 'children'
  

Re: [SQLObject] Name of MultipleJoin attribute being ignored.

[Ian B. <ia...@co...>]

I haven't had a chance to look at MultipleJoin closely, to really figure 
out what it's problem is, but I did (rather blindly) apply a patch sent 
by Cyril.  It's not in 0.6, but it's in the repository, maybe it will 
help you.

David M. Cook wrote:
> I like to give my MultipleJoin columns the name 'children' to give a uniform
> way to access the associated objects.  But SQLObject 0.6 ignores my class
> attribute name:
> 
>   from sqlobject import *
>   
>   __connection__ = 'sqlite:///tmp/test.db'
>   
>   class Composer(SQLObject):
>   
>       name = StringCol()
>       children = MultipleJoin('Work')
>   
>   class Work(SQLObject):
>       
>       composer = ForeignKey('Composer')
>       title = StringCol()
>   
>   for klass in Composer, Work:
>       klass.dropTable(ifExists=True)
>       klass.createTable(ifNotExists=True)
>   
>   c = Composer(name='Beethoven, Ludwig van')
>   w = Work(composer=c, title='Symphony No. 7')
>   
>   print c.works
>   print c.children
> 
> This gives the result:
> 
> [<Work 1 composerID=1 title='Symphony No. 7'>]
> Traceback (most recent call last):
>   File "<stdin>", line 23, in ?
>   AttributeError: 'Composer' object has no attribute 'children'
>   
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss


-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org

Re: [SQLObject] Name of MultipleJoin attribute being ignored.

[David M. C. <da...@da...>]

On Fri, Sep 24, 2004 at 11:00:24AM -0500, Ian Bicking wrote:

> I haven't had a chance to look at MultipleJoin closely, to really figure 
> out what it's problem is, but I did (rather blindly) apply a patch sent 
> by Cyril.  It's not in 0.6, but it's in the repository, maybe it will 
> help you.

Just tried out the SVN sqlobject and see the same thing.

And even weirder:

  In [10]: [j.joinMethodName for j in Composer._joins]
  Out[10]: ['children']

But it *does* work if I explictly specify the joinMethodName: 

  children = MultipleJoin('Work', joinMethodName='children')

Thanks, BTW, for the change that allows foreignKeys to be used when
inserting, rather than having to use the ID.  Also it's great to now be able
to use multiple keys in selectBy (though that method does not understand
foreignKeys yet).

Dave Cook

Re: [SQLObject] Name of MultipleJoin attribute being ignored.

[Andrew B. <and...@pu...>]

On Fri, Sep 24, 2004 at 09:31:02AM -0700, David M. Cook wrote:
> On Fri, Sep 24, 2004 at 11:00:24AM -0500, Ian Bicking wrote:
> 
> > I haven't had a chance to look at MultipleJoin closely, to really figure 
> > out what it's problem is, but I did (rather blindly) apply a patch sent 
> > by Cyril.  It's not in 0.6, but it's in the repository, maybe it will 
> > help you.
> 
> Just tried out the SVN sqlobject and see the same thing.

Try latest SVN (r273).  Brad has just committed a fix that fixes this issue
for me.

-Andrew.