apertura_2012.rb in sportdb-0.4.5

- old
+ new
@@ -1,160 +1,33 @@
 # encoding: utf-8
 
 # note: timezone for games (play_at) is *always* CST (central standard time / -6 hours ??)
 
 
-mx = Event.create!( key: 'mx_ap_2012',
+mx = Event.create!( key: 'mx.apertura.2012',
                     title: 'México Primera División Apertura 2012',
                     start_at: Time.cst('2012-07-20 00:00')  )
 
+team_keys_mx = [
+  'america',
+  'atlante',
+  'atlas',
+  'chivas',
+  'cruzazul',
+  'jaguares',
+  'leon',
+  'monarcas',
+  'monterrey',
+  'pachuca',
+  'puebla',
+  'queretaro',
+  'sanluis',
+  'slaguna',
+  'tijuana',
+  'toluca',
+  'tigres',
+  'pumas'
+]
 
-america   = Team.find_by_key!( 'america' )
-atlante   = Team.find_by_key!( 'atlante' )
-atlas     = Team.find_by_key!( 'atlas'   )
-chivas    = Team.find_by_key!( 'chivas'  )
-cruzazul  = Team.find_by_key!( 'cruzazul' )
-jaguares  = Team.find_by_key!( 'jaguares' )
-leon      = Team.find_by_key!( 'leon'  )
-monarcas  = Team.find_by_key!( 'monarcas' )
-monterrey = Team.find_by_key!( 'monterrey' )
-pachuca   = Team.find_by_key!( 'pachuca'  )
-puebla    = Team.find_by_key!( 'puebla'  )
-queretaro = Team.find_by_key!( 'queretaro' )
-sanluis   = Team.find_by_key!( 'sanluis' )
-slaguna   = Team.find_by_key!( 'slaguna'  )
-tijuana   = Team.find_by_key!( 'tijuana'  )
-toluca    = Team.find_by_key!( 'toluca' )
-tigres    = Team.find_by_key!( 'tigres' )
-pumas     = Team.find_by_key!( 'pumas' )
-
-
-mx.teams << america
-mx.teams << atlante
-mx.teams << atlas
-mx.teams << chivas
-mx.teams << cruzazul
-mx.teams << jaguares
-mx.teams << leon
-mx.teams << monarcas
-mx.teams << monterrey
-mx.teams << pachuca
-mx.teams << puebla
-mx.teams << queretaro
-mx.teams << sanluis
-mx.teams << slaguna
-mx.teams << tijuana
-mx.teams << toluca
-mx.teams << tigres
-mx.teams << pumas
-
-j1 = Round.create!( event: mx, pos: 1, title: 'Jornada 1', start_at: Time.cst('2012-07-20'), title2: '20, 21 y 22 de julio' )
-j2 = Round.create!( event: mx, pos: 2, title: 'Jornada 2', start_at: Time.cst('2012-07-27'), title2: '27, 28 y 29 de julio' )
-j3 = Round.create!( event: mx, pos: 3, title: 'Jornada 3', start_at: Time.cst('2012-08-03'), title2: '3, 4, y 5 de agosto' )
-j4 = Round.create!( event: mx, pos: 4, title: 'Jornada 4', start_at: Time.cst('2012-08-10'), title2: '10, 11 y 12 de agosto' )
-j5 = Round.create!( event: mx, pos: 5, title: 'Jornada 5', start_at: Time.cst('2012-08-17'), title2: '17, 18 y 19 de agosto' )
-j6 = Round.create!( event: mx, pos: 6, title: 'Jornada 6', start_at: Time.cst('2012-08-24'), title2: '24, 25 y 26 de agosto' )
-j7 = Round.create!( event: mx, pos: 7, title: 'Jornada 7', start_at: Time.cst('2012-08-31'), title2: '31 de agosto, 1 y 2 de septiembre' )
-j8 = Round.create!( event: mx, pos: 8, title: 'Jornada 8', start_at: Time.cst('2012-09-14'), title2: '14, 15 y 16 de septiembre' )
-
-
-games_j1 = [
-  [ jaguares,  [], tigres,   Time.cst('2012-07-20 19:30') ],
-  [ tijuana,   [], puebla,   Time.cst('2012-07-20 21:30') ],
-  [ cruzazul,  [], monarcas, Time.cst('2012-07-21 17:00') ],
-  [ queretaro, [], leon,     Time.cst('2012-07-21 17:00') ],
-  [ slaguna,   [], sanluis,  Time.cst('2012-07-21 19:00') ],
-  [ monterrey, [], america,  Time.cst('2012-07-21 19:00') ],
-  [ atlas,     [], pumas,    Time.cst('2012-07-21 21:00') ],
-  [ toluca,    [], chivas,   Time.cst('2012-07-22 12:00') ],
-  [ atlante,   [], pachuca,  Time.cst('2012-07-22 18:00') ]]
-
-
-games_j2 = [
-  [ monarcas,   [], monterrey,   Time.cst('2012-07-27 19:30') ],
-  [ leon,       [], tijuana,     Time.cst('2012-07-27 21:30') ],
-  [ america,    [], jaguares,    Time.cst('2012-07-28 17:00') ],
-  [ pachuca,    [], atlas,       Time.cst('2012-07-28 19:00') ],
-  [ tigres,     [], atlante,     Time.cst('2012-07-28 19:00') ],
-  [ sanluis,    [], cruzazul,    Time.cst('2012-07-28 21:00') ],
-  [ puebla,     [], toluca,      Time.cst('2012-07-29 12:00') ],
-  [ pumas,      [], queretaro,   Time.cst('2012-07-29 12:00') ],
-  [ chivas,     [], slaguna,     Time.cst('2012-07-29 17:00')]]
-
-games_j3 = [
-  [ slaguna,     [], puebla,    Time.cst('2012-08-03 19:00') ],
-  [ tijuana,     [], pumas,     Time.cst('2012-08-03 19:30') ],
-  [ monarcas,    [], sanluis,   Time.cst('2012-08-03 21:30') ],
-  [ cruzazul,    [], chivas,    Time.cst('2012-08-04 17:00') ],
-  [ queretaro,   [], pachuca,   Time.cst('2012-08-04 17:00') ],
-  [ monterrey,   [], jaguares,  Time.cst('2012-08-04 19:00') ],
-  [ atlas,       [], tigres,    Time.cst('2012-08-04 21:00') ],
-  [ toluca,      [], leon,      Time.cst('2012-08-05 12:00') ],
-  [ atlante,     [], america,   Time.cst('2012-08-05 18:00') ]]
-
-games_j4 = [
-  [ jaguares,    [], atlante,  Time.cst('2012-08-10 19:30') ],
-  [ leon,        [], slaguna,   Time.cst('2012-08-10 21:30') ],
-  [ america,     [], atlas,     Time.cst('2012-08-11 17:00') ],
-  [ pachuca,     [], tijuana,   Time.cst('2012-08-11 19:00') ],
-  [ tigres,      [], queretaro, Time.cst('2012-08-11 19:00') ],
-  [ sanluis,     [], monterrey, Time.cst('2012-08-11 21:00') ],
-  [ puebla,      [], cruzazul,  Time.cst('2012-08-12 12:00') ],
-  [ pumas,       [], toluca,    Time.cst('2012-08-12 12:00') ],
-  [ chivas,      [], monarcas,  Time.cst('2012-08-12 17:00') ]]
-
-games_j5 = [
-  [ tijuana,     [], tigres,    Time.cst('2012-08-17 19:30') ],
-  [ monarcas,    [], puebla,    Time.cst('2012-08-17 21:30') ],
-  [ cruzazul,    [], leon,      Time.cst('2012-08-17 21:30') ],
-  [ queretaro,   [], america,   Time.cst('2012-08-18 17:00') ],
-  [ slaguna,     [], pumas,     Time.cst('2012-08-18 19:00') ],
-  [ monterrey,   [], atlante,   Time.cst('2012-08-18 19:00') ],
-  [ sanluis,     [], chivas,    Time.cst('2012-08-18 21:00') ],
-  [ atlas,       [], jaguares,  Time.cst('2012-08-18 21:00') ],
-  [ toluca,      [], pachuca,   Time.cst('2012-08-19 12:00') ]]
-
-games_j6 = [
-  [ jaguares,    [], queretaro, Time.cst('2012-08-24 19:30') ],
-  [ leon,        [], monarcas,  Time.cst('2012-08-24 21:30') ],
-  [ america,     [], tijuana,   Time.cst('2012-08-25 17:00') ],
-  [ pachuca,     [], slaguna,   Time.cst('2012-08-25 19:00') ],
-  [ tigres,      [], toluca,    Time.cst('2012-08-25 19:00') ],
-  [ puebla,      [], sanluis,   Time.cst('2012-08-26 12:00') ],
-  [ pumas,       [], cruzazul,  Time.cst('2012-08-26 12:00') ],
-  [ chivas,      [], monterrey, Time.cst('2012-08-26 17:00') ],
-  [ atlante,     [], atlas,     Time.cst('2012-08-26 18:00') ]]
-
-games_j7 = [
-  [ tijuana,      [], jaguares,  Time.cst('2012-08-31 19:30') ],
-  [ monarcas,     [], pumas,     Time.cst('2012-08-31 21:30') ],
-  [ cruzazul,     [], pachuca,   Time.cst('2012-09-01 17:00') ],
-  [ queretaro,    [], atlante,   Time.cst('2012-09-01 17:00') ],
-  [ slaguna,      [], tigres,    Time.cst('2012-09-01 19:00') ],
-  [ monterrey,    [], atlas,     Time.cst('2012-09-01 19:00') ],
-  [ sanluis,      [], leon,      Time.cst('2012-09-01 21:00') ],
-  [ toluca,       [], america,   Time.cst('2012-09-02 12:00') ],
-  [ chivas,       [], puebla,    Time.cst('2012-09-02 17:00') ]]
-
-games_j8 = [
-  [ jaguares,     [], toluca,    Time.cst('2012-09-14 19:30') ],
-  [ pachuca,      [], monarcas,  Time.cst('2012-09-14 19:30') ],
-  [ leon,         [], chivas,    Time.cst('2012-09-14 21:30') ],
-  [ america,      [], slaguna,   Time.cst('2012-09-15 17:00') ],
-  [ tigres,       [], cruzazul,  Time.cst('2012-09-15 19:00') ],
-  [ atlas,        [], queretaro, Time.cst('2012-09-15 21:00') ],
-  [ puebla,       [], monterrey, Time.cst('2012-09-16 12:00') ],
-  [ pumas,        [], sanluis,   Time.cst('2012-09-16 12:00') ],
-  [ atlante,      [], tijuana,   Time.cst('2012-09-16 18:00') ]]
-
-
-Game.create_from_ary!( games_j1, j1 )
-Game.create_from_ary!( games_j2, j2 )
-Game.create_from_ary!( games_j3, j3 )
-Game.create_from_ary!( games_j4, j4 )
-Game.create_from_ary!( games_j5, j5 )
-Game.create_from_ary!( games_j6, j6 )
-Game.create_from_ary!( games_j7, j7 )
-Game.create_from_ary!( games_j8, j8 )
-
+mx.add_teams_from_ary!( team_keys_mx )
 
 Prop.create!( key: 'db.mx.apertura.2012.version', value: '1' )
\ No newline at end of file