$lastIntId = null;
foreach ($entries as $entry) {
/* @var $entry entry */
$categoriesCriteria = new Criteria();
$categoriesCriteria->add(categoryPeer::ID, $entry->getCategoriesIds(), Criteria::IN);
$categories = categoryPeer::doSelect($categoriesCriteria);
$categoryIds = array();
foreach ($categories as $category) {
/* @var $category category */
$categoryIds[] = $category->getId();
}
$categoryEntriesCriteria = new Criteria();
$categoryEntriesCriteria->addSelectColumn(categoryEntryPeer::CATEGORY_ID);
$categoryEntriesCriteria->add(categoryEntryPeer::ENTRY_ID, $entry->getId());
$categoryEntriesCriteria->add(categoryEntryPeer::CATEGORY_ID, $categoryIds, Criteria::IN);
$stmt = categoryEntryPeer::doSelectStmt($categoryEntriesCriteria);
$categoryEntriesIds = $stmt->fetchAll(PDO::FETCH_COLUMN);
KalturaStatement::setDryRun($dryRun);
foreach ($categories as $category) {
/* @var $category category */
$entryId = $entry->getId();
$categoryId = $category->getId();
if (in_array($categoryId, $categoryEntriesIds)) {
KalturaLog::debug("CategoryEntry already exists for entry [{$entryId}] and category [{$categoryId}]");
continue;
}
$categoryEntry = new migrationCategoryEntry();
$categoryEntry->setEntryId($entryId);
$categoryEntry->setCategoryId($categoryId);
$categoryEntry->setPartnerId($entry->getPartnerId());
$categoryEntry->setCategoryFullIds($category->getFullIds());
/**
* Reloads this object from datastore based on primary key and (optionally) resets all associated objects.
*
* This will only work if the object has been saved and has a valid primary key set.
*
* @param boolean $deep (optional) Whether to also de-associated any related objects.
* @param PropelPDO $con (optional) The PropelPDO connection to use.
* @return void
* @throws PropelException - if this object is deleted, unsaved or doesn't have pk match in db
*/
public function reload($deep = false, PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("Cannot reload a deleted object.");
}
if ($this->isNew()) {
throw new PropelException("Cannot reload an unsaved object.");
}
if ($con === null) {
$con = Propel::getConnection(categoryEntryPeer::DATABASE_NAME, Propel::CONNECTION_READ);
}
// We don't need to alter the object instance pool; we're just modifying this instance
// already in the pool.
categoryEntryPeer::setUseCriteriaFilter(false);
$stmt = categoryEntryPeer::doSelectStmt($this->buildPkeyCriteria(), $con);
categoryEntryPeer::setUseCriteriaFilter(true);
$row = $stmt->fetch(PDO::FETCH_NUM);
$stmt->closeCursor();
if (!$row) {
throw new PropelException('Cannot find matching row in the database to reload object values.');
}
$this->hydrate($row, 0, true);
// rehydrate
if ($deep) {
// also de-associate any related objects?
}
// if (deep)
}
