Added hack to SQL in TagManager.related_for_model to prevent severe performance loss...

[wolnelektury.git] / apps / catalogue / models.py

diff --git a/apps/catalogue/models.py b/apps/catalogue/models.py
index 9786150..7bddbbd 100644 (file)
--- a/apps/catalogue/models.py
+++ b/apps/catalogue/models.py
@@ -34,8 +34,8 @@ class TagSubcategoryManager(models.Manager):
 
 class Tag(TagBase):
     name = models.CharField(_('name'), max_length=50, unique=True, db_index=True)
 
 class Tag(TagBase):
     name = models.CharField(_('name'), max_length=50, unique=True, db_index=True)

-    slug = models.SlugField(_('slug'), unique=True, db_index=True)
-    sort_key = models.SlugField(_('sort key'), db_index=True)
+    slug = models.SlugField(_('slug'), max_length=120, unique=True, db_index=True)
+    sort_key = models.SlugField(_('sort key'), max_length=120, db_index=True)

     category = models.CharField(_('category'), max_length=50, blank=False, null=False, 
         db_index=True, choices=TAG_CATEGORIES)
     description = models.TextField(blank=True)
     category = models.CharField(_('category'), max_length=50, blank=False, null=False, 
         db_index=True, choices=TAG_CATEGORIES)
     description = models.TextField(blank=True)


@@ -70,7 +70,7 @@ class Tag(TagBase):
 
 class Book(models.Model):
     title = models.CharField(_('title'), max_length=120)
 
 class Book(models.Model):
     title = models.CharField(_('title'), max_length=120)

-    slug = models.SlugField(_('slug'), unique=True, db_index=True)
+    slug = models.SlugField(_('slug'), max_length=120, unique=True, db_index=True)

     description = models.TextField(_('description'), blank=True)
     created_at = models.DateTimeField(_('creation date'), auto_now=True)
     _short_html = models.TextField(_('short HTML'), editable=False)
     description = models.TextField(_('description'), blank=True)
     created_at = models.DateTimeField(_('creation date'), auto_now=True)
     _short_html = models.TextField(_('short HTML'), editable=False)


@@ -207,7 +207,7 @@ class Fragment(models.Model):
     text = models.TextField()
     short_text = models.TextField(editable=False)
     _short_html = models.TextField(editable=False)
     text = models.TextField()
     short_text = models.TextField(editable=False)
     _short_html = models.TextField(editable=False)

-    anchor = models.IntegerField()
+    anchor = models.CharField(max_length=120)

     book = models.ForeignKey(Book, related_name='fragments')
 
     objects = models.Manager()
     book = models.ForeignKey(Book, related_name='fragments')
 
     objects = models.Manager()