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