from django.db import models


class CompanyManager(models.Manager):

    def get_for_index(self, index):
        return self.get(index=index)


class Company(models.Model):
    """
    A Paranuaran company.
    """

    # The index of the company record in the JSON source data
    index = models.PositiveIntegerField(unique=True)

    # Referred to as 'company' in the JSON source data
    company_name = models.CharField(unique=True, max_length=100)

    objects = CompanyManager()

    # A current employee isn't dead yet! ;-)
    @property
    def current_employees(self):
        return self.employees.is_alive()

    def __str__(self):
        return self.company_name

    class Meta:
        ordering = ['company_name']
        verbose_name_plural = 'Companies'


class FoodstuffQuerySet(models.QuerySet):

    def fruit(self):
        return self.filter(type=Foodstuff.FRUIT)

    def vegetables(self):
        return self.filter(type=Foodstuff.VEGETABLE)


class Foodstuff(models.Model):
    """
    A kind of food - initially either a fruit or a vegetable
    """
    FRUIT = 'f'
    VEGETABLE = 'v'

    TYPE_CHOICES = (
        (FRUIT, 'Fruit'),
        (VEGETABLE, 'Vegetable'),
    )

    name = models.CharField(unique=True, max_length=100)
    type = models.CharField(max_length=1, choices=TYPE_CHOICES)

    objects = FoodstuffQuerySet.as_manager()

    def __str__(self):
        return self.name

    class Meta:
        ordering = ['name']
        verbose_name_plural = 'Foodstuffs'


class Tag(models.Model):
    """
    A tag which can be linked to a Person
    """
    label = models.CharField(unique=True, max_length=100)

    def __str__(self):
        return self.label

    class Meta:
        ordering = ['label']
        verbose_name_plural = 'Tags'


class PersonQuerySet(models.QuerySet):

    def is_alive(self):
        return self.filter(has_died=False)

    def has_brown_eyes(self):
        return self.filter(eyecolor=Person.EYE_COLOR_BROWN)

    def has_friend(self, friend):
        return self.filter(friends=friend)

    def friend_of(self, friend):
        return self.filter(friend_of=friend)


class PersonManager(models.Manager):

    def get_for_index(self, index):
        return self.get(index=index)

    # TODO: Determine what 'friendship' actually means in this context!
    # Is a friendship define just by the 'has friend' (forward) relationship,
    # or also by the 'friend of' (reverse) relationship.
    #
    # Consider:
    #   Jack:
    #       friends: Jill, Simon
    #
    #   Jill:
    #       friends: Jack, Simon
    #
    #   Simon:
    #       friends: (none)
    #
    #   Susan:
    #       friends: Jack
    #
    # There are a range of reasonable answers to the question "who are Jack's
    # friends":
    #   1) Just the friends Jack lists: Jill & Simon
    #   2) (1) plus the people who list Jack as a friend: Jill, Simon, & Susan
    #   3) Only those who also consider Jack a friend: Jill (only)
    #
    # For the purposes of this exercise, we'll choose the easy option - 1!

    def mutual_friends_alive_with_brown_eyes(self, person, friend):
        # Select people who:
        #   'person' considers a friend and
        #   'friend' considers a friend and
        #   are still alive and
        #   have brown eyes
        return (self.friend_of(person).friend_of(friend).
                is_alive().has_brown_eyes())


