- The Index() construct can be created inline with a Table

definition, using strings as column names, as an alternative
to the creation of the index outside of the Table.

1 files changed, 20 insertions, 1 deletions

diff --git a/lib/sqlalchemy/ext/declarative.py b/lib/sqlalchemy/ext/declarative.py
index 39aaf5488..898a9a728 100755
--- a/lib/sqlalchemy/ext/declarative.py
+++ b/lib/sqlalchemy/ext/declarative.py
@@ -819,7 +819,7 @@ from multiple collections::
         __tablename__='my_model'
 
         @declared_attr
-        def __table_args__(self):
+        def __table_args__(cls):
             args = dict()
             args.update(MySQLSettings.__table_args__)
             args.update(MyOtherMixin.__table_args__)
@@ -827,6 +827,25 @@ from multiple collections::
 
         id =  Column(Integer, primary_key=True)
 
+Creating Indexes with Mixins
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+To define a named, potentially multicolumn :class:`.Index` that applies to all 
+tables derived from a mixin, use the "inline" form of :class:`.Index` and establish
+it as part of ``__table_args__``::
+
+    class MyMixin(object):
+        a =  Column(Integer)
+        b =  Column(Integer)
+        
+        @declared_attr
+        def __table_args__(cls):
+            return (Index('test_idx_%s' % cls.__tablename__, 'a', 'b'),)
+
+    class MyModel(Base,MyMixin):
+        __tablename__ = 'atable'
+        c =  Column(Integer,primary_key=True)
+
 
 Class Constructor
 =================