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)
{
