/** * Test update author_username on a series of posts */ public function testUpdateAuthorUsernameByAuthorUserId() { $dao = new PostMySQLDAO(); $post = $dao->getPost(10, 'twitter'); $authorid = $post->author_user_id; // bad id $update_cnt = $dao->updateAuthorUsername(-99, 'twitter', 'newname'); $this->assertEqual($update_cnt, 0); // bad network $update_cnt = $dao->updateAuthorUsername($authorid, 'no-net', 'newname'); $this->assertEqual($update_cnt, 0); // good id $update_cnt = $dao->updateAuthorUsername($authorid, 'twitter', 'newname'); $stmt = PostMySQLDAO::$PDO->query("select * from " . $this->table_prefix . "posts where author_user_id = {$authorid} and network = 'twitter'"); $data_returned = false; $cnt = 0; while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $this->assertEqual($row['author_username'], 'newname'); $data_returned = true; $cnt++; } $stmt->closeCursor(); $this->assertTrue($data_returned); $this->assertEqual($update_cnt, $cnt); }