示例#1
0
 public function indexAction()
 {
     foreach ($this->app->config['database']['redis'] as $serverId => $server) {
         if (!empty($server['stats']['enable'])) {
             $time = time();
             $db = Db::factory($server);
             $info = $db->info();
             $statsModel = new Stats_Model($server);
             $statsModel->addKey('memory', $info['used_memory'], $time);
             $statsModel->addKey('connections', $info['total_connections_received'], $time);
             $statsModel->addKey('commands', $info['total_commands_processed'], $time);
             $statsModel->addKey('expired_keys', $info['expired_keys'], $time);
             $statsModel->addKey('hits', $info['keyspace_hits'], $time);
             $statsModel->addKey('misses', $info['keyspace_misses'], $time);
             $statsModel->addKey('clients', $info['connected_clients'], $time);
             $statsModel->addKey('user_cpu', $info['used_cpu_user'], $time);
             $statsModel->addKey('system_cpu', $info['used_cpu_sys'], $time);
             if ($info['aof_enabled']) {
                 $statsModel->addKey('aof_size', $info['aof_current_size'], $time);
                 $statsModel->addKey('aof_base', $info['aof_base_size'], $time);
             }
             foreach ($this->infoModel->getDbs($info) as $i) {
                 if (preg_match('/^keys=([0-9]+),expires=([0-9]+)$/', $info["db{$i}"], $matches)) {
                     $statsModel->addKey("db{$i}:keys", $matches[1], $time);
                     $statsModel->addKey("db{$i}:expired_keys", $matches[2], $time);
                 }
             }
         }
     }
 }
示例#2
0
 public function __construct($config)
 {
     $this->_objects['app'] = App::instance();
     $this->_objects['router'] = Router::instance();
     $this->_objects['inputs'] = Inputs::instance();
     $this->_objects['session'] = Session::instance();
     $this->_objects['log'] = Log::factory();
     if (!isset($this->app->config['database']['redis'][$config['serverId']])) {
         $config['serverId'] = 0;
     }
     $current = $this->app->config['database']['redis'][$config['serverId']];
     $current['serverId'] = $config['serverId'];
     $this->_objects['db'] = Db::factory($current);
     $this->_objects['infoModel'] = new Info_Model($current);
     $info = $this->db->info();
     $dbs = $this->infoModel->getDbs($info);
     if (!isset($current['max_databases'])) {
         $databasesConfig = $this->_objects['db']->config('GET', 'databases');
         $current['max_databases'] = $databasesConfig['databases'];
     }
     // Take care of invalid dbId's. If invalid, set to first available database
     if (!is_numeric($config['dbId']) || $config['dbId'] < 0 || $config['dbId'] >= $current['max_databases']) {
         $config['dbId'] = $dbs[0];
     }
     $current['newDB'] = !in_array($config['dbId'], $dbs) ? true : false;
     $current['database'] = $config['dbId'];
     // Extract number of keys
     foreach ($dbs as $i) {
         if (preg_match('/^keys=([0-9]+),expires=([0-9]+)/', $info["db{$i}"], $matches)) {
             $current['dbs'][$i] = array('id' => $i, 'keys' => $matches[1], 'name' => isset($current['dbNames'][$i]) ? $current['dbNames'][$i] : null);
         }
     }
     $this->db->select($current['database']);
     $this->app->current = $current;
 }
示例#3
0
文件: model.php 项目: xxoxx/phpredmin
 public function __construct($config)
 {
     $this->_objects['app'] = App::instance();
     $this->_objects['router'] = Router::instance();
     $this->_objects['session'] = Session::instance();
     $this->_objects['db'] = Db::factory($config);
     $this->_objects['log'] = Log::factory();
 }
