public function __construct(Configuration $configuration, $accountId)
{
$this->configuration = $configuration;
$storageApi = $this->configuration->getStorageApi();
$sysBucket = $this->configuration->getSysBucketId();
$this->accountId = $accountId;
parent::__construct($storageApi, $sysBucket . '.' . $accountId);
}
public function uploadCsv($file, $tableId, $incremental = false)
{
$sapi = $this->configuration->getStorageApi();
$table = new Table($sapi, $tableId, $file, 'id', false, ',', '"', $incremental);
try {
$table->save(true);
} catch (ClientException $e) {
throw new UserException('Error while uploading data to StorageAPI: ' . $e->getMessage(), $e);
}
}
public function run($options = null)
{
$accounts = $this->configuration->getAccounts();
$status = array();
$dateFrom = isset($options['since']) ? date('Y-m-d', strtotime($options['since'])) : date('Y-m-d', strtotime('-4 days'));
$dateTo = isset($options['until']) ? date('Y-m-d', strtotime($options['until'])) : date('Y-m-d', strtotime('-1 day'));
$dataset = isset($options['dataset']) ? $options['dataset'] : null;
if (isset($options['account'])) {
if (!isset($accounts[$options['account']])) {
throw new UserException(sprintf("Account '%s' does not exist.", $options['account']));
}
$accounts = array($options['account'] => $accounts[$options['account']]);
}
if (isset($options['config'])) {
if (!isset($accounts[$options['config']])) {
throw new UserException(sprintf("Config '%s' does not exist.", $options['config']));
}
$accounts = array($options['config'] => $accounts[$options['config']]);
}
if ($dataset != null && !isset($options['config']) && !isset($options['account'])) {
throw new UserException("Missing parameter 'config'");
}
/** @var Account $account */
foreach ($accounts as $accountId => $account) {
// check if account has been authorized
if (null == $account->getAttribute('accessToken')) {
continue;
}
$this->currAccountId = $accountId;
if (null == $account->getAttribute('outputBucket')) {
$this->configuration->initDataBucket($account->getAccountId());
} else {
if (!$this->configuration->getStorageApi()->bucketExists($account->getAttribute('outputBucket'))) {
$outBucketArr = explode('.', $account->getAttribute('outputBucket'));
$this->configuration->getStorageApi()->createBucket(str_replace('c-', '', $outBucketArr[1]), $outBucketArr[0], 'Google Analytics data bucket');
}
}
$this->gaApi->getApi()->setCredentials($account->getAccessToken(), $account->getRefreshToken());
$this->gaApi->getApi()->setRefreshTokenCallback(array($this, 'refreshTokenCallback'));
$tmpFileInfo = $this->temp->createFile("profiles-" . $accountId . "-" . microtime() . ".csv");
$profilesCsv = new CsvFile($tmpFileInfo->getPathname());
$profilesCsv->writeRow(array('id', 'name'));
/** @var Profile $profile */
foreach ($account->getProfiles() as $profile) {
$profilesCsv->writeRow(array($profile->getGoogleId(), $profile->getName()));
try {
$configuration = $account->getConfiguration();
// Download just the dataset specified in request
if ($dataset != null) {
if (!isset($configuration[$dataset])) {
throw new UserException(sprintf("Dataset '%s' doesn't exist", $dataset));
}
$configuration = [$dataset => $configuration[$dataset]];
}
foreach ($configuration as $tableName => $cfg) {
// Download dataset only for specific profile
if (isset($cfg['profile']) && $cfg['profile'] != $profile->getGoogleId()) {
continue;
}
$antisampling = isset($cfg['antisampling']) ? $cfg['antisampling'] : false;
$this->getData($account, $profile, $tableName, $dateFrom, $dateTo, $antisampling);
$status[$accountId][$profile->getName()][$tableName] = 'ok';
}
} catch (RequestException $e) {
if ($e->getCode() == 401) {
throw new UserException("Expired or wrong credentials, please reauthorize.", $e);
}
if ($e->getCode() == 403) {
if (strtolower($e->getResponse()->getReasonPhrase()) == 'forbidden') {
$this->logger->warning("You don't have access to Google Analytics resource. Probably you don't have access to profile, or profile doesn't exists anymore.");
continue;
} else {
throw new UserException("Reason: " . $e->getResponse()->getReasonPhrase(), $e);
}
}
if ($e->getCode() == 400) {
throw new UserException($e->getMessage());
}
if ($e->getCode() == 503) {
throw new UserException("Google API error: " . $e->getMessage(), $e);
}
throw new ApplicationException($e->getResponse()->getBody(), $e);
}
}
$this->getDataManager()->uploadCsv($profilesCsv->getPathname(), $this->getOutputTable($account, 'profiles'));
}
return $status;
}
