/** * Akce pro ověření přihlášeného uživatele * @param string $dbType * @SWG\Get( * tags={"Databases"}, * path="/databases/{dbType}", * summary="Get user access credentials for MySQL and other databases", * produces={"application/json","application/xml"}, * security={{"apiKey":{}},{"apiKeyHeader":{}}}, * @SWG\Parameter( * name="dbType", * description="Type of database", * required=true, * type="string", * in="path", * enum={"limited","unlimited","mysql"} * ), * @SWG\Response( * response=200, * description="Connection params", * @SWG\Schema( * required={"server","username","password","database"}, * @SWG\Property(property="server",type="string",description="DB Server (IP or URL)"), * @SWG\Property(property="port",type="integer",description="DB server port (empty if default)"), * @SWG\Property(property="username",type="string",description="Database username"), * @SWG\Property(property="password",type="string",description="Database password"), * @SWG\Property(property="database",type="string",description="Database name"), * ) * ), * @SWG\Response( * response=400, * description="Invalid API key supplied", * @SWG\Schema(ref="#/definitions/StatusResponse") * ) * ) */ public function actionRead($dbType) { $this->setXmlMapperElements('database'); $dbType = strtolower($dbType); //kontrola toho, kdy byl naposled kontrolován přístup k DB if ($this->currentUser->getLastDbCheck($dbType) < time() - DatabaseFactory::DB_AVAILABILITY_CHECK_INTERVAL) { $this->currentUser->setLastDbCheck($dbType, time()); $this->usersFacade->saveUser($this->currentUser); //TODO tahle kontrola by ještě měla být optimalizovaná $dbAvailabilityCheck = true; } else { $dbAvailabilityCheck = false; } //připravení informací o datovém zdroji pro konkrétního uživatele... $datasource = $this->datasourcesFacade->prepareNewDatasourceForUser($dbType, $this->currentUser, !$dbAvailabilityCheck); $dbConnection = $datasource->getDbConnection(); #region sestavení data arr $result = []; if (!empty($dbConnection->dbServer)) { $result['server'] = $dbConnection->dbServer; } if (!empty($dbConnection->dbApi)) { $result['api'] = $dbConnection->dbApi; } if (!empty($dbConnection->dbPort)) { $result['port'] = $dbConnection->dbPort; } #endregion sestavení data arr $arr =& $result; if (!empty($datasource->dbUsername)) { $arr['username'] = $datasource->dbUsername; } $dbPassword = $datasource->getDbPassword(); if (!empty($dbPassword)) { $arr['password'] = $dbPassword; } if (!empty($datasource->dbName)) { $arr['database'] = $datasource->dbName; } $this->resource = $arr; $this->sendResource(); }
/** * Formulář pro import CSV souboru * @return Form */ public function createComponentImportCsvForm() { $form = new Form(); $form->setTranslator($this->translator); $tableName = $form->addText('table', 'Table name:')->setAttribute('class', 'normalWidth')->setRequired('Input table name!'); $presenter = $this; $tableName->addRule(Form::MAX_LENGTH, 'Max length of the table name is %s characters!', 30)->addRule(Form::MIN_LENGTH, 'Min length of the table name is %s characters!', 3)->addRule(Form::PATTERN, 'Table name can contain only letters, numbers and underscore and start with a letter!', '[a-zA-Z0-9_]+')->addRule(function (TextInput $control) use($presenter) { $formValues = $control->form->getValues(true); $csvColumnsCount = $presenter->fileImportsFacade->getColsCountInCSV($formValues['file'], $formValues['separator'], $formValues['enclosure'], $formValues['escape']); $databaseType = $presenter->databasesFacade->prefferedDatabaseType($csvColumnsCount); $newDatasource = $presenter->datasourcesFacade->prepareNewDatasourceForUser($this->usersFacade->findUser($presenter->user->id), $databaseType); $presenter->databasesFacade->openDatabase($newDatasource->getDbConnection()); return !$presenter->databasesFacade->checkTableExists($control->value); }, 'Table with this name already exists!'); $form->addSelect('separator', 'Separator:', array(',' => 'Comma (,)', ';' => 'Semicolon (;)', '|' => 'Vertical line (|)', '\\t' => 'Tab (\\t)'))->setRequired()->setAttribute('class', 'normalWidth'); $form->addSelect('encoding', 'Encoding:', array('utf8' => 'UTF-8', 'cp1250' => 'WIN 1250', 'iso-8859-1' => 'ISO 8859-1'))->setRequired()->setAttribute('class', 'normalWidth'); $file = $form->addHidden('file'); $file->setAttribute('id', 'frm-importCsvForm-file'); $form->addHidden('type'); $form->addText('enclosure', 'Enclosure:', 1, 1)->setDefaultValue('"'); $form->addText('escape', 'Escape:', 1, 1)->setDefaultValue('\\'); $nullValuesArr = CsvImport::getDefaultNullValuesArr(); $defaultNullValue = 'none'; foreach ($nullValuesArr as $value => $text) { $defaultNullValue = $value; break; } $form->addSelect('nullValue', 'Null values:', array_merge(['none' => '--none--'], $nullValuesArr))->setAttribute('title', 'This value will be imported as missing (null).')->setDefaultValue($defaultNullValue)->setAttribute('class', 'normalWidth'); $form->addSubmit('submit', 'Import data into database...')->onClick[] = function (SubmitButton $submitButton) { /** @var Form $form */ $form = $submitButton->form; $values = $form->getValues(); $nullValue = $values->nullValue == 'none' ? null : $values->nullValue; $user = $this->usersFacade->findUser($this->user->id); $colsCount = $this->fileImportsFacade->getColsCountInCSV($values->file, $values->separator, $values->enclosure, $values->escape); $dbType = $this->databasesFacade->prefferedDatabaseType($colsCount); //připravení připojení k DB $datasource = $this->datasourcesFacade->prepareNewDatasourceForUser($user, $dbType); $this->fileImportsFacade->importCsvFile($values->file, $datasource->getDbConnection(), $values->table, $values->encoding, $values->separator, $values->enclosure, $values->escape, $nullValue); $datasource->name = $values->table; //uložíme datasource $this->datasourcesFacade->saveDatasource($datasource); //smažeme dočasné soubory... $this->fileImportsFacade->deleteFile($values->file); $this->redirect('Data:newMinerFromDatasource', array('datasource' => $datasource->datasourceId)); }; $form->addSubmit('storno', 'storno')->setValidationScope([])->onClick[] = function (SubmitButton $button) use($file) { /** @var DataPresenter $presenter */ $presenter = $button->form->getParent(); $this->fileImportsFacade->deleteFile($file->value); $presenter->redirect('Data:newMiner'); }; return $form; }