<?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);
