Changeset 120

Timestamp:

06/12/07 20:19:26 (6 years ago)

Author:

bbangert

Message:

Adding select_by helper function to query associables for columns from the associated table.

Files:

• elixir/trunk/elixir/ext/associable.py (modified) (3 diffs)

elixir/trunk/elixir/ext/associable.py

@@ -158 +158 @@
             entity._descriptor.add_field(field)
             entity._descriptor.relationships[able_name] = self
+            
+            def select_by(cls, **kwargs):
+                return cls.query().join(attr_name).join('targets').filter_by(**kwargs).list()
+            setattr(entity, 'select_by_%s' % self.name, classmethod(select_by))
         
-        def setup(self):        
+        def setup(self):
             self.create_properties()
             return True
@@ -167 +171 @@
             entity.mapper.add_property(attr_name, sa.relation(GenericAssoc, lazy=self.lazy,
                                        backref='_backref_%s' % entity.table.name))
+            entity.mapper.add_property(self.name, sa.synonym(attr_name))
             if self.uselist:
                 def get(self):
@@ -184 +189 @@
                     getattr(self, attr_name).targets = [value]
                 setattr(entity, self.name, property(get, set))
-        
+                
     sa.mapper(GenericAssoc, association_table, properties={
         'targets':sa.relation(entity, secondary=association_to_table,