示例#4
0
文件: Gear.php 项目: brussens/cogear2
 /**
  * Default dispatcher
  *
  * @param string $action
  * @param string $subaction
  */
 public function index($action = '')
 {
     template('Install/templates/header')->show('info');
     new Menu_Tabs(array('name' => 'install', 'render' => 'content', 'elements' => array(array('label' => t('1. Начало'), 'link' => '', 'active' => check_route('install$')), array('label' => t('2. Проверка'), 'link' => '', 'active' => check_route('check$')), array('label' => t('3. Настройки'), 'link' => '', 'active' => check_route('site$')), array('label' => t('4. Завершение'), 'link' => '', 'active' => check_route('finish$')))));
     switch ($action) {
         case 'check':
             $tpl = new Template('Install/templates/check');
             $tpl->show();
             break;
         case 'site':
             append('content', '<p class="alert alert-info">' . t('Определите базовые настройки сайта.') . '</p>');
             $form = new Form('Install/forms/site');
             if ($result = $form->result()) {
                 $site = new Config(SITE . DS . 'site' . EXT);
                 $config = new Config(SITE . DS . 'config' . EXT);
                 $config->site->name = $result->sitename;
                 $site->key or $site->key = md5(md5(time()) + time() + $site->site->name);
                 $result->port or $result->port = 3306;
                 $site->database = array('driver' => config('database.driver'), 'host' => $result->host, 'base' => $result->base, 'user' => $result->user, 'pass' => $result->pass, 'port' => $result->port, 'prefix' => $result->prefix);
                 $db = Db::factory('temp', $site->database);
                 if (!$db->connect()) {
                     if ($result->create_db && $db->connect(FALSE)) {
                         $db->query("CREATE DATABASE `{$site->database->base}` DEFAULT  CHARACTER SET utf8 COLLATE utf8_general_ci;\n                CREATE USER '{$site->database->user}'@'{$site->database->host}' IDENTIFIED BY '{$site->database->pass}';\n                GRANT ALL ON `{$site->database->base}`.* TO '{$site->database->user}'@'localhost';\n                FLUSH PRIVILEGES;");
                     }
                     $db->connect();
                 }
                 if ($db->is_connected) {
                     $site->store(TRUE);
                     $config->store(TRUE);
                     if ($db->import($this->dir . DS . 'cogear.sql', $site->database->prefix)) {
                         redirect(l('/install/finish'));
                     }
                 } else {
                     error(t("Не удалось установить подключение к базе данных."), '', 'content');
                 }
             } else {
                 $form->save->label = t('Попробуйте снова');
             }
             $form->show();
             break;
         case 'finish':
             $tpl = new Template('Install/templates/finish');
             $tpl->show();
             break;
         case 'done':
             //                $site = new Config(SITE . DS . 'site' . EXT);
             //                $site->store(TRUE);
             flash_success(t('Ваш сайт успешно настроен! <p> Данные для входа – логин <b>admin</b> и пароль <b>password</b>.'), '', 'info');
             $this->disable();
             redirect();
             break;
         default:
         case 'welcome':
             $tpl = new Template('Install/templates/welcome');
             $tpl->show();
     }
 }
示例#5
0
文件: Gear.php 项目: brussens/cogear2
 /**
  * Инициализация
  */
 public function init()
 {
     $config = config('database');
     $db = Db::factory('system', $config);
     if ($db->connect()) {
         parent::init();
         $this->object($db);
     }
 }
示例#6
0
 /**
  * 取得数据库连接实例
  * @param string $config 配置
  * @return mixed 实例
  */
 public static function getInstance($config = '')
 {
     $guid = toGUIDString($config);
     if (!isset(self::$_instance[$guid])) {
         $obj = new Db();
         self::$_instance[$guid] = $obj->factory($config);
     }
     return self::$_instance[$guid];
 }
示例#7
0
 /**
  * 取得数据库类实例
  * @static
  * @access public
  * @return mixed 返回数据库驱动类
  */
 public static function getInstance($db_config = '')
 {
     static $_instance = array();
     $guid = to_guid_string($db_config);
     if (!isset($_instance[$guid])) {
         $obj = new Db();
         $_instance[$guid] = $obj->factory($db_config);
     }
     return $_instance[$guid];
 }