class Person(models.Model):
    """
    A Paranuaran Person
    """
    EYE_COLOR_BLUE = 'bl'
    EYE_COLOR_BROWN = 'br'
    EYE_COLOR_CHOICES = (
        (EYE_COLOR_BLUE, 'Blue'),
        (EYE_COLOR_BROWN, 'Brown'),
    )

    GENDER_MALE = 'm'
    GENDER_FEMALE = 'f'
    GENDER_CHOICES = (
        (GENDER_MALE, 'Male'),
        (GENDER_FEMALE, 'Female'),
    )

    # The _id field from the JSON source file
    json_id = models.CharField(unique=True, max_length=24)

    # The index of of the Person record in the JSON file
    index = models.PositiveIntegerField(unique=True)

    guid = models.CharField(unique=True, max_length=36)

    has_died = models.BooleanField()

    balance = models.DecimalField(max_digits=8, decimal_places=2)

    picture = models.URLField()

    age = models.PositiveIntegerField()

    eyecolor = models.CharField(max_length=2, choices=EYE_COLOR_CHOICES)

    name = models.CharField(max_length=100)

    gender = models.CharField(max_length=1, choices=GENDER_CHOICES)

    company = models.ForeignKey(Company, null=True, blank=True,
                                related_name='employees')

    email = models.EmailField(unique=True)

    phone = models.CharField(max_length=30)

    address = models.CharField(max_length=200)

    about = models.TextField()

    registered = models.DateTimeField()

    tags = models.ManyToManyField(Tag, blank=True)

    friends = models.ManyToManyField('Person', blank=True,
                                     related_name='friend_of')

    greeting = models.CharField(max_length=100)

    favourite_food = models.ManyToManyField(Foodstuff)

    objects = PersonManager.from_queryset(PersonQuerySet)()

    @property
    def favourite_fruit(self):
        return self.favourite_food.fruit()

    @property
    def favourite_vegetables(self):
        return self.favourite_food.vegetables()

    def __str__(self):
        return self.name

    class Meta:
        ordering = ['name']
        verbose_name_plural = 'People'

from django.db import models


class CompanyManager(models.Manager):

    def get_for_index(self, index):
        return self.get(index=index)


class Company(models.Model):
    """
    A Paranuaran company.
    """

    # The index of the company record in the JSON source data
    index = models.PositiveIntegerField(unique=True)

    # Referred to as 'company' in the JSON source data
    company_name = models.CharField(unique=True, max_length=100)

    objects = CompanyManager()

    # A current employee isn't dead yet! ;-)
    @property
    def current_employees(self):
        return self.employees.is_alive()

    def __str__(self):
        return self.company_name

    class Meta:
        ordering = ['company_name']
        verbose_name_plural = 'Companies'


class FoodstuffQuerySet(models.QuerySet):

    def fruit(self):
        return self.filter(type=Foodstuff.FRUIT)

    def vegetables(self):
        return self.filter(type=Foodstuff.VEGETABLE)


class Foodstuff(models.Model):
    """
    A kind of food - initially either a fruit or a vegetable
    """
    FRUIT = 'f'
    VEGETABLE = 'v'

    TYPE_CHOICES = (
        (FRUIT, 'Fruit'),
        (VEGETABLE, 'Vegetable'),
    )

    name = models.CharField(unique=True, max_length=100)
    type = models.CharField(max_length=1, choices=TYPE_CHOICES)

    objects = FoodstuffQuerySet.as_manager()

    def __str__(self):
        return self.name

    class Meta:
        ordering = ['name']
        verbose_name_plural = 'Foodstuffs'


class Tag(models.Model):
    """
    A tag which can be linked to a Person
    """
    label = models.CharField(unique=True, max_length=100)

    def __str__(self):
        return self.label

    class Meta:
        ordering = ['label']
        verbose_name_plural = 'Tags'


class PersonQuerySet(models.QuerySet):

    def is_alive(self):
        return self.filter(has_died=False)

    def has_brown_eyes(self):
        return self.filter(eyecolor=Person.EYE_COLOR_BROWN)

    def has_friend(self, friend):
        return self.filter(friends=friend)

    def friend_of(self, friend):
        return self.filter(friend_of=friend)


