Contents

# encoding: utf-8

## fix/todo:
##  bayern, schalke, etc. already defined in cl
##  change create to create_or_update or similar (check for name convention in Rails?)


## nb: three letter codes (tags) taken from official bundesliga.de site

teams = [
  [ 'bayern',      'FC Bayern München|Bayern München|Bayern München GER',   'FCB' ],
  [ 'schalke',     'FC Schalke 04|FC Schalke 04 GER',                       'S04' ],
  [ 'dortmund',    'Borussia Dortmund|Bor. Dortmund|Bor. Dortmund GER',     'BVB' ],
  [ 'frankfurt',   'Eintracht Frankfurt|E. Frankfurt',    'FFM' ],
  [ 'hannover',    'Hannover 96',                         'H96' ],
  [ 'leverkusen',  'Bayer 04 Leverkusen|Bay. Leverkusen', 'B04' ],
  [ 'duesseldorf', 'Fortuna Düsseldorf|F. Düsseldorf',    'F95' ],
  [ 'hsv',         'Hamburger SV',                        'HSV' ],
  [ 'mainz',       '1. FSV Mainz 05',                     'M05' ],
  [ 'mgladbach',   "Borussia M'gladbach|Bor. M'gladbach", 'BMG' ],
  [ 'freiburg',    'SC Freiburg',                         'SCF' ],
  [ 'bremen',      'Werder Bremen',                       'BRE' ],
  [ 'hoffenheim',  '1899 Hoffenheim',                     'HOF' ],
  [ 'nuernberg',   '1. FC Nürnberg',                      'FCN' ],
  [ 'stuttgart',   'VfB Stuttgart',                       'VFB' ],
  [ 'augsburg',    'FC Augsburg',                         'FCA' ],
  [ 'wolfsburg',   'VfL Wolfsburg',                       'WOB' ],
  [ 'fuerth',      'Greuther Fürth',                      'SGF' ]
]

de = Country.find_by_key!( 'de' )

Team.create_from_ary!( teams, club: true, country: de )


Prop.create!( key: 'db.de.teams.version', value: '1' )

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
sportdb-0.5.0	db/de/teams.rb
sportdb-0.4.5	db/de/teams.rb
sportdb-0.4.4	db/de/teams.rb
sportdb-0.4.3	db/de/teams.rb
sportdb-0.4.2	db/de/teams.rb
sportdb-0.4.1	db/de/teams.rb