Changeset 712

Timestamp:

11/25/10 10:09:51 (3 years ago)

Author:

jose.brandao

Message:

Support for fossil indexing

Location:

sandbox/django-fossil/fossil

Files:

• migrations/0003_index.py (added)
• models.py (modified) (2 diffs)

sandbox/django-fossil/fossil/models.py

@@ -34 +34 @@
         return qs.filter(content_type=c_type, object_id=obj.pk).order_by('creation')
 
+    def indexed(self, **kwargs):
+        """
+        Find fossils by fossil indexes
+        """
+        qs = self.get_query_set()
+
+        # Find all indexes by given key and value
+        indexeds = FossilIndexer.objects.all()
+        for k,v in kwargs.items():
+            indexeds = indexeds.filter(**{'key': k, 'value': v})
+
+        pks = indexeds.distinct().values_list('fossil', flat=True)
+
+        return qs.filter(pk__in=pks)
+
 class Fossil(models.Model):
     objects = FossilManager()
@@ -66 +81 @@
             return list(deserialize('json', data))[0]
     
+class FossilIndexer(models.Model):
+    """
+    Class used to index fossil by field values. This is a sollution for querying
+    fossils withouth use search in the field 'serialized'. Of course, this is
+    because index + join is faster than like.
+    """
+    class Meta:
+        unique_together = (
+                ('fossil','key','value'),
+                )
+
+    fossil = models.ForeignKey('Fossil', related_name='indexeds')
+    key = models.CharField(max_length=250)
+    value = models.CharField(max_length=250)
+
 # SIGNALS
 from django.db.models import signals