class PersonManager(models.Manager):

    def get_for_index(self, index):
        return self.get(index=index)

    # TODO: Determine what 'friendship' actually means in this context!
    # Is a friendship define just by the 'has friend' (forward) relationship,
    # or also by the 'friend of' (reverse) relationship.
    #
    # Consider:
    #   Jack:
    #       friends: Jill, Simon
    #
    #   Jill:
    #       friends: Jack, Simon
    #
    #   Simon:
    #       friends: (none)
    #
    #   Susan:
    #       friends: Jack
    #
    # There are a range of reasonable answers to the question "who are Jack's
    # friends":
    #   1) Just the friends Jack lists: Jill & Simon
    #   2) (1) plus the people who list Jack as a friend: Jill, Simon, & Susan
    #   3) Only those who also consider Jack a friend: Jill (only)
    #
    # For the purposes of this exercise, we'll choose the easy option - 1!

    def mutual_friends_alive_with_brown_eyes(self, person, friend):
        # Select people who:
        #   'person' considers a friend and
        #   'friend' considers a friend and
        #   are still alive and
        #   have brown eyes
        return (self.friend_of(person).friend_of(friend).
                is_alive().has_brown_eyes())


class Person(models.Model):
    """
    A Paranuaran Person
    """
    EYE_COLOR_BLUE = 'bl'
    EYE_COLOR_BROWN = 'br'
    EYE_COLOR_CHOICES = (
        (EYE_COLOR_BLUE, 'Blue'),
        (EYE_COLOR_BROWN, 'Brown'),
    )

    GENDER_MALE = 'm'
    GENDER_FEMALE = 'f'
    GENDER_CHOICES = (
        (GENDER_MALE, 'Male'),
        (GENDER_FEMALE, 'Female'),
    )

    # The _id field from the JSON source file
    json_id = models.CharField(unique=True, max_length=24)

    # The index of of the Person record in the JSON file
    index = models.PositiveIntegerField(unique=True)

    guid = models.CharField(unique=True, max_length=36)

    has_died = models.BooleanField()

    balance = models.DecimalField(max_digits=8, decimal_places=2)

    picture = models.URLField()

    age = models.PositiveIntegerField()

    eyecolor = models.CharField(max_length=2, choices=EYE_COLOR_CHOICES)

    name = models.CharField(max_length=100)

    gender = models.CharField(max_length=1, choices=GENDER_CHOICES)

    company = models.ForeignKey(Company, null=True, blank=True,
                                related_name='employees')

    email = models.EmailField(unique=True)

    phone = models.CharField(max_length=30)

    address = models.CharField(max_length=200)

    about = models.TextField()

    registered = models.DateTimeField()

    tags = models.ManyToManyField(Tag, blank=True)

    friends = models.ManyToManyField('Person', blank=True,
                                     related_name='friend_of')

    greeting = models.CharField(max_length=100)

    favourite_food = models.ManyToManyField(Foodstuff)

    objects = PersonManager.from_queryset(PersonQuerySet)()

    @property
    def favourite_fruit(self):
        return self.favourite_food.fruit()

    @property
    def favourite_vegetables(self):
        return self.favourite_food.vegetables()

    def __str__(self):
        return self.name

    class Meta:
        ordering = ['name']
        verbose_name_plural = 'People'

A Paranuaran company. # The index of the company record in the JSON source data # Referred to as 'company' in the JSON source data # A current employee isn't dead yet! ;-) A kind of food - initially either a fruit or a vegetable A tag which can be linked to a Person # TODO: Determine what 'friendship' actually means in this context! # Is a friendship define just by the 'has friend' (forward) relationship, # or also by the 'friend of' (reverse) relationship. # # Consider: #   Jack: #       friends: Jill, Simon # #   Jill: #       friends: Jack, Simon # #   Simon: #       friends: (none) # #   Susan: #       friends: Jack # # There are a range of reasonable answers to the question "who are Jack's # friends": #   1) Just the friends Jack lists: Jill & Simon #   2) (1) plus the people who list Jack as a friend: Jill, Simon, & Susan #   3) Only those who also consider Jack a friend: Jill (only) # # For the purposes of this exercise, we'll choose the easy option - 1! # Select people who: #   'person' considers a friend and #   'friend' considers a friend and #   are still alive and #   have brown eyes A Paranuaran Person # The _id field from the JSON source file # The index of of the Person record in the JSON file