class hostingService_db_mysql in Hostmaster (Aegir) 6
A MySQL specific db service implementation class.
Hierarchy
- class \hostingService
- class \hostingService_db
- class \hostingService_db_mysql
- class \hostingService_db
Expanded class hierarchy of hostingService_db_mysql
File
- modules/
hosting/ db_server/ hosting_db_server.service.inc, line 17 - Provide the hosting serivce classes for database integration.
View source
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' => $this->db_passwd ? FALSE : $this->available,
'#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]);
}
}