APIv4 - Reorganize test classes, don't use transactions for custom value tests

[civicrm-core.git] / tests / phpunit / api / v4 / Action / DateTest.php

diff --git a/tests/phpunit/api/v4/Action/DateTest.php b/tests/phpunit/api/v4/Action/DateTest.php
index 255534510c91e89b5be40c21f49870c3e417012d..b58a59ad06d3a96eb7fa5705138df6ee378aed76 100644 (file)
--- a/tests/phpunit/api/v4/Action/DateTest.php
+++ b/tests/phpunit/api/v4/Action/DateTest.php
@@ -23,12 +23,13 @@ use Civi\Api4\Activity;
 use Civi\Api4\Contact;
 use Civi\Api4\Contribution;
 use Civi\Api4\Relationship;
-use api\v4\UnitTestCase;
+use api\v4\Api4TestBase;
+use Civi\Test\TransactionalInterface;
 
 /**
  * @group headless
  */
-class DateTest extends UnitTestCase {
+class DateTest extends Api4TestBase implements TransactionalInterface {
 
   public function testRelationshipDate() {
     $c1 = Contact::create()
@@ -107,8 +108,9 @@ class DateTest extends UnitTestCase {
     $this->assertContains($act[5], $result);
     $this->assertContains($act[6], $result);
 
+    // Ensure it also works if the DATE() function is used
     $result = Activity::get(FALSE)->addSelect('id')
-      ->addWhere('activity_date_time', '>=', 'this.year')
+      ->addWhere('DATE(activity_date_time)', '>=', 'this.year')
       ->execute()->column('id');
     $this->assertNotContains($act[0], $result);
     $this->assertNotContains($act[1], $result);