public function testAddPhoto() { $dao = new PhotoMySQLDAO(); $photo['post_id'] = '3454352543543543'; $photo['author_user_id'] = '1'; $photo['author_username'] = '******'; $photo['author_fullname'] = 'aaron kalair'; $photo['author_avatar'] = 'http://www.avatarland.com'; $photo['post_text'] = 'This is my amazing picture'; $photo['source'] = 'web'; $photo['is_protected'] = false; $photo['pub_date'] = '2013-12-09 12:00:00'; $photo['network'] = 'instagram'; $photo['filter'] = 'hipster'; $photo['standard_resolution_url'] = 'http://distilleryimage0.s3.amazonaws.com/yhgfdh_7.jpg'; $photo['low_resolution_url'] = 'http://distilleryimage0.s3.amazonaws.com/yhgfdh_6.jpg'; $photo['thumbnail_url'] = 'http://distilleryimage0.s3.amazonaws.com/yhgfdh_5.jpg'; $dao->addPhoto($photo); // Now check all the values were inserted $result = $dao->getPhoto('3454352543543543', 'instagram'); $this->assertTrue(isset($result)); $this->assertEqual($result->post_id, '3454352543543543'); $this->assertEqual($result->author_user_id, '1'); $this->assertEqual($result->author_username, 'aaron'); $this->assertEqual($result->author_fullname, 'aaron kalair'); $this->assertEqual($result->author_avatar, 'http://www.avatarland.com'); $this->assertEqual($result->post_text, 'This is my amazing picture'); $this->assertEqual($result->is_protected, false); $this->assertEqual($result->source, 'web'); $this->assertEqual($result->pub_date, '2013-12-09 12:00:00'); $this->assertEqual($result->network, 'instagram'); $this->assertEqual($result->filter, 'hipster'); $srurl = 'http://distilleryimage0.s3.amazonaws.com/yhgfdh_7.jpg'; $this->assertEqual($result->standard_resolution_url, $srurl); $lrurl = 'http://distilleryimage0.s3.amazonaws.com/yhgfdh_6.jpg'; $this->assertEqual($result->low_resolution_url, $lrurl); $tnurl = 'http://distilleryimage0.s3.amazonaws.com/yhgfdh_5.jpg'; $this->assertEqual($result->thumbnail_url, $tnurl); }