Sets the default Zend_Db_Adapter_Abstract for all Zend_Db_Table objects.
public static setDefaultAdapter ( mixed $db = null ) : void | ||
$db | mixed | Either an Adapter object, or a string naming a Registry key |
리턴 | void |
/** * @todo expireSessionCookie() * @todo rememberMe(xx) * @todo forgetMe() * @see Zend_Registry::get('session'); * @return Zend_Session_Namespace */ protected function _initSession() { $options = $this->getOption('ca_mgr'); $db = Zend_Db::factory($options['db']['session']['pdo'], $options['db']['session']); /** * automatically clean up expired session entries from session cache * use the modified and lifetime stamps to calculate expire time */ if ($options['db']['session']['autocleanup'] == '1') { $stmt = $db->query('delete from front_session where (modified + lifetime * 2) < unix_timestamp()'); # $stmt->execute(); } //you can either set the Zend_Db_Table default adapter //or you can pass the db connection straight to the save handler $config // @see lifetimeColumn / lifetime / overrideLifetime, lifetime defaults to php.ini: session.gc_maxlifetime Zend_Db_Table_Abstract::setDefaultAdapter($db); $config = array('name' => 'front_session', 'primary' => 'id', 'modifiedColumn' => 'modified', 'dataColumn' => 'data', 'lifetimeColumn' => 'lifetime'); //create your Zend_Session_SaveHandler_DbTable and //set the save handler for Zend_Session Zend_Session::setSaveHandler(new Zend_Session_SaveHandler_DbTable($config)); // Zend_Session::rememberMe(7200); //start your session! Zend_Session::start(); $session = new Zend_Session_Namespace(); if (!isset($session->started)) { $session->started = time(); } if (!isset($session->authdata)) { $session->authdata = array('authed' => false); } Zend_Registry::set('session', $session); return $session; }
/** * Inicializa a conexão com o banco de dados * Usa o Zend_Cache para o metadata das tabelas * * @uses Zend_Cache */ protected function _initDB() { // Configura a conexão com o BD $config = new Zend_Config($this->getOptions()); $db = Zend_Db::factory($config->resources->db); Zend_Db_Table_Abstract::setDefaultAdapter($db); }
/** * Store the db adapter in the registry * and set the default one for the mappers * * @return Zend_Db_Adapter_Abstract */ protected function _initDb() { $db = $this->getPluginResource('db')->getDbAdapter(); Zend_Registry::set('db', $db); Zend_Db_Table_Abstract::setDefaultAdapter($db); return $db; }
protected function _initDb() { $config = Zend_Registry::get('config'); $options = $config->mtb->db->params; $db = Zend_Db::factory('PDO_MYSQL', $options); Zend_Db_Table_Abstract::setDefaultAdapter($db); }
/** * Cleans up the environment after running a test. */ protected function tearDown() { $this->Feeds = null; // restore the old default db Zend_Db_Table_Abstract::setDefaultAdapter($this->oldDefaultDb); parent::tearDown(); }
public function run() { // Lade Konfig $config = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini', APPLICATION_ENV); Zend_Registry::set('config', $config); // Erstelle DB Adapter $db = Zend_Db::factory($config->db); Zend_Registry::set('db', $db); Zend_Db_Table_Abstract::setDefaultAdapter(Zend_Registry::get('db')); if (APPLICATION_ENV !== 'production') { $profiler = new Zend_Db_Profiler_Firebug('All Database Queries:'); $profiler->setEnabled(true); $db->setProfiler($profiler); } $resourceLoader = new Zend_Loader_Autoloader_Resource(array('basePath' => APPLICATION_PATH, 'namespace' => '')); $resourceLoader->addResourceType('plugins', 'plugins', 'Plugins'); if (PHP_SAPI != 'cli') { $front = Zend_Controller_Front::getInstance(); $front->registerPlugin(new Plugins_Stats()); if (APPLICATION_ENV == 'production') { $front->registerPlugin(new Plugins_Cache()); } } Zend_View_Helper_PaginationControl::setDefaultViewPartial('_partials/controls.phtml'); parent::run(); }
public static function setDbAdapter() { $cnf = Zend_Registry::get('cnf'); $db = Zend_Db::factory($cnf->db); Zend_Db_Table_Abstract::setDefaultAdapter($db); Zend_Registry::set('db', $db); }
public function dispatchLoopStartup(Zend_Controller_Request_Abstract $request) { $auth = Zend_Auth::getInstance(); $result = $auth->getStorage(); $identity = $auth->getIdentity(); $registry = Zend_Registry::getInstance(); $config = Zend_Registry::get('config'); $module = strtolower($this->_request->getModuleName()); $controller = strtolower($this->_request->getControllerName()); $action = strtolower($this->_request->getActionName()); if ($identity && $identity != "") { $layout = Zend_Layout::getMvcInstance(); $view = $layout->getView(); $view->login = $identity; $siteInfoNamespace = new Zend_Session_Namespace('siteInfoNamespace'); $id = $siteInfoNamespace->userId; $view->firstname = $siteInfoNamespace->Firstname; $username = $siteInfoNamespace->username; $password = $siteInfoNamespace->password; $db = new Zend_Db_Adapter_Pdo_Mysql(array('host' => $config->resources->db->params->host, 'username' => $username, 'password' => $password, 'dbname' => $config->resources->db->params->dbname)); Zend_Db_Table_Abstract::setDefaultAdapter($db); return; } else { $siteInfoNamespace = new Zend_Session_Namespace('siteInfoNamespace'); $siteInfoNamespace->requestURL = $this->_request->getParams(); $this->_request->setModuleName('default'); $this->_request->setControllerName('Auth'); $this->_request->setActionName('login'); } }
public function routeShutdown(Zend_Controller_Request_Abstract $request) { $useModule = array('default', 'mice'); if (in_array($request->getModuleName(), $useModule) and $this->getRequest()->getParam('language') != 'scripts') { Zend_Db_Table_Abstract::setDefaultAdapter(Zend_Registry::get('read')); } else { Zend_Db_Table_Abstract::setDefaultAdapter(Zend_Registry::get('write')); } if (in_array($request->getModuleName(), $useModule) and $this->getRequest()->getParam('language') != 'scripts') { $language = $this->getRequest()->getParam('language'); if (empty($language)) { $language = 'id'; } // Model $dictionaryDb = new Model_DbTable_Dictionary(); $languageDb = new Model_DbTable_Language(); // Data $dictionary = $dictionaryDb->getDictionaryArray($language); $languageId = $languageDb->getIdByName($language); try { // Translator Zend $translate = new Zend_Translate('array', $dictionary, $language); // Set registry Zend_Registry::set('Zend_Translate', $translate); Zend_Registry::set('language', $language); Zend_Registry::set('languageId', $languageId['language_id']); Zend_Registry::set('languageText', $languageId['language_text']); } catch (Zend_Translate_Exception $zte) { } catch (Zend_Exception $ze) { } } }
public function testAction() { $time_start = microtime(true); $params = array('host' => '127.0.0.1', 'username' => 'root', 'password' => 'root', 'dbname' => 'langithp'); $db = Zend_Db::factory('PDO_MYSQL', $params); Zend_Db_Table_Abstract::setDefaultAdapter($db); require_once '/Users/n/Documents/Work/Zend/kutump/test/CatalogAttribute.php'; $tbl = new CatalogAttribute(); $rows = $tbl->fetchAll(); $num = count($rows); echo "<b><center>Database Output</center></b><br><br>"; $i = 0; for ($i = 0; $i < $num; $i++) { //$tmpGuid = mysql_result($result,$i,"guid"); $row = $rows->current(); $tmpGuid = $row->title; echo '<br>' . $tmpGuid; echo '<br>' . $i; $rows->next(); //$i++; } $dbh = null; echo '<br>Total: ' . $i; $time_end = microtime(true); $time = $time_end - $time_start; echo '<br>WAKTU EKSEKUSI: ' . $time; //die('hiho'); }
function __construct() { $options = array('host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'zendcastdev'); $this->db = Zend_Db::factory('PDO_MYSQL', $options); Zend_Db_Table_Abstract::setDefaultAdapter($this->db); $this->users = new UsersTable(); }
/** * Initizlize Zend DB */ function init_zend_db() { try { include APPPATH . 'config' . DIRECTORY_SEPARATOR . 'database.php'; $__dbParams = array('host' => $db[$active_group]['hostname'], 'username' => $db[$active_group]['username'], 'password' => $db[$active_group]['password'], 'dbname' => $db[$active_group]['database'], 'persistent' => $db[$active_group]['pconnect']); $__db = Zend_Db::factory('PDO_MYSQL', $__dbParams); include APPPATH . 'config/cache.php'; $feEngine = $config['dbschema_frontend_engine']; $feOptions = $config['dbschema_frontend']; $beEngine = $config['dbschema_backend_engine']; $beOptions = $config['dbschema_backend']; if (isset($beOptions['cache_dir']) && !file_exists($beOptions['cache_dir'])) { mkdir($beOptions['cache_dir']); chmod($beOptions['cache_dir'], 0777); } // var_dump($beOptions['cache_dir']); $cache = Zend_Cache::factory($feEngine, $beEngine, $feOptions, $beOptions); Zend_Db_Table_Abstract::setDefaultMetadataCache($cache); Zend_Db_Table_Abstract::setDefaultAdapter($__db); Profiler::start($db[$active_group], $__db); $__db->query('SET NAMES ' . $db['default']['char_set']); $__db->query('SET SQL_MODE = "NO_UNSIGNED_SUBTRACTION"'); } catch (Exception $e) { header("HTTP/1.1 500 Internal Server Error (DB)"); echo $e->getMessage(); exit; } }
public function __construct() { //set country //lookup country from subdomain // must be format like http://country.site.org $parts = explode('.', $_SERVER['HTTP_HOST']); self::$COUNTRY = $parts[0]; require_once 'settings.php'; $countryLoaded = false; if ($parts[1] == 'trainingdata') { Settings::$DB_DATABASE = Globals::$DB_TABLE_PREFIX . $parts[0]; self::$COUNTRY = $parts[0]; Settings::$COUNTRY_BASE_URL = 'http://' . $parts[0] . '.' . Globals::$DOMAIN; $countryLoaded = true; } error_reporting(E_ALL); // PATH_SEPARATOR = ; for windows, : for *nix $iReturn = ini_set('include_path', Globals::$BASE_PATH . PATH_SEPARATOR . Globals::$BASE_PATH . 'app' . PATH_SEPARATOR . (Globals::$BASE_PATH . 'ZendFramework' . DIRECTORY_SEPARATOR . 'library') . PATH_SEPARATOR . ini_get('include_path')); require_once 'Zend/Loader.php'; if ($countryLoaded) { //fixes mysterious configuration issue require_once 'Zend/Db/Adapter/Pdo/Mysql.php'; require_once 'Zend/Db.php'; //set a default database adaptor $db = Zend_Db::factory('PDO_MYSQL', array('host' => Settings::$DB_SERVER, 'username' => Settings::$DB_USERNAME, 'password' => Settings::$DB_PWD, 'dbname' => Settings::$DB_DATABASE)); require_once 'Zend/Db/Table/Abstract.php'; Zend_Db_Table_Abstract::setDefaultAdapter($db); } }
public function _initDb() { $resource = $this->getPluginResource('db'); $options = $resource->getOptions(); $db = new Zend_Db_Adapter_Pdo_Mysql($options["params"]); Zend_Db_Table_Abstract::setDefaultAdapter($db); }
/** * initalize session */ protected function _initSession() { $resource = $this->getPluginResource('db'); $db = $resource->getDbAdapter(); Zend_Db_Table_Abstract::setDefaultAdapter($db); $config = array('name' => 'sessions', 'primary' => 'sessionId', 'modifiedColumn' => 'modified', 'dataColumn' => 'data', 'lifetimeColumn' => 'lifetime', 'lifetime' => 60 * 60 * 24 * 14); Zend_Session::setSaveHandler(new Zend_Session_SaveHandler_DbTable($config)); }
protected function initDB() { /* @var $cnf Zend_Config_Ini */ $cnf = Zend_Registry::get('config'); $db = Zend_Db::factory($cnf->database->adapter, $cnf->database->params->toArray()); Zend_Db_Table_Abstract::setDefaultAdapter($db); Zend_Registry::set('db_adapter', $db); }
protected function getConnection() { $config = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini', 'testing'); $connection = Zend_Db::factory($config->resources->db->adapter, $config->resources->db->params); $this->_connectionMock = $this->createZendDbConnection($connection, 'zfunittests'); Zend_Db_Table_Abstract::setDefaultAdapter($connection); return $this->_connectionMock; }
/** * Prepares the environment before running a test. */ protected function setUp() { parent::setUp(); $adapter = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => dirname(__FILE__) . '/_files/testdb.sqlite')); Zend_Db_Table_Abstract::setDefaultAdapter($adapter); $this->_zymTable = new Bugs(); $this->_zymTable->addReference('Reporter', 'reported_by', 'Accounts', 'account_name')->addReference('Engineer', 'assigned_to', 'Accounts', 'account_name')->addReference('Verifier', array('verified_by'), 'Accounts', array('account_name')); }
public function _initDatabase() { // Register DB $dbConfig = new Zend_Config_Ini(APPLICATION_PATH . '/configs/database.ini', APPLICATION_ENV); $dbAdapter = Zend_Db::factory($dbConfig->database); Zend_Db_Table_Abstract::setDefaultAdapter($dbAdapter); Zend_Registry::set('dbAdapter', $dbAdapter); }
protected function _initDb() { $resource = $this->getPluginResource('db'); $db = $resource->getDbAdapter(); $db->getProfiler()->setEnabled(true); Zend_Db_Table_Abstract::setDefaultAdapter($db); Zend_Registry::set('db', $db); }
/** * Initialisation for the database, values see configs/application.ini * */ protected function _initDb() { if ($this->_config->db) { $db = Zend_Db::factory($this->_config->db); Zend_Db_Table_Abstract::setDefaultAdapter($db); Zend_Registry::set('db', $db); } }
/** * @param string $adapter * @param array $options * @return \Enlight_Components_Db_Adapter_Pdo_Mysql */ public function factory($adapter, $options) { /** @var \Enlight_Components_Db_Adapter_Pdo_Mysql $db */ $db = \Enlight_Components_Db::factory($adapter, $options); // Reset sql_mode "STRICT_TRANS_TABLES" that will be default in MySQL 5.6 $db->exec("SET @@session.sql_mode = ''"); \Zend_Db_Table_Abstract::setDefaultAdapter($db); return $db; }
protected function _initDatabase() { $config = Zend_Registry::get('config'); $db = Zend_Db::factory($config->resources->db->adapter, $config->resources->db->params->toArray()); Zend_Db_Table_Abstract::setDefaultAdapter($db); $db->setFetchMode(Zend_Db::FETCH_OBJ); /** Registra a variável db */ Zend_Registry::set('db', $db); }
/** * @return PHPUnit_Extensions_Database_DB_IDatabaseConnection */ protected function getConnection() { if ($this->_connectionMock == null) { $connection = Zend_Db_Table_Abstract::getDefaultAdapter(); $this->_connectionMock = $this->createZendDbConnection($connection, 'zfunittests'); Zend_Db_Table_Abstract::setDefaultAdapter($connection); } return $this->_connectionMock; }
/** * initialize and creates the db adapter * * @return Zend_Db_Adapter_Pdo_Mysql */ public function initDb() { //loads the db application option given in the application starter $config = $this->Application()->getOptions(); $db = Enlight_Components_Db::factory(new Zend_Config(array('adapter' => $config["adapter"], 'params' => $config["db"]))); $db->getConnection(); Zend_Db_Table_Abstract::setDefaultAdapter($db); return $db; }
public function controllerDrivenDB($request) { $controller = $request->getControllerName(); $config = Zend_Registry::get('config'); if (isset($config['resources']['db'][$controller])) { $dbs = $config['resources']['db'][$controller]; if (!isset($dbs[0])) { $dbs = array($dbs); } $dbs = $config['resources']['db'][$controller]; $count = sizeof($dbs); for ($i = 0; $i < $count; $i++) { $connect = true; try { $db = Zend_Db::factory($dbs[$i]['adapter'], $dbs[$i]['params']); $db->getConnection(); } catch (Zend_Db_Adapter_Exception $e) { $connect = false; } catch (Zend_Exception $e) { $connect = false; } if ($connect == true) { Zend_Registry::set('db-prefix', $dbs[$i]['prefix']); break; } } } else { $dbs = $config['resources']['db']; if (!isset($dbs[0])) { $dbs = array($dbs); } $count = sizeof($dbs); for ($i = 0; $i < $count; $i++) { $connect = true; try { $db = Zend_Db::factory($dbs[$i]['adapter'], $dbs[$i]['params']); $db->getConnection(); } catch (Zend_Db_Adapter_Exception $e) { $connect = false; } catch (Zend_Exception $e) { $connect = false; } if ($connect == true) { Zend_Registry::set('db-prefix', $dbs[$i]['prefix']); break; } } } if ($config['evil']['db']['profiling']) { $profiler = new Zend_Db_Profiler_Firebug('DB Queries'); $profiler->setEnabled(true); $db->setProfiler($profiler); } Zend_Registry::set('db', $db); Zend_Db_Table_Abstract::setDefaultAdapter($db); }
protected function _initDb() { // set up multiple databases $this->bootstrap('multidb'); $multidb = $this->getResource('multidb'); Zend_Registry::set('db_default', $multidb->getDb('default')); // set default database $default = $multidb->getDb('default'); Zend_Db_Table_Abstract::setDefaultAdapter($default); }
public static function vindb_connect() { if (self::$_vindb == null) { $vin_config = new Zend_Config_Ini(dirname(__FILE__) . "/../config.ini", "vin-db"); $vin_params = array('host' => $vin_config->vin_params->host, 'username' => $vin_config->vin_params->username, 'password' => $vin_config->vin_params->password, 'dbname' => $vin_config->vin_params->dbname, 'charset' => 'utf8', 'profiler' => true); self::$_vindb = Zend_Db::factory($vin_config->adapter, $vin_params); Zend_Db_Table_Abstract::setDefaultAdapter(self::$_vindb); } return self::$_vindb; }
public function testUnitTestLoadFixtures() { Zend_Db_Table_Abstract::setDefaultAdapter($db = new Zend_Db_Adapter_Pdo_Sqlite(array('dbname' => ":memory:"))); $db->getConnection()->exec('DROP TABLE IF EXISTS `foo`; CREATE TABLE `foo` (`a` VARCHAR, `b` VARCHAR);'); $suite = new PHPUnit_Framework_TestSuite(); $suite->addTestSuite('NotEmptyZendDbTest'); $suite->run($result = new PHPUnit_Framework_TestResult()); $this->assertEquals(1, $result->count()); $this->assertTestsAreSuccessful($result); }
function __construct($prefetch = true) { if (!$prefetch === false) { unset($_rowClass); } $this->db = Zend_Registry::get("db"); Zend_Db_Table_Abstract::setDefaultAdapter($this->db); $this->log = Zend_Registry::get('log'); $this->_setup(); }