Changeset View
Changeset View
Standalone View
Standalone View
scripts/calendar/import_us_holidays.php
| #!/usr/bin/env php | #!/usr/bin/env php | ||||
| <?php | <?php | ||||
| $root = dirname(dirname(dirname(__FILE__))); | $root = dirname(dirname(dirname(__FILE__))); | ||||
| require_once $root.'/scripts/__init_script__.php'; | require_once $root.'/scripts/__init_script__.php'; | ||||
| // http://www.opm.gov/operating_status_schedules/fedhol/ | // http://www.opm.gov/operating_status_schedules/fedhol/ | ||||
| $holidays = array( | $holidays = array( | ||||
| '2014-01-01' => "New Year's Day", | '2014-01-01' => "New Year's Day", | ||||
| '2014-01-20' => "Birthday of Martin Luther King, Jr.", | '2014-01-20' => 'Birthday of Martin Luther King, Jr.', | ||||
| '2014-02-17' => "Washington's Birthday", | '2014-02-17' => "Washington's Birthday", | ||||
| '2014-05-26' => "Memorial Day", | '2014-05-26' => 'Memorial Day', | ||||
| '2014-07-04' => "Independence Day", | '2014-07-04' => 'Independence Day', | ||||
| '2014-09-01' => "Labor Day", | '2014-09-01' => 'Labor Day', | ||||
| '2014-10-13' => "Columbus Day", | '2014-10-13' => 'Columbus Day', | ||||
| '2014-11-11' => "Veterans Day", | '2014-11-11' => 'Veterans Day', | ||||
| '2014-11-27' => "Thanksgiving Day", | '2014-11-27' => 'Thanksgiving Day', | ||||
| '2014-12-25' => "Christmas Day", | '2014-12-25' => 'Christmas Day', | ||||
| '2015-01-01' => "New Year's Day", | '2015-01-01' => "New Year's Day", | ||||
| '2015-01-19' => "Birthday of Martin Luther King, Jr.", | '2015-01-19' => 'Birthday of Martin Luther King, Jr.', | ||||
| '2015-02-16' => "Washington's Birthday", | '2015-02-16' => "Washington's Birthday", | ||||
| '2015-05-25' => "Memorial Day", | '2015-05-25' => 'Memorial Day', | ||||
| '2015-07-03' => "Independence Day", | '2015-07-03' => 'Independence Day', | ||||
| '2015-09-07' => "Labor Day", | '2015-09-07' => 'Labor Day', | ||||
| '2015-10-12' => "Columbus Day", | '2015-10-12' => 'Columbus Day', | ||||
| '2015-11-11' => "Veterans Day", | '2015-11-11' => 'Veterans Day', | ||||
| '2015-11-26' => "Thanksgiving Day", | '2015-11-26' => 'Thanksgiving Day', | ||||
| '2015-12-25' => "Christmas Day", | '2015-12-25' => 'Christmas Day', | ||||
| '2016-01-01' => "New Year's Day", | '2016-01-01' => "New Year's Day", | ||||
| '2016-01-18' => "Birthday of Martin Luther King, Jr.", | '2016-01-18' => 'Birthday of Martin Luther King, Jr.', | ||||
| '2016-02-15' => "Washington's Birthday", | '2016-02-15' => "Washington's Birthday", | ||||
| '2016-05-30' => "Memorial Day", | '2016-05-30' => 'Memorial Day', | ||||
| '2016-07-04' => "Independence Day", | '2016-07-04' => 'Independence Day', | ||||
| '2016-09-05' => "Labor Day", | '2016-09-05' => 'Labor Day', | ||||
| '2016-10-10' => "Columbus Day", | '2016-10-10' => 'Columbus Day', | ||||
| '2016-11-11' => "Veterans Day", | '2016-11-11' => 'Veterans Day', | ||||
| '2016-11-24' => "Thanksgiving Day", | '2016-11-24' => 'Thanksgiving Day', | ||||
| '2016-12-26' => "Christmas Day", | '2016-12-26' => 'Christmas Day', | ||||
| '2017-01-02' => "New Year's Day", | '2017-01-02' => "New Year's Day", | ||||
| '2017-01-16' => "Birthday of Martin Luther King, Jr.", | '2017-01-16' => 'Birthday of Martin Luther King, Jr.', | ||||
| '2017-02-10' => "Washington's Birthday", | '2017-02-10' => "Washington's Birthday", | ||||
| '2017-05-29' => "Memorial Day", | '2017-05-29' => 'Memorial Day', | ||||
| '2017-07-04' => "Independence Day", | '2017-07-04' => 'Independence Day', | ||||
| '2017-09-04' => "Labor Day", | '2017-09-04' => 'Labor Day', | ||||
| '2017-10-09' => "Columbus Day", | '2017-10-09' => 'Columbus Day', | ||||
| '2017-11-10' => "Veterans Day", | '2017-11-10' => 'Veterans Day', | ||||
| '2017-11-23' => "Thanksgiving Day", | '2017-11-23' => 'Thanksgiving Day', | ||||
| '2017-12-25' => "Christmas Day", | '2017-12-25' => 'Christmas Day', | ||||
| ); | ); | ||||
| $table = new PhabricatorCalendarHoliday(); | $table = new PhabricatorCalendarHoliday(); | ||||
| $conn_w = $table->establishConnection('w'); | $conn_w = $table->establishConnection('w'); | ||||
| $table_name = $table->getTableName(); | $table_name = $table->getTableName(); | ||||
| foreach ($holidays as $day => $name) { | foreach ($holidays as $day => $name) { | ||||
| queryfx( | queryfx( | ||||
| $conn_w, | $conn_w, | ||||
| 'INSERT IGNORE INTO %T (day, name) VALUES (%s, %s)', | 'INSERT IGNORE INTO %T (day, name) VALUES (%s, %s)', | ||||
| $table_name, | $table_name, | ||||
| $day, | $day, | ||||
| $name); | $name); | ||||
| } | } | ||||