On Monday 03 December 2007 17:49:15 lolostar wrote:
> On 3 déc, 17:37, "Diez B. Roggisch" <[EMAIL PROTECTED]> wrote:
> > On Monday 03 December 2007 16:56:07 lolostar wrote:
> > > Hi,
> > >
> > > I try to use a foreign key and a multiple join in my model but as my
> > > fkey column is named ''agence' in my model, it is created as
> > > 'agence_id' in my database and, here's the problem, whenever I call
> > > 'AgenceEDF.get(1).photos()' for example, the sql generated uses the
> > > 'agence' name :
> > >
> > > ProgrammingError: column "agence" does not exist
> > > LINE 1: SELECT id FROM agences.photo WHERE agence = (1)
> > >
> > > Here's my model :
> > >
> > > class AgenceEDF(SQLObject):
> > > class sqlmeta:
> > > table ='agences.agenceedf2'
> > > idName ='id'
> > > codepostal = UnicodeCol(length=5)
> > > lat = FloatCol(default=None)
> > > lon = FloatCol(default=None)
> > > nom = UnicodeCol(length=100,varchar=True)
> > > adresse = UnicodeCol(length=100,varchar=True)
> > > complement_adresse = UnicodeCol(length=100,varchar=True)
> > > commune = UnicodeCol(length=100,varchar=True)
> > > telephone = UnicodeCol(length=25,varchar=True, default=None)
> > > plage_horaire = UnicodeCol(length=100,varchar=True, default=None)
> > > jours_ouverture = UnicodeCol(length=100,varchar=True,
> > > default=None)
> > > dcpp = UnicodeCol(length=25,varchar=True, default=None)
> > > type_accueil = UnicodeCol(length=25,varchar=True, default=None)
> > > photos = MultipleJoin('Photo',joinColumn='agence')
> > >
> > > class Photo(SQLObject):
> > > class sqlmeta:
> > > table ='agences.photo'
> > > idName ='id'
> > > agence = ForeignKey('AgenceEDF')
> > > image = BLOBCol(default=None)
> > > thumbnail = BLOBCol(default=None)
> > > created = DateTimeCol(default = datetime.now)
> > > tag = UnicodeCol(length = 10,default=None)
> > > description = UnicodeCol(default=None)
> > >
> > > agence_idx = DatabaseIndex("agence")
> > >
> > > Any idea ?
> >
> > Just get rid of the joinColumn attribute in the AgenceEDF.photos column
> > descriptor.
> >
> > Diez
>
> Hi,
>
> when I do that, I get an error : the SQL generator forgets the from
> clause and is looking for a wrong 'agenceedf2_id' in agenceEDF.
> But, when I replace :
> agence = ForeignKey('AgenceEDF')
> by
> agence = IntCol()
>
> it works just fine ...
> --~--~---------~--~----
Hm. I'm not sure then, but maybe you should use
Child.ForeignKey
Parent.RelatedJoin
insttead of MultipleJoin.
If everything goes wrong, pinning down the columnName on both parts of the
join should be an option, to.
Diez
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
