/**
* Test for PMA_getParamsForUpdateOrInsert
*
* @return void
*/
public function testGetParamsForUpdateOrInsert()
{
$_REQUEST['where_clause'] = 'LIMIT 1';
$_REQUEST['submit_type'] = 'showinsert';
$result = PMA_getParamsForUpdateOrInsert();
$this->assertEquals(array(array('LIMIT 1'), true, true, false), $result);
// case 2 (else)
unset($_REQUEST['where_clause']);
$_REQUEST['fields']['multi_edit'] = array('a' => 'b', 'c' => 'd');
$result = PMA_getParamsForUpdateOrInsert();
$this->assertEquals(array(array('a', 'c'), false, true, false), $result);
}
if ($_REQUEST['after_insert'] == 'same_insert') {
$url_params['where_clause'][] = $one_where_clause;
} elseif ($_REQUEST['after_insert'] == 'edit_next') {
PMA_setSessionForEditNext($one_where_clause);
}
}
}
}
//get $goto_include for different cases
$goto_include = PMA_getGotoInclude($goto_include);
// Defines the url to return in case of failure of the query
$err_url = PMA_getErrorUrl($url_params);
/**
* Prepares the update/insert of a row
*/
list($loop_array, $using_key, $is_insert, $is_insertignore) = PMA_getParamsForUpdateOrInsert();
$query = array();
$value_sets = array();
$func_no_param = array('CONNECTION_ID', 'CURRENT_USER', 'CURDATE', 'CURTIME', 'CURRENT_DATE', 'CURRENT_TIME', 'DATABASE', 'LAST_INSERT_ID', 'NOW', 'PI', 'RAND', 'SYSDATE', 'UNIX_TIMESTAMP', 'USER', 'UTC_DATE', 'UTC_TIME', 'UTC_TIMESTAMP', 'UUID', 'UUID_SHORT', 'VERSION');
$func_optional_param = array('RAND', 'UNIX_TIMESTAMP');
$gis_from_text_functions = array('GeomFromText', 'GeomCollFromText', 'LineFromText', 'MLineFromText', 'PointFromText', 'MPointFromText', 'PolyFromText', 'MPolyFromText');
$gis_from_wkb_functions = array('GeomFromWKB', 'GeomCollFromWKB', 'LineFromWKB', 'MLineFromWKB', 'PointFromWKB', 'MPointFromWKB', 'PolyFromWKB', 'MPolyFromWKB');
// to create an object of PMA_File class
require_once './libraries/File.class.php';
//if some posted fields need to be transformed.
$mime_map = PMA_getMIME($GLOBALS['db'], $GLOBALS['table']);
if ($mime_map === false) {
$mime_map = array();
}
$query_fields = array();
$insert_errors = array();
PMA_setSessionForEditNext($one_where_clause);
}
}
}
}
//get $goto_include for different cases
$goto_include = PMA_getGotoInclude($goto_include);
// Defines the url to return in case of failure of the query
$err_url = PMA_getErrorUrl($url_params);
/**
* Prepares the update/insert of a row
*/
list($loop_array, $using_key, $is_insert, $is_insertignore)
= PMA_getParamsForUpdateOrInsert();
$query = array();
$value_sets = array();
$func_no_param = array(
'CONNECTION_ID',
'CURRENT_USER',
'CURDATE',
'CURTIME',
'CURRENT_DATE',
'CURRENT_TIME',
'DATABASE',
'LAST_INSERT_ID',
'NOW',
'PI',
'RAND',