Django Notes

django-notes.md

Accessing ORM from outside django

import os
# first set your django settings (might need to append sys path for this to work)
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "django_root.settings.local")
# then you can import models and access ORM functions
from django_root.myapp import models
models.MyTable.objects.all()

Custom methods on database table

Link to Docs

from django.db import models

class Person(models.Model):
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)
    birth_date = models.DateField()

    def baby_boomer_status(self):
        "Returns the person's baby-boomer status."
        import datetime
        if self.birth_date < datetime.date(1945, 8, 1):
            return "Pre-boomer"
        elif self.birth_date < datetime.date(1965, 1, 1):
            return "Baby boomer"
        else:
            return "Post-boomer"