i want to add a composite index to the class inherited from declarative_base
I tried this, class MyClass: __tablename__ = 'my_table' id = Column(Integer, primary_key=True) name = Column(String, nullable=False) type = Column(String, nullable=False) __table_args__ = ( Index('ix_name_type','name','type',unique=True) ) gave me an error, File "/m2svn/trunk/src/model/MyClass.py", line 32, in MyClass __table_args__ = ( File "/usr/lib/python2.4/site-packages/SQLAlchemy-0.5.5-py2.4.egg/ sqlalchemy/schema.py", line 1461, in __init__ self._init_items(*columns) File "/usr/lib/python2.4/site-packages/SQLAlchemy-0.5.5-py2.4.egg/ sqlalchemy/schema.py", line 1465, in _init_items self.append_column(_to_schema_column(column)) File "/usr/lib/python2.4/site-packages/SQLAlchemy-0.5.5-py2.4.egg/ sqlalchemy/schema.py", line 2145, in _to_schema_column raise exc.ArgumentError("schema.Column object expected") sqlalchemy.exc.ArgumentError: schema.Column object expected On Aug 21, 3:23 am, Michael Bayer <mike...@zzzcomputing.com> wrote: > this is usually accomplished using "Index()". see the metadata docs > for details. > > On Aug 20, 2009, at 12:35 PM, rajasekhar911 wrote: > > > > > Hi > > > Is it possible to add index to my table using sqlalchemy? > > Or should i do it directly on the database? > > > Thanks.. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---