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; }