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