Re: [sqlalchemy] relationship problem

2015-03-12 Thread Michael Bayer
Julien Cigar wrote: > > Hi Mike, > > Sorry to bother you once with this, but I've re-read all the docs on > the relationships and I want to be sure that I've understand correctly. > > Imagine I have the following "link" table in SQL: > https://gist.github.com/silenius/77d406f8e0c0e26eb38f wi

Re: [sqlalchemy] relationship problem

2015-03-12 Thread Julien Cigar
On Mon, Mar 02, 2015 at 12:15:51PM -0500, Michael Bayer wrote: > > > Julien Cigar wrote: > > > On Sun, Mar 01, 2015 at 01:53:30PM +0100, Julien Cigar wrote: > >> On Fri, Feb 27, 2015 at 11:38:05PM -0500, Michael Bayer wrote: > On Feb 26, 2015, at 5:56 AM, Julien Cigar wrote: > > >>>

Re: [sqlalchemy] relationship problem

2015-03-02 Thread Michael Bayer
Julien Cigar wrote: > On Sun, Mar 01, 2015 at 01:53:30PM +0100, Julien Cigar wrote: >> On Fri, Feb 27, 2015 at 11:38:05PM -0500, Michael Bayer wrote: On Feb 26, 2015, at 5:56 AM, Julien Cigar wrote: > On Wed, Feb 25, 2015 at 06:10:55PM -0500, Michael Bayer wrote: > > >

Re: [sqlalchemy] relationship problem

2015-03-02 Thread Julien Cigar
On Sun, Mar 01, 2015 at 01:53:30PM +0100, Julien Cigar wrote: > On Fri, Feb 27, 2015 at 11:38:05PM -0500, Michael Bayer wrote: > > > > > > > > > On Feb 26, 2015, at 5:56 AM, Julien Cigar wrote: > > > > > >> On Wed, Feb 25, 2015 at 06:10:55PM -0500, Michael Bayer wrote: > > >> > > >> > > >> J

Re: [sqlalchemy] relationship problem

2015-03-01 Thread Julien Cigar
On Fri, Feb 27, 2015 at 11:38:05PM -0500, Michael Bayer wrote: > > > > > On Feb 26, 2015, at 5:56 AM, Julien Cigar wrote: > > > >> On Wed, Feb 25, 2015 at 06:10:55PM -0500, Michael Bayer wrote: > >> > >> > >> Julien Cigar wrote: > >> > On Thu, Feb 19, 2015 at 11:31:10AM -0500, Michael

Re: [sqlalchemy] relationship problem

2015-02-27 Thread Michael Bayer
> On Feb 26, 2015, at 5:56 AM, Julien Cigar wrote: > >> On Wed, Feb 25, 2015 at 06:10:55PM -0500, Michael Bayer wrote: >> >> >> Julien Cigar wrote: >> On Thu, Feb 19, 2015 at 11:31:10AM -0500, Michael Bayer wrote: Julien Cigar wrote: >> On Thu, Feb 19, 2015 at 02:45:43

Re: [sqlalchemy] relationship problem

2015-02-26 Thread Julien Cigar
On Wed, Feb 25, 2015 at 06:10:55PM -0500, Michael Bayer wrote: > > > Julien Cigar wrote: > > > On Thu, Feb 19, 2015 at 11:31:10AM -0500, Michael Bayer wrote: > >> Julien Cigar wrote: > >> > >>> On Thu, Feb 19, 2015 at 02:45:43PM +0100, Julien Cigar wrote: > Hello, > > I'm usin

Re: [sqlalchemy] relationship problem

2015-02-25 Thread Michael Bayer
Julien Cigar wrote: > On Thu, Feb 19, 2015 at 11:31:10AM -0500, Michael Bayer wrote: >> Julien Cigar wrote: >> >>> On Thu, Feb 19, 2015 at 02:45:43PM +0100, Julien Cigar wrote: Hello, I'm using SQLAlchemy 0.9.8 with PostgreSQL and the reflection feature of SQLAlchemy. >>>

Re: [sqlalchemy] relationship problem

2015-02-24 Thread Julien Cigar
On Thu, Feb 19, 2015 at 11:31:10AM -0500, Michael Bayer wrote: > > > Julien Cigar wrote: > > > On Thu, Feb 19, 2015 at 02:45:43PM +0100, Julien Cigar wrote: > >> Hello, > >> > >> I'm using SQLAlchemy 0.9.8 with PostgreSQL and the reflection feature of > >> SQLAlchemy. > >> > >> I have the fol

Re: [sqlalchemy] relationship problem

2015-02-19 Thread Julien Cigar
On Thu, Feb 19, 2015 at 11:31:10AM -0500, Michael Bayer wrote: > > > Julien Cigar wrote: > > > On Thu, Feb 19, 2015 at 02:45:43PM +0100, Julien Cigar wrote: > >> Hello, > >> > >> I'm using SQLAlchemy 0.9.8 with PostgreSQL and the reflection feature of > >> SQLAlchemy. > >> > >> I have the fol

Re: [sqlalchemy] relationship problem

2015-02-19 Thread Michael Bayer
Julien Cigar wrote: > On Thu, Feb 19, 2015 at 02:45:43PM +0100, Julien Cigar wrote: >> Hello, >> >> I'm using SQLAlchemy 0.9.8 with PostgreSQL and the reflection feature of >> SQLAlchemy. >> >> I have the following tables (only relevant parts are show): >> https://gist.github.com/silenius/390

Re: [sqlalchemy] relationship problem

2015-02-19 Thread Julien Cigar
On Thu, Feb 19, 2015 at 02:45:43PM +0100, Julien Cigar wrote: > Hello, > > I'm using SQLAlchemy 0.9.8 with PostgreSQL and the reflection feature of > SQLAlchemy. > > I have the following tables (only relevant parts are show): > https://gist.github.com/silenius/390bb9937490730741f2 > > and the "p

Re: [sqlalchemy] relationship problem

2012-11-10 Thread Werner
Michael, On 09/11/2012 23:40, Michael Bayer wrote: ... Authuser.cellar = sao.relationship('Cellar', primaryjoin= ('Authuser.fk_cellar_id==Cellar.id')) With this query I don't get the authuser relation on the second record even so the fk_authuser_id is set to 1, which is the same a

Re: [sqlalchemy] relationship problem

2012-11-09 Thread Michael Bayer
On Nov 9, 2012, at 3:45 AM, Werner wrote: > Hi, > > I don't understand why on one record I don't get the authuser relation. > > My definition is: > class Cellar(DeclarativeBase, mix.StandardColumnMixin): >__tablename__ = u'cellar' > >name = sa.Column(sa.Unicode(length=50), nullable=Fal

RE: [sqlalchemy] relationship problem

2011-07-12 Thread King Simon-NFHD78
mik wrote: > Hello, > > I am trying to use sqlalchemy with oracle, here is my code: > > from sqlalchemy import * > from sqlalchemy.orm import sessionmaker, mapper, relationship > class Activite(object): > pass > class Famprod(object): > pass > engine = create_engine('oracle://login/paswd@