Untitled

from django.db import models
from django.db.models import Count
from datetime import date, timedelta


class CinemaInfoManager(models.Manager):
    def get_query_set(self):
        qs = super(CinemaInfoManager, self).get_query_set()
        return qs.filter({'inicio__lte': date.today(), 'fim__gte': date.today()})


class CinemaInfo(models.Model):
    codigo = models.IntegerField(primary_key=True, db_column='CODIGO')
    cinema = models.ForeignKey('Cinema', db_column='COD_CINEMA')
    obs = models.TextField(db_column='OBS')
    inicio = models.DateField(db_column='DATA_I')
    fim = models.DateField(db_column='DATA_F')
    objects = CinemaInfoManager()

    class Meta:
        db_table = u'OBS_CINE'
        managed = False