public function test_array_keep() { $array = ['A' => 1, 'B' => 2, 'C' => 3, 'D' => 4]; $extracted = UtilArray::array_keep_keys(['A', 'B'], $array); $this->assertCount(2, $extracted); $this->assertArrayHasKey('A', $extracted); $this->assertArrayHasKey('B', $extracted); $this->assertEquals(1, $extracted['A']); $this->assertEquals(2, $extracted['B']); $extracted = UtilArray::array_keep_keys(['A', 'B'], $array, true); $this->assertCount(2, $extracted); $this->assertEquals(1, $extracted[0]); $this->assertEquals(2, $extracted[1]); }
/** * @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; }