public function startAppAction() { $view = new ViewModel(['sql_connectors' => $this->getSqlConnectorsForClient(), 'dbal_connections' => array_values($this->dbalConnections->toArray())]); $view->setTemplate('prooph.link.sqlconnector/sql-manager/app'); $this->layout()->setVariable('includeRiotJs', true); return $view; }
private function saveConnections($checkFile = false) { $path = $this->configLocation->toString() . DIRECTORY_SEPARATOR . self::FILE_NAME; $config = ['prooph.link.sqlconnector' => ['connections' => $this->connections->toArray()]]; if ($checkFile && !file_exists($path)) { $this->configWriter->writeNewConfigToDirectory($config, $path); } else { $this->configWriter->replaceConfigInDirectory($config, $path); } }
protected function setUp() { $this->connection = DbalConnection::fromConfiguration(['driver' => 'pdo_sqlite', 'memory' => true, 'dbname' => 'test_db']); $testDataTable = new Table("test_data"); $testDataTable->addColumn("name", "string"); $testDataTable->addColumn("age", "integer"); $testDataTable->addColumn("created_at", "datetime"); $testDataTable->addColumn("price", "float"); $testDataTable->addColumn("active", "boolean"); $testDataTable->setPrimaryKey(["name"]); $this->connection->connection()->getSchemaManager()->createTable($testDataTable); $this->dataTypeLocation = ApplicationDataTypeLocation::fromPath(sys_get_temp_dir()); $this->commandBus = new CommandBusMock(); if (!is_dir(sys_get_temp_dir() . "/SqlConnector")) { mkdir(sys_get_temp_dir() . "/SqlConnector"); mkdir(sys_get_temp_dir() . "/SqlConnector/DataType"); } $connections = new DbalConnectionCollection(); $connections->add($this->connection); $this->tableConnectorGenerator = new TableConnectorGenerator($connections, $this->dataTypeLocation, ConfigLocation::fromPath(sys_get_temp_dir()), $this->commandBus, Bootstrap::getServiceManager()->get("config")['prooph.link.sqlconnector']['doctrine_processing_type_map']); }
public function updateConnector($id, array $connector, $regenerateType = false) { $this->assertConnector($connector); if (!$this->dbalConnections->containsKey($connector['dbal_connection'])) { throw new \InvalidArgumentException(sprintf("Dbal connection %s for connector %s does not exists", $connector['dbal_connection'], $connector['name'])); } $connection = $this->dbalConnections->get($connector['dbal_connection']); if ($regenerateType) { $generatedTypes = $this->replaceProcessingTypes($connection->config()['dbname'], $connector['table'], $connection->connection()); } else { $generatedTypes = $this->generateTypeClassFQCNs($connection->config()['dbname'], $connector['table']); } $connector['icon'] = self::ICON; $connector['ui_metadata_riot_tag'] = self::METADATA_UI_KEY; $connector['allowed_types'] = $generatedTypes; $connector['allowed_messages'] = [MessageNameUtils::COLLECT_DATA, MessageNameUtils::PROCESS_DATA]; $command = ChangeConnectorConfig::ofConnector($id, $connector, $this->configLocation); $this->commandBus->dispatch($command); }
/** * Create service * * @param ServiceLocatorInterface $serviceLocator * @return mixed */ public function createService(ServiceLocatorInterface $serviceLocator) { $appConfig = $serviceLocator->get('config'); return DbalConnectionCollection::fromConnectionConfigs($appConfig['prooph.link.sqlconnector']['connections']); }