示例#8
0
 /**
  * Constructor
  *
  * @param string $tableName Table name to associate with class
  * @param PDO $db PDO instance
  * @return void
  */
 public function __construct($tableName = null, $db = null)
 {
     if ($db == null) {
         if (self::$_defaultDb instanceof PDO) {
             $db = self::$_defaultDb;
         } else {
             $db = Db::factory();
         }
     }
     $this->db = $db;
     if ($tableName != null) {
         $this->name = $tableName;
     } else {
         if ($this->name == null) {
             $this->setDefaultTableName();
         }
     }
 }
示例#9
0
文件: Db.php 项目: agui2200/yaf
 /**
  * 取得数据库类实例
  * @static
  * @access public
  * @return mixed 返回数据库驱动类
  */
 public static function getInstance($db_config = '')
 {
     static $_instance = array();
     $config_str = $db_config;
     if (is_object($config_str) && function_exists('spl_object_hash')) {
         $guid = spl_object_hash($config_str);
     } elseif (is_resource($config_str)) {
         $config_str = get_resource_type($config_str) . strval($config_str);
     } else {
         $config_str = serialize($config_str);
     }
     $guid = md5($config_str);
     if (!isset($_instance[$guid])) {
         $obj = new Db();
         $_instance[$guid] = $obj->factory($db_config);
     }
     return $_instance[$guid];
 }
示例#10
0
 public function deleteKeys($job)
 {
     $data = unserialize($job->workload());
     Log::factory()->write(Log::NOTICE, "Try to delete: {$data['key']} at {$data['server']['host']}:{$data['server']['port']}, DB: {$data['server']['database']}", 'Gearman');
     $db = Db::factory($data['server']);
     $db->changeDB($data['server']['database']);
     $keys = $db->keys($data['key']);
     $count = count($keys);
     if ($count) {
         $db->set("phpredmin:gearman:deletecount:{$data['key']}", $count);
         $db->del("phpredmin:gearman:deleted:{$data['key']}");
         $db->del("phpredmin:gearman:requests:{$data['key']}");
         foreach ($keys as $key) {
             if ($db->delete($key) !== false) {
                 $db->incrBy("phpredmin:gearman:deleted:{$data['key']}", 1);
                 $db->expireAt("phpredmin:gearman:deleted:{$data['key']}", strtotime('+10 minutes'));
             } else {
                 Log::factory()->write(Log::INFO, "Unable to delete {$key}", 'Gearman');
             }
         }
         $db->del("phpredmin:gearman:deletecount:{$data['key']}");
     }
 }
 /**
  * Ejecuta una consulta en el RDBM directamente
  *
  * @param string $sql
  * @return resource
  */
 public static function static_select_one($sql)
 {
     $db = Db::factory();
     if (substr(ltrim($sql), 0, 7) != "SELECT") {
         $sql = "SELECT " . $sql;
     }
     $num = $db->fetch_one($sql);
     return $num[0];
 }
示例#12
0
 /**
  * Constructor
  *
  * @return void
  */
 public function __construct()
 {
     $this->db = Db::factory();
 }
示例#13
0
 /**
  * Método que verifica la conexión con la base de datos
  * @param type $data
  * @param type $source
  * @return boolean 
  */
 public static function testConnection($data, $source, $db = false)
 {
     //Filtro el array con los parámetros
     $data = Filter::data($data, array('host', 'username', 'password', 'name', 'type'), 'trim');
     //Se utiliza por defecto el driver mysqli por ser orientado a objetos
     $data['type'] = 'mysqli';
     $data['charset'] = 'UTF-8';
     try {
         //Seteo las variables del core
         Config::set("databases.{$source}", $data);
         //Reviso la conexión, sino, genera la excepción
         @Db::factory($source, true);
         MkcMessage::valid("Conexión establecida en modo <b>{$source}!</b>");
     } catch (KumbiaException $e) {
         MkcMessage::error("Error en modo '{$source}': <br /> " . $e->getMessage());
         return false;
     }
 }
示例#14
0
 protected function __construct()
 {
     $this->db = Db::factory(App::instance()->current);
 }