/**
* Get HTML snippet for privileges that are attached to a specific column
*
* @param string $columns olumns array
* @param array $row first row from result or boolean false
*
* @return string $html_output
*/
function PMA_getHtmlForAttachedPrivilegesToTableSpecificColumn($columns, $row)
{
$html_output = PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'Select_priv', 'SELECT', 'select', __('Allows reading data.'), 'Select');
$html_output .= PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'Insert_priv', 'INSERT', 'insert', __('Allows inserting and replacing data.'), 'Insert');
$html_output .= PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'Update_priv', 'UPDATE', 'update', __('Allows changing data.'), 'Update');
$html_output .= PMA_getHtmlForDisplayColumnPrivileges($columns, $row, 'References_priv', 'REFERENCES', 'references', __('Has no effect in this MySQL version.'), 'References');
return $html_output;
}
/**
* Test for PMA_getHtmlForDisplayColumnPrivileges
*
* @return void
*/
public function testPMAGetHtmlForDisplayColumnPrivileges()
{
$columns = array(
'row1' => 'name1'
);
$row = array(
'name_for_select' => 'Y'
);
$name_for_select = 'name_for_select';
$priv_for_header = 'priv_for_header';
$name = 'name';
$name_for_dfn = 'name_for_dfn';
$name_for_current = 'name_for_current';
$html = PMA_getHtmlForDisplayColumnPrivileges(
$columns, $row, $name_for_select,
$priv_for_header, $name, $name_for_dfn, $name_for_current
);
//$name
$this->assertContains(
$name,
$html
);
//$name_for_dfn
$this->assertContains(
$name_for_dfn,
$html
);
//$priv_for_header
$this->assertContains(
$priv_for_header,
$html
);
//$name_for_select
$this->assertContains(
$name_for_select,
$html
);
//$columns and $row
$this->assertContains(
htmlspecialchars('row1'),
$html
);
//$columns and $row
$this->assertContains(
_pgettext('None privileges', 'None'),
$html
);
}
