public function testDisplayCalculationInferredRelationModelAttributeWithCastingHintToNotCastDowButAlsoWithFullCastDown()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Meeting');
$selectQueryAdapter = new RedBeanModelSelectQueryAdapter();
$builder = new DisplayAttributesReportQueryBuilder($joinTablesAdapter, $selectQueryAdapter);
$displayAttribute = new DisplayAttributeForReportForm('MeetingsModule', 'Meeting', Report::TYPE_SUMMATION);
$displayAttribute->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___createdDateTime__Maximum';
$displayAttribute2 = new DisplayAttributeForReportForm('MeetingsModule', 'Meeting', Report::TYPE_SUMMATION);
$displayAttribute2->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___name';
$content = $builder->makeQueryContent(array($displayAttribute, $displayAttribute2));
$compareContent = "select max({$q}item{$q}.{$q}createddatetime{$q}) col0, " . "{$q}account{$q}.{$q}id{$q} accountid ";
$this->assertEquals($compareContent, $content);
$leftTablesAndAliases = $joinTablesAdapter->getLeftTablesAndAliases();
$fromTablesAndAliases = $joinTablesAdapter->getFromTablesAndAliases();
$this->assertEquals(1, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(5, $joinTablesAdapter->getLeftTableJoinCount());
$this->assertEquals('activity_item', $leftTablesAndAliases[0]['tableAliasName']);
$this->assertEquals('activity', $leftTablesAndAliases[0]['onTableAliasName']);
$this->assertEquals('item', $leftTablesAndAliases[1]['tableAliasName']);
$this->assertEquals('activity_item', $leftTablesAndAliases[1]['onTableAliasName']);
$this->assertEquals('securableitem', $leftTablesAndAliases[2]['tableAliasName']);
$this->assertEquals('item', $leftTablesAndAliases[2]['onTableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[3]['tableAliasName']);
$this->assertEquals('securableitem', $leftTablesAndAliases[3]['onTableAliasName']);
$this->assertEquals('account', $leftTablesAndAliases[4]['tableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[4]['onTableAliasName']);
}
/**
* After work on reporting branch, this test was breaking. So we switched the test to show left joins as
* 0. This might be ok, just depends how you are using the adapter. Normally you would add more
* filters in which case a join would be added if you are filtering on something specific with industry
* @depends testResolveShouldAddFromTableWithAttributeOnModelSameTable
*/
public function testResolveShouldAddFromTableWithOwnedCustomFieldAttribute()
{
$adapter = new RedBeanModelAttributeToDataProviderAdapter('Account', 'industry');
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Account');
$builder = new ModelWhereAndJoinBuilder($adapter, $joinTablesAdapter, true);
$tableAliasName = $builder->resolveJoins();
$this->assertEquals(0, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(0, $joinTablesAdapter->getLeftTableJoinCount());
$adapter = new RedBeanModelAttributeToDataProviderAdapter('Account', 'industry');
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Account');
$builder = new ModelWhereAndJoinBuilder($adapter, $joinTablesAdapter, false);
$tableAliasName = $builder->resolveJoins();
$this->assertEquals(0, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(0, $joinTablesAdapter->getLeftTableJoinCount());
}
public function testAddLeftTableAndGetAliasNameWithSpecifiedOnTableAliasName()
{
$quote = DatabaseCompatibilityUtil::getQuote();
$adapter = new RedBeanModelJoinTablesQueryAdapter('QueryFromModel');
$alias = $adapter->addLeftTableAndGetAliasName('zz', 'joinid');
$this->assertEquals('zz', $alias);
$this->assertEquals(0, $adapter->getFromTableJoinCount());
$this->assertEquals(1, $adapter->getLeftTableJoinCount());
$fromPart = $adapter->getJoinFromQueryPart();
$joinPart = $adapter->getJoinQueryPart();
$wherePart = $adapter->getJoinWhereQueryPart();
$compareFromPart = null;
$compareJoinPart = "left join {$quote}zz{$quote} ";
$compareJoinPart .= "on {$quote}zz{$quote}.{$quote}id{$quote} = {$quote}queryfrommodel{$quote}.{$quote}joinid{$quote} ";
$compareWherePart = null;
$this->assertEquals($compareFromPart, $fromPart);
$this->assertEquals($compareJoinPart, $joinPart);
$this->assertEquals($compareWherePart, $wherePart);
//Now add a specified onTableAliasName
$alias = $adapter->addLeftTableAndGetAliasName('xyz', 'ajoinid', 'zz');
$this->assertEquals('xyz', $alias);
$this->assertEquals(0, $adapter->getFromTableJoinCount());
$this->assertEquals(2, $adapter->getLeftTableJoinCount());
$fromPart = $adapter->getJoinFromQueryPart();
$joinPart = $adapter->getJoinQueryPart();
$wherePart = $adapter->getJoinWhereQueryPart();
$compareFromPart = null;
$compareJoinPart = "left join {$quote}zz{$quote} ";
$compareJoinPart .= "on {$quote}zz{$quote}.{$quote}id{$quote} = {$quote}queryfrommodel{$quote}.{$quote}joinid{$quote} ";
$compareJoinPart .= "left join {$quote}xyz{$quote} ";
$compareJoinPart .= "on {$quote}xyz{$quote}.{$quote}id{$quote} = {$quote}zz{$quote}.{$quote}ajoinid{$quote} ";
$compareWherePart = null;
$this->assertEquals($compareFromPart, $fromPart);
$this->assertEquals($compareJoinPart, $joinPart);
$this->assertEquals($compareWherePart, $wherePart);
}
public function testInferredRelationModelAttributeWithCastingHintToNotCastDownSoFarWithItemAttribute()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Meeting');
$builder = new FiltersReportQueryBuilder($joinTablesAdapter, '1');
$filter = new FilterForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$filter->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___ReadOptimization';
$content = $builder->makeQueryContent(array($filter));
$compareContent = "({$q}ownedsecurableitem{$q}.{$q}securableitem_id{$q} = (select securableitem_id " . "from {$q}account_read{$q} where {$q}securableitem_id{$q} = {$q}ownedsecurableitem" . "{$q}.{$q}securableitem_id{$q} and {$q}munge_id{$q} in ('U" . self::$superUserId . "', 'G" . self::$everyoneGroupId . "') limit 1))";
$this->assertEquals($compareContent, $content);
$this->assertEquals(1, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(4, $joinTablesAdapter->getLeftTableJoinCount());
}
public function testInferredRelationModelAttributeWithCastingHintToNotCastDowButAlsoWithFullCastDown()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Meeting');
$builder = new OrderBysReportQueryBuilder($joinTablesAdapter);
$orderBy = new OrderByForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$orderBy->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___createdDateTime';
$orderBy2 = new OrderByForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$orderBy2->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___name';
$content = $builder->makeQueryContent(array($orderBy, $orderBy2));
$compareContent = "{$q}item{$q}.{$q}createddatetime{$q} asc, " . "{$q}account{$q}.{$q}name{$q} asc";
$this->assertEquals($compareContent, $content);
$leftTablesAndAliases = $joinTablesAdapter->getLeftTablesAndAliases();
$fromTablesAndAliases = $joinTablesAdapter->getFromTablesAndAliases();
$this->assertEquals(1, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(5, $joinTablesAdapter->getLeftTableJoinCount());
$this->assertEquals('activity_item', $leftTablesAndAliases[0]['tableAliasName']);
$this->assertEquals('activity', $leftTablesAndAliases[0]['onTableAliasName']);
$this->assertEquals('item', $leftTablesAndAliases[1]['tableAliasName']);
$this->assertEquals('activity_item', $leftTablesAndAliases[1]['onTableAliasName']);
$this->assertEquals('securableitem', $leftTablesAndAliases[2]['tableAliasName']);
$this->assertEquals('item', $leftTablesAndAliases[2]['onTableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[3]['tableAliasName']);
$this->assertEquals('securableitem', $leftTablesAndAliases[3]['onTableAliasName']);
$this->assertEquals('account', $leftTablesAndAliases[4]['tableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[4]['onTableAliasName']);
}
public function testCreatedDateTimeFilterWithInferredRelationModelAttributeAsDisplay()
{
$q = DatabaseCompatibilityUtil::getQuote();
$selectQueryAdapter = new RedBeanModelSelectQueryAdapter();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Meeting');
$builder = new DisplayAttributesReportQueryBuilder($joinTablesAdapter, $selectQueryAdapter, Report::CURRENCY_CONVERSION_TYPE_ACTUAL);
$displayAttribute = new DisplayAttributeForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$displayAttribute->attributeIndexOrDerivedType = 'Account__activityItems__Inferred___name';
$builder->makeQueryContent(array($displayAttribute));
$builder = new FiltersReportQueryBuilder($joinTablesAdapter, '1');
$filter = new FilterForReportForm('MeetingsModule', 'Meeting', Report::TYPE_ROWS_AND_COLUMNS);
$filter->attributeIndexOrDerivedType = 'createdDateTime';
$filter->valueType = MixedDateTypesSearchFormAttributeMappingRules::TYPE_BETWEEN;
$filter->value = '1991-05-05';
$filter->secondValue = '1991-06-05';
$filter->availableAtRunTime = true;
$content = $builder->makeQueryContent(array($filter));
$compareContent = "((({$q}item1{$q}.{$q}createddatetime{$q} >= '1991-05-05 00:00:00') " . "and ({$q}item1{$q}.{$q}createddatetime{$q} <= '1991-06-05 23:59:59')))";
$this->assertEquals($compareContent, $content);
$this->assertEquals(4, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(5, $joinTablesAdapter->getLeftTableJoinCount());
$builder = new FiltersReportQueryBuilder($joinTablesAdapter, 'not 1');
$content = $builder->makeQueryContent(array($filter));
$compareContent = "(not (({$q}item1{$q}.{$q}createddatetime{$q} >= '1991-05-05 00:00:00') " . "and ({$q}item1{$q}.{$q}createddatetime{$q} <= '1991-06-05 23:59:59')))";
$this->assertEquals($compareContent, $content);
}
public function testHasManyForHasManyBelongsToOnCastedUpModel()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('ReportModelTestItem9');
$builder = new GroupBysReportQueryBuilder($joinTablesAdapter);
$groupBy = new GroupByForReportForm('ReportsTestModule', 'ReportModelTestItem9', Report::TYPE_SUMMATION);
$groupBy->attributeIndexOrDerivedType = 'reportModelTestItem9s___owner__User';
$content = $builder->makeQueryContent(array($groupBy));
$compareContent = "{$q}_user{$q}.{$q}id{$q}";
$this->assertEquals($compareContent, $content);
$leftTablesAndAliases = $joinTablesAdapter->getLeftTablesAndAliases();
$fromTablesAndAliases = $joinTablesAdapter->getFromTablesAndAliases();
$this->assertEquals(0, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(3, $joinTablesAdapter->getLeftTableJoinCount());
$this->assertEquals('reportmodeltestitem91', $leftTablesAndAliases[0]['tableAliasName']);
$this->assertEquals('reportmodeltestitem9', $leftTablesAndAliases[0]['onTableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[1]['tableAliasName']);
$this->assertEquals('reportmodeltestitem91', $leftTablesAndAliases[1]['onTableAliasName']);
$this->assertEquals('id', $leftTablesAndAliases[1]['tableJoinIdName']);
$this->assertEquals('_user', $leftTablesAndAliases[2]['tableAliasName']);
$this->assertEquals('ownedsecurableitem', $leftTablesAndAliases[2]['onTableAliasName']);
}
/**
* Tag cloud should utilize a sub-query as part of its query.
*/
public function testASingleTagCloudAttributeWithEqualsOperator()
{
$q = DatabaseCompatibilityUtil::getQuote();
$joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('ReportModelTestItem');
$builder = new FiltersReportQueryBuilder($joinTablesAdapter, '1');
$filter = new FilterForReportForm('ReportsTestModule', 'ReportModelTestItem', Report::TYPE_ROWS_AND_COLUMNS);
$filter->attributeIndexOrDerivedType = 'tagCloud';
$filter->value = 'a';
$filter->operator = OperatorRules::TYPE_EQUALS;
$content = $builder->makeQueryContent(array($filter));
$leftTablesAndAliases = $joinTablesAdapter->getLeftTablesAndAliases();
$fromTablesAndAliases = $joinTablesAdapter->getFromTablesAndAliases();
$compareContent = "((1 = (select 1 from {$q}customfieldvalue{$q} customfieldvalue where " . "{$q}customfieldvalue{$q}.{$q}multiplevaluescustomfield_id{$q} = {$q}" . "multiplevaluescustomfield{$q}.id and {$q}customfieldvalue{$q}.{$q}value{$q}" . " = 'a' limit 1)))";
$this->assertEquals($compareContent, $content);
$this->assertEquals(0, $joinTablesAdapter->getFromTableJoinCount());
$this->assertEquals(1, $joinTablesAdapter->getLeftTableJoinCount());
$this->assertEquals('multiplevaluescustomfield', $leftTablesAndAliases[0]['tableAliasName']);
$this->assertEquals('reportmodeltestitem', $leftTablesAndAliases[0]['onTableAliasName']);
}
