Hi, > class Team(models.Model): > name = models.CharField(max_length=60) > > class Player(models.Model): > surname = models.CharField(max_length=60) > lastname = models.CharField(max_length=60) > team = models.ForeignKey(Team) > > Now you can just specify the home_team and the away_team in the Game > model without having to add every player. > > For more functionality (like allowing players to switch teams) you > could use a through table that includes Player, Team, join_date and > leave_date -- The example in the docs is a good starting point for > that: http://docs.djangoproject.com/en/dev/topics/db/models/
I guess the models ith a through table won't work, because it's quite complicated. On one site I have a roster of my team which will be published on the site. There you see all guys playing at a specific team. On the other hand I have a game, where some players played, and some note. So I have to know, which player played, therefore I have to connect players to a game. You know what I mean? > I'm not sure how to answer a), but you can figure out b) because the > goal_scorer will be assigned to either home_players or away_players in > your original Game model, or the goal_scorer will be assigned to the > home_team or away_team in the modified models. Exactly, if I know the player who shoot the goal I know the team he is playing at. I think the big part will be the forms to create/add games and players. They need a lot of logic and some customizations.. Cheers, Chris > On Oct 5, 7:21 am, "c!w" <wittwe...@gmail.com> wrote: >> Hi, >> I trying to create a hockey database, based on Django. >> The heaviest part so long is to define the structure of my models. >> There I need some help. >> What I have so far.. >> >> class Team(models.Model): >> name = models.CharField(max_length=60) >> >> class Player(models.Model): >> surname = models.CharField(max_length=60) >> lastname = models.CharField(max_length=60) >> >> class Game(models.Model): >> date_time = models.DateTimeField() >> home_team = models.ForeignKey(Team,related_name='home_team') >> away_team = models.ForeignKey(Team,related_name='away_team') >> home_players = models.ManyToManyField(Player,blank=True) >> away_players = models.ManyToManyField(Player,blank=True) >> >> class GameGoal(models.Model): >> goal_scorer = models.ForeignKey(Player,blank=True,null=True) >> first_assist = models.ForeignKey(Player,blank=True,null=True) >> game = models.ForeignKey(Game) >> >> So now I have the following problems with these models. >> >> a) How can I limit the choice (in the admin page) of goal_scorer to >> Players, which are assigned to the Game? >> b) A GameGoal should be connected to the home_team or the away_team, >> how can I handle this? Add a foreignkey to Team and limit the choice >> to the both teams? >> c) Is there a better way, to define such a case? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
