/**
  * Sets up the fixture, for example, open a network connection.
  * This method is called before a test is executed.
  *
  * @access protected
  */
 protected function setUp()
 {
     $conf = new Conf();
     $this->connection = mysql_connect($conf->dbhost . ":" . $conf->dbport, $conf->dbuser, $conf->dbpass);
     mysql_select_db($conf->dbname);
     $this->_truncateTables();
     // insert some test data
     $this->_runQuery("INSERT INTO hs_hr_custom_export(export_id, name, fields, headings) VALUES (1, 'Export 1', 'empId,lastName,firstName,middleName,street1,street2,city', '')");
     $this->_runQuery("INSERT INTO hs_hr_custom_export(export_id, name, fields, headings) VALUES (2, 'Export 2', 'empId,lastName,firstName,city', 'Employee Id,Last Name,First Name,City')");
     $this->_runQuery("INSERT INTO hs_hr_custom_export(export_id, name, fields, headings) VALUES (3, 'Export 3', 'empId,street1,street2,city', 'Employee Id,Address1, Address2, City')");
     // insert some employee data
     $sql = "INSERT INTO hs_hr_employee" . "(emp_number,   employee_id, emp_lastname, emp_firstname, emp_middle_name, " . "emp_nick_name, emp_smoker, ethnic_race_code, emp_birthday, nation_code, " . "emp_gender, emp_marital_status, emp_ssn_num, emp_sin_num, emp_other_id, " . "emp_dri_lice_num, emp_dri_lice_exp_date, emp_military_service, emp_status, " . "job_title_code, eeo_cat_code, work_station, " . "emp_street1, emp_street2, city_code, coun_code, provin_code, emp_zipcode, " . "emp_hm_telephone, emp_mobile, emp_work_telephone, emp_work_email, " . "sal_grd_code, joined_date,\temp_oth_email, " . "custom1, custom2, custom3, custom4, custom5, " . "custom6, custom7, custom8, custom9, custom10)  VALUES (" . "'10', 'E1921A', 'Karunadasa', 'Kamal', 'K', " . "NULL, NULL, NULL, '1974-11-20', NULL, " . "1, NULL, '987654320', '', '', " . "null, NULL, NULL, 'EST001', " . "NULL, NULL, NULL, " . "'111 Main Street', 'SUITE A29', 'Houston', 'US', 'TX', '77845', " . "'', '', '', NULL, " . "NULL, '1997-12-11', NULL, " . "'c1', 'c2', 'c3', 'c4', 'c5'," . "'c6', 'c7', 'c8', 'c9', 'c10'" . ")";
     if (KeyHandlerOld::keyExists()) {
         $key = KeyHandlerOld::readKey();
         $sql = str_replace("'987654320'", "AES_ENCRYPT('987654320', '{$key}')", $sql);
     }
     $this->_runQuery($sql);
     $sql = "INSERT into hs_hr_emp_us_tax(emp_number, tax_federal_status, tax_federal_exceptions, " . "tax_state, tax_state_status, tax_state_exceptions, tax_unemp_state,tax_work_state) VALUES (" . "10, 'NRA', 2, 'MD', 'NA', 3, 'VA', 'AZ')";
     $this->_runQuery($sql);
     // Add direct debit information
     $dd = new EmpDirectDebit();
     $dd->setEmpNumber(10);
     $dd->setRoutingNumber(11111);
     $dd->setAccount('AC 1');
     $dd->setAmount(121);
     $dd->setAccountType('CHECKING');
     $dd->setTransactionType('BLANK');
     $this->assertTrue($dd->add(), mysql_error());
     $dd = new EmpDirectDebit();
     $dd->setEmpNumber(10);
     $dd->setRoutingNumber(22222);
     $dd->setAccount('AC #2');
     $dd->setAmount(23);
     $dd->setAccountType('SAVINGS');
     $dd->setTransactionType('FLATMINUS');
     $this->assertTrue($dd->add(), mysql_error());
 }