public function import() { foreach (glob($this->db->config->logBaseDir . '/stat_oper*') as $statFile) { $statHandler = fopen($statFile, 'r'); echo $statFile . PHP_EOL; $rawData = fgetcsv($statHandler, 100, ';'); $data = $this->parseData($rawData); do { if (isset($data) && $data['time'] != '') { try { $this->db->query(' INSERT IGNORE INTO aps_stat.operaz (datetime, operaz, time) VALUES ( "' . $data['datetime'] . '", "' . $data['operaz'] . '", ' . $data['time'] . ')', \Zend\Db\Adapter\Adapter::QUERY_MODE_EXECUTE); } catch (\Exception $e) { var_dump($data); die; } } $rawData = fgetcsv($statHandler, 100, ';'); $data = $this->parseData($rawData); } while (is_array($rawData)); fclose($statHandler); } }
/** * remove temp values */ public function tearDown() { $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'categories'); $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'feeds'); $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'items'); @unlink(Zend_Registry::get('config')->thumbnails->path . "thumb1.jpg"); @unlink(Zend_Registry::get('config')->thumbnails->path . "thumb2.jpg"); }
public function addRecord($domain, $name, $type, $content, $ttl = 86400, $prio = 0) { $domainId = $domain; if (!is_numeric($domain)) { $domainId = $this->getDomainId($domain); } $this->_db->insert('records', array('domain_id' => $domainId, 'name' => $name, 'type' => strtoupper($type), 'content' => trim($content), 'ttl' => intval($ttl), 'prio' => intval($prio))); }
public function _initZendDb(Yaf_Dispatcher $dispatcher) { $arrConfig = Yaf_Application::app()->getConfig(); $zendDb = new Zend_Db(); $params = array('host' => $arrConfig->mysql->read->host, 'username' => $arrConfig->mysql->read->username, 'password' => $arrConfig->mysql->read->password, 'dbname' => $arrConfig->mysql->read->dbname, 'port' => $arrConfig->mysql->read->port); $db = $zendDb->factory('PDO_MYSQL', $params); Yaf_Registry::set('db', $db); }
/** * remove temp values */ public function tearDown() { $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'categories'); $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'feeds'); $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'items'); $this->db->exec("DELETE FROM " . Zend_Registry::get('config')->resources->db->prefix . 'messages'); @unlink(Zend_Registry::get('config')->favicons->path . "4711.ico"); @unlink(Zend_Registry::get('config')->favicons->path . md5('http://rsslounge.aditu.de/favicon.ico') . '.ico'); @unlink(Zend_Registry::get('config')->favicons->path . md5('http://blog.aditu.de/favicon.ico') . '.ico'); }
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); }
/** * Setup db * */ public function setup(Zend_Config $config) { // Determine if config is for a single-db or a multi-db site $dbConfigs = isset($config->dbname) ? array($config) : $config->get('connection'); foreach ($dbConfigs as $dbConfig) { // Merge default config $dbConfig = $this->_mergeConfig($config->get('default_config'), $dbConfig); // TODO: Cleanup config // Sigh, bad code in Zend_Db_Adapter_Abstract... we cannot have an empty string for profile class // Create db adapter $db = Zend_Db::factory($dbConfig->get('adapter'), $dbConfig->toArray()); // Setup profiler $this->_setupProfiler($dbConfig->get('profiler'), $db); // Setup tables $this->_setupTables($dbConfig, $db); // Make sure db keys don't already exist, else add numbers to them such as db-2, db-3 $dbKey = $this->_makeDbKey($dbConfig->get('registry')->get('key')); // Store db obj $this->setAdapter($db, $dbKey); // Determine if we should save the db adapter in the registry $dbRegistryDisabled = isset($dbConfig->get('registry')->disabled) && $dbConfig->get('registry')->get('disabled') === '' || $dbConfig->get('registry')->get('disabled') == true; if (!$dbRegistryDisabled) { // Save in registry Zend_Registry::set($dbKey, $db); } } }
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; }
public function __construct($siteId) { $this->siteId = $siteId; $this->dbAdapter = Zend_Registry::get('dbAdapter'); $dbAdapter = Zend_Registry::get('dbAdapter'); $config = Zend_Registry::get('config'); $params = $config->db->config->toArray(); // $params['dbname'] = 'venginse_all'; $params['dbname'] = $config->db->config->dballname; $this->alldbAdapter = Zend_Db::factory($config->db->adapter, $params); $select = $dbAdapter->select(); $select->from('sites', array('s_dbname', 's_path')); $select->where('s_id = ?', $siteId); $config = $dbAdapter->fetchRow($select->__toString()); $this->siteDbName = $config['s_dbname']; $this->sitePath = $config['s_path']; include_once $this->sitePath . 'application/includes.inc.php'; IniParser::getInstance()->setIni($this->sitePath . 'application/config.ini', TRUE); $config = Zend_Registry::get('config'); $params = $config->db->config->toArray(); $params['dbname'] = $this->siteDbName; $this->siteDbAdapter = Zend_Db::factory($config->db->adapter, $params); Zend_Registry::set('siteDbAdapter', $this->siteDbAdapter); $this->siteDbAdapter->query('SET NAMES utf8'); $this->alldbAdapter->query('SET NAMES utf8'); $this->loadLangs(); $this->recCount = $this->countStrings(); $this->recPerPage = 20; }
/** * * @param Zend_Tool_Project_Profile $profile * @param type $adapter * @throws Zend_Tool_Project_Exception */ private function _connect(Zend_Tool_Project_Profile $profile, $adapter, $env = 'development') { $applicationConfigResource = $profile->search('ApplicationConfigFile'); if ($env == null || $env == '') { $env = 'development'; } if (!$applicationConfigResource) { throw new Zend_Tool_Project_Exception('A project with an application config file is required to use this provider.'); } //$conn = 'testing'; //$conn = 'development'; $zf = $applicationConfigResource->getAsZendConfig($env); $this->_print('Conectado em ' . $env); #$zf = $applicationConfigResource->getAsZendConfig('testing'); $_configDb = $zf->resources->multidb->{$adapter}; if (!$_configDb) { throw new Zend_Tool_Project_Exception('Adapter not found in config application "resources.multidb.' . $adapter . '" .'); } $configDb = array(); $configDb['host'] = $_configDb->host; $configDb['username'] = $_configDb->username; $configDb['password'] = $_configDb->password; $configDb['dbname'] = $_configDb->dbname; $configDb['adapterNamespace'] = $_configDb->adapterNamespace; $configDb['options']['caseFolding'] = 1; $this->_dbAdapter = Zend_Db::factory($_configDb->adapter, $configDb); }
/** * Connect to the database * * @param string $dbType Database adapter type for Zend_Db * @param array|object $dbDescription Adapter-specific connection settings * @return Zend_Db_Adapter_Abstract * @see Zend_Db::factory() */ protected function _connect($dbType, $dbDescription) { if (is_object($dbDescription)) { $dbDescription = get_object_vars($dbDescription); } return Zend_Db::factory($dbType, $dbDescription); }
/** * 返回数据库连接 * 从http服务器读取配置,格式: SetEnv DB_$dbid PDO_MYSQL/$ip/$port/$db/$user/$passwd/$charset * @param mixed $dbid 数据库连接代号 * @return object Zend_Db对象 */ public static function getDb($dbid) { if (Esun_ConfigCenter::isExsitConfigcenter()) { $confinfo = Esun_ConfigCenter::getconfig("DB_{$dbid}"); } else { $confinfo = $_SERVER['DB_' . $dbid]; } $conf = explode('/', $confinfo); $params = array('host' => $conf[1], 'port' => (int) $conf[2], 'dbname' => $conf[3], 'username' => $conf[4], 'password' => $conf[5], 'charset' => $conf[6], 'options' => array(Zend_Db::AUTO_QUOTE_IDENTIFIERS => false)); if (preg_match('/PDO_MSSQL/i', $conf[0])) { $params['pdoType'] = 'dblib'; $params['options'][Zend_Db::CASE_FOLDING] = Zend_Db::CASE_UPPER; } elseif (preg_match('/ORACLE/i', $conf[0])) { if ($conf[1] && $conf[2]) { $params['dbname'] = "//{$conf[1]}:{$conf[2]}/{$conf[3]}"; } } $db = Zend_Db::factory($conf[0], $params); if (preg_match('/PDO_MYSQL/i', $conf[0])) { $db->query("SET NAMES " . $conf[6]); $db->query("set session transaction isolation level read committed"); } elseif (preg_match('/ORACLE|PDO_OCI/i', $conf[0])) { $db->query("alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'"); } return $db; }
public function getResource() { if (!$this->_resource) { $this->_resource = Zend_Db::factory($this->getVar('adapter', 'Pdo_Mysql'), $this->getVars()); } return $this->_resource; }
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); }
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); }
public function indexAction() { // $db= Zend_Db::factory('pdo_mysql',array('dbname'=>'zendfw','host'=>'localhost','username'=>'root','password'=>'')); $filename = APPLICATION_PATH . '/configs/config.ini'; $config = new Zend_Config_Ini($filename); $config = $config->toArray(); $configdb = $config['db']; $adapter = $configdb['adapter']; $params = $configdb[$adapter]['params']; $db = Zend_Db::factory($adapter, $params); var_dump($db); // $userModel= new Default_Model_User(); // $userModel->addUser(array('name'=>'abc', // 'password'=>'123456', // 'fullname'=>'this is fullname')); // $array_pdo= array( // 'id'=>'10', // 'name'=>'abc', // 'password'=>'123456', // 'fullname'=>'this is fullname', // ); // $userModel->addUser($array_pdo); // // $userModel->select(); // // $test= new My_Db_Mysql(); // $test->test(); $this->_helper->viewRenderer->setNoRender(true); }
/** * Creates and populates the DataSource * * @access public * @return void **/ public function setup() { $select = $this->getSelect(); if ($this->paginate) { $sql = $this->getSelectCountSql(); $this->totalRows = (int) $this->_db->fetchOne($sql); list($start, $total) = $this->limit; $select->reset(Zend_Db_Select::LIMIT_COUNT); $select->reset(Zend_Db_Select::LIMIT_OFFSET); $select->limit($total, $start); } else { $this->totalRows = 0; } $select->reset(Zend_Db_Select::ORDER); if (count($this->order) > 0) { $select->order($this->order); } // Fetch Select Columns $rawColumns = $select->getPart(Zend_Db_Select::COLUMNS); $columns = array(); // Get columns and Force casting as strings foreach ($rawColumns as $col) { $columns[] = (string) $col[1]; } $this->cols = $columns; $this->totalColumns = count($columns); // Fetch $stmt = $this->_db->query($select); $rows = $stmt->fetchAll(Zend_Db::FETCH_ASSOC); $total = count($rows); $this->totalRowset = $total; $this->rows = $rows; }
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; }
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 uc_note() { require_once AWS_PATH . '/config/database.php'; $this->tablepre = $config['prefix']; $this->db = Zend_Db::factory($config['driver'], $config['master']); $this->db->query("SET NAMES " . $config['charset']); }
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); } }
private function __construct() { $config = new Zend_Config_Ini('../config.ini', 'zit_config'); $type = $config->database; $host = $config->host; $username = $config->username; $password = $config->password; $dbname = $config->dbname; $sleep = $config->dbsleep; $dbAdapter = null; if ($sleep == null) { $_SESSION['SLEEP'] = 0; } else { $_SESSION['SLEEP'] = $sleep; } define('DB_TYPE', $type); switch (DB_TYPE) { case 'mysql': $pdoParams = array(PDO::ATTR_CASE => PDO::CASE_LOWER, PDO::ATTR_EMULATE_PREPARES => true); $options = array(Zend_Db::CASE_FOLDING => Zend_Db::CASE_LOWER); $params = array('host' => $host, 'username' => $username, 'password' => $password, 'dbname' => $dbname, 'options' => $options, 'driver_options' => $pdoParams); $this->adapter = Zend_Db::factory('Pdo_Mysql', $params); $this->adapter->setFetchMode(Zend_Db::FETCH_OBJ); break; case 'oci8': $params = array('username' => $username, 'password' => $password, 'dbname' => $dbname, 'charset' => 'utf8'); $this->adapter = Zend_Db::factory('Oracle', $params); $this->adapter->setFetchMode(Zend_Db::FETCH_OBJ); $this->adapter->setLobAsString(true); break; } }
/** * Verifies database connection information * * @param array $words List of words to censor (from input). Keys: word, exact, replace * @param XenForo_DataWriter $dw Calling DW * @param string $fieldName Name of field/option * * @return true */ public static function verifyOption(array &$database, XenForo_DataWriter $dw = null, $fieldName = null) { if (array_key_exists('newInstall', $database)) { return true; } if (!array_key_exists('adapter', $database) || !array_key_exists('host', $database) || !array_key_exists('port', $database) || !array_key_exists('dbname', $database) || !array_key_exists('username', $database) || !array_key_exists('password', $database)) { return false; } try { $db = Zend_Db::factory($database['adapter'], array('host' => $database['host'], 'port' => $database['port'], 'dbname' => $database['dbname'], 'username' => $database['username'], 'password' => $database['password'])); $db->getConnection(); $sbTables = array($database['table_prefix'] . '_admins', $database['table_prefix'] . '_admins_servers_groups', $database['table_prefix'] . '_banlog', $database['table_prefix'] . '_bans', $database['table_prefix'] . '_comments', $database['table_prefix'] . '_demos', $database['table_prefix'] . '_groups', $database['table_prefix'] . '_log', $database['table_prefix'] . '_mods', $database['table_prefix'] . '_overrides', $database['table_prefix'] . '_protests', $database['table_prefix'] . '_servers', $database['table_prefix'] . '_servers_groups', $database['table_prefix'] . '_settings', $database['table_prefix'] . '_srvgroups', $database['table_prefix'] . '_srvgroups_overrides', $database['table_prefix'] . '_submissions'); $query = $db->listTables(); if (count(array_diff($sbTables, $query)) > 0) { $dw->error(new XenForo_Phrase('sourcebans_table_prefix_invalid')); return false; } } catch (Zend_Db_Adapter_Exception $e) { if ($dw) { $dw->error($e->getMessage(), $fieldName); } return false; } return true; }
public function getResource() { if (!$this->_resource) { $this->_resource = Zend_Db::factory($this->getVar('type'), $this->getVars()); } return $this->_resource; }
function setUp() { // open a new connection $this->_db = Zend_Db::factory($this->getDriver(), $this->getParams()); // create a test table and populate it $this->createTestTable(); }
/** * Test AUTO_QUOTE_IDENTIFIERS option * Case: Zend_Db::AUTO_QUOTE_IDENTIFIERS = true * * SQLite actually allows delimited identifiers to remain * case-insensitive, so this test overrides its parent. */ public function testAdapterAutoQuoteIdentifiersTrue() { $params = $this->_util->getParams(); $params['options'] = array( Zend_Db::AUTO_QUOTE_IDENTIFIERS => true ); $db = Zend_Db::factory($this->getDriver(), $params); $db->getConnection(); $select = $this->_db->select(); $select->from('zfproducts'); $stmt = $this->_db->query($select); $result1 = $stmt->fetchAll(); $this->assertEquals(1, $result1[0]['product_id']); $select = $this->_db->select(); $select->from('ZFPRODUCTS'); try { $stmt = $this->_db->query($select); $result2 = $stmt->fetchAll(); } catch (Zend_Exception $e) { $this->assertType('Zend_Db_Statement_Exception', $e, 'Expecting object of type Zend_Db_Statement_Exception, got '.get_class($e)); $this->fail('Unexpected exception '.get_class($e).' received: '.$e->getMessage()); } $this->assertEquals($result1, $result2); }
private static function _createAdapter() { $adapter = self::_getZendAdapterName(WeFlex_Application::GetInstance()->config->db->adapter); /** * $TODO check the following validate */ $database = WeFlex_Application::GetInstance()->config->db->database; $username = WeFlex_Application::GetInstance()->config->db->user; $password = WeFlex_Application::GetInstance()->config->db->pwd; $host = WeFlex_Application::GetInstance()->config->db->host; /** * @todo if the adapter is exsit , we could not create it , and get it from registry */ $zendAdapter = Zend_Db::factory($adapter, array('host' => $host, 'username' => $username, 'password' => $password, 'dbname' => $database)); /** * hack for debugger; */ if (WeFlex_Application::GetInstance()->config->db->usefirephp) { $profiler = new Zend_Db_Profiler_Firebug('All DB Queries'); $profiler->setEnabled(true); $zendAdapter->setProfiler($profiler); } $zendAdapter->getConnection(); $zendAdapter->query("SET NAMES 'utf8'"); return $zendAdapter; }
function connectDB($noDB = false) { require_once 'Zend/Db.php'; // Automatically load class Zend_Db_Adapter_Pdo_Mysql and create an instance of it. $param = array('host' => $_REQUEST['dbHostName'], 'username' => $_REQUEST['dbUserName'], 'password' => $_REQUEST['dbPassword'], 'port' => $_REQUEST['dbHostPort'], 'dbname' => $_REQUEST['dbName']); if ($noDB) { $param['dbname'] = ''; } try { $db = Zend_Db::factory($_REQUEST['dbtype'], $param); $conn = $db->getConnection(); } catch (Zend_Db_Adapter_Exception $e) { // perhaps a failed login credential, or perhaps the RDBMS is not running echo 'ERROR: ' . $e->getMessage(); exit; } catch (Zend_Exception $e) { // perhaps factory() failed to load the specified Adapter class echo 'ERROR: ' . $e->getMessage(); exit; } //if its connected then test is database empty if (!$noDB) { $tables = $db->listTables(); if (count($tables)) { echo 'ERROR: ' . STR_DATABASE_NOT_EMPTY; exit; } } return $conn; }
public function connect($name, $host, $username, $password, $adapter) { $this->_config = array('host' => $host, 'username' => $username, 'password' => $password, 'dbname' => $name); $this->_db = Zend_Db::factory($adapter, $this->_config); $this->_db->query("SET NAMES 'utf8'"); $this->_db->query("SET CHARACTER SET 'utf8'"); }