db/euro/2012.rb in sportdb-0.9.1 vs db/euro/2012.rb in sportdb-0.9.2

- old
+ new

@@ -12,155 +12,14 @@ euro = Event.create!( league: League.find_by_key!('euro'), season: Season.find_by_key!('2012'), start_at: Time.cet( '2012-06-07 17:00' ), team3: false ) -pol = Team.find_by_key!( 'pol' ) -gre = Team.find_by_key!( 'gre' ) -rus = Team.find_by_key!( 'rus' ) -cze = Team.find_by_key!( 'cze' ) - -ned = Team.find_by_key!( 'ned' ) -den = Team.find_by_key!( 'den' ) -ger = Team.find_by_key!( 'ger' ) -por = Team.find_by_key!( 'por' ) - -esp = Team.find_by_key!( 'esp' ) -ita = Team.find_by_key!( 'ita' ) -irl = Team.find_by_key!( 'irl' ) -cro = Team.find_by_key!( 'cro' ) - -ukr = Team.find_by_key!( 'ukr' ) -swe = Team.find_by_key!( 'swe' ) -fra = Team.find_by_key!( 'fra' ) -eng = Team.find_by_key!( 'eng' ) - - -euro.teams << pol -euro.teams << gre -euro.teams << rus -euro.teams << cze -euro.teams << ned -euro.teams << den -euro.teams << ger -euro.teams << por -euro.teams << esp -euro.teams << ita -euro.teams << irl -euro.teams << cro -euro.teams << ukr -euro.teams << swe -euro.teams << fra -euro.teams << eng - - - -euroa = Group.create!( event: euro, pos: 1, title: 'Gruppe A' ) -eurob = Group.create!( event: euro, pos: 2, title: 'Gruppe B' ) -euroc = Group.create!( event: euro, pos: 3, title: 'Gruppe C' ) -eurod = Group.create!( event: euro, pos: 4, title: 'Gruppe D' ) - -################################# -# Gruppe A - -euroa.teams << pol -euroa.teams << gre -euroa.teams << rus -euroa.teams << cze - - -################################# -# Gruppe B - -eurob.teams << ned -eurob.teams << den -eurob.teams << ger -eurob.teams << por - - -#################################3 -# Gruppe C - -euroc.teams << esp -euroc.teams << ita -euroc.teams << irl -euroc.teams << cro - -#################################3 -# Gruppe D - -eurod.teams << ukr -eurod.teams << swe -eurod.teams << fra -eurod.teams << eng - - -euro_round1 = Round.create!( event: euro, pos: 1, title: 'Vorrunde 1. Spieltag', start_at: Time.cet( '2012-06-08' ), title2: '8.-11. Juni' ) -euro_round2 = Round.create!( event: euro, pos: 2, title: 'Vorrunde 2. Spieltag', start_at: Time.cet( '2012-06-12' ), title2: '12.-15. Juni' ) -euro_round3 = Round.create!( event: euro, pos: 3, title: 'Vorrunde 3. Spieltag', start_at: Time.cet( '2012-06-16' ), title2: '16.-19. Juni' ) - - - -games_euro_round1 = [ - [ 1, pol, [1,1], gre, Time.cet('2012-06-08 18:00'), euroa ], - [ 2, rus, [4,1], cze, Time.cet('2012-06-08 20:45'), euroa ], - [ 3, ned, [0,1], den, Time.cet('2012-06-09 18:00'), eurob ], - [ 4, ger, [1,0], por, Time.cet('2012-06-09 20:45'), eurob ], - [ 5, esp, [1,1], ita, Time.cet('2012-06-10 18:00'), euroc ], - [ 6, irl, [1,3], cro, Time.cet('2012-06-10 20:45'), euroc ], - [ 7, fra, [1,1], eng, Time.cet('2012-06-11 18:00'), eurod ], - [ 8, ukr, [2,1], swe, Time.cet('2012-06-11 20:45'), eurod ] -] - -games_euro_round2 = [ - [ 9, gre, [1,2], cze, Time.cet('2012-06-12 18:00'), euroa ], - [ 10, pol, [1,1], rus, Time.cet('2012-06-12 20:45'), euroa ], - [ 11, den, [2,3], por, Time.cet('2012-06-13 18:00'), eurob ], - [ 12, ned, [1,2], ger, Time.cet('2012-06-13 20:45'), eurob ], - [ 13, ita, [1,1], cro, Time.cet('2012-06-14 18:00'), euroc ], - [ 14, esp, [4,0], irl, Time.cet('2012-06-14 20:45'), euroc ], - [ 15, swe, [2,3], eng, Time.cet('2012-06-15 20:45'), eurod ], - [ 16, ukr, [0,2], fra, Time.cet('2012-06-15 18:00'), eurod ] -] - -games_euro_round3 = [ - [ 17, cze, [1,0], pol, Time.cet('2012-06-16 20:45'), euroa ], - [ 18, gre, [1,0], rus, Time.cet('2012-06-16 20:45'), euroa ], - [ 19, por, [2,1], ned, Time.cet('2012-06-17 20:45'), eurob ], - [ 20, den, [1,2], ger, Time.cet('2012-06-17 20:45'), eurob ], - [ 21, cro, [0,1], esp, Time.cet('2012-06-18 20:45'), euroc ], - [ 22, ita, [2,0], irl, Time.cet('2012-06-18 20:45'), euroc ], - [ 23, eng, [1,0], ukr, Time.cet('2012-06-19 20:45'), eurod ], - [ 24, swe, [2,0], fra, Time.cet('2012-06-19 20:45'), eurod ] -] - -Game.create_from_ary!( games_euro_round1, euro_round1 ) -Game.create_from_ary!( games_euro_round2, euro_round2 ) -Game.create_from_ary!( games_euro_round3, euro_round3 ) - - - -euro8 = Round.create!( event: euro, pos: 4, title: 'Viertelfinale', start_at: Time.cet( '2012-06-21' ) ) -euro4 = Round.create!( event: euro, pos: 5, title: 'Halbfinale', start_at: Time.cet( '2012-06-27' ) ) -euro1 = Round.create!( event: euro, pos: 6, title: 'Finale', start_at: Time.cet( '2012-07-01' ) ) - - -games_euro8 = [ - [ 25, cze, [0,1], por, Time.cet('2012-06-21 20:45') ], - [ 26, ger, [4,2], gre, Time.cet('2012-06-22 20:45') ], - [ 27, esp, [2,0], fra, Time.cet('2012-06-23 20:45') ], - [ 28, eng, [0,0,0,0,2,4], ita, Time.cet('2012-06-24 20:45') ]] - -games_euro4 = [ - [ 29, por, [0,0,0,0,2,4], esp, Time.cet('2012-06-27 20:45') ], - [ 30, ger, [1,2], ita, Time.cet('2012-06-28 20:45') ]] - -games_euro1 = [ - [ 31, esp, [4,0], ita, Time.cet('2012-07-01 20:45') ]] - - -Game.create_knockouts_from_ary!( games_euro8, euro8 ) -Game.create_knockouts_from_ary!( games_euro4, euro4 ) -Game.create_knockouts_from_ary!( games_euro1, euro1 ) +euro.add_teams_from_ary!([ + 'pol', 'gre', 'rus', 'cze', + 'ned', 'den', 'ger', 'por', + 'esp', 'ita', 'irl', 'cro', + 'ukr', 'swe', 'fra', 'eng' +]) ## The End ################# \ No newline at end of file