public function mysql_delete()
{
$ws = $this->get_UserWorkspace();
$shares = UserShare::from_property(array("UserWorkspace_id" => $this->UserWorkspace_id, "invitee_id" => $this->invitee_id));
if ($ws != null && count($shares) <= 1) {
$ws->revoke_privileges_db_user($this->invitee_id);
}
parent::mysql_delete();
}
public function mysql_delete()
{
$this->delete_object_links(TestSectionValue::get_mysql_table());
$this->delete_object_links(TestTemplate::get_mysql_table());
parent::mysql_delete();
}
public function mysql_save()
{
$new = false;
if ($this->id == 0) {
$new = true;
}
$lid = parent::mysql_save();
if ($new) {
$ts = TestSession::from_mysql_id($lid);
$ts->hash = TestSession::generate_hash($lid);
$ts->mysql_save();
}
return $lid;
}
public function to_DOMElement($xml_document)
{
$element = parent::to_DOMElement($xml_document);
$element->setAttribute("source", $this->get_external_source());
$element->setAttribute("stored_as", $this->get_stored_as());
return $element;
}
public function create_db_user()
{
$user = Ini::$db_users_name_prefix . $this->id;
$password = User::generate_password();
$db_name = Ini::$db_users_db_name_prefix . $this->id;
$sql = sprintf("CREATE USER '%s'@'localhost' IDENTIFIED BY '%s';", $user, $password);
mysql_query($sql);
$this->db_login = $user;
$this->db_password = $password;
$this->db_name = $db_name;
parent::mysql_save();
$sql = sprintf("CREATE DATABASE `%s` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci", $db_name);
mysql_query($sql);
$sql = sprintf("GRANT ALL PRIVILEGES ON `%s`.* TO '%s'@'localhost'", $db_name, $user);
mysql_query($sql);
Ini::create_db_structure();
}
public function mysql_delete()
{
parent::mysql_delete();
$this->delete_object_links(TableIndexColumn::get_mysql_table());
}
