diff options
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 |