addOptions(array( new sfCommandOption('application', null, sfCommandOption::PARAMETER_REQUIRED, 'The application name'), new sfCommandOption('env', null, sfCommandOption::PARAMETER_REQUIRED, 'The environment', 'dev'), new sfCommandOption('connection', null, sfCommandOption::PARAMETER_REQUIRED, 'The connection name', 'doctrine'), )); $this->namespace = ''; $this->name = 'UpgradeLeaveModule'; $this->briefDescription = 'This task will upgrade leave related database tables'; $this->detailedDescription = <<configuration); $pdo = $databaseManager->getDatabase(isset($options['connection']) ? $options['connection'] : null)->getConnection(); try { $sqlString = file_get_contents(sfConfig::get('sf_plugins_dir') . DIRECTORY_SEPARATOR . 'orangehrmLeavePlugin' . DIRECTORY_SEPARATOR .'install'. DIRECTORY_SEPARATOR . 'upgrade.sql'); $queries = explode(';', $sqlString); foreach ($queries as $query) { $pdo->exec($query); } } catch (Exception $e) { return "
Exception: Tables already created or SQL error \n "; } } }