function test_text_linearize()
{
$inputText = "ABC \n\n DEF\r\nGHI\r\n\r\nJKL \n";
$expected = "ABC DEF GHI JKL ";
$this->assertEquals($expected, UtilString::text_linearize($inputText));
$inputText = "ABC \n\n DEF\r\nGHI\r\n\r\nJKL \n";
$expected = "ABC DEF GHI JKL ";
$this->assertEquals($expected, UtilString::text_linearize($inputText, true));
$inputText = "ABC \n\n DEF\r\nGHI\r\n\r\nJKL \n";
$expected = "ABC DEF GHI JKL";
$this->assertEquals($expected, UtilString::text_linearize($inputText, true, true));
$inputText = "ABC \n\n DEF\r\nGHI\r\n\r\nJKL \n\r\n ";
$expected = "ABC DEF GHI JKL";
$this->assertEquals($expected, UtilString::text_linearize($inputText, true, true));
}
/**
* @see \dbeurive\Backend\Database\EntryPoints\AbstractEntryPoint
*/
public function execute($inExecutionConfig)
{
/* @var \PDO $pdo */
$pdo = $this->getDbh();
$result = new SqlResult();
$fieldsValues = UtilArray::array_keep_keys(self::$__conditionFields, $inExecutionConfig, true);
$req = $pdo->prepare($this->__sql());
if (false === $req->execute($fieldsValues)) {
$message = "SQL request failed:\n" . UtilString::text_linearize($sql, true, true) . "\n" . "Condition fields: " . implode(', ', self::$__conditionFields) . "\n" . "Bound to values: " . implode(', ', $fieldsValues);
$result->setErrorMessage($message);
return $result;
}
$result->setDataSets($req->fetchAll(\PDO::FETCH_ASSOC));
return $result;
}
/**
* @see \dbeurive\Backend\Database\EntryPoints\AbstractEntryPoint
*/
public function execute($inExecutionConfig)
{
/* @var \PDO $pdo */
$pdo = $this->getDbh();
// Execute the request.
$result = new BaseResult();
$fieldsValues = UtilArray::array_keep_keys(self::$__insertedFields, $inExecutionConfig, true);
$req = $pdo->prepare($this->__sql);
if (false === $req->execute($fieldsValues)) {
$message = "SQL request failed:\n" . UtilString::text_linearize($this->__sql, true, true) . "\n" . "Condition fields: " . implode(', ', self::$__insertedFields) . "\n" . "Bound to values: " . implode(', ', $fieldsValues);
$result->setErrorMessage($message);
return $result;
}
$result->setStatusSuccess();
return $result;
}
