public function _initDb()
{
$dbconf = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini', APPLICATION_ENV);
Zend_Registry::set('Zend_Db', Zend_Db::factory($dbconf->resources->db));
Zend_Registry::get('Zend_Db')->setFetchMode(Zend_Db::FETCH_OBJ);
Zend_Db_Table::setDefaultAdapter(Zend_Registry::get('Zend_Db'));
}
public function __construct($addr = "127.0.0.1", $port = 8080)
{
$this->port = $port;
$this->addr = $addr;
// Setup basic stuff
error_reporting(E_ALL & ~E_NOTICE);
$base = realpath(dirname(__FILE__) . '/../');
$paths = array('.', realpath($base . '/library'), get_include_path());
$this->base = $base;
// Setup autoloading ...
set_include_path(implode(PATH_SEPARATOR, $paths));
require_once 'Zend/Loader/Autoloader.php';
$autoloader = Zend_Loader_Autoloader::getInstance();
$autoloader->registerNamespace('EvHttp_');
$resourceLoader = new Zend_Loader_Autoloader_Resource(array('basePath' => realpath($base . '/application'), 'namespace' => '', 'resourceTypes' => array('model' => array('namespace' => 'Model', 'path' => 'models/'), 'api' => array('namespace' => 'Service', 'path' => 'apis/'))));
// Load config
$this->config = new Zend_Config_Ini($this->base . '/deploy/config.ini', 'default');
Zend_Registry::set('config', $this->config);
// Connect database
$dbType = $this->config->database->type;
$params = $this->config->database->toArray();
$db = Zend_Db::factory($dbType, $params);
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('db', $db);
// Setup Xml-Rpc Server
$this->xmlrpc_server = new Zend_XmlRpc_Server();
$this->xmlrpc_server->setClass('Service_Poll', 'poll');
Zend_XmlRpc_Server_Fault::attachFaultException('Exception');
// Setup Json-Rpc Server
$this->jsonrpc_server = new Zend_Json_Server();
$this->jsonrpc_server->setClass('Service_Poll', 'poll')->setAutoEmitResponse(false)->setTarget('/jsonrpc')->setEnvelope(Zend_Json_Server_Smd::ENV_JSONRPC_2);
}
/**
* Instantiate the application database resource object
*
* @return Zend_Db_Adapter
* @link http://framework.zend.com/manual/en/zend.db.html
*/
protected function _initDb()
{
// Only attempt to cache the metadata if we have a cache available
if (!is_null($this->_cache)) {
try {
Zend_Db_Table_Abstract::setDefaultMetadataCache($this->_cache);
} catch (Zend_Db_Table_Exception $e) {
print $e->getMessage();
}
}
$db = null;
$dbPluginResource = $this->getPluginResource('db');
if (!is_null($dbPluginResource)) {
$db = $dbPluginResource->getDbAdapter();
// Set the default fetch mode to object throughout the application
$db->setFetchMode(Zend_Db::FETCH_OBJ);
// Force the initial connection to handle error relating to caching etc.
try {
$db->getConnection();
} catch (Zend_Db_Adapter_Exception $e) {
// perhaps a failed login credential, or perhaps the RDBMS is not running
} catch (Zend_Exception $e) {
// perhaps factory() failed to load the specified Adapter class
}
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('db', $db);
}
return $db;
}
public function __construct($addr = "127.0.0.1", $port = 8080)
{
$this->port = $port;
$this->addr = $addr;
$this->_startupSuperGlobal();
// Setup basic stuff
error_reporting(E_ALL & ~E_NOTICE);
$base = realpath(dirname(__FILE__) . '/../');
$paths = array('.', realpath($base . '/library'), get_include_path());
$this->base = $base;
// Setup autoloading ...
set_include_path(implode(PATH_SEPARATOR, $paths));
require_once 'Zend/Loader/Autoloader.php';
$autoloader = Zend_Loader_Autoloader::getInstance();
$autoloader->registerNamespace('EvHttp_');
$resourceLoader = new Zend_Loader_Autoloader_Resource(array('basePath' => realpath($base . '/application'), 'namespace' => '', 'resourceTypes' => array('model' => array('namespace' => 'Model', 'path' => 'models/'), 'form' => array('namespace' => 'Form', 'path' => 'forms/'))));
// Load config
$this->config = new Zend_Config_Ini($this->base . '/deploy/config.ini', 'default');
Zend_Registry::set('config', $this->config);
// Connect database
$dbType = $this->config->database->type;
$params = $this->config->database->toArray();
$db = Zend_Db::factory($dbType, $params);
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('db', $db);
// Setup extended front controller.
$this->controller = EvHttp_Controller_Front::getInstance();
$this->controller->throwExceptions(true);
$this->controller->returnResponse(true);
$this->controller->setDefaultAction('index');
$this->controller->setControllerDirectory(array('default' => $base . '/application/controllers'));
}
protected function _initDatabase()
{
$config = $this->getOptions();
$db = Zend_Db::factory($config['resources']['db']['adapter'], $config['resources']['db']['params']);
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set("db", $db);
}
protected function _initConfig()
{
/* for local */
$host = "localhost";
$username = "******";
$password = "";
$dbname = "pocket_recruiter";
/* for TEST Site */
/*
$host = "andybui.ipagemysql.com";
$username = "******";
$password = "******";
$dbname = "advantages_sis";
*/
//--- db
$db = Zend_Db::factory('MYSQLI', array('host' => $host, 'username' => $username, 'password' => $password, 'dbname' => $dbname));
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('DB', $db);
Zend_Registry::set('DB_Info', array('host' => $host, 'username' => $username, 'password' => $password, 'dbname' => $dbname));
$sql = "SET NAMES utf8";
$db->query($sql);
if (!$db->isConnected()) {
throw new PR_Exception('No Db connection', 1, PR_Exception::CRITICAL_ERROR);
}
//--- user_types
$user_types = array(1 => "Super Admin", 2 => "School Admin", 3 => "Teacher", 4 => "Student");
Zend_Registry::set('USER_TYPES', $user_types);
//--- return
return new Zend_Config($this->getOptions());
}
protected function _initDB()
{
$db = Zend_Db::factory('Pdo_Mysql', array('host' => 'localhost', 'username' => 'root', 'password' => '', 'dbname' => 'xoso', 'charset' => 'utf8'));
$db->setFetchMode(Zend_Db::FETCH_BOTH);
Zend_Db_Table::setDefaultAdapter($db);
return $db;
}
/**
* Create adapter
*
* @param string $adapterName database adapter name
* @param array $dbInfos database connection info
* @param bool $connect
* @return mixed (Piwik_Db_Adapter_Mysqli, Piwik_Db_Adapter_Pdo_Mysql, etc)
*/
public static function factory($adapterName, & $dbInfos, $connect = true)
{
if($connect)
{
if($dbInfos['port'][0] == '/')
{
$dbInfos['unix_socket'] = $dbInfos['port'];
unset($dbInfos['host']);
unset($dbInfos['port']);
}
// not used by Zend Framework
unset($dbInfos['tables_prefix']);
unset($dbInfos['adapter']);
unset($dbInfos['schema']);
}
$className = self::getAdapterClassName($adapterName);
Piwik_Loader::loadClass($className);
$adapter = new $className($dbInfos);
if($connect)
{
$adapter->getConnection();
Zend_Db_Table::setDefaultAdapter($adapter);
// we don't want the connection information to appear in the logs
$adapter->resetConfig();
}
return $adapter;
}
/**
* Init Db -- register db adapter
*/
protected function _initDb()
{
$resource = $this->getPluginResource('db');
Zend_Db_Table::setDefaultAdapter($resource->getDbAdapter());
Zend_Registry::set('db', $resource->getDbAdapter());
return $resource->getDbAdapter();
}
protected function _database()
{
$this->_db = Zend_Db::factory('Pdo_Mysql', array('host' => 'localhost', 'username' => 'test_bruno', 'password' => 'test_bruno', 'dbname' => 'test_bruno'));
$this->_db->exec("SET NAMES 'utf8'");
Zend_Db_Table::setDefaultAdapter($this->_db);
return $this;
}
/**
* Load database adapter.
*
* @param string $testConfigDir
* @param string $dbType
* @return Zend_Db_Adapter_Abstract
* @throws Zend_Exception
*/
function loadDbAdapter($testConfigDir, $dbType)
{
// create the lockfile for this dbType
$dbConfigFile = $testConfigDir . '/' . $dbType . '.ini';
$lockFile = $testConfigDir . '/lock.' . $dbType . '.ini';
copy($dbConfigFile, $lockFile);
// load the lockfile as the test dbConfig
if (file_exists($lockFile)) {
$configDatabase = new Zend_Config_Ini($lockFile, 'testing');
} else {
throw new Zend_Exception('Error, cannot load lockfile: ' . $lockFile);
}
if (empty($configDatabase->database->params->driver_options)) {
$driverOptions = array();
} else {
$driverOptions = $configDatabase->database->params->driver_options->toArray();
}
$params = array('dbname' => $configDatabase->database->params->dbname, 'driver_options' => $driverOptions);
if ($dbType != 'sqlite') {
$params['username'] = $configDatabase->database->params->username;
$params['password'] = $configDatabase->database->params->password;
if (empty($configDatabase->database->params->unix_socket)) {
$params['host'] = $configDatabase->database->params->host;
$params['port'] = $configDatabase->database->params->port;
} else {
$params['unix_socket'] = $configDatabase->database->params->unix_socket;
}
}
$db = Zend_Db::factory($configDatabase->database->adapter, $params);
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('dbAdapter', $db);
Zend_Registry::set('configDatabase', $configDatabase);
return $db;
}
protected function _initDb()
{
$resources = $this->getOption('resources');
$dbConfig = $resources['db'];
$db = \Zend_Db::factory($dbConfig['adapter'], array('host' => $dbConfig['params']['host'], 'username' => $dbConfig['params']['username'], 'password' => $dbConfig['params']['password'], 'dbname' => $dbConfig['params']['dbname'], 'adapterNamespace' => $dbConfig['params']['adapterNamespace']));
\Zend_Db_Table::setDefaultAdapter($db);
}
protected function _initDb()
{
if (isset($this->_config->db)) {
try {
$connections = new ArrayObject();
foreach ($this->_config->db->connections as $dbId => $db) {
// using zend_db to setup connection but not using it for the app
$conn = Zend_Db::factory($db);
$connections->{$dbId} = $conn;
if ($dbId == @$this->_config->db->default) {
Zend_Db_Table::setDefaultAdapter($conn);
$this->_registry->set('db', $conn);
$this->_db = $conn;
}
}
$this->_registry->set('dbs', $connections);
} catch (Exception $e) {
$this->__throwError(new Exception('Cannot connect to required database; please try again later.'));
}
} else {
$this->_db = null;
$this->_dbs = array();
$this->_registry->set('db', null);
}
}
/**
* Create adapter
*
* @param string $adapterName database adapter name
* @param array $dbInfos database connection info
* @param bool $connect
* @return Piwik_Db_Adapter_Interface
*/
public static function factory($adapterName, &$dbInfos, $connect = true)
{
if ($connect) {
if ($dbInfos['port'][0] == '/') {
$dbInfos['unix_socket'] = $dbInfos['port'];
unset($dbInfos['host']);
unset($dbInfos['port']);
}
// not used by Zend Framework
unset($dbInfos['tables_prefix']);
unset($dbInfos['adapter']);
unset($dbInfos['schema']);
}
$className = self::getAdapterClassName($adapterName);
Piwik_Loader::loadClass($className);
/*
* 5.2.1 fixes various bugs with references that caused PDO_MYSQL getConnection()
* to clobber $dbInfos. (#33282, #35106, #39944)
*/
if (version_compare(PHP_VERSION, '5.2.1') < 0) {
$adapter = new $className(array_map('trim', $dbInfos));
} else {
$adapter = new $className($dbInfos);
}
if ($connect) {
$adapter->getConnection();
Zend_Db_Table::setDefaultAdapter($adapter);
// we don't want the connection information to appear in the logs
$adapter->resetConfig();
}
return $adapter;
}
public function init()
{
$url = constant("APPLICATION_PATH") . DIRECTORY_SEPARATOR . 'configs' . DIRECTORY_SEPARATOR . 'application.ini';
$dbconfig = new Zend_Config_Ini($url, "mysql");
$db = Zend_Db::factory($dbconfig->db);
$db->query('SET NAMES UTF8');
Zend_Db_Table::setDefaultAdapter($db);
}
protected function _initConnection()
{
$config = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini');
$params = $config->db->jwl->toArray();
$dbAdapter = Zend_Db::factory($config->db->adapter, $params['server1']);
Zend_Db_Table::setDefaultAdapter($dbAdapter);
Zend_Registry::set('db_Adapter', $dbAdapter);
}
protected function _initDb()
{
$resource = $this->getPluginResource('db');
$db = $resource->getDbAdapter();
Zend_Registry::set('db', $db);
Zend_Db_Table::setDefaultAdapter($db);
Zend_Db_Table_Abstract::setDefaultAdapter($db);
}
public function _initDatabase()
{
$params = array('host' => 'localhost', 'username' => 'root', 'password' => 'root', 'dbname' => 'logs');
$db = Zend_db::factory('Pdo_Mysql', $params);
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('db_params', $params);
Zend_Registry::set('db', $db);
}
public function setUp()
{
$this->rowResolver = new Waf_Zend_Controller_Action_Helper_Param_Resolver_DbTableRow();
$this->dbAdapter = new Zend_Test_DbAdapter();
Zend_Db_Table::setDefaultAdapter($this->dbAdapter);
// I know this sucks
$this->dbTable = $this->getMock('Zend_Db_Table', array(), array('db' => $this->dbAdapter));
}
public static function setupDatabase()
{
$config = self::$registry->configuration;
$db = Zend_Db::factory($config->db->adapter, $config->db->toArray());
$db->query("SET NAMES 'utf8'");
self::$registry->database = $db;
Zend_Db_Table::setDefaultAdapter($db);
}
public function init()
{
$url = constant("APPLICATION_PATH") . DIRECTORY_SEPARATOR . 'configs' . DIRECTORY_SEPARATOR . 'application.ini';
$dbconfig = new Zend_Config_Ini($url, 'mysql');
$db = Zend_Db::factory($dbconfig->db);
date_default_timezone_set("PRC");
$db->query('set names utf8');
$db = Zend_Db_Table::setDefaultAdapter($db);
}
protected function _initDb()
{
if (!extension_loaded('pdo') && !in_array('sqlite', PDO::getAvailableDrivers())) {
$this->markTestSkipped('Test only with pdo_sqlite');
}
$db = Zend_Db::factory('Pdo_Sqlite', array('dbname' => ':memory:'));
Zend_Db_Table::setDefaultAdapter($db);
$this->_createTable();
}
protected function _initDb()
{
$config = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini', APPLICATION_ENV);
$adapter = $config->resources->db->adapter;
$db = Zend_Db::factory($adapter, $config->resources->db->params->toArray());
$db->query("SET NAMES 'utf8' ");
Zend_Db_Table::setDefaultAdapter($db);
return $db;
}
public function _initRegistries()
{
$this->bootstrap('multidb');
$db = $this->getPluginResource('multidb')->getDb('db');
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('multidb', $db);
$this->bootstrap('cachemanager');
$cache = $this->getResource('cachemanager')->getCache('file');
Zend_Registry::set('cache', $cache);
}
public function init()
{
//初始化数据库适配器
$url = "../application/configs/application.ini";
$dbconfig = new Zend_Config_Ini($url, "mysql");
$register = Zend_Registry::getInstance();
Zend_Registry::set('config', $dbconfig);
$db = Zend_Db::factory($dbconfig->resources->db);
Zend_Db_Table::setDefaultAdapter($db);
}
protected function _initDB()
{
$options = $this->getOption('resources');
$options = $options['db'];
$resources = $this->getPluginResource('db');
$db = $resources->getDbAdapter();
Zend_Db_Table::setDefaultAdapter($db);
Zend_Registry::set('dbAdapter', $db);
Zend_Registry::set('dbprefix', $options['params']['prefix']);
}
/**
* Defined by Zend_Application_Resource_Resource
*
* @return Zend_Db_Adapter_Abstract|null
*/
public function init()
{
if (null !== ($oDbAdapter = $this->getDbAdapter())) {
if ($this->isDefaultTableAdapter()) {
Zend_Db_Table::setDefaultAdapter($oDbAdapter);
}
$oDbAdapter->query('SET NAMES utf8');
return $oDbAdapter;
}
}
/**
* Sets up the fixture, for example, opens a network connection.
* This method is called before a test is executed.
*/
protected function setUp()
{
parent::setUp();
$this->db = $this->getConnection()->getConnection();
\Zend_Registry::set('db', $this->db);
\Zend_Db_Table::setDefaultAdapter($this->db);
$settings = new \Zend_Config_Ini(GEMS_ROOT_DIR . '/configs/application.example.ini', APPLICATION_ENV);
$sa = $settings->toArray();
$this->loader = new \Gems_Loader(\Zend_Registry::getInstance(), $sa['loaderDirs']);
\Zend_Registry::set('loader', $this->loader);
}
public function __construct()
{
$pimDb = Pimcore_Resource_Mysql::get();
$rev = Pimcore_Version::$revision;
if ($rev > 1350) {
Zend_Db_Table::setDefaultAdapter($pimDb->getResource());
} else {
Zend_Db_Table::setDefaultAdapter($pimDb);
}
$this->table = new Formbuilder_DbTable_Formbuilder();
}
function init()
{
define('KUTU_ROOT_DIR', dirname(__FILE__));
error_reporting(E_ALL | E_STRICT);
date_default_timezone_set('Asia/Jakarta');
set_include_path('.' . PATH_SEPARATOR . KUTU_ROOT_DIR . '/library' . PATH_SEPARATOR . get_include_path());
require_once 'Zend/Loader/Autoloader.php';
$loader = Zend_Loader_Autoloader::getInstance();
$loader->setFallbackAutoloader(true);
$loader->suppressNotFoundWarnings(false);
// include "Zend/Loader.php";
// Zend_Loader::registerAutoload();
require_once KUTU_ROOT_DIR . '/library/phpgacl/gacl.class.php';
require_once KUTU_ROOT_DIR . '/library/phpgacl/gacl_api.class.php';
require_once KUTU_ROOT_DIR . '/js/jcart/jcart.php';
$config = new Zend_Config_Ini(KUTU_ROOT_DIR . '/application/configs/application.ini', 'general');
$registry = Zend_Registry::getInstance();
$registry->set('config', $config);
$registry->set('files', $_FILES);
//$db = Zend_Db::factory($config->db->adapter, $config->db->config->toArray());
//Zend_Db_Table_Abstract::setDefaultAdapter($db);
$databases = new Zend_Config_Ini(KUTU_ROOT_DIR . '/application/configs/application.ini', 'databases');
$dbAdapters = array();
foreach ($databases->db as $config_name => $db) {
$dbAdapters[$config_name] = Zend_Db::factory($db->adapter, $db->config->toArray());
if ((bool) $db->default) {
Zend_Db_Table::setDefaultAdapter($dbAdapters[$config_name]);
}
}
Zend_Registry::set('dbAdapters', $dbAdapters);
$kutuUtil = new Kutu_Core_Util();
define('KUTU_ROOT_URL', $kutuUtil->getRootUrl(KUTU_ROOT_DIR));
require_once 'Kutu/Session/Manager.php';
$kutuSession = new Kutu_Session_Manager();
$kutuSession->start();
// set the expiration time for auth session to expire
$authNamespace = new Zend_Session_Namespace('Zend_Auth');
$authNamespace->setExpirationSeconds(86400);
// will expire in one day
$frontendOptions = array('lifetime' => 7200, 'automatic_serialization' => true);
$backendOptions = array('cache_dir' => KUTU_ROOT_DIR . '/data/cache');
$cacheDbTable = Zend_Cache::factory('Core', 'File', $frontendOptions, $backendOptions);
// Next, set the cache to be used with all table objects
Zend_Db_Table_Abstract::setDefaultMetadataCache($cacheDbTable);
// define('IN_PHPBB', true);
// define('PBB_ROOT_PATH', "../phpBB3");
// global $phpbb_root_path, $phpEx, $user, $db, $config, $cache, $template;
// $phpEx = "php";
// $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : PBB_ROOT_PATH . '/';
// require_once($phpbb_root_path . 'config.' . $phpEx);
// include($phpbb_root_path . 'common.' . $phpEx);
// $user->session_begin();
// $auth->acl($user->data);
}
