function testExecuteUsingDefaultConnection()
{
$this->toolkit->setDefaultDbConnection($this->conn);
$this->conn->expectOnce('execute', array($sql = 'SELECT 1=1'));
lmbDBAL::execute('SELECT 1=1');
}
protected function _createRootElementIfNotExists()
{
if (!($root = lmbDBAL::fetchOneRow('SELECT * FROM ' . $this->_table->getName()))) {
lmbDBAL::execute('INSERT INTO ' . $this->_table->getName() . ' (parent_id, level, priority, is_published, path, identifier, ctime, utime) VALUES (0,0,0,0,\'/1/\',\'\',0,0)');
}
}
/**
* @desc create db by specified DSN
* @deps project_db_init_config
* @example project.php create_db -D DSN=mysqli://root:test@localhost/limb_app?charset=utf8
*/
function task_project_db_create($args)
{
lmb_package_require('dbal');
lmb_require('limb/dbal/src/lmbDbDSN.class.php');
$code = <<<EOD
\$toolkit = lmbToolkit :: instance();
echo \$toolkit->getDefaultDbDSN()->toString();
EOD;
$output = lmb_cli_run_code_in_project_env($code);
$dsn = new lmbDbDSN($output);
$db_name = $dsn->database;
$dsn->database = false;
$conn = lmbToolkit::instance()->createDbConnection($dsn);
lmbDBAL::execute('CREATE DATABASE ' . $conn->quoteIdentifier($db_name), $conn);
taskman_msg("Database ({$db_name}) created...\n");
}
protected function _changeItemsPriority($model, $where_field, $where_field_value)
{
$priority_items = $this->request->get('priority_items');
$info_item = new $model();
$sql = 'SELECT id, priority FROM ' . $info_item->getTableName() . ' WHERE ' . $where_field . '=' . $where_field_value;
$current_priorities_object = lmbDBAL::fetch($sql);
$current_priorities_object = $current_priorities_object->getArray();
$current_priorities = array();
foreach ($current_priorities_object as $item) {
$current_priorities[$item->get('id')] = $item->get('priority');
}
foreach ($priority_items as $id => $priority) {
$current_priorities[$id] = $priority;
}
asort($current_priorities);
$i = 10;
$table_name = $info_item->getTableName();
foreach ($current_priorities as $id => $priority) {
$sql = "UPDATE " . $table_name . " SET priority='" . $i . "' WHERE id='" . $id . "'";
lmbDBAL::execute($sql);
$i += 10;
}
}
