public static function setUpBeforeClass()
{
DatabaseService::configProfile(array('Product' => 'root', 'pass' => 'root'));
self::$_storagePath = __DIR__ . '/storage/';
DBOperator::getInstance()->dropDB(self::$_DBName)->createDB(self::$_DBName)->useDB(self::$_DBName);
FSService::unlinkRecursive(self::$_storagePath);
QC::executeSQL('SET FOREIGN_KEY_CHECKS = 0');
call_user_func(array(get_called_class(), 'putTestContent'));
}
public function setUp()
{
DatabaseService::configProfile(array('user' => 'root', 'pass' => 'root'));
$DBName = 'solve_test_database';
DBOperator::getInstance()->createDB($DBName)->useDB($DBName);
QC::executeSQL('DROP TABLE IF EXISTS users');
DBOperator::getInstance()->createTable('users', array('table' => 'users', 'columns' => array('id' => array('type' => 'int(11) unsigned', 'auto_increment' => true), 'position' => 'varchar(255)', 'age' => 'tinyint(1) unsigned', 'name' => 'varchar(255)'), 'indexes' => array('id' => array('type' => 'primary', 'columns' => 'id'))));
QC::executeSQL('TRUNCATE `users`');
}
public function onKernelReady(BaseEvent $event)
{
$this->onEnvironmentUpdate($event);
if ($webRoot = DC::getProjectConfig('webRoot')) {
DC::getEnvironment()->setWebRoot($webRoot);
}
$databaseConfig = DC::getDatabaseConfig();
$request = DC::getRouter()->getCurrentRequest();
if ($profiles = $databaseConfig->get('profiles')) {
foreach ($profiles as $profileName => $profileInfo) {
DatabaseService::configProfile($profileInfo, $profileName);
}
if (empty($request) || $request && !$request->isConsoleRequest()) {
ModelOperator::getInstance(DC::getEnvironment()->getUserClassesRoot() . 'db/');
if ($databaseConfig->get('autoUpdateAll')) {
ModelOperator::getInstance()->generateAllModelClasses()->updateDBForAllModels();
}
}
}
}
/**
* Created database for profile default
*/
public function createDbAction()
{
$config = DC::getDatabaseConfig('profiles/default');
DatabaseService::configProfile(array('user' => $config['user'], 'pass' => $config['pass']));
DBOperator::getInstance()->createDB($config['name']);
$this->notify($config['name'], '+Database created:');
}
/**
* @param mixed|QC $criteria
* @return Model
*/
protected function _loadOne($criteria)
{
/**
* @var QC $criteria
*/
if (is_object($criteria) && $criteria->getModifier('rawSelect')) {
$qc = $criteria;
} else {
$criteria = $this->_processCriteria($criteria);
$qc = QC::create($this->_tableName);
if (!empty($criteria)) {
if (is_object($criteria)) {
$qc->importQC($criteria);
}
$qc->and($criteria);
}
}
$this->_preLoad($qc);
$this->setOriginalData($qc->executeOne());
$this->unpackOriginalData();
$this->_postLoad();
if (empty($this->_data['id'])) {
return DatabaseService::getConfig('loadOneFails') == 'model' ? $this : null;
} else {
return $this;
}
}
public static function executeSQL($sql)
{
if (empty(self::$_staticAdapter)) {
self::$_staticAdapter = DatabaseService::getAdapter();
}
return self::$_staticAdapter->executeSQL($sql);
}
public static function setUpBeforeClass()
{
DatabaseService::configProfile(array('user' => 'root', 'pass' => 'root'));
}
