annotate gpp/bio/models.py @ 118:a20b2c492d55

Reduced some sql queries by adding a select_related and monkey patching user profiles onto a user list in shoutbox and the bio/member's list, respectively.
author Brian Neal <bgneal@gmail.com>
date Sat, 24 Oct 2009 02:39:19 +0000
parents 93d9e74a471e
children f8f4514b806a
rev   line source
gremmie@1 1 """
gremmie@1 2 Contains models for the bio application.
gremmie@1 3 I would have picked profile for this application, but that is already taken, apparently.
gremmie@1 4 """
gremmie@1 5
gremmie@1 6 import os.path
gremmie@1 7
gremmie@1 8 from django.db import models
gremmie@1 9 from django.contrib import auth
gremmie@1 10 from django.conf import settings
gremmie@1 11 from django.template.loader import render_to_string
bgneal@54 12 from django.core.cache import cache
gremmie@1 13
gremmie@1 14
gremmie@1 15 def avatar_file_path_for_user(username, filename):
gremmie@1 16 return os.path.join(settings.AVATAR_DIR, 'users', username, filename)
gremmie@1 17
gremmie@1 18 def avatar_file_path(instance, filename):
gremmie@1 19 return avatar_file_path_for_user(instance.user.username, filename)
gremmie@1 20
gremmie@1 21
gremmie@1 22 class UserProfile(models.Model):
gremmie@1 23 """model to represent additional information about users"""
gremmie@1 24
gremmie@1 25 user = models.ForeignKey(auth.models.User, unique=True)
gremmie@1 26 location = models.CharField(max_length=128, blank=True)
gremmie@1 27 birthday = models.DateField(blank=True, null=True,
gremmie@1 28 help_text='Optional; the year is not shown to others')
gremmie@1 29 occupation = models.CharField(max_length=128, blank=True)
gremmie@1 30 interests = models.CharField(max_length=255, blank=True)
gremmie@1 31 profile_text = models.TextField(blank=True)
gremmie@1 32 profile_html = models.TextField(blank=True)
gremmie@1 33 hide_email = models.BooleanField(default=True)
gremmie@1 34 signature = models.TextField(blank=True)
gremmie@1 35 signature_html = models.TextField(blank=True)
gremmie@1 36 avatar = models.ImageField(upload_to=avatar_file_path, blank=True)
bgneal@70 37 time_zone = models.CharField(max_length=64, blank=True,
bgneal@70 38 default='US/Pacific')
bgneal@96 39 forum_post_count = models.IntegerField(default=0)
gremmie@1 40
gremmie@1 41 def __unicode__(self):
gremmie@1 42 return self.user.username
gremmie@1 43
gremmie@1 44 class Meta:
gremmie@1 45 ordering = ('user__username', )
gremmie@1 46
gremmie@1 47 def save(self, *args, **kwargs):
gremmie@1 48 html = render_to_string('bio/markdown.html', {'data': self.profile_text})
gremmie@1 49 self.profile_html = html.strip()
gremmie@1 50 html = render_to_string('bio/markdown.html', {'data': self.signature})
gremmie@1 51 self.signature_html = html.strip()
gremmie@1 52 super(UserProfile, self).save(*args, **kwargs)
bgneal@54 53 cache.delete('avatar_' + self.user.username)
gremmie@1 54