sqlobject-discuss

[SQLObject] Quesiton about multiple Joins

[Cary F. <ckf...@ho...>]

Hey all,

I'm using SQLObject 0.5 with SQLite and had a problem with multiple joins.

The relevant code is:

class Users(SQLObject):
    _connection = conn
    name = StringCol(default=None)
    email = StringCol(default=None)
    password = StringCol()
    username = StringCol(alternateID=True)
    lastLogin = DateTimeCol(default=None)
    user_type = IntCol(default=None)
    projects = MultipleJoin('Projects')

AND:

class Projects(SQLObject):
    _connection = conn
    state = IntCol()
    number = IntCol(alternateID=True)
    creator = ForeignKey('Users')
    client = ForeignKey('Clients',notNone=True)

As far as I could tell in the documentation to connect these two tables, I 
just say:
Projects.add(blah blah, creator=Users(1))

and then
for a in Users(1).projects:
        print a

should give me something, but it just says that there is no users_id in the 
projects table.

I am guessing that there is some flag I am not setting or something I'm not 
doing that would make that flag get added.

Any suggestions?

_________________________________________________________________
Get fast, reliable Internet access with MSN 9 Dial-up – now 3 months FREE! 
http://join.msn.click-url.com/go/onm00200361ave/direct/01/

Re: [SQLObject] Quesiton about multiple Joins

[Ivo v. d. W. <iv...@am...>]

On 15-jun-04, at 16:52, Cary Fitzhugh wrote:

> Hey all,
>
> I'm using SQLObject 0.5 with SQLite and had a problem with multiple 
> joins.
>
> The relevant code is:
>
> class Users(SQLObject):
>    _connection = conn
>    name = StringCol(default=None)
>    email = StringCol(default=None)
>    password = StringCol()
>    username = StringCol(alternateID=True)
>    lastLogin = DateTimeCol(default=None)
>    user_type = IntCol(default=None)
>    projects = MultipleJoin('Projects')
>
> AND:
>
> class Projects(SQLObject):
>    _connection = conn
>    state = IntCol()
>    number = IntCol(alternateID=True)
>    creator = ForeignKey('Users')
>    client = ForeignKey('Clients',notNone=True)
>
> As far as I could tell in the documentation to connect these two 
> tables, I just say:
> Projects.add(blah blah, creator=Users(1))
>
> and then
> for a in Users(1).projects:
>        print a
>
> should give me something, but it just says that there is no users_id 
> in the projects table.
>

Add joinColumn="creator_id' in your MultipleJoin definition.

Cheers

	Ivo