reports_models.py

# -*- coding: utf-8 -*-
from django.db import models
from jsonfield import JSONField

from base.fields import AutoSlugField
from graphs.models import Graph
from operators.models import Query


class ReportTemplate(models.Model):
    name = models.CharField(max_length=150)
    slug = AutoSlugField(populate_from=['name'], max_length=250,
                         editable=False, unique=True)
    start_date = models.DateTimeField()
    frequency = models.DateTimeField() # maybe here just use an integer in minutes...
    last_run = models.DateTimeField()
    table = JSONField()
    graph = models.ForeignKey(Graph, related_name='report_templates')
    queries = models.ManyToManyField(Query, related_name='report_templates')

    # Various methods here


class Report(models.Model):
    date_run = models.DateTimeField()
    slug = AutoSlugField(populate_from=['date_run'], max_length=250,
                         editable=False, unique=True) # maybe populate from date_run...
    table = JSONField()
    template = models.ForeignKey(ReportTemplate, related_name='reports')

    # Various methods here