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; }