bl.rb in sportdb-0.4.4

- old
+ new
@@ -10,238 +10,22 @@
 
 bl = Event.create!( key:     'at_bl_2012_13',
                     title:   'Österr. Bundesliga 2012/13',
                     start_at: Time.cet('2012-07-21 00:00') )
 
-salzburg    = Team.find_by_key!( 'salzburg' )
-rapid       = Team.find_by_key!( 'rapid' )
-admira      = Team.find_by_key!( 'admira' )
-austria     = Team.find_by_key!( 'austria' )
-sturm       = Team.find_by_key!( 'sturm' )
-ried        = Team.find_by_key!( 'ried' )
-wacker      = Team.find_by_key!( 'wacker' )
-mattersburg = Team.find_by_key!( 'mattersburg' )
-neustadt    = Team.find_by_key!( 'neustadt' )
-wac         = Team.find_by_key!( 'wac' )
+## 10 Bundeliga Teams
 
+team_keys_bl = [
+   'salzburg',
+   'rapid',
+   'admira',
+   'austria',
+   'sturm',
+   'ried',
+   'wacker',
+   'mattersburg',
+   'neustadt',
+   'wac' ]
 
-bl.teams << salzburg
-bl.teams << rapid
-bl.teams << admira
-bl.teams << austria
-bl.teams << sturm
-bl.teams << ried
-bl.teams << wacker
-bl.teams << mattersburg
-bl.teams << neustadt
-bl.teams << wac
+bl.add_teams_from_ary!( team_keys_bl )
 
