public function testResolveSearchAttributesDataByRelatedItemIds() { $quote = DatabaseCompatibilityUtil::getQuote(); $rules = new EmailMessageMashableActivityRules(); $searchAttributeData = $rules->resolveSearchAttributesDataByRelatedItemIds(array(4, 5)); $joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('EmailMessage'); $where = RedBeanModelDataProvider::makeWhere('EmailMessage', $searchAttributeData, $joinTablesAdapter); $compareWhere = "(({$quote}emailmessagesender{$quote}.{$quote}personoraccount_item_id{$quote} IN(4,5)) or (1 = "; // Not Coding Standard $compareWhere .= "(select 1 from {$quote}emailmessagerecipient{$quote} emailmessagerecipient where "; $compareWhere .= "{$quote}emailmessagerecipient{$quote}.{$quote}emailmessage_id` = {$quote}emailmessage"; $compareWhere .= "{$quote}.id and {$quote}emailmessagerecipient{$quote}.{$quote}personoraccount_item_id` IN(4,5) limit 1)))"; // Not Coding Standard $this->assertEquals($compareWhere, $where); $sql = EmailMessage::makeSubsetOrCountSqlQuery('emailmessage', $joinTablesAdapter, 1, 5, $where, null); $compareSubsetSql = "select {$quote}emailmessage{$quote}.{$quote}id{$quote} id "; $compareSubsetSql .= "from {$quote}emailmessage{$quote} "; $compareSubsetSql .= "left join {$quote}emailmessagesender{$quote} on "; $compareSubsetSql .= "{$quote}emailmessagesender{$quote}.{$quote}id{$quote} = {$quote}emailmessage{$quote}."; $compareSubsetSql .= "{$quote}sender_emailmessagesender_id{$quote} "; $compareSubsetSql .= "where " . $compareWhere . ' '; $compareSubsetSql .= 'limit 5 offset 1'; $this->assertEquals($compareSubsetSql, $sql); //Make sure the sql runs properly. $data = EmailMessage::getSubset($joinTablesAdapter, 0, 5, $where, null); $this->assertEquals(0, count($data)); }