class hostingService_db_mysql in Hosting 6.2

A MySQL specific db service implementation class.

Hierarchy

• class \hostingService
  • class \hostingService_db
    • class \hostingService_db_mysql

File

db_server/hosting_db_server.service.inc, line 17

Provide the hosting serivce classes for database integration.

class hostingService_db_mysql extends hostingService_db {
  public $type = 'mysql';
  public $has_port = TRUE;
  function default_port() {
    return 3306;
  }
  function form(&$form) {
    parent::form($form);
    $form['db_user'] = array(
      '#type' => 'textfield',
      '#required' => $this->available,
      '#title' => t('Username'),
      '#description' => t('The user that will be used to create new mysql users and databases for new sites.'),
      '#size' => 40,
      '#default_value' => $this->db_user,
      '#maxlength' => 64,
      '#weight' => 5,
    );
    if ($this->db_passwd) {
      $passwd_description = t('<strong>You have already set a password for this database server.</strong><br />');
    }
    $form['db_passwd'] = array(
      '#type' => 'password_confirm',
      '#required' => FALSE,
      '#description' => $passwd_description . t('The password for the user that will be used to create new mysql users and databases for new sites'),
      '#size' => 30,
      '#weight' => 10,
    );
  }
  function insert() {
    parent::insert();
    db_query("INSERT INTO {hosting_db_server} (vid, nid, db_user, db_passwd) \n      VALUES (%d, %d, '%s', '%s')", $this->server->vid, $this->server->nid, $this->db_user, $this->db_passwd);
  }
  function update() {
    if (!empty($this->db_passwd)) {
      parent::update();
    }
    else {

      // only do the parent's update routine.
      parent::delete_revision();
      parent::insert();
    }
  }
  function delete_revision() {
    parent::delete_revision();
    db_query('DELETE FROM {hosting_db_server} WHERE vid = %d', $this->server->vid);
  }
  function delete() {
    parent::delete();
    db_query('DELETE FROM {hosting_db_server} WHERE nid = %d', $this->server->nid);
  }
  function load() {
    parent::load();
    $this
      ->mergeData('SELECT db_user, db_passwd FROM {hosting_db_server} WHERE vid = %d', $this->server->vid);
  }
  function view(&$render) {
    parent::view($render);
    $render['db_user'] = array(
      '#type' => 'item',
      '#title' => t('Database user'),
      '#value' => filter_xss($this->db_user),
    );
  }
  public function context_options($task_type, $ref_type, &$task) {
    parent::context_options($task_type, $ref_type, $task);

    // Provide context_options for verification and writing out to an alias
    $task->context_options['master_db'] = 'mysql' . '://' . urlencode($this->db_user) . ':' . urlencode($this->db_passwd) . '@' . $this->server->title;
  }
  public function context_import($context) {
    parent::context_import($context);
    $matches = array();
    preg_match("+^mysql://(.*):(.*)@.*\$+", stripslashes($context->master_db), $matches);
    $this->db_user = urldecode($matches[1]);
    $this->db_passwd = urldecode($matches[2]);
  }

}

Members

Name	Modifiers	Type	Description	Overrides
hostingService::$has_restart_cmd	protected	property		8
hostingService::$server	public	property
hostingService::default_restart_cmd	public	function		8
hostingService::has_port	public	function		3
hostingService::mergeData	protected	function
hostingService::save	public	function
hostingService::setValues	public	function
hostingService::validate	public	function		2
hostingService::__construct		function
hostingService_db::$service	public	property
hostingService_db_mysql::$has_port	public	property	Overrides hostingService::$has_port
hostingService_db_mysql::$type	public	property
hostingService_db_mysql::context_import	public	function	Overrides hostingService::context_import
hostingService_db_mysql::context_options	public	function	Overrides hostingService::context_options
hostingService_db_mysql::default_port		function	Overrides hostingService::default_port
hostingService_db_mysql::delete		function	Overrides hostingService::delete
hostingService_db_mysql::delete_revision		function	Overrides hostingService::delete_revision
hostingService_db_mysql::form		function	Overrides hostingService::form
hostingService_db_mysql::insert		function	Overrides hostingService::insert
hostingService_db_mysql::load		function	Overrides hostingService::load
hostingService_db_mysql::update		function	Overrides hostingService::update
hostingService_db_mysql::view		function	Overrides hostingService::view