*
* 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();