aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
Diffstat
-rw-r--r--db/migrate/074_create_holidays.rb60
-rw-r--r--spec/fixtures/holidays.yml168
2 files changed, 172 insertions, 56 deletions
diff --git a/db/migrate/074_create_holidays.rb b/db/migrate/074_create_holidays.rb
index 46b1ab684..cf4a5808a 100644
--- a/db/migrate/074_create_holidays.rb
+++ b/db/migrate/074_create_holidays.rb
@@ -1,3 +1,5 @@
+require 'active_record/fixtures'
+
class CreateHolidays < ActiveRecord::Migration
def self.up
create_table :holidays do |t|
@@ -6,62 +8,8 @@ class CreateHolidays < ActiveRecord::Migration
end
add_index :holidays, :day
- holidays = {
- # Union of holidays from these places:
- # http://www.direct.gov.uk/en/Governmentcitizensandrights/LivingintheUK/DG_073741
- # http://www.dti.gov.uk/employment/bank-public-holidays/
- # http://www.scotland.gov.uk/Publications/2005/01/bankholidays
-
- '2007-11-30' => "St. Andrew's Day",
- '2007-12-25' => "Christmas Day",
- '2007-12-26' => "Boxing Day",
-
- '2008-01-01' => "New Year's Day",
- '2008-01-02' => "2nd January (Scotland)",
- '2008-03-17' => "St. Patrick's Day (NI)",
- '2008-03-21' => "Good Friday",
- '2008-03-24' => "Easter Monday",
- '2008-05-05' => "Early May Bank Holiday",
- '2008-05-26' => "Spring Bank Holiday",
- '2008-07-14' => "Battle of the Boyne (NI)",
- '2008-08-04' => "Summer Bank Holiday (Scotland)",
- '2008-08-25' => "Summer Bank Holiday (England + Wales)",
- '2008-12-01' => "St. Andrew's Day (Scotland)",
- '2008-12-25' => "Christmas Day",
- '2008-12-26' => "Boxing Day",
-
- '2009-01-01' => "New Year's Day",
- '2009-01-02' => "2nd January (Scotland)",
- '2009-03-17' => "St. Patrick's Day (NI)",
- '2009-04-10' => "Good Friday",
- '2009-04-13' => "Easter Monday",
- '2009-05-04' => "Early May Bank Holiday",
- '2009-05-25' => "Spring Bank Holiday",
- '2009-07-13' => "Battle of the Boyne (NI)",
- '2009-08-03' => "Summer Bank Holiday (Scotland)",
- '2009-08-31' => "Summer Bank Holiday (England + Wales)",
- '2009-11-30' => "St. Andrew's Day (Scotland)",
- '2009-12-25' => "Christmas Day",
- '2009-12-28' => "Boxing Day",
-
- '2010-01-01' => "New Year's Day",
- '2010-01-04' => "2nd January (Scotland)",
- '2010-03-17' => "St. Patrick's Day (NI)",
- '2010-04-02' => "Good Friday",
- '2010-04-05' => "Easter Monday",
- '2010-05-03' => "Early May Bank Holiday",
- '2010-05-31' => "Spring Bank Holiday",
- '2010-07-12' => "Battle of the Boyne (NI)",
- '2010-08-02' => "Summer Bank Holiday (Scotland)",
- '2010-08-30' => "Summer Bank Holiday (England + Wales)",
- '2010-11-30' => "St. Andrew's Day (Scotland)",
- '2010-12-27' => "Christmas Day",
- '2010-12-28' => "Boxing Day"
- }
-
- holidays.sort.each { |date, desc|
- Holiday.create :day => date, :description => desc
- }
+ # Load our default holiday list
+ Fixtures.create_fixtures('spec/fixtures', 'holidays')
end
diff --git a/spec/fixtures/holidays.yml b/spec/fixtures/holidays.yml
new file mode 100644
index 000000000..5a3d018bc
--- /dev/null
+++ b/spec/fixtures/holidays.yml
@@ -0,0 +1,168 @@
+date20071130:
+ id: '1'
+ day: '2007-11-30'
+ description: "St. Andrew's Day"
+date20071225:
+ id: '2'
+ day: '2007-12-25'
+ description: "Christmas Day"
+date20071226:
+ id: '3'
+ day: '2007-12-26'
+ description: "Boxing Day"
+date20080101:
+ id: '4'
+ day: '2008-01-01'
+ description: "New Year's Day"
+date20080102:
+ id: '5'
+ day: '2008-01-02'
+ description: "2nd January (Scotland)"
+date20080317:
+ id: '6'
+ day: '2008-03-17'
+ description: "St. Patrick's Day (NI)"
+date20080321:
+ id: '7'
+ day: '2008-03-21'
+ description: "Good Friday"
+date20080324:
+ id: '8'
+ day: '2008-03-24'
+ description: "Easter Monday"
+date20080505:
+ id: '9'
+ day: '2008-05-05'
+ description: "Early May Bank Holiday"
+date20080526:
+ id: '10'
+ day: '2008-05-26'
+ description: "Spring Bank Holiday"
+date20080714:
+ id: '11'
+ day: '2008-07-14'
+ description: "Battle of the Boyne (NI)"
+date20080804:
+ id: '12'
+ day: '2008-08-04'
+ description: "Summer Bank Holiday (Scotland)"
+date20080825:
+ id: '13'
+ day: '2008-08-25'
+ description: "Summer Bank Holiday (England + Wales)"
+date20081201:
+ id: '14'
+ day: '2008-12-01'
+ description: "St. Andrew's Day (Scotland)"
+date20081225:
+ id: '15'
+ day: '2008-12-25'
+ description: "Christmas Day"
+date20081226:
+ id: '16'
+ day: '2008-12-26'
+ description: "Boxing Day"
+date20090101:
+ id: '17'
+ day: '2009-01-01'
+ description: "New Year's Day"
+date20090102:
+ id: '18'
+ day: '2009-01-02'
+ description: "2nd January (Scotland)"
+date20090317:
+ id: '19'
+ day: '2009-03-17'
+ description: "St. Patrick's Day (NI)"
+date20090410:
+ id: '20'
+ day: '2009-04-10'
+ description: "Good Friday"
+date20090413:
+ id: '21'
+ day: '2009-04-13'
+ description: "Easter Monday"
+date20090504:
+ id: '22'
+ day: '2009-05-04'
+ description: "Early May Bank Holiday"
+date20090525:
+ id: '23'
+ day: '2009-05-25'
+ description: "Spring Bank Holiday"
+date20090713:
+ id: '24'
+ day: '2009-07-13'
+ description: "Battle of the Boyne (NI)"
+date20090803:
+ id: '25'
+ day: '2009-08-03'
+ description: "Summer Bank Holiday (Scotland)"
+date20090831:
+ id: '26'
+ day: '2009-08-31'
+ description: "Summer Bank Holiday (England + Wales)"
+date20091130:
+ id: '27'
+ day: '2009-11-30'
+ description: "St. Andrew's Day (Scotland)"
+date20091225:
+ id: '28'
+ day: '2009-12-25'
+ description: "Christmas Day"
+date20091228:
+ id: '29'
+ day: '2009-12-28'
+ description: "Boxing Day"
+date20100101:
+ id: '30'
+ day: '2010-01-01'
+ description: "New Year's Day"
+date20100104:
+ id: '31'
+ day: '2010-01-04'
+ description: "2nd January (Scotland)"
+date20100317:
+ id: '32'
+ day: '2010-03-17'
+ description: "St. Patrick's Day (NI)"
+date20100402:
+ id: '33'
+ day: '2010-04-02'
+ description: "Good Friday"
+date20100405:
+ id: '34'
+ day: '2010-04-05'
+ description: "Easter Monday"
+date20100503:
+ id: '35'
+ day: '2010-05-03'
+ description: "Early May Bank Holiday"
+date20100531:
+ id: '36'
+ day: '2010-05-31'
+ description: "Spring Bank Holiday"
+date20100712:
+ id: '37'
+ day: '2010-07-12'
+ description: "Battle of the Boyne (NI)"
+date20100802:
+ id: '38'
+ day: '2010-08-02'
+ description: "Summer Bank Holiday (Scotland)"
+date20100830:
+ id: '39'
+ day: '2010-08-30'
+ description: "Summer Bank Holiday (England + Wales)"
+date20101130:
+ id: '40'
+ day: '2010-11-30'
+ description: "St. Andrew's Day (Scotland)"
+date20101227:
+ id: '41'
+ day: '2010-12-27'
+ description: "Christmas Day"
+date20101228:
+ id: '42'
+ day: '2010-12-28'
+ description: "Boxing Day"
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-29 12:26:10 +0000