projects
/
civicrm-core.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
APIv4 - Automatically coalesce potentially null field values in equations
[civicrm-core.git]
/
tests
/
phpunit
/
api
/
v4
/
Action
/
SqlExpressionTest.php
diff --git
a/tests/phpunit/api/v4/Action/SqlExpressionTest.php
b/tests/phpunit/api/v4/Action/SqlExpressionTest.php
index b5fb0a15f68eaf37a6260ccb564b677598adaab1..402bb53ab3c89488d216f8e616b025a2507dd703 100644
(file)
--- a/
tests/phpunit/api/v4/Action/SqlExpressionTest.php
+++ b/
tests/phpunit/api/v4/Action/SqlExpressionTest.php
@@
-108,7
+108,10
@@
class SqlExpressionTest extends UnitTestCase {
'(5 > 11) AS five_greater_eleven',
'(5 <= 11) AS five_less_eleven',
'(1 BETWEEN 0 AND contact_id) AS is_between',
'(5 > 11) AS five_greater_eleven',
'(5 <= 11) AS five_less_eleven',
'(1 BETWEEN 0 AND contact_id) AS is_between',
+ // These fields don't exist
'(illegal * stuff) AS illegal_stuff',
'(illegal * stuff) AS illegal_stuff',
+ // This field will be null
+ '(hold_date + 5) AS null_plus_five',
])
->addWhere('contact_id', '=', $contact['id'])
->setLimit(1)
])
->addWhere('contact_id', '=', $contact['id'])
->setLimit(1)
@@
-121,6
+124,7
@@
class SqlExpressionTest extends UnitTestCase {
$this->assertTrue($result['five_less_eleven']);
$this->assertTrue($result['is_between']);
$this->assertArrayNotHasKey('illegal_stuff', $result);
$this->assertTrue($result['five_less_eleven']);
$this->assertTrue($result['is_between']);
$this->assertArrayNotHasKey('illegal_stuff', $result);
+ $this->assertEquals('5', $result['null_plus_five']);
}
}
}
}