*
 * Arguments:
 *      db      The database namespace defined in $lc_databases of config.php [default: "default"]
 *
 * @package     PHPLucidFrame\Console
 * @since       PHPLucidFrame v 1.14.0
 * @copyright   Copyright (c), PHPLucidFrame.
 * @author      Sithu K. <*****@*****.**>
 * @link        http://phplucidframe.com
 * @license     http://www.opensource.org/licenses/mit-license.php MIT License
 *
 * This source file is subject to the MIT license that is bundled
 * with this source code in the file LICENSE
 */
use LucidFrame\Core\SchemaManager;
_consoleCommand('schema:export')->setDescription('Process the schema and export the database sql dump file')->addArgument('db', 'The database namespace defined in $lc_databases of config.php', 'default')->setDefinition(function (\LucidFrame\Console\Command $cmd) {
    $db = $cmd->getArgument('db');
    $schema = _schema($db);
    if ($schema === null) {
        _writeln('Failed to load schema.');
    } elseif ($schema === false) {
        _writeln('Unable to find the schema file "%s".', DB . 'schema.' . $db . '.php');
    } else {
        $sm = new SchemaManager($schema);
        if ($sm->export($db)) {
            _writeln('"%s" has been exported.', DB . 'generated' . _DS_ . 'schema.' . $db . '.sql');
        } else {
            _writeln('No sql file is exported.');
        }
    }
})->register();
 * @package     PHPLucidFrame\Console
 * @since       PHPLucidFrame v 1.14.0
 * @copyright   Copyright (c), PHPLucidFrame.
 * @author      Sithu K. <*****@*****.**>
 * @link        http://phplucidframe.com
 * @license     http://www.opensource.org/licenses/mit-license.php MIT License
 *
 * This source file is subject to the MIT license that is bundled
 * with this source code in the file LICENSE
 */
use LucidFrame\Core\SchemaManager;
_consoleCommand('schema:load')->setDescription('Process the schema and import the database')->addArgument('db', 'The database namespace defined in $lc_databases of config.php', 'default')->setDefinition(function (\LucidFrame\Console\Command $cmd) {
    $db = $cmd->getArgument('db');
    $schema = _schema($db);
    if ($schema === null) {
        _writeln('Failed to load schema.');
    } elseif ($schema === false) {
        _writeln('Unable to find the schema file "%s".', DB . 'schema.' . $db . '.php');
    } else {
        if ($cmd->confirm('The database will be purged. Type "y" or "yes" to continue:')) {
            $sm = new SchemaManager($schema);
            if ($sm->import($db)) {
                _writeln('Schema is successfully loaded. The database for "%s" has been imported.', $db);
            } else {
                _writeln('No schema is loaded.');
            }
        } else {
            _writeln('Aborted.');
        }
    }
})->register();
 *
 * Arguments:
 *      db      The database namespace defined in $lc_databases of config.php [default: "default"]
 *
 * @package     PHPLucidFrame\Console
 * @since       PHPLucidFrame v 1.16.0
 * @copyright   Copyright (c), PHPLucidFrame.
 * @author      Sithu K. <*****@*****.**>
 * @link        http://phplucidframe.com
 * @license     http://www.opensource.org/licenses/mit-license.php MIT License
 *
 * This source file is subject to the MIT license that is bundled
 * with this source code in the file LICENSE
 */
use LucidFrame\Core\SchemaManager;
_consoleCommand('schema:build')->setDescription('Build the schema in /db/build/')->addArgument('db', 'The database namespace defined in $lc_databases of config.php', 'default')->setDefinition(function (\LucidFrame\Console\Command $cmd) {
    $db = $cmd->getArgument('db');
    $schema = _schema($db);
    if ($schema === null) {
        _writeln('Failed to load schema.');
    } elseif ($schema === false) {
        _writeln('Unable to find the schema file "%s".', DB . 'schema.' . $db . '.php');
    } else {
        $sm = new SchemaManager($schema);
        if ($sm->build($db)) {
            _writeln('The schema has been build at "db/build/schema.%s.inc".', $db);
        } else {
            _writeln('No schema is loaded.');
        }
    }
})->register();