From e8c38773959499d22ffbf63d31a5058aefa941c3 Mon Sep 17 00:00:00 2001
From: Seamus Lee <seamuslee001@gmail.com>
Date: Fri, 12 Nov 2021 11:59:43 +1100
Subject: [PATCH] [NFC] dev/mail#103 Add in unit test to demonstate issue with
 APIv4 and joins

Add comment to test along the lines from Coleman and fix test cleanup

Update test to extend from BaseCustomValueTest
---
 .../api/v4/Entity/ContactCustomJoinTest.php   | 53 +++++++++++++++++++
 1 file changed, 53 insertions(+)
 create mode 100644 tests/phpunit/api/v4/Entity/ContactCustomJoinTest.php

diff --git a/tests/phpunit/api/v4/Entity/ContactCustomJoinTest.php b/tests/phpunit/api/v4/Entity/ContactCustomJoinTest.php
new file mode 100644
index 0000000000..2a92ec0d3a
--- /dev/null
+++ b/tests/phpunit/api/v4/Entity/ContactCustomJoinTest.php
@@ -0,0 +1,53 @@
+<?php
+
+/*
+ +--------------------------------------------------------------------+
+ | Copyright CiviCRM LLC. All rights reserved.                        |
+ |                                                                    |
+ | This work is published under the GNU AGPLv3 license with some      |
+ | permitted exceptions and without any warranty. For full license    |
+ | and copyright information, see https://civicrm.org/licensing       |
+ +--------------------------------------------------------------------+
+ */
+
+/**
+ *
+ * @package CRM
+ * @copyright CiviCRM LLC https://civicrm.org/licensing
+ */
+
+
+namespace api\v4\Entity;
+
+use Civi\Api4\Contact;
+use Civi\Api4\CustomGroup;
+use Civi\Api4\CustomField;
+use api\v4\Action\BaseCustomValueTest;
+
+/**
+ * @group headless
+ */
+class ContactCustomJoinTest extends BaseCustomValueTest {
+
+  /**
+   * Add test to ensure that in the very unusual and not really supported situation where there is a space in the
+   * custom group machine name. This is not supported but has been seen in the wild and as such we have this test to lock in the fix for dev/mail#103
+   */
+  public function testContactCustomJoin() {
+    $customGroup = CustomGroup::create()->setValues([
+      'name' => 'D - Identification_20',
+      'table_name' => 'civicrm_value_demographics',
+      'title' => 'D - Identification',
+      'extends' => 'Individual',
+    ])->execute();
+    \CRM_Core_DAO::executeQuery("UPDATE civicrm_custom_group SET name = 'D - Identification_20' WHERE id = %1", [1 => [$customGroup[0]['id'], 'Integer']]);
+    $customField = CustomField::create()->setValues([
+      'label' => 'Test field',
+      'custom_group_id' => $customGroup[0]['id'],
+      'html_type' => 'Text',
+      'data_type' => 'String',
+    ])->execute();
+    Contact::get()->addSelect('*')->addSelect('custom.*')->execute();
+  }
+
+}
-- 
2.25.1