private function dumpPeopleTable() { $allRows = CW_MySQL::getInstance()->query('SELECT * FROM people'); $isFirstRow = true; $row = $allRows->fetch_assoc(); do { if ($isFirstRow) { foreach ($row as $columnName => $columnValue) { printf(self::ROW_FORMAT, $columnName); echo ' '; } echo "\n"; } foreach ($row as $columnName => $columnValue) { printf(self::ROW_FORMAT, $columnValue); } echo "\n"; } while ($row = $allRows->fetch_assoc()); }
/** * Builds the order clauses from the incoming data, if any are present * * @param $order the order to build from * @return array containing the build SQL order clauses * @throws InvalidArgumentException in the event that any of the incoming data is invalid (i.e. ASK instead of ASC) */ private function buildOrderClauses($order) { $orderClauses = array(); if ($order != null) { array_walk($order, function ($val, $key) use(&$orderClauses) { $val = strtoupper(trim($val)); if ($val != CW_MySQL::OP_ASC && $val != CW_MySQL::OP_DESC) { throw new InvalidArgumentException('Order must either be ASC or DESC. Order column: ' . $key); } $orderClauses[] = CW_MySQL::escapeFieldName($key) . ' ' . $val; }); return $orderClauses; } return $orderClauses; }
public function testLastInsertId() { CW_MySQL::getInstance()->insert('people', array('firstname' => 'testLastInsertId', 'lastname' => 'User', 'age' => 50, 'createdDate' => time())); $lastInsertId = CW_MySQL::getInstance()->getLastInsertId(); //$lastInsertOnly = CW_MySQL::getInstance()->select('people', array('firstname' => 'testLastInsertId')); $results = CW_MySQL::getInstance()->query('SELECT id, firstname FROM people WHERE id=' . $lastInsertId); $this->assertEquals(1, $results->num_rows, 'No row found by ID ' . $lastInsertId); $singleRow = $results->fetch_object(); $this->assertEquals($singleRow->id, $lastInsertId, 'Insert ID from class does not match actual from database.'); $this->assertEquals('testLastInsertId', $singleRow->firstname, 'Inserted name does not match row retrieved via inserted ID'); }