Sha256: 39d71da29d0f0582749136afadf6d38370ca16647aed16f3b10d1e0b4f563a83
Contents?: true
Size: 1.96 KB
Versions: 4
Compression:
Stored size: 1.96 KB
Contents
module SportDb
module Model
##################
# FIX: add ?
#
# use single table inheritance STI ????
# - to mark two dervided classes e.g.
# - Club ??? - why? why not?
# - NationalTeam ??? - why? why not?
class Team < ActiveRecord::Base
has_many :home_matches, class_name: 'Match', foreign_key: 'team1_id'
has_many :away_matches, class_name: 'Match', foreign_key: 'team2_id'
validates :key, format: { with: TEAM_KEY_RE, message: TEAM_KEY_MESSAGE }
validates :code, format: { with: TEAM_CODE_RE, message: TEAM_CODE_MESSAGE }, allow_nil: true
has_many :event_teams, class_name: 'EventTeam' # join table (events+teams)
has_many :events, :through => :event_teams
# note: team belongs_to a single (optinal) assoc for now (national assoc may have many assocs)
belongs_to :assoc
### fix!!! - how to do it with has_many macro? use finder_sql?
## finder_sql is depreciated in Rails 4!!!
# use -> { where() } etc. -- try it if it works
## keep as is! best solution ??
## a discussion here -> https://github.com/rails/rails/issues/9726
## a discussion here (not really helpful) -> http://stackoverflow.com/questions/2125440/activerecord-has-many-where-two-columns-in-table-a-are-primary-keys-in-table-b
def matches
Match.where( 'team1_id = ? or team2_id = ?', id, id ).order( 'date' )
end
def upcoming_matches
Match.where( 'team1_id = ? or team2_id = ?', id, id ).where( 'date > ?', Date.today ).order( 'date' )
end
def past_matches
Match.where( 'team1_id = ? or team2_id = ?', id, id ).where( 'date < ?', Date.today ).order( 'date desc' )
end
has_many :badges # Winner, 2nd, Cupsieger, Aufsteiger, Absteiger, etc.
belongs_to :country, class_name: 'WorldDb::Model::Country', foreign_key: 'country_id'
belongs_to :city, class_name: 'WorldDb::Model::City', foreign_key: 'city_id'
end # class Team
end # module Model
end # module SportDb
Version data entries
4 entries across 4 versions & 1 rubygems