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 ...
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
