protected function getComposite()
{
$event = $this->getMockBuilder('Symfony\\Component\\EventDispatcher\\EventDispatcherInterface')->getMock();
$schema = new SchemaNode('schema', $event);
$formatter = $this->getMockBuilder('Faker\\Tests\\Engine\\Common\\Formatter\\Mock\\MockFormatter')->disableOriginalConstructor()->getMock();
$tableA = new TableNode('tableA', $event);
$columnA1 = new ColumnNode('columnA1', $event);
$columnA2 = new ColumnNode('columnA2', $event);
$tableB = new TableNode('tableB', $event);
$columnB1 = new ColumnNode('columnB1', $event);
$columnB2 = new ColumnNode('columnB2', $event);
$tableC = new TableNode('tableC', $event);
$columnC1 = new ColumnNode('columnC1', $event);
$columnC2 = new ColumnNode('columnC2', $event);
$fkc1 = new ForeignKeyNode('fkc1', $event);
$fmNode = new FormatterNode('fmnode', $event, $formatter);
$fkc1->setOption('foreignTable', $tableA->getId());
$fkc1->setOption('foreignColumn', $columnA1->getId());
$columnC2->addChild($fkc1);
$tableC->addChild($columnC1);
$tableC->addChild($columnC2);
$tableB->addChild($columnB1);
$tableB->addChild($columnB2);
$tableA->addChild($columnA1);
$tableA->addChild($columnA2);
$schema->addChild($tableA);
$schema->addChild($tableB);
$schema->addChild($tableC);
$schema->addChild($fmNode);
return $schema;
}
public function testValidationOk()
{
$id = 'fk_table_1';
$event = $this->getMockBuilder('Symfony\\Component\\EventDispatcher\\EventDispatcherInterface')->getMock();
$node = new ForeignKeyNode($id, $event);
$node->setOption('name', 'fk1');
$node->setOption('locale', 'en');
$node->setOption('foreignColumn', 'mykey');
$node->setOption('foreignTable', 'mytable');
$node->validate();
$this->assertTrue(true);
}
public function addForeignKey($name, array $options = array())
{
# merge options with default
$options = array_merge(array('foreignColumn' => null, 'foreignTable' => null), $options);
# schema and table exist
if (!$this->head instanceof ColumnNode) {
throw new EngineException('Can not add a Foreign-Key without first setting a column');
}
if (empty($name)) {
throw new EngineException('Foreign-key must have a name unique name try foreignTable.foriegnColumn');
}
if (isset($options['name']) === false) {
$options['name'] = $name;
}
# create new column
$foreignKey = new ForeignKeyNode($name, $this->eventDispatcher);
# set the options
foreach ($options as $optionKey => $optionValue) {
$foreignKey->setOption($optionKey, $optionValue);
}
# add the column to the table
$this->head->addChild($foreignKey);
$this->head = $foreignKey;
return $this;
}