本文整理匯總了PHP中InsightMySQLDAO::getAllOwnerInstanceInsights方法的典型用法代碼示例。如果您正苦於以下問題:PHP InsightMySQLDAO::getAllOwnerInstanceInsights方法的具體用法?PHP InsightMySQLDAO::getAllOwnerInstanceInsights怎麽用?PHP InsightMySQLDAO::getAllOwnerInstanceInsights使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類InsightMySQLDAO
的用法示例。
在下文中一共展示了InsightMySQLDAO::getAllOwnerInstanceInsights方法的2個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testGetAllOwnerInstanceInsights
public function testGetAllOwnerInstanceInsights()
{
$builders = array();
//insert a public instance
$builders[] = FixtureBuilder::build('instances', array('id' => 1, 'network_user_id' => 10, 'network_username' => 'jack', 'network' => 'twitter', 'network_viewer_id' => 10, 'crawler_last_run' => '1988-01-20 12:00:00', 'is_active' => 1, 'is_public' => 0));
//insert a private instance
$builders[] = FixtureBuilder::build('instances', array('id' => 2, 'network_user_id' => 12, 'network_username' => 'jill', 'network' => 'twitter', 'network_viewer_id' => 12, 'crawler_last_run' => '2010-01-20 12:00:00', 'is_active' => 1, 'is_public' => 1));
//insert a non-active instance
$builders[] = FixtureBuilder::build('instances', array('id' => 3, 'network_user_id' => 12, 'network_username' => 'jane', 'network' => 'twitter', 'network_viewer_id' => 12, 'crawler_last_run' => '2010-01-20 12:00:00', 'is_active' => 0, 'is_public' => 1));
//insert instance owner
$builders[] = FixtureBuilder::build('owners', array('id' => 1, 'full_name' => 'Owner 1', 'email' => 'owner@example.com'));
$builders[] = FixtureBuilder::build('owner_instances', array('owner_id' => 1, 'instance_id' => 1));
$builders[] = FixtureBuilder::build('owner_instances', array('owner_id' => 1, 'instance_id' => 2));
$builders[] = FixtureBuilder::build('owner_instances', array('owner_id' => 1, 'instance_id' => 3));
//insert 2 insights for a private instance and 3 for a public instance
$time_now = date("Y-m-d H:i:s");
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-02', 'slug' => 'avg_replies_per_week', 'instance_id' => '1', 'text' => 'Retweet spike! Your post got retweeted 110 times', 'emphasis' => Insight::EMPHASIS_HIGH, 'time_generated' => $time_now));
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-01', 'slug' => 'avg_replies_per_week', 'instance_id' => '2', 'text' => 'Retweet spike! Your post got retweeted 110 times', 'emphasis' => Insight::EMPHASIS_HIGH, 'time_generated' => $time_now));
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-02', 'slug' => 'avg_replies_per_week', 'instance_id' => '2', 'text' => 'Retweet spike! Your post got retweeted 110 times', 'emphasis' => Insight::EMPHASIS_HIGH, 'time_generated' => $time_now));
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-03', 'slug' => 'avg_replies_per_week', 'instance_id' => '2', 'text' => 'Retweet spike! Your post got retweeted 110 times', 'emphasis' => Insight::EMPHASIS_HIGH, 'time_generated' => $time_now));
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-01', 'slug' => 'another_slug', 'instance_id' => '1', 'text' => 'Retweet spike! Your post got retweeted 110 times', 'emphasis' => Insight::EMPHASIS_HIGH, 'time_generated' => $time_now));
//insight with no text shouldn't be returned
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-01', 'slug' => 'another_slug', 'instance_id' => '1', 'text' => '', 'emphasis' => Insight::EMPHASIS_HIGH, 'time_generated' => $time_now));
//assert that page of insights includes from both private and public
$dao = new InsightMySQLDAO();
$results = $dao->getAllOwnerInstanceInsights(1, $page_count = 10, $page_number = 1);
$this->assertEqual(sizeof($results), 7);
foreach ($results as $result) {
$this->assertTrue(isset($result->instance));
}
}
示例2: testGetAllOwnerInstanceInsightsPaging
public function testGetAllOwnerInstanceInsightsPaging()
{
$builders = array();
//insert a public instance
$builders[] = FixtureBuilder::build('instances', array('id' => 1, 'network_user_id' => 10, 'network_username' => 'jack', 'network' => 'twitter', 'network_viewer_id' => 10, 'crawler_last_run' => '1988-01-20 12:00:00', 'is_active' => 1, 'is_public' => 0));
//insert a private instance
$builders[] = FixtureBuilder::build('instances', array('id' => 2, 'network_user_id' => 12, 'network_username' => 'jill', 'network' => 'twitter', 'network_viewer_id' => 12, 'crawler_last_run' => '2010-01-20 12:00:00', 'is_active' => 1, 'is_public' => 1));
$time_now = date("Y-m-d H:i:s");
//insert instance owner
$builders[] = FixtureBuilder::build('owners', array('id' => 1, 'full_name' => 'Owner 1', 'email' => 'owner@example.com'));
$builders[] = FixtureBuilder::build('users', array('user_id' => 12, 'network_username' => 'jill'));
$builders[] = FixtureBuilder::build('owner_instances', array('owner_id' => 1, 'instance_id' => 1));
$builders[] = FixtureBuilder::build('owner_instances', array('owner_id' => 1, 'instance_id' => 2));
//Insert 25 insights
$time_now = date("Y-m-d H:i:s");
$i = 25;
while ($i > 0) {
//insert 2 insights for a private instance and 3 for a public instance
$builders[] = FixtureBuilder::build('insights', array('date' => '2012-05-01', 'slug' => 'avg_replies_per_week', 'instance_id' => 2, 'text' => 'Insight ' . $i, 'emphasis' => Insight::EMPHASIS_HIGH, 'time_updated' => $time_now, 'date' => $time_now, 'filename' => 'test.php', 'related_data' => null));
$i--;
}
//Assert that a page of 10 insights with 1 extra comes back correctly
$dao = new InsightMySQLDAO();
$results = $dao->getAllOwnerInstanceInsights(1, $page_count = 11, $page_number = 1);
$this->debug(Utils::varDumpToString($results));
$this->assertEqual(sizeof($results), 11);
$this->assertEqual($results[0]->text, 'Insight 1');
$this->assertEqual($results[9]->text, 'Insight 10');
$this->debug(Utils::varDumpToString($results));
$results = $dao->getAllOwnerInstanceInsights(1, $page_count = 11, $page_number = 2);
$this->assertEqual($results[0]->text, 'Insight 11');
$this->assertEqual($results[9]->text, 'Insight 20');
}