/** * Test if extraction for "update" item works. */ public function testCreatingUpdateItem() { $category = 'product'; $id = 123; $timestamp = new \DateTime('-1 hour'); $diffItem = new UpdateDiffItem(); $diffItem->setCategory($category); $diffItem->setTimestamp($timestamp); $diffItem->setItemId($id); $this->storage->expects($this->once())->method('save')->with(ActionTypes::UPDATE, $category, $id, $timestamp); $this->service->extract($diffItem); }
/** * Test extraction service to insert updates to SyncStorage. * * @throws \Doctrine\DBAL\DBALException */ public function testExtract() { $container = $this->getServiceContainer(); /** @var \ONGR\ConnectionsBundle\Sync\Extractor\DoctrineExtractor $extractor */ $extractor = $container->get('ongr_connections.sync.extractor.doctrine_extractor'); // Populate database with schema and data. $this->importData('ExtractorTest/sample_db.sql'); // Get storage mock. /** @var SyncStorageInterface|\PHPUnit_Framework_MockObject_MockObject $dummySyncStorage */ $dummySyncStorage = $this->getMock('\\ONGR\\ConnectionsBundle\\Sync\\SyncStorage\\SyncStorageInterface'); $dummySyncStorage->expects($this->exactly(7))->method('save')->withConsecutive([ActionTypes::UPDATE, 'product', 'art0', $this->isInstanceOf('\\DateTime')], [ActionTypes::UPDATE, 'product', 'art1', $this->isInstanceOf('\\DateTime')], [ActionTypes::UPDATE, 'category', 'cat0', $this->isInstanceOf('\\DateTime')], [ActionTypes::UPDATE, 'product', 'art0', $this->isInstanceOf('\\DateTime')], [ActionTypes::UPDATE, 'product', 'art1', $this->isInstanceOf('\\DateTime')], [ActionTypes::UPDATE, 'product', 'art0', $this->isInstanceOf('\\DateTime')], [ActionTypes::UPDATE, 'product', 'art1', $this->isInstanceOf('\\DateTime')]); $extractor->setStorageFacility($dummySyncStorage); // Execute. // Should not make any save calls because Category CREATE action is turned off. $item = new CreateDiffItem(); $item->setCategory('oxcategories'); $item->setItem(['OXID' => 'cat0', 'OXTITLE' => 'Category']); $item->setTimestamp(new \DateTime()); $extractor->extract($item); // Should save 2 products but not category. $item = new UpdateDiffItem(); $item->setCategory('oxcategories'); $item->setItem(['OXID' => 'cat0', 'OXTITLE' => 'Category']); $item->setOldItem(['OXID' => 'cat0', 'OXTITLE' => 'Category']); $item->setTimestamp(new \DateTime()); $extractor->extract($item); // Should make 5 save calls. $item->setItem(['OXID' => 'cat0', 'OXTITLE' => 'CategoryNew']); $extractor->extract($item); }
/** * Test if extract is able to add data to the storage for item update action. */ public function testExtractForUpdateItem() { $category = 'product'; $id = 123; $timestamp = new DateTime('-1 hour 20 minutes'); $updateDiffItem = new UpdateDiffItem(); $updateDiffItem->setCategory($category); $updateDiffItem->setItemId($id); $updateDiffItem->setTimestamp($timestamp); $this->extractor->extract($updateDiffItem); foreach ($this->shopIds as $shopId) { $actual = (object) $this->getConnection()->fetchAssoc('SELECT * FROM ' . $this->storageManager->getTableName($shopId) . ' WHERE `type` = :operationType AND `document_type` = :documentType AND `document_id` = :documentId AND `status` = :status', ['operationType' => ActionTypes::UPDATE, 'documentType' => $category, 'documentId' => $id, 'status' => 0]); $this->assertTrue(!empty($actual->id)); $this->assertEquals(ActionTypes::UPDATE, $actual->type); $this->assertEquals($category, $actual->document_type); $this->assertEquals($id, $actual->document_id); $this->assertEquals($timestamp, new DateTime($actual->timestamp)); } }