On Mon, 04 Sep 2006 15:51:06 +0200
Sol <[EMAIL PROTECTED]> wrote:
> Hello, not sure if i got you right, but here is what i think.
>
> > users_projects=Table('users_projects', metadata,
> > Column('id_users', Integer, ForeignKey('users.id_users')),
> > Column('id_projects', Integer,
> > ForeignKey('projects.id_projects')), )
> >
> > users_projects.create()
> >
> > class Users(object):
> > pass
> > class Projects(object):
> > pass
> >
> > umapper=mapper(Users, users)
>
> umapper = mapper(Users, users, properties = dict(
> projects = relation(Projects, secondary = users_projects),
> ))
>
> > pmapper=mapper(Projects, projects, properties={
> > 'users' : relation(Users, secondary=users_projects,
> > backref="projects"), }
> > )
>
>
>
> >
> > u=session.query(Users).select()
> >
> > for i in range(len(u)):
> > pr=u[i].fk_project.split(',')
> > for p in range(len(pr)-1):
> >
> > pname=session.query(Projects).selectfirst(projects.c.id_projects==pr[p])
> > ????????
>
> all_usuers = session.query(Users).select()
>
> for user in all_users:
> project_ids = user.fk_project.split(',')
> for project_id in project_ids:
> project = session.get(Projects, project_id)
> user.projects.append(project)
>
> session.flush()
>
>
> > Actually, the users table has a fk_project field like 1,15,3,. Each
> Now dismiss the fk_project field altogether, you do not need it with
> many-to-many relationships.
>
Thanks seems to works. But when I try to get some results I obtain
an object.
>>> u=session.query(Users).selectfirst(users.c.login=='morelli')
>>> u.login
morelli
>>> u.projects
[<__main__.Projects object at 0xb77f8cac>]
How can I obtain the project names related to a given user?
Thanks
--
-------------------------------------------------------------------
(o_
(o_ //\ Coltivate Linux che tanto Windows si pianta da solo.
(/)_ V_/_
+------------------------------------------------------------------+
| ENRICO MORELLI | email: [EMAIL PROTECTED] |
| * * * * | phone: +39 055 4574269 |
| University of Florence | fax : +39 055 4574253 |
| CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY |
+------------------------------------------------------------------+
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
