[Summary view] [Print] [Text view]

   1  #!/usr/bin/env php
   2  <?php
   3  
   4  $root = dirname(dirname(dirname(__FILE__)));
   5  require_once $root.'/scripts/__init_script__.php';
   6  
   7  // http://www.opm.gov/operating_status_schedules/fedhol/
   8  $holidays = array(
   9    '2014-01-01' => "New Year's Day",
  10    '2014-01-20' => 'Birthday of Martin Luther King, Jr.',
  11    '2014-02-17' => "Washington's Birthday",
  12    '2014-05-26' => 'Memorial Day',
  13    '2014-07-04' => 'Independence Day',
  14    '2014-09-01' => 'Labor Day',
  15    '2014-10-13' => 'Columbus Day',
  16    '2014-11-11' => 'Veterans Day',
  17    '2014-11-27' => 'Thanksgiving Day',
  18    '2014-12-25' => 'Christmas Day',
  19    '2015-01-01' => "New Year's Day",
  20    '2015-01-19' => 'Birthday of Martin Luther King, Jr.',
  21    '2015-02-16' => "Washington's Birthday",
  22    '2015-05-25' => 'Memorial Day',
  23    '2015-07-03' => 'Independence Day',
  24    '2015-09-07' => 'Labor Day',
  25    '2015-10-12' => 'Columbus Day',
  26    '2015-11-11' => 'Veterans Day',
  27    '2015-11-26' => 'Thanksgiving Day',
  28    '2015-12-25' => 'Christmas Day',
  29    '2016-01-01' => "New Year's Day",
  30    '2016-01-18' => 'Birthday of Martin Luther King, Jr.',
  31    '2016-02-15' => "Washington's Birthday",
  32    '2016-05-30' => 'Memorial Day',
  33    '2016-07-04' => 'Independence Day',
  34    '2016-09-05' => 'Labor Day',
  35    '2016-10-10' => 'Columbus Day',
  36    '2016-11-11' => 'Veterans Day',
  37    '2016-11-24' => 'Thanksgiving Day',
  38    '2016-12-26' => 'Christmas Day',
  39    '2017-01-02' => "New Year's Day",
  40    '2017-01-16' => 'Birthday of Martin Luther King, Jr.',
  41    '2017-02-10' => "Washington's Birthday",
  42    '2017-05-29' => 'Memorial Day',
  43    '2017-07-04' => 'Independence Day',
  44    '2017-09-04' => 'Labor Day',
  45    '2017-10-09' => 'Columbus Day',
  46    '2017-11-10' => 'Veterans Day',
  47    '2017-11-23' => 'Thanksgiving Day',
  48    '2017-12-25' => 'Christmas Day',
  49  );
  50  
  51  $table = new PhabricatorCalendarHoliday();
  52  $conn_w = $table->establishConnection('w');
  53  $table_name = $table->getTableName();
  54  
  55  foreach ($holidays as $day => $name) {
  56    queryfx(
  57      $conn_w,
  58      'INSERT IGNORE INTO %T (day, name) VALUES (%s, %s)',
  59      $table_name,
  60      $day,
  61      $name);
  62  }