view gpp/core/models.py @ 334:6805d15cda13

Adding a script I had to write on the fly to filter out posts from the posts csv file that had no parent topics. MyISAM let me get away with that, but InnoDB won't.
author Brian Neal <bgneal@gmail.com>
date Sat, 26 Feb 2011 01:28:22 +0000
parents dcc929973bba
children 3fe60148f75c
line wrap: on
line source
"""
This file contains the core Models used in gpp
"""
import datetime

from django.db import models
from django.contrib.auth.models import User


class UserLastVisit(models.Model):
    """
    This model represents timestamps indicating a user's last visit to the
    site.
    """
    user = models.ForeignKey(User, unique=True)
    last_visit = models.DateTimeField(db_index=True)


class AnonLastVisit(models.Model):
    """
    This model represents timestamps for the last visit from non-authenticated
    users.
    """
    ip = models.CharField(max_length=16, db_index=True, unique=True)
    last_visit = models.DateTimeField(db_index=True)


class Statistic(models.Model):
    """
    This model keeps track of site statistics. Currently, the only statistic
    is the maximum number of users online. This stat is computed by a mgmt.
    command that is run on a cron job to peek at the previous two models.
    """
    max_users = models.IntegerField()
    max_users_date = models.DateTimeField()
    max_anon_users = models.IntegerField()
    max_anon_users_date = models.DateTimeField()

    def __unicode__(self):
        return u'%d users on %s' % (self.max_users, 
                self.max_users_date.strftime('%Y-%m-%d %H:%M:%S'))