okay, I succeded to get the property I want:
from sqlalchemy import UniqueConstraint
from myproject import model
for constraint in model.User.__table__.constraints:
if isinstance(constraint, UniqueConstraint):
for columns in constraint.columns:
print 'column ' + columns.name + ' has unique contraint'
is there a better way to do that ?
On Jul 22, 11:54 am, Oliver Christen <[email protected]>
wrote:
> hello all
>
> Im tring to find a way to extract from the model which colums have the
> attribute "unique" set, but after reading the documentation, exploring
> the source code and many many attempts, Im failing miserably.
>
> is there any way to do that?
>
> im using sqlalchemy 0.6.5 with the declarative syntax
>
> class User(Base):
> __tablename__ = 'user'
> id = Column(types.Integer, primary_key=True)
> username = Column(types.Unicode, unique=True, nullable=False)
>
> I would like to be able to find that username has unique = True
>
> from myproject import model
> # do something to find the column with unique=True
> ???
>
> thanks in advance
> best regards
> Oliver
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en.
