sqlobject-discuss

[SQLObject] Related Join

[Michel T. <mic...@ya...>]

Hi guys!

I recently faced some problems with RelatedJoin, he is droping the
attribute name I use and using another, the class method added by a s.
I like to make programs in my language, the plural form is not made
this way, and in english it isn't sometimes too.

-----
from sqlobject import *

CONNECTION='a connection string'

class Person(SQLObject):
  _connection=CONNECTION
  name=StringCol()
  roles=RelatedJoin('Role')

class Role(SQLObject):
  _connection=CONNECTION
  description=StringCol()
  people=RelatedJoin('Person')

if __name__=='__main__':
  Person.createTable()
  Role.createTable()
  p=Person(name='person test')
  r=Role(description='role test')
  p.addRole(r)
  p.roles # ok
  r.persons # ok
  r.people # ops
----

I upgraded the version last saturday, I used the site package 0.6, the
old one was 0.6 too, but from svn... Is this a bug or this is the
correct way of work now?

thanks for attention!

=====
--
Michel Thadeu Sabchuk
Curitiba/PR


	
	
		
_______________________________________________________ 
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/

[SQLObject] Related Join

[Ian W. <ven...@gm...>]

Hello SQLObject and friends,
  If I have the two classes:

class Product(InheritableSQLObject):
  name = StringCol(length=255, alternateID=True)
  description = StringCol()
  archived = BoolCol(default=False)
  options = RelatedJoin('ProductOption', orderBy="name")

class ProductOption(SQLObject):
  name = StringCol(alternateID=True, length=255)
  archived = BoolCol(default=False)
  products = RelatedJoin('Product', orderBy="name")

I want to get all products that are not archived of a given product option.

So how can I emulate this using a SQLBuilder and preferably without
mention of product_product_option?

SELECT * FROM product, product_product_option WHERE product.id =
product_product_option.product_id AND
product_product_option.product_option_id = 2 AND product.archived = 0;


Thanks in advance,
  -Ian

Re: [SQLObject] Related Join

[Rick F. <rf...@im...>]

Product.select(
     AND(Product.q.id == ProductOption.q.productID,
         ProductOption.q.id == 2,
         Product.q.archived == 0))

On Thu, 3 Aug 2006, Ian Wilson wrote:

> Hello SQLObject and friends,
>  If I have the two classes:
>
> class Product(InheritableSQLObject):
>  name = StringCol(length=255, alternateID=True)
>  description = StringCol()
>  archived = BoolCol(default=False)
>  options = RelatedJoin('ProductOption', orderBy="name")
>
> class ProductOption(SQLObject):
>  name = StringCol(alternateID=True, length=255)
>  archived = BoolCol(default=False)
>  products = RelatedJoin('Product', orderBy="name")
>
> I want to get all products that are not archived of a given product option.
>
> So how can I emulate this using a SQLBuilder and preferably without
> mention of product_product_option?
>
> SELECT * FROM product, product_product_option WHERE product.id =
> product_product_option.product_id AND
> product_product_option.product_option_id = 2 AND product.archived = 0;
>
>
> Thanks in advance,
>  -Ian
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>

Re: [SQLObject] Related Join

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

On Thu, Oct 14, 2004 at 02:11:46AM -0300, Michel Thadeu wrote:
> Hi guys!
> 
> I recently faced some problems with RelatedJoin, he is droping the
[...]
> 
> I upgraded the version last saturday, I used the site package 0.6, the
> old one was 0.6 too, but from svn... Is this a bug or this is the
> correct way of work now?

It's a bug, recently fixed in SVN.  Could you try upgrading to the latest
SQLObject in SVN and confirm that it fixes the bug?

-Andrew.