public function testDelete()
{
// Cleanup
Keyword::deleteAll();
// Insert
$keyword = new Keyword();
$keyword->name = 'Habanero';
$keyword->description = 'Habaneros are reasonably hot';
$keyword->external_url = 'https://en.wikipedia.org/wiki/Habanero';
$term_id = $keyword->save();
// Delete
$keyword = new Keyword();
$this->assertTrue($keyword->load($term_id));
$this->assertTrue($keyword->delete());
// Load shouldn't work
$keyword = new Keyword();
$this->assertFalse($keyword->load($term_id));
}
fputs($fp, "{$campaign->ga_campaign_name},20,iw,IL,,,{$adgroup}," . MAX_CPC . "\r\n");
foreach ($adgroup->ads as $add) {
fputs($fp, "{$campaign->ga_campaign_name},,,,,,{$adgroup},,,," . $add->gia_image . "," . $add->gia_name . "," . $add->gia_size . "," . $adgroup->giag_display_url . ",\"" . $adgroup->giag_destination_url . "\"\r\n");
}
$tmp = explode(" ", $val['keyword']);
$search = "";
foreach ($tmp as $t) {
$search .= " and (keyword LIKE '% " . addslashes($t) . " %' or keyword LIKE '% " . addslashes($t) . "' or keyword LIKE '" . addslashes($t) . " %')";
}
$db->executeSQL("SELECT keyword_id, keyword FROM keywords WHERE 1 {$search}", $resultArry2, $rowsAffected);
foreach ($resultArry2 as $r2) {
if (!in_array($r2['keyword'], $kws)) {
$c++;
$data .= stripslashes($r2['keyword']) . "\r\n";
$kws[] = $r2['keyword'];
$keyword->load($r2['keyword_id']);
foreach ($adgroup->ads as $aval) {
$keyword->addToGoogleAd($aval->gia_id);
}
fputs($fp, "{$campaign->ga_campaign_name},,,,,,{$adgroup}," . MAX_CPC . "," . DEFAULT_MATCH_TYPE . "," . str_replace(",", " ", $keyword->keyword) . "\r\n");
}
}
$cond = '';
$db->executeSQL("SELECT * FROM {$table} WHERE keyword_id={$val['keyword_id']}", $resultArry2, $rowsAffected);
foreach ($resultArry2[0] as $k => $v) {
if ($k != 'keyword_id' && $k != 'l_latitude' && $k != 'l_longitude') {
$cond .= " and {$k}='" . addslashes($v) . "'";
}
}
$db->executeSQL("SELECT keyword_id FROM {$table} WHERE 1 {$cond}", $resultArry2, $rowsAffected);
foreach ($resultArry2 as $r2) {
