public function __construct($source)
{
parent::__construct($source);
$object = new AssociationType($this->getSource());
$object->loadBy('caption', 'dafault');
$this->associationType = $object;
$object = new ObjectType($this->getSource());
$object->loadBy('caption', 'default');
$this->objectType = $object;
}
<?php
use PMD\Capital\Configuration\DataSource;
use PMD\Capital\Module\Tag\Model\Tag;
use PMD\Capital\Model\ObjectType;
use PMD\Capital\Module\Tag\Model\Type;
use PMD\Capital\Module\Tag\Model\Association;
use PMD\Capital\Module\Tag\Model\AssociationType;
ini_set('memory_limit', '-1');
$oldModel = DataSource::get('old');
$newModel = DataSource::get('new');
$ezObjectType = new ObjectType($newModel);
$ezObjectType->loadBy('qname', 'ezobject');
$defaultAssociation = new AssociationType($newModel);
$defaultAssociation->loadBy('qname', 'default');
$query = "\n SELECT DISTINCT\n tag.keyword,\n association.object_id\n FROM eztags_attribute_link association\n JOIN eztags tag\n ON tag.id=association.keyword_id\n\n";
$rows = $oldModel->queryAndFetch($query);
$newModel->autocommit(false);
foreach ($rows as $row) {
$tag = new Tag($newModel);
$tag->loadBy('caption', $row['keyword']);
$association = new Association($newModel);
$association->setValue('tag_id', $tag->getId());
$association->setValue('object_id', $row['object_id']);
$association->setObjectType($ezObjectType);
$association->setType($defaultAssociation);
$association->insert();
echo $tag->getValue('caption') . "\t" . $row['object_id'] . "\n";
}
$newModel->commit();
//print_r($rows);
<?php
use PMD\Capital\Configuration\DataSource;
use PMD\Capital\Module\Tag\Model\Tag;
use PMD\Capital\Model\ObjectType;
use PMD\Capital\Module\Tag\Model\Type;
use PMD\Capital\Module\Tag\Model\Association;
use PMD\Capital\Module\Tag\Model\AssociationType;
$tagDataSource = DataSource::get('old');
//selection de toutes les relations pagehub/tag de l'ancien système
$query = "SELECT * FROM eztags";
$rows = $tagDataSource->queryAndFetch($query);
$relatedAssociation = new AssociationType('new');
$relatedAssociation->loadBy('qname', 'related');
$tagType = new ObjectType('new');
$tagType->loadBy('qname', 'tag');
foreach ($rows as $values) {
$query = "\n SELECT\n DISTINCT\n originTag.id as tagId,\n originTag.remote_id as pagehubId,\n originTag.keyword as fromKeyword,\n destinationTag.id as destinationId,\n destinationTag.keyword as destinationKeyword\n FROM eztags originTag\n JOIN eztags_attribute_link link\n ON link.object_id=originTag.remote_id\n JOIN eztags destinationTag\n ON destinationTag.id=link.keyword_id\n WHERE originTag.id=" . $values['id'] . "\n ";
$relationData = $tagDataSource->queryAndFetch($query);
if (!empty($relationData)) {
foreach ($relationData as $values) {
//récupération du tag d'origine dans la nouvelle bdd
$fromTag = new Tag('new');
$fromTag->loadBy('caption', $values['fromKeyword']);
$relatedTag = new Tag('new');
$relatedTag->loadBy('caption', $values['destinationKeyword']);
//récupération pour le related tag
if ($fromTag->getId() && $relatedTag->getId()) {
$association = new Association('new');
$association->setType($relatedAssociation);
$association->setObjectType($tagType);
<?php
use PMD\Capital\Configuration\DataSource;
use PMD\Capital\Module\Tag\Model\Tag;
use PMD\Capital\Model\ObjectType;
use PMD\Capital\Module\Tag\Model\Type;
use PMD\Capital\Module\Tag\Model\Association;
use PMD\Capital\Module\Tag\Model\AssociationType;
$tagDataSource = DataSource::get('new');
$tagDataSource->autocommit(false);
$rootObjectType = new ObjectType($tagDataSource);
$rootObjectType->loadBy('qname', 'default');
$rootObjectTypeId = $rootObjectType->getId();
echo "Create ezObject Object type\n";
$query = "\n INSERT INTO " . ObjectType::getTableName() . " (\n qname,\n caption,\n parent_id,\n datecreation\n ) VALUES (\n 'ezobject',\n 'Objet EzPublish',\n '" . $rootObjectTypeId . "',\n NOW()\n )\n";
$tagDataSource->query($query);
echo "Construction de l'arbre des types d'objet\n";
$tree = new ObjectType();
$tree->setSource($tagDataSource);
$tree->reset();
$tree->buildTree();
$contentTagType = new Type($tagDataSource);
$contentTagType->loadBy('qname', 'content');
echo "Create Company tag type\n";
$contentTagId = $contentTagType->getId();
$query = "\n INSERT INTO " . Type::getTableName() . " (\n parent_id,\n qname,\n caption,\n datecreation,\n data\n ) VALUES (\n " . $contentTagId . ",\n 'company',\n 'Entreprise',\n NOW(),\n '" . '{
"attributes": {
"isin": {
"caption" : "Code ISIN",
"mandatory": false,
"type": "text",
