<reponame>kigold/fullApp
from django.db import models
from . import Team, Profile
from django.core.validators import MaxValueValidator, MinValueValidator


class Game(models.Model):

    class Game_Status(models.IntegerChoices):
        Fixtured = 1
        Played = 2
        Postponed = 3
    '''GAME_STATUS = [
        (1, "Fixture"),
        (2, "Played"),
        (3, "Postponed")
    ]'''
    away_user = models.ForeignKey(Profile, on_delete=models.CASCADE,
                                  related_name="away_team_user",
                                  to_field='user_id',
                                  default=1)
    away_score = models.IntegerField(null=True)
    away_team = models.ForeignKey(Team, on_delete=models.CASCADE,
                                  related_name="away_team",
                                  to_field='id',
                                  default=1)
    home_user = models.ForeignKey(Profile, on_delete=models.CASCADE,
                                  related_name="home_team_user",
                                  to_field='user_id',
                                  default=1)
    home_score = models.IntegerField(null=True)
    home_team = models.ForeignKey(Team, on_delete=models.CASCADE,
                                  related_name="home_team",
                                  to_field='id',
                                  default=1)
    penalty_shootout = models.BooleanField(null=True)
    date_played = models.DateTimeField(null=True, blank=True)
    status = models.IntegerField(
        choices=Game_Status.choices,
        default=Game_Status.Fixtured)

    class Meta:
        ordering = ['-pk']
        # ordering = ['-away_user__points']

from django.db import models
from . import Team, Profile
from django.core.validators import MaxValueValidator, MinValueValidator


class Game(models.Model):

    class Game_Status(models.IntegerChoices):
        Fixtured = 1
        Played = 2
        Postponed = 3
    '''GAME_STATUS = [
        (1, "Fixture"),
        (2, "Played"),
        (3, "Postponed")
    ]'''
    away_user = models.ForeignKey(Profile, on_delete=models.CASCADE,
                                  related_name="away_team_user",
                                  to_field='user_id',
                                  default=1)
    away_score = models.IntegerField(null=True)
    away_team = models.ForeignKey(Team, on_delete=models.CASCADE,
                                  related_name="away_team",
                                  to_field='id',
                                  default=1)
    home_user = models.ForeignKey(Profile, on_delete=models.CASCADE,
                                  related_name="home_team_user",
                                  to_field='user_id',
                                  default=1)
    home_score = models.IntegerField(null=True)
    home_team = models.ForeignKey(Team, on_delete=models.CASCADE,
                                  related_name="home_team",
                                  to_field='id',
                                  default=1)
    penalty_shootout = models.BooleanField(null=True)
    date_played = models.DateTimeField(null=True, blank=True)
    status = models.IntegerField(
        choices=Game_Status.choices,
        default=Game_Status.Fixtured)

    class Meta:
        ordering = ['-pk']
        # ordering = ['-away_user__points']
GAME_STATUS = [         (1, "Fixture"),         (2, "Played"),         (3, "Postponed")     ] # ordering = ['-away_user__points']