/**
* Generate database documentation
*
* @access public
* @return Response
*/
public function action_generate()
{
$this->template->active = 'generate';
$data = array();
if (Input::method() === 'POST') {
/**
* get Fieldset instance
*/
$platform = Input::post('platform');
$fieldset = static::_get_form($platform);
/**
* validation
*/
$validation = $fieldset->validation();
if ($validation->run(Input::post())) {
$config = $validated = $validation->validated();
Arr::delete($config, 'platform');
Arr::delete($config, 'name');
Arr::delete($config, 'submit');
Arr::delete($config, Config::get('security.csrf_token_key'));
/**
* directory
*/
$dir = DOCROOT . 'dbdocs' . DS . $validated['name'] . DS . 'dbdoc' . DS;
/**
* generate
*/
$dd = Dbdocs::forge('default', $config);
try {
$ret = $dd->generate($dir, true);
if ($ret !== true) {
Session::set_flash('error', 'System error occurred.');
}
Session::set_flash('success', 'Generated database documentation "' . $validated['name'] . '" !!');
} catch (Exception $e) {
Session::set_flash('error', 'System error occurred.');
}
Response::redirect();
} else {
$validated = $validation->validated();
$data['platform'] = $platform;
Arr::delete($validated, Config::get('security.csrf_token_key'));
$data['form'] = $fieldset->populate($validated);
$this->template->content = View::forge('index/generate', array('data' => $data));
Session::set_flash('error', $validation->error());
}
} else {
$this->template->content = View::forge('index/generate', array('data' => $data));
}
}
/**
* Generate process
*/
private static function process()
{
/**
* interactive mode?
*/
if (\Cli::option('n', false) or \Cli::option('non-interactive', false)) {
/**
* option values into config
*/
foreach (static::$config as $k => &$v) {
if ($k != 'driver') {
$v = \Cli::option($k);
}
}
} else {
/**
* enter values into config
*/
static::prompt();
static::confirm();
}
/**
* generate documentation
*/
$dd = \Dbdocs::forge('default', static::$config);
$ret = $dd->generate(static::$dir, \Cli::option('f') or \Cli::option('force'));
if ($ret === true) {
\Cli::write('Generated MySQL Documentation in "' . static::$dir . '"', 'green');
} else {
if (is_string($ret)) {
\Cli::write($ret, 'red');
} else {
\Cli::write('System error occurred.', 'red');
}
}
}
/**
* Test for Dbdocs::forge()
*/
public function test_forge()
{
static::$dd = Dbdocs::forge(\Str::random('unique'), static::$config);
$this->assertTrue(static::$dd instanceof Dbdocs);
}
public static function setUpBeforeClass()
{
parent::setUpBeforeClass();
/**
* get config
*/
if (isset($_SERVER['TRAVIS_DB'])) {
static::$config = static::$travis_dbs[$_SERVER['TRAVIS_DB']];
} else {
static::$config = (include APPPATH . 'config' . DS . \Fuel::DEVELOPMENT . DS . 'dbdocs.php');
static::$config = \Arr::get(static::$config, 'test_config.db');
}
/**
* connect to db
*/
static::$dd = Dbdocs::forge('default', static::$config);
/**
* drop views
*/
krsort(static::$test_views);
foreach (static::$test_views as $test_view_name => $sql) {
try {
//TODO: check view exist
static::$dd->sm->dropView($test_view_name);
} catch (\Doctrine\DBAL\DBALException $e) {
//do nothing
}
}
/**
* drop tables
*/
krsort(static::$test_tables);
foreach (static::$test_tables as $test_table_name => $infos) {
static::$dd->sm->tablesExist($test_table_name) and static::$dd->sm->dropTable($test_table_name);
}
/**
* create tables
*/
ksort(static::$test_tables);
foreach (static::$test_tables as $test_table_name => $infos) {
$table = new \Doctrine\DBAL\Schema\Table($test_table_name);
foreach ($infos['columns'] as $column) {
empty($column['options']) and $column['options'] = array();
$table->addColumn($column['name'], $column['type'], $column['options']);
}
$table->setPrimaryKey($infos['primary_keys']);
if (!empty($infos['foreign_keys'])) {
foreach ($infos['foreign_keys'] as $foreign_key) {
list($to_table_name, $to_column_name) = explode(".", $foreign_key['to']);
$table->addForeignKeyConstraint($to_table_name, array($foreign_key['from']), array($to_column_name));
}
}
static::$dd->sm->createTable($table);
}
/**
* create views
*/
ksort(static::$test_views);
foreach (static::$test_views as $test_view_name => $sql) {
$view = new \Doctrine\DBAL\Schema\View($test_view_name, $sql);
static::$dd->sm->createView($view);
}
}
