Aaah Michael, thanks! This is awesome! I tried a lot and all the time I felt that I missed exact this kind of easy answer. ;)
Thanks again. Will implement this now. Sven Am Dienstag, 30. Dezember 2014 17:01:14 UTC+1 schrieb Michael Bayer: > > why don’t you set up your PrimaryKeyConstraint directly? > > class AbstractPK(NameByClass): > """ this table defines a frequently used composite primary key """ > > @declared_attr > def key1(cls): > return Column(ForeignKey("somekey.keypart1"), primary_key=True) > > @declared_attr > def key2(cls): > return Column(ForeignKey("anotherkey.keypart2"), primary_key=True) > > key3 = Column( Integer, primary_key=True ) > > @declared_attr > def __table_args__(self): > return ( > PrimaryKeyConstraint('key1', 'key2', 'key3'), > ) > > > > > Sven Teresniak <realk...@gmail.com <javascript:>> wrote: > > > Am Freitag, 2. Juli 2010 02:24:05 UTC+2 schrieb Michael Bayer: > >> The Column object contains a "sort key" when constructed, against a >> single global value, that is used as a sort key when the Table is >> generated. This is to get around the fact that the attribute dictionary of >> the declarative class is unordered. >> >> The mixin columns should copy their "sort key" over, or it should somehow >> be tailored in the declarative base so that the order of the two columns >> stays relatively the same, and perhaps is also tailored to be at the same >> position relative to the other columns in the ultimate table. >> >> I'd welcome any patches in this regard since I don't usually deal with >> the "mixin" feature. >> > Is there any simple way to modify/set this "sort key" or is there any way > for me to workaround this random ordering in the class dict? Or to simple > inspect the ordering to generate code that re-orders my primary composite > key parts accordingly? > > Thanks > Sven > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+...@googlegroups.com <javascript:>. > To post to this group, send email to sqlal...@googlegroups.com > <javascript:>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.