public function delete(FolderDeleteEvent $event, $eventName, EventDispatcherInterface $dispatcher) { if (null !== ($folder = FolderQuery::create()->findPk($event->getFolderId()))) { $con = Propel::getWriteConnection(FolderTableMap::DATABASE_NAME); $con->beginTransaction(); try { $fileList = ['images' => [], 'documentList' => []]; // Get folder's files to delete after folder deletion $fileList['images']['list'] = FolderImageQuery::create()->findByFolderId($event->getFolderId()); $fileList['images']['type'] = TheliaEvents::IMAGE_DELETE; $fileList['documentList']['list'] = FolderDocumentQuery::create()->findByFolderId($event->getFolderId()); $fileList['documentList']['type'] = TheliaEvents::DOCUMENT_DELETE; // Delete folder $folder->setDispatcher($dispatcher)->delete($con); $event->setFolder($folder); // Dispatch delete folder'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; } } }
public function preImport() { // Delete table before proceeding ContentQuery::create()->deleteAll(); FolderQuery::create()->deleteAll(); FolderImageQuery::create()->deleteAll(); FolderDocumentQuery::create()->deleteAll(); // Create T1 <-> T2 IDs correspondance tables $this->fld_corresp->reset(); }
public function testQueryImages() { $data = $this->handler->setImageExport(true)->buildData($this->lang)->getData(); $max = count($data); if ($max > 50) { $max = 50; } for ($i = 0; $i < $max; ++$i) { $images = ContentImageQuery::create()->filterByContentId($data[$i]["id"])->select(ContentImageTableMap::FILE)->find()->toArray(); $imagesString = implode(",", $images); if (empty($data[$i]["content_images"])) { $j = 1; while ($data[$i - $j]["id"] === $data[$i]["id"]) { if (!empty($data[$i - $j++]["content_images"])) { $data[$i]["content_images"] = $data[$i - $j + 1]["content_images"]; break; } } } $this->assertEquals($imagesString, $data[$i]["content_images"]); $folderImages = FolderImageQuery::create()->useFolderQuery()->useContentFolderQuery()->filterByContentId($data[$i]["id"])->filterByFolderId($data[$i]["folder_id"])->endUse()->endUse()->select(FolderImageTableMap::FILE)->find()->toArray(); $folderImages = implode(",", $folderImages); $this->assertEquals($folderImages, $data[$i]["folder_images"]); } }
/** * Performs an INSERT on the database, given a FolderImage or Criteria object. * * @param mixed $criteria Criteria or FolderImage 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(FolderImageTableMap::DATABASE_NAME); } if ($criteria instanceof Criteria) { $criteria = clone $criteria; // rename for clarity } else { $criteria = $criteria->buildCriteria(); // build Criteria from FolderImage object } if ($criteria->containsKey(FolderImageTableMap::ID) && $criteria->keyContainsValue(FolderImageTableMap::ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . FolderImageTableMap::ID . ')'); } // Set the correct dbName $query = FolderImageQuery::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; }
/** * @return array * * return an array with the paths to the images to include in the archive */ public function getImagesPaths() { $imagePaths = []; $folderImages = FolderImageQuery::create()->find(); /** @var \Thelia\Model\FolderDocument $folderImage */ foreach ($folderImages as $folderImage) { $this->addFileToArray($folderImage, $imagePaths); } $contentImages = ContentImageQuery::create()->find(); /** @var \Thelia\Model\ContentImage $contentImage */ foreach ($contentImages as $contentImage) { $this->addFileToArray($contentImage, $imagePaths); } return $imagePaths; }
Model\ProductQuery::create()->deleteAll(); Model\ProductI18nQuery::create()->deleteAll(); Model\CustomerQuery::create()->deleteAll(); Model\AdminQuery::create()->deleteAll(); Model\FolderQuery::create()->deleteAll(); Model\FolderI18nQuery::create()->deleteAll(); 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";
/** * Removes this object from datastore and sets delete attribute. * * @param ConnectionInterface $con * @return void * @throws PropelException * @see FolderImage::setDeleted() * @see FolderImage::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(FolderImageTableMap::DATABASE_NAME); } $con->beginTransaction(); try { $deleteQuery = ChildFolderImageQuery::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; } }
$content->delete(); $content = Thelia\Model\ContentI18nQuery::create()->find(); $content->delete(); $accessory = Thelia\Model\AccessoryQuery::create()->find(); $accessory->delete(); $stock = \Thelia\Model\ProductSaleElementsQuery::create()->find(); $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";
/** * Returns the number of related FolderImage objects. * * @param Criteria $criteria * @param boolean $distinct * @param ConnectionInterface $con * @return int Count of related FolderImage objects. * @throws PropelException */ public function countFolderImages(Criteria $criteria = null, $distinct = false, ConnectionInterface $con = null) { $partial = $this->collFolderImagesPartial && !$this->isNew(); if (null === $this->collFolderImages || null !== $criteria || $partial) { if ($this->isNew() && null === $this->collFolderImages) { return 0; } if ($partial && !$criteria) { return count($this->getFolderImages()); } $query = ChildFolderImageQuery::create(null, $criteria); if ($distinct) { $query->distinct(); } return $query->filterByFolder($this)->count($con); } return count($this->collFolderImages); }
public function testSearchByFolderId() { $image = FolderImageQuery::create()->findOne(); $this->baseTestSearchById($image->getId(), array('source' => 'folder')); }
/** * Get the associated ChildFolderImage object * * @param ConnectionInterface $con Optional Connection object. * @return ChildFolderImage The associated ChildFolderImage object. * @throws PropelException */ public function getFolderImage(ConnectionInterface $con = null) { if ($this->aFolderImage === null && $this->id !== null) { $this->aFolderImage = ChildFolderImageQuery::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->aFolderImage->addFolderImageI18ns($this); */ } return $this->aFolderImage; }