-
-bl01 = Round.create!( event: bl, pos:  1, title: '1. Runde', start_at: Time.cet('2012-07-21'),  title2: 'Sa+So 21.+22. Jul 2012' )
-bl02 = Round.create!( event: bl, pos:  2, title: '2. Runde', start_at: Time.cet('2012-07-28'),  title2: 'Sa+So 28.+29. Jul 2012' )
-bl03 = Round.create!( event: bl, pos:  3, title: '3. Runde', start_at: Time.cet('2012-08-04'),  title2: 'Sa+So 4.+5. Aug 2012' )
-bl04 = Round.create!( event: bl, pos:  4, title: '4. Runde', start_at: Time.cet('2012-08-11'),  title2: 'Sa 11. Aug 2012' )
-bl05 = Round.create!( event: bl, pos:  5, title: '5. Runde', start_at: Time.cet('2012-08-18'),  title2: 'Sa 18. Aug 2012' )
-bl06 = Round.create!( event: bl, pos:  6, title: '6. Runde', start_at: Time.cet('2012-08-25'),  title2: 'Sa 25. Aug 2012' )
-bl07 = Round.create!( event: bl, pos:  7, title: '7. Runde', start_at: Time.cet('2012-09-01'),  title2: 'Sa 1. Sep 2012' )
-bl08 = Round.create!( event: bl, pos:  8, title: '8. Runde', start_at: Time.cet('2012-09-15'),  title2: 'Sa 15. Sep 2012' )
-bl09 = Round.create!( event: bl, pos:  9, title: '9. Runde', start_at: Time.cet('2012-09-22'),  title2: 'Sa 22. Sep 2012' )
-bl10 = Round.create!( event: bl, pos: 10, title: '10. Runde', start_at: Time.cet('2012-09-29'), title2: 'Sa 29. Sep 2012' )
-bl11 = Round.create!( event: bl, pos: 11, title: '11. Runde', start_at: Time.cet('2012-10-06'), title2: 'Sa 6. Okt 2012' )
-bl12 = Round.create!( event: bl, pos: 12, title: '12. Runde', start_at: Time.cet('2012-10-20'), title2: 'Sa 20. Okt 2012' )
-bl13 = Round.create!( event: bl, pos: 13, title: '13. Runde', start_at: Time.cet('2012-10-27'), title2: 'Sa 27. Okt 2012' )
-bl14 = Round.create!( event: bl, pos: 14, title: '14. Runde', start_at: Time.cet('2012-11-03'), title2: 'Sa 3. Nov 2012' )
-bl15 = Round.create!( event: bl, pos: 15, title: '15. Runde', start_at: Time.cet('2012-11-10'), title2: 'Sa 10. Nov 2012' )
-bl16 = Round.create!( event: bl, pos: 16, title: '16. Runde', start_at: Time.cet('2012-11-17'), title2: 'Sa 17. Nov 2012' )
-bl17 = Round.create!( event: bl, pos: 17, title: '17. Runde', start_at: Time.cet('2012-11-24'), title2: 'Sa 24. Nov 2012' )
-bl18 = Round.create!( event: bl, pos: 18, title: '18. Runde', start_at: Time.cet('2012-12-01'), title2: 'Sa 1. Dez 2012' )
-bl19 = Round.create!( event: bl, pos: 19, title: '19. Runde', start_at: Time.cet('2012-12-08'), title2: 'Sa 8. Dez 2012' )
-bl20 = Round.create!( event: bl, pos: 20, title: '20. Runde', start_at: Time.cet('2012-12-15'), title2: 'Sa 15. Dez 2012' )
-
-
-## todo: fix game dates - do not use 00:00
-
-games_bl01 = [
-  [ sturm,       [0,2], salzburg,  Time.cet('2012-07-21 16:00') ],
-  [ rapid,       [4,0], wacker,    Time.cet('2012-07-21 18:30') ],
-  [ mattersburg, [2,0], neustadt,  Time.cet('2012-07-21 18:30') ],
-  [ wac,         [0,1], austria,   Time.cet('2012-07-25 18:30') ],  # NB: date changed
-  [ admira,      [0,2], ried,      Time.cet('2012-07-22 16:00') ]
-]
-
-games_bl02 = [
-  [ neustadt,    [0,1], rapid,       Time.cet('2012-07-28 18:30') ],
-  [ salzburg,    [3,2], mattersburg, Time.cet('2012-07-28 18:30') ],
-  [ austria,     [0,1], sturm,       Time.cet('2012-07-28 18:30') ],
-  [ wacker,      [1,2], admira,      Time.cet('2012-07-29 16:00') ],
-  [ ried,        [0,2], wac,         Time.cet('2012-07-29 18:30') ]
-]
-
-games_bl03 = [
-  [ ried,        [2,0], wacker,       Time.cet('2012-08-04 18:30') ],
-  [ mattersburg, [3,1], sturm,        Time.cet('2012-08-04 18:30') ],
-  [ wac,         [0,2], salzburg,     Time.cet('2012-08-04 18:30') ],
-  [ admira,      [4,0], neustadt,     Time.cet('2012-08-04 18:30') ],
-  [ rapid,       [0,3], austria,      Time.cet('2012-08-05 16:00') ]
-]
-
-games_bl04 = [
-  [ neustadt,    [2,3], ried,        Time.cet('2012-08-11 00:00') ],
-  [ sturm,       [4,1], wac,         Time.cet('2012-08-11 00:00') ],
-  [ salzburg,    [0,2], rapid,       Time.cet('2012-08-11 00:00') ],
-  [ austria,     [1,0], admira,      Time.cet('2012-08-11 00:00') ],
-  [ wacker,      [2,1], mattersburg, Time.cet('2012-08-11 00:00') ]
-]
-
-games_bl05 = [
-  [ ried,     [0,1], austria,       Time.cet('2012-08-18 00:00') ],
-  [ rapid,    [3,0], sturm,         Time.cet('2012-08-18 00:00') ],
-  [ wacker,   [2,3], neustadt,      Time.cet('2012-08-18 00:00') ],
-  [ wac,      [0,1], mattersburg,   Time.cet('2012-08-18 00:00') ],
-  [ admira,   [4,4], salzburg,      Time.cet('2012-08-18 00:00') ]
-]
-
-games_bl06 = [
-  [ sturm,       [3,2], admira,       Time.cet('2012-08-25 00:00') ],
-  [ salzburg,    [1,1], neustadt,     Time.cet('2012-08-25 00:00') ],
-  [ austria,     [2,0], wacker,       Time.cet('2012-08-25 00:00') ],
-  [ mattersburg, [2,1], ried,         Time.cet('2012-08-25 00:00') ],
-  [ wac,         [1,0], rapid,        Time.cet('2012-08-25 00:00') ]
-]
-
-games_bl07 = [
-  [ ried,    [0,1], sturm,       Time.cet('2012-09-01 00:00') ],
-  [ neustadt,[0,2], austria,     Time.cet('2012-09-01 00:00') ],
-  [ rapid,   [3,0], mattersburg, Time.cet('2012-09-01 00:00') ],
-  [ wacker,  [0,4], salzburg,    Time.cet('2012-09-01 00:00') ],
-  [ admira,  [1,1], wac,         Time.cet('2012-09-01 00:00') ]
-]
-
-games_bl08 = [
-  [ sturm,       [3,0], wacker,       Time.cet('2012-09-15 00:00') ],
-  [ salzburg,    [1,1], ried,         Time.cet('2012-09-15 00:00') ],
-  [ rapid,       [0,0], admira,       Time.cet('2012-09-15 00:00') ],
-  [ mattersburg, [2,4], austria,      Time.cet('2012-09-15 00:00') ],
-  [ wac,         [6,0], neustadt,     Time.cet('2012-09-15 00:00') ]
-]
-
-games_bl09 = [
-  [ ried,    [0,2], rapid,       Time.cet('2012-09-22 00:00') ],
-  [ neustadt,[1,1], sturm,       Time.cet('2012-09-22 00:00') ],
-  [ austria, [0,1], salzburg,    Time.cet('2012-09-22 00:00') ],
-  [ wacker,  [0,1], wac,         Time.cet('2012-09-22 00:00') ],
-  [ admira,  [5,1], mattersburg, Time.cet('2012-09-22 00:00') ]
-]
-
-games_bl10 = [
-  [ salzburg,  [3,2], sturm,       Time.cet('2012-09-29 00:00') ],
-  [ wacker,    [0,2], rapid,       Time.cet('2012-09-29 00:00') ],
-  [ neustadt,  [0,0], mattersburg, Time.cet('2012-09-29 00:00') ],
-  [ austria,   [1,1], wac,         Time.cet('2012-09-29 00:00') ],
-  [ ried,      [1,1], admira,      Time.cet('2012-09-29 00:00') ]
-]
-
-games_bl11 = [
-  [ wac,         [2,5], ried,       Time.cet('2012-10-06 00:00') ],
-  [ rapid,       [1,1], neustadt,   Time.cet('2012-10-06 00:00') ],
-  [ mattersburg, [1,3], salzburg,   Time.cet('2012-10-06 00:00') ],
-  [ sturm,       [1,1], austria,    Time.cet('2012-10-06 00:00') ],
-  [ admira,      [4,1], wacker,     Time.cet('2012-10-06 00:00') ]
-]
-
-games_bl12 = [
-  [ wacker,    [], ried,        Time.cet('2012-10-20 00:00') ],
-  [ austria,   [], rapid,       Time.cet('2012-10-20 00:00') ],
-  [ sturm,     [], mattersburg, Time.cet('2012-10-20 00:00') ],
-  [ salzburg,  [], wac,         Time.cet('2012-10-20 00:00') ],
-  [ neustadt,  [], admira,      Time.cet('2012-10-20 00:00') ]
-]
-
-games_bl13 = [
-  [ ried,        [], neustadt,     Time.cet('2012-10-27 00:00') ],
-  [ wac,         [], sturm,        Time.cet('2012-10-27 00:00') ],
-  [ rapid,       [], salzburg,     Time.cet('2012-10-27 00:00') ],
-  [ admira,      [], austria,      Time.cet('2012-10-27 00:00') ],
-  [ mattersburg, [], wacker,       Time.cet('2012-10-27 00:00') ]
-]
-
-games_bl14 = [
-  [ austria,      [], ried,     Time.cet('2012-11-03 00:00') ],
-  [ sturm,        [], rapid,    Time.cet('2012-11-03 00:00') ],
-  [ neustadt,     [], wacker,   Time.cet('2012-11-03 00:00') ],
-  [ mattersburg,  [], wac,      Time.cet('2012-11-03 00:00') ],
-  [ salzburg,     [], admira,   Time.cet('2012-11-03 00:00') ]
-]
-
-games_bl15 = [
-  [ admira,      [], sturm,       Time.cet('2012-11-10 00:00') ],
-  [ neustadt,    [], salzburg,    Time.cet('2012-11-10 00:00') ],
-  [ wacker,      [], austria,     Time.cet('2012-11-10 00:00') ],
-  [ ried,        [], mattersburg, Time.cet('2012-11-10 00:00') ],
-  [ rapid,       [], wac,         Time.cet('2012-11-10 00:00') ]
-]
-
-games_bl16 = [
-  [ sturm,      [], ried,        Time.cet('2012-11-17 00:00') ],
-  [ austria,    [], neustadt,    Time.cet('2012-11-17 00:00') ],
-  [ mattersburg,[], rapid,       Time.cet('2012-11-17 00:00') ],
-  [ salzburg,   [], wacker,      Time.cet('2012-11-17 00:00') ],
-  [ wac,        [], admira,      Time.cet('2012-11-17 00:00') ]
-]
-
-games_bl17 = [
-  [ wacker,    [], sturm,       Time.cet('2012-11-24 00:00') ],
-  [ ried,      [], salzburg,    Time.cet('2012-11-24 00:00') ],
-  [ admira,    [], rapid,       Time.cet('2012-11-24 00:00') ],
-  [ austria,   [], mattersburg, Time.cet('2012-11-24 00:00') ],
-  [ neustadt,  [], wac,         Time.cet('2012-11-24 00:00') ]
-]
-
-games_bl18 = [
-  [ rapid,       [], ried,     Time.cet('2012-12-01 00:00') ],
-  [ sturm,       [], neustadt, Time.cet('2012-12-01 00:00') ],
-  [ salzburg,    [], austria,  Time.cet('2012-12-01 00:00') ],
-  [ wac,         [], wacker,   Time.cet('2012-12-01 00:00') ],
-  [ mattersburg, [], admira,   Time.cet('2012-12-01 00:00') ]
-]
-
-games_bl19 = [
-  [ sturm,       [], salzburg,    Time.cet('2012-12-08 00:00') ],
-  [ rapid,       [], wacker,      Time.cet('2012-12-08 00:00') ],
-  [ mattersburg, [], neustadt,    Time.cet('2012-12-08 00:00') ],
-  [ wac,         [], austria,     Time.cet('2012-12-08 00:00') ],
-  [ admira,      [], ried,        Time.cet('2012-12-08 00:00') ]
-]
-
-games_bl20 = [
-  [ ried,      [], wac,         Time.cet('2012-12-15 00:00') ],
-  [ neustadt,  [], rapid,       Time.cet('2012-12-15 00:00') ],
-  [ salzburg,  [], mattersburg, Time.cet('2012-12-15 00:00') ],
-  [ austria,   [], sturm,       Time.cet('2012-12-15 00:00') ],
-  [ wacker,    [], admira,      Time.cet('2012-12-15 00:00') ]
-]
-
-
-
-Game.create_from_ary!( games_bl01, bl01 )
-Game.create_from_ary!( games_bl02, bl02 )
-Game.create_from_ary!( games_bl03, bl03 )
-Game.create_from_ary!( games_bl04, bl04 )
-Game.create_from_ary!( games_bl05, bl05 )
-Game.create_from_ary!( games_bl06, bl06 )
-Game.create_from_ary!( games_bl07, bl07 )
-Game.create_from_ary!( games_bl08, bl08 )
-Game.create_from_ary!( games_bl09, bl09 )
-Game.create_from_ary!( games_bl10, bl10 )
-Game.create_from_ary!( games_bl11, bl11 )
-Game.create_from_ary!( games_bl12, bl12 )
-Game.create_from_ary!( games_bl13, bl13 )
-Game.create_from_ary!( games_bl14, bl14 )
-Game.create_from_ary!( games_bl15, bl15 )
-Game.create_from_ary!( games_bl16, bl16 )
-Game.create_from_ary!( games_bl17, bl17 )
-Game.create_from_ary!( games_bl18, bl18 )
-Game.create_from_ary!( games_bl19, bl19 )
-Game.create_from_ary!( games_bl20, bl20 )
-
-
-Prop.create!( key: 'db.at.bl.2012/13.version', value: '1' )
+Prop.create!( key: 'db.at.2012/13.version', value: '1' )