annotate gpp/weblinks/models.py @ 191:046e6ef0ff45

Added select_related() to weblinks.
author Brian Neal <bgneal@gmail.com>
date Thu, 01 Apr 2010 02:01:33 +0000
parents 5c889b587416
children fa7d82bfb100
rev   line source
gremmie@1 1 '''
gremmie@1 2 This module contains the models for the weblinks application.
gremmie@1 3 '''
gremmie@1 4
gremmie@1 5 from django.db import models
gremmie@1 6 from django.contrib import auth
gremmie@1 7
gremmie@1 8
gremmie@1 9 class Category(models.Model):
gremmie@1 10 '''Links belong to categories'''
gremmie@1 11 title = models.CharField(max_length = 64)
gremmie@1 12 description = models.TextField(blank = True)
gremmie@1 13
gremmie@1 14 def __unicode__(self):
gremmie@1 15 return self.title
gremmie@1 16
gremmie@1 17 def num_links(self):
gremmie@1 18 return Link.public_objects.filter(category = self.pk).count()
gremmie@1 19
gremmie@1 20 class Meta:
gremmie@1 21 verbose_name_plural = 'Categories'
gremmie@1 22 ordering = ('title', )
gremmie@1 23
gremmie@1 24
gremmie@1 25 class PublicLinkManager(models.Manager):
gremmie@1 26 """The manager for all public links."""
gremmie@1 27 def get_query_set(self):
bgneal@191 28 return super(PublicLinkManager, self).get_query_set().filter(
bgneal@191 29 is_public=True).select_related()
gremmie@1 30
gremmie@1 31
gremmie@1 32 class Link(models.Model):
gremmie@1 33 '''Model to represent a web link'''
gremmie@1 34 category = models.ForeignKey(Category)
gremmie@1 35 title = models.CharField(max_length=128)
gremmie@1 36 url = models.URLField(verify_exists=False, db_index=True)
gremmie@1 37 description = models.TextField(blank=True)
gremmie@1 38 user = models.ForeignKey(auth.models.User)
gremmie@1 39 date_added = models.DateField(auto_now_add=True)
gremmie@1 40 hits = models.IntegerField(default=0)
gremmie@1 41 is_public = models.BooleanField(default=False, db_index=True)
gremmie@1 42
gremmie@1 43 # Managers:
gremmie@1 44 objects = models.Manager()
gremmie@1 45 public_objects = PublicLinkManager()
gremmie@1 46
bgneal@20 47 class Meta:
bgneal@20 48 ordering = ('title', )
bgneal@20 49
gremmie@1 50 def __unicode__(self):
gremmie@1 51 return self.title
gremmie@1 52
bgneal@20 53 @models.permalink
bgneal@20 54 def get_absolute_url(self):
bgneal@20 55 return ('weblinks-link_detail', [str(self.id)])
gremmie@1 56
gremmie@1 57
gremmie@1 58 class FlaggedLinkManager(models.Manager):
gremmie@1 59
gremmie@1 60 def create(self, link, user):
gremmie@1 61 flagged_link = FlaggedLink(link = link, user = user, approved = False)
gremmie@1 62 flagged_link.save()
gremmie@1 63
gremmie@1 64
gremmie@1 65 class FlaggedLink(models.Model):
gremmie@1 66 '''Model to represent links that have been flagged as broken by users'''
gremmie@1 67 link = models.ForeignKey(Link)
gremmie@1 68 user = models.ForeignKey(auth.models.User)
gremmie@1 69 date_flagged = models.DateField(auto_now_add = True)
gremmie@1 70 approved = models.BooleanField(default = False,
gremmie@1 71 help_text = 'Check this and save to remove the referenced link from the database')
gremmie@1 72
gremmie@1 73 objects = FlaggedLinkManager()
gremmie@1 74
bgneal@182 75 def save(self, *args, **kwargs):
gremmie@1 76 if self.approved:
gremmie@1 77 self.link.delete()
gremmie@1 78 self.delete()
gremmie@1 79 else:
bgneal@182 80 super(FlaggedLink, self).save(*args, **kwargs)
gremmie@1 81
gremmie@1 82 def url(self):
gremmie@1 83 return self.link.url
gremmie@1 84
bgneal@165 85 def get_link_url(self):
bgneal@165 86 return '<a href="%s">Link #%d</a>' % (self.link.get_absolute_url(),
bgneal@165 87 self.link.id)
bgneal@165 88 get_link_url.allow_tags = True
bgneal@165 89 get_link_url.short_description = "View Link on Site"
bgneal@165 90
gremmie@1 91 def __unicode__(self):
gremmie@1 92 return self.link.title
gremmie@1 93
gremmie@1 94 class Meta:
gremmie@1 95 ordering = ('-date_flagged', )