<?php chdir(dirname(__FILE__)); require_once __DIR__ . '/../../bootstrap.php'; $c = new Criteria(); if ($argc > 1 && is_numeric($argv[1])) { $c->add(CaptionAssetItemPeer::CREATED_AT, $argv[1], Criteria::GREATER_EQUAL); } if ($argc > 2 && is_numeric($argv[2])) { $c->add(CaptionAssetItemPeer::PARTNER_ID, $argv[2], Criteria::EQUAL); } if ($argc > 3 && is_numeric($argv[3])) { $c->add(CaptionAssetItemPeer::ID, $argv[3], Criteria::GREATER_EQUAL); } if ($argc > 4) { CaptionAssetItemPeer::setUseCriteriaFilter((bool) $argv[4]); } $c->addAscendingOrderByColumn(CaptionAssetItemPeer::CREATED_AT); $c->addAscendingOrderByColumn(CaptionAssetItemPeer::ID); $c->setLimit(10000); $con = myDbHelper::getConnection(myDbHelper::DB_HELPER_CONN_PROPEL2); //$sphinxCon = DbManager::getSphinxConnection(); $captions = CaptionAssetItemPeer::doSelect($c, $con); $sphinx = new kSphinxSearchManager(); while (count($captions)) { foreach ($captions as $caption) { KalturaLog::log('caption_asset_id ' . $caption->getId() . ' int id[' . $caption->getIntId() . '] crc id[' . $sphinx->getSphinxId($caption) . '] last updated at [' . $caption->getUpdatedAt(null) . ']'); try { $ret = $sphinx->saveToSphinx($caption, true); } catch (Exception $e) { KalturaLog::err($e->getMessage());
/** * 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(CaptionAssetItemPeer::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. CaptionAssetItemPeer::setUseCriteriaFilter(false); $stmt = CaptionAssetItemPeer::doSelectStmt($this->buildPkeyCriteria(), $con); CaptionAssetItemPeer::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) }