public function delete($file_path) { $result = ftp_delete($this->_connection_id, $file_path); if ($result) { return true; } else { $log = new \Kiva\Silverpop_Connector\Logger(); $log->error("Failed to remove {$file_path} from FTP."); return false; } }
/** * @param $vsql * @return array */ public function fetchData($vsql) { try { $result = $this->_db->query($vsql); $vertica_data = $result->fetchAll(); } catch (PDOException $e) { $log = new \Kiva\Silverpop_Connector\Logger(); $log->error($e->getMessage()); exit; } return $vertica_data; }
array_push($sql_files_to_use, $val); } #pull each query into a local file foreach ($sql_files as $sql_file) { $sql_basename = basename($sql_file, '.sql'); $is_hidden_file = substr($sql_basename, 0, 1) === '.'; if (!$is_hidden_file) { try { $query = file_get_contents(LOCAL_SQL_DIR . '/' . $sql_file); if (empty($sql_files_to_use) || in_array($sql_basename, $sql_files_to_use)) { $filename = getSilverpopFilename($vertex->getEnvironment(), $sql_basename); $local_file = $vertex->exportToCsv(LOCAL_UPLOAD_DIR . '/' . $filename, $query); $upload_files[] = $local_file; } } catch (PDOException $e) { $logger->error("Failed downloading {$sql_file} to local instance. Error: " . print_r($e)); throw new Exception($e); } } } #upload to ftp $silverpop = new \Kiva\Silverpop_Connector\SilverpopFTP(); $silverpop->upload($upload_files); //remove local files foreach (glob(LOCAL_UPLOAD_DIR . "/*") as $file) { unlink($file); } $logger->info('Successfully completed Silverpop Upload job'); #TODO move this function getSilverpopFilename($env_prefix, $basename) {