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')); }