diff options
author | Stefan Wintermeyer <stefan.wintermeyer@amooma.de> | 2012-12-17 12:05:14 +0100 |
---|---|---|
committer | Stefan Wintermeyer <stefan.wintermeyer@amooma.de> | 2012-12-17 12:05:14 +0100 |
commit | eaad37485fe59d0306c37cc038dda6d210052910 (patch) | |
tree | 072c4b0e33d442528555b82c415f5e7a1712b2b0 /db/to-dos/20120223142004_add_more_german_area_codes.rb | |
parent | 3e706c2025ecc5523e81ad649639ef2ff75e7bac (diff) | |
parent | b80bd744ad873f6fc43018bc4bfb90677de167bd (diff) |
Merge branch 'develop'
Diffstat (limited to 'db/to-dos/20120223142004_add_more_german_area_codes.rb')
-rw-r--r-- | db/to-dos/20120223142004_add_more_german_area_codes.rb | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/db/to-dos/20120223142004_add_more_german_area_codes.rb b/db/to-dos/20120223142004_add_more_german_area_codes.rb new file mode 100644 index 0000000..2eb2554 --- /dev/null +++ b/db/to-dos/20120223142004_add_more_german_area_codes.rb @@ -0,0 +1,58 @@ +# encoding: UTF-8 + +class AddMoreGermanAreaCodes < ActiveRecord::Migration + def up + # http://www.bundesnetzagentur.de/cln_1912/DE/Sachgebiete/Telekommunikation/RegulierungTelekommunikation/Nummernverwaltung/Nummernverwaltung_node.html + + germany = Country.find_by_name('Germany') + german_service_number_range = germany.phone_number_ranges.find_by_name('service_numbers') + + # Harmonisierte Dienste von sozialem Wert + # + (0..9).each do |x| + (0..9).each do |y| + (0..9).each do |z| + german_service_number_range.phone_numbers.create( + :name => "Harmonisierte Dienste von sozialem Wert", + :number => "116#{x}#{y}#{z}" + ) + end + end + end + + # Auskunftsdienste + # + (0..9).each do |x| + (0..9).each do |y| + german_service_number_range.phone_numbers.create( + :name => "Auskunftsdienste", + :number => "118#{x}#{y}" + ) + end + end + + # Online-Dienste + # + (0..9).each do |x| + (0..9).each do |y| + (0..9).each do |z| + AreaCode.create( + :country_id => germany.id, + :name => 'Online-Dienste', + :area_code => "19#{x}#{y}#{z}" + ) + end + end + end + + AreaCode.create(:country_id => germany.id, :name => 'Neuartige Dienste', :area_code => '12') + AreaCode.create(:country_id => germany.id, :name => 'Massenverkehrs-Dienste', :area_code => '137') + AreaCode.create(:country_id => germany.id, :name => 'Nutzergruppen', :area_code => '18') + AreaCode.create(:country_id => germany.id, :name => 'Internationale Virtuelle Private Netze', :area_code => '181') + AreaCode.create(:country_id => germany.id, :name => 'Nationale Teilnehmernummern', :area_code => '32') + AreaCode.create(:country_id => germany.id, :name => 'Anwählprogramme (Dialer)', :area_code => '9009') + end + + def down + end +end |