public function preImport() { // Delete table before proceeding ContentQuery::create()->deleteAll(); ContentImageQuery::create()->deleteAll(); ContentDocumentQuery::create()->deleteAll(); // Create T1 <-> T2 IDs correspondance tables $this->content_corresp->reset(); }
/** * Returns the number of related ContentDocument objects. * * @param Criteria $criteria * @param boolean $distinct * @param ConnectionInterface $con * @return int Count of related ContentDocument objects. * @throws PropelException */ public function countContentDocuments(Criteria $criteria = null, $distinct = false, ConnectionInterface $con = null) { $partial = $this->collContentDocumentsPartial && !$this->isNew(); if (null === $this->collContentDocuments || null !== $criteria || $partial) { if ($this->isNew() && null === $this->collContentDocuments) { return 0; } if ($partial && !$criteria) { return count($this->getContentDocuments()); } $query = ChildContentDocumentQuery::create(null, $criteria); if ($distinct) { $query->distinct(); } return $query->filterByContent($this)->count($con); } return count($this->collContentDocuments); }
public function testCopyUploadedFileContentDocument() { $this->dotTestDocumentUpload(ContentDocumentQuery::create()->findOne(), 'content'); }
public function testQueryDocument() { $data = $this->handler->setDocumentExport(true)->buildData($this->lang)->getData(); $max = count($data); if ($max > 50) { $max = 50; } for ($i = 0; $i < $max; ++$i) { $documents = ContentDocumentQuery::create()->filterByContentId($data[$i]["id"])->select(ContentDocumentTableMap::FILE)->find()->toArray(); $documentsString = implode(",", $documents); if (empty($data[$i]["content_documents"])) { $j = 1; while ($data[$i - $j]["id"] === $data[$i]["id"]) { if (!empty($data[$i - $j++]["content_documents"])) { $data[$i]["content_documents"] = $data[$i - $j + 1]["content_documents"]; break; } } } $this->assertEquals($documentsString, $data[$i]["content_documents"]); $folderDocuments = FolderDocumentQuery::create()->useFolderQuery()->useContentFolderQuery()->filterByContentId($data[$i]["id"])->filterByFolderId($data[$i]["folder_id"])->endUse()->endUse()->select(FolderDocumentTableMap::FILE)->find()->toArray(); $folderDocuments = implode(",", $folderDocuments); $this->assertEquals($folderDocuments, $data[$i]["folder_documents"]); } }
/** * @return array * * return an array with the paths to the documents to include in the archive */ public function getDocumentsPaths() { $documentPaths = []; $folderDocuments = FolderDocumentQuery::create()->find(); /** @var \Thelia\Model\FolderDocument $folderDocument */ foreach ($folderDocuments as $folderDocument) { $this->addFileToArray($folderDocument, $documentPaths); } $contentDocuments = ContentDocumentQuery::create()->find(); /** @var \Thelia\Model\ContentDocument $contentDocument */ foreach ($contentDocuments as $contentDocument) { $this->addFileToArray($contentDocument, $documentPaths); } return $documentPaths; }
public function delete(ContentDeleteEvent $event, $eventName, EventDispatcherInterface $dispatcher) { if (null !== ($content = ContentQuery::create()->findPk($event->getContentId()))) { $con = Propel::getWriteConnection(ContentTableMap::DATABASE_NAME); $con->beginTransaction(); try { $fileList = ['images' => [], 'documentList' => []]; $defaultFolderId = $content->getDefaultFolderId(); // Get content's files to delete after content deletion $fileList['images']['list'] = ContentImageQuery::create()->findByContentId($event->getContentId()); $fileList['images']['type'] = TheliaEvents::IMAGE_DELETE; $fileList['documentList']['list'] = ContentDocumentQuery::create()->findByContentId($event->getContentId()); $fileList['documentList']['type'] = TheliaEvents::DOCUMENT_DELETE; // Delete content $content->setDispatcher($dispatcher)->delete($con); $event->setDefaultFolderId($defaultFolderId); $event->setContent($content); // Dispatch delete content's files event foreach ($fileList as $fileTypeList) { foreach ($fileTypeList['list'] as $fileToDelete) { $fileDeleteEvent = new FileDeleteEvent($fileToDelete); $dispatcher->dispatch($fileTypeList['type'], $fileDeleteEvent); } } $con->commit(); } catch (\Exception $e) { $con->rollback(); throw $e; } } }
Model\ContentQuery::create()->deleteAll(); Model\ContentI18nQuery::create()->deleteAll(); Model\AccessoryQuery::create()->deleteAll(); Model\ProductSaleElementsQuery::create()->deleteAll(); Model\ProductPriceQuery::create()->deleteAll(); Model\BrandQuery::create()->deleteAll(); Model\BrandI18nQuery::create()->deleteAll(); Model\ProductImageQuery::create()->deleteAll(); Model\CategoryImageQuery::create()->deleteAll(); Model\FolderImageQuery::create()->deleteAll(); Model\ContentImageQuery::create()->deleteAll(); Model\BrandImageQuery::create()->deleteAll(); Model\ProductDocumentQuery::create()->deleteAll(); Model\CategoryDocumentQuery::create()->deleteAll(); Model\FolderDocumentQuery::create()->deleteAll(); Model\ContentDocumentQuery::create()->deleteAll(); Model\BrandDocumentQuery::create()->deleteAll(); Model\CouponQuery::create()->deleteAll(); Model\OrderQuery::create()->deleteAll(); Model\SaleQuery::create()->deleteAll(); Model\SaleProductQuery::create()->deleteAll(); Model\MetaDataQuery::create()->deleteAll(); $stmt = $con->prepare("SET foreign_key_checks = 1"); $stmt->execute(); echo "Creating customers\n"; //API $api = new Thelia\Model\Api(); $api->setProfileId(null)->setApiKey('79E95BD784CADA0C9A578282E')->setLabel("test")->save(); //customer $customer = new Thelia\Model\Customer(); $customer->createOrUpdate(1, "thelia", "thelia", "5 rue rochon", "", "", "0102030405", "0601020304", "63000", "clermont-ferrand", 64, "*****@*****.**", "azerty");
public function testSearchByContentId() { $document = ContentDocumentQuery::create()->findOne(); $this->baseTestSearchById($document->getId(), array('source' => 'content')); }
$stock->delete(); $productPrice = \Thelia\Model\ProductPriceQuery::create()->find(); $productPrice->delete(); $brand = Thelia\Model\BrandQuery::create()->find(); $brand->delete(); $brand = Thelia\Model\BrandI18nQuery::create()->find(); $brand->delete(); \Thelia\Model\ProductImageQuery::create()->find()->delete(); \Thelia\Model\CategoryImageQuery::create()->find()->delete(); \Thelia\Model\FolderImageQuery::create()->find()->delete(); \Thelia\Model\ContentImageQuery::create()->find()->delete(); \Thelia\Model\BrandImageQuery::create()->find()->delete(); \Thelia\Model\ProductDocumentQuery::create()->find()->delete(); \Thelia\Model\CategoryDocumentQuery::create()->find()->delete(); \Thelia\Model\FolderDocumentQuery::create()->find()->delete(); \Thelia\Model\ContentDocumentQuery::create()->find()->delete(); \Thelia\Model\BrandDocumentQuery::create()->find()->delete(); \Thelia\Model\CouponQuery::create()->find()->delete(); \Thelia\Model\OrderQuery::create()->find()->delete(); \Thelia\Model\SaleQuery::create()->find()->delete(); \Thelia\Model\SaleProductQuery::create()->find()->delete(); \Thelia\Model\MetaDataQuery::create()->find()->delete(); $stmt = $con->prepare("SET foreign_key_checks = 1"); $stmt->execute(); echo "Creating customers\n"; //API $api = new Thelia\Model\Api(); $api->setProfileId(null)->setApiKey('79E95BD784CADA0C9A578282E')->setLabel("test")->save(); //customer $customer = new Thelia\Model\Customer(); $customer->createOrUpdate(1, "thelia", "thelia", "5 rue rochon", "", "", "0102030405", "0601020304", "63000", "clermont-ferrand", 64, "*****@*****.**", "azerty");
/** * Removes this object from datastore and sets delete attribute. * * @param ConnectionInterface $con * @return void * @throws PropelException * @see ContentDocument::setDeleted() * @see ContentDocument::isDeleted() */ public function delete(ConnectionInterface $con = null) { if ($this->isDeleted()) { throw new PropelException("This object has already been deleted."); } if ($con === null) { $con = Propel::getServiceContainer()->getWriteConnection(ContentDocumentTableMap::DATABASE_NAME); } $con->beginTransaction(); try { $deleteQuery = ChildContentDocumentQuery::create()->filterByPrimaryKey($this->getPrimaryKey()); $ret = $this->preDelete($con); if ($ret) { $deleteQuery->delete($con); $this->postDelete($con); $con->commit(); $this->setDeleted(true); } else { $con->commit(); } } catch (Exception $e) { $con->rollBack(); throw $e; } }
/** * Get the associated ChildContentDocument object * * @param ConnectionInterface $con Optional Connection object. * @return ChildContentDocument The associated ChildContentDocument object. * @throws PropelException */ public function getContentDocument(ConnectionInterface $con = null) { if ($this->aContentDocument === null && $this->id !== null) { $this->aContentDocument = ChildContentDocumentQuery::create()->findPk($this->id, $con); /* The following can be used additionally to guarantee the related object contains a reference to this object. This level of coupling may, however, be undesirable since it could result in an only partially populated collection in the referenced object. $this->aContentDocument->addContentDocumentI18ns($this); */ } return $this->aContentDocument; }
/** * Performs an INSERT on the database, given a ContentDocument or Criteria object. * * @param mixed $criteria Criteria or ContentDocument object containing data that is used to create the INSERT statement. * @param ConnectionInterface $con the ConnectionInterface connection to use * @return mixed The new primary key. * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function doInsert($criteria, ConnectionInterface $con = null) { if (null === $con) { $con = Propel::getServiceContainer()->getWriteConnection(ContentDocumentTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from ContentDocument object } if ($criteria->containsKey(ContentDocumentTableMap::ID) && $criteria->keyContainsValue(ContentDocumentTableMap::ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . ContentDocumentTableMap::ID . ')'); } // Set the correct dbName $query = ContentDocumentQuery::create()->mergeWith($criteria); try { // use transaction because $criteria could contain info // for more than one table (I guess, conceivably) $con->beginTransaction(); $pk = $query->doInsert($con); $con->commit(); } catch (PropelException $e) { $con->rollBack(); throw $e; } return $pk; }