3 +--------------------------------------------------------------------+
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2018 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
29 * Test that the core actions for APIv3 entities comply with standard syntax+behavior.
31 * By default, this tests all API entities. To only test specific entities, call phpunit with
32 * environment variable SYNTAX_CONFORMANCE_ENTITIES, e.g.
34 * env SYNTAX_CONFORMANCE_ENTITIES="Contact Event" ./scripts/phpunit api_v3_SyntaxConformanceTest
36 * @package CiviCRM_APIv3
37 * @subpackage API_Core
40 class api_v3_SyntaxConformanceTest
extends CiviUnitTestCase
{
41 protected $_apiversion = 3;
44 * @var array e.g. $this->deletes['CRM_Contact_DAO_Contact'][] = $contactID;
46 protected $deletableTestObjects;
49 * This test case doesn't require DB reset.
51 public $DBResetRequired = FALSE;
56 * Map custom group entities to civicrm components.
58 static $componentMap = array(
59 'Contribution' => 'CiviContribute',
60 'Membership' => 'CiviMember',
61 'Participant' => 'CiviEvent',
62 'Event' => 'CiviEvent',
64 'Pledge' => 'CiviPledge',
65 'Grant' => 'CiviGrant',
66 'Campaign' => 'CiviCampaign',
67 'Survey' => 'CiviCampaign',
73 * There are two types of missing APIs:
74 * Those that are to be implemented
75 * (in some future version when someone steps in -hint hint-). List the entities in toBeImplemented[ {$action} ]
76 * Those that don't exist
77 * and that will never exist (eg an obsoleted Entity
78 * they need to be returned by the function toBeSkipped_{$action} (because it has to be a static method and therefore couldn't access a this->toBeSkipped)
80 public function setUp() {
82 $this->enableCiviCampaign();
83 $this->toBeImplemented
['get'] = array(
84 'CxnApp', // CxnApp.get exists but relies on remote data outside our control; QA w/UtilsTest::testBasicArrayGet
96 $this->toBeImplemented
['create'] = array(
110 'SavedSearch', //work fine in local
113 $this->toBeImplemented
['delete'] = array(
126 $this->onlyIDNonZeroCount
['get'] = array(
133 $this->deprecatedAPI
= array('Location', 'ActivityType', 'SurveyRespondant');
134 $this->deletableTestObjects
= array();
137 public function tearDown() {
138 foreach ($this->deletableTestObjects
as $entityName => $entities) {
139 foreach ($entities as $entityID) {
140 CRM_Core_DAO
::deleteTestObjects($entityName, array('id' => $entityID));
146 * Generate list of all entities.
153 public static function entities($skip = array()) {
154 // The order of operations in here is screwy. In the case where SYNTAX_CONFORMANCE_ENTITIES is
155 // defined, we should be able to parse+return it immediately. However, some weird dependency
156 // crept into the system where civicrm_api('Entity','get') must be called as part of entities()
157 // (even if its return value is ignored).
159 $tmp = civicrm_api('Entity', 'Get', array('version' => 3));
160 if (getenv('SYNTAX_CONFORMANCE_ENTITIES')) {
162 'values' => explode(' ', getenv('SYNTAX_CONFORMANCE_ENTITIES')),
166 if (!is_array($skip)) {
169 $tmp = array_diff($tmp['values'], $skip);
171 foreach ($tmp as $e) {
172 $entities[] = array($e);
178 * Get list of entities for get test.
182 public static function entities_get() {
183 // all the entities, beside the ones flagged
184 return static::entities(static::toBeSkipped_get(TRUE));
188 * Get entities for create tests.
192 public static function entities_create() {
193 return static::entities(static::toBeSkipped_create(TRUE));
199 public static function entities_updatesingle() {
200 return static::entities(static::toBeSkipped_updatesingle(TRUE));
206 public static function entities_getlimit() {
207 return static::entities(static::toBeSkipped_getlimit());
211 * Generate list of entities that can be retrieved using SQL operator syntax.
215 public static function entities_getSqlOperators() {
216 return static::entities(static::toBeSkipped_getSqlOperators());
222 public static function entities_delete() {
223 return static::entities(static::toBeSkipped_delete(TRUE));
229 public static function entities_getfields() {
230 return static::entities(static::toBeSkipped_getfields(TRUE));
236 public static function custom_data_entities_get() {
237 return static::custom_data_entities();
243 public static function custom_data_entities() {
244 $entities = CRM_Core_BAO_CustomQuery
::$extendsMap;
245 $enabledComponents = Civi
::settings()->get('enable_components');
246 $customDataEntities = array();
247 $invalidEntities = array('Individual', 'Organization', 'Household');
248 $entitiesToFix = array('Case', 'Relationship');
249 foreach ($entities as $entityName => $entity) {
250 if (!in_array($entityName, $invalidEntities)
251 && !in_array($entityName, $entitiesToFix)
253 if (!empty(self
::$componentMap[$entityName]) && empty($enabledComponents[self
::$componentMap[$entityName]])) {
254 CRM_Core_BAO_ConfigSetting
::enableComponent(self
::$componentMap[$entityName]);
256 $customDataEntities[] = array($entityName);
259 return $customDataEntities;
263 * Add a smattering of entities that don't normally have custom data.
267 public static function custom_data_incl_non_std_entities_get() {
268 return static::entities(static::toBeSkipped_custom_data_creatable(TRUE));
272 * Get entities to be skipped on get tests.
274 * @param bool $sequential
278 public static function toBeSkipped_get($sequential = FALSE) {
279 $entitiesWithoutGet = array(
280 'MailingEventSubscribe',
281 'MailingEventConfirm',
282 'MailingEventResubscribe',
283 'MailingEventUnsubscribe',
286 if ($sequential === TRUE) {
287 return $entitiesWithoutGet;
290 foreach ($entitiesWithoutGet as $e) {
291 $entities[] = array($e);
297 * Get entities to be skipped for get call.
299 * Mailing Contact Just doesn't support id. We have always insisted on finding a way to
300 * support id in API but in this case the underlying tables are crying out for a restructure
301 * & it just doesn't make sense.
303 * User doesn't support get By ID because the user id is actually the CMS user ID & is not part of
304 * CiviCRM - so can only be tested through UserTest - not SyntaxConformanceTest.
306 * Entity doesn't support get By ID because it simply gives the result of string Entites in CiviCRM
308 * @param bool $sequential
311 * Entities that cannot be retrieved by ID
313 public static function toBeSkipped_getByID($sequential = FALSE) {
314 return array('MailingContact', 'User', 'Attachment', 'Entity');
318 * @param bool $sequential
322 public static function toBeSkipped_create($sequential = FALSE) {
323 $entitiesWithoutCreate = array('Constant', 'Entity', 'Location', 'Profile', 'MailingRecipients');
324 if ($sequential === TRUE) {
325 return $entitiesWithoutCreate;
328 foreach ($entitiesWithoutCreate as $e) {
329 $entities[] = array($e);
335 * @param bool $sequential
339 public static function toBeSkipped_delete($sequential = FALSE) {
340 $entitiesWithout = array(
342 'MailingEventConfirm',
343 'MailingEventResubscribe',
344 'MailingEventSubscribe',
345 'MailingEventUnsubscribe',
357 if ($sequential === TRUE) {
358 return $entitiesWithout;
361 foreach ($entitiesWithout as $e) {
362 $entities[] = array($e);
368 * @param bool $sequential
372 public static function toBeSkipped_custom_data_creatable($sequential = FALSE) {
373 $entitiesWithout = array(
383 'MailingEventConfirm',
384 'MailingEventResubscribe',
385 'MailingEventSubscribe',
386 'MailingEventUnsubscribe',
397 // ones that are not real entities hence not extendable.
421 if ($sequential === TRUE) {
422 return $entitiesWithout;
425 foreach ($entitiesWithout as $e) {
426 $entities[] = array($e);
432 * @param bool $sequential
435 * @todo add metadata for ALL these entities
437 public static function toBeSkipped_getfields($sequential = FALSE) {
438 $entitiesWithMetadataNotYetFixed = array('ReportTemplate', 'CustomSearch');
439 if ($sequential === TRUE) {
440 return $entitiesWithMetadataNotYetFixed;
443 foreach ($entitiesWithMetadataNotYetFixed as $e) {
444 $entities[] = array($e);
450 * Generate list of entities to test for get by id functions.
451 * @param bool $sequential
453 * Entities to be skipped
455 public static function toBeSkipped_automock($sequential = FALSE) {
456 $entitiesWithoutGet = array(
469 if ($sequential === TRUE) {
470 return $entitiesWithoutGet;
473 foreach ($entitiesWithoutGet as $e) {
474 $entities[] = array($e);
480 * At this stage exclude the ones that don't pass & add them as we can troubleshoot them
481 * @param bool $sequential
484 public static function toBeSkipped_updatesingle($sequential = FALSE) {
485 $entitiesWithout = array(
487 // pseudo-entity; testUpdateSingleValueAlter doesn't introspect properly on it. Multiple magic fields
489 'MailingEventUnsubscribe',
490 'MailingEventSubscribe',
509 'MailingEventConfirm',
514 'MailingEventResubscribe',
528 //skip this because it doesn't make sense to update logs,
531 if ($sequential === TRUE) {
532 return $entitiesWithout;
535 foreach ($entitiesWithout as $e) {
540 return array('pledge');
545 * At this stage exclude the ones that don't pass & add them as we can troubleshoot them
547 public static function toBeSkipped_getlimit() {
548 $entitiesWithout = array(
550 //case api has non-std mandatory fields one of (case_id, contact_id, activity_id, contact_id)
552 // non-standard api - has inappropriate mandatory fields & doesn't implement limit
554 // failed 'check that a 5 limit returns 5' - probably is_template field is wrong or something, or could be limit doesn't work right
556 // can't handle creating 25
558 // fails on 5 limit - probably a set up problem
560 //a bit of a pseudoapi - keys by domain
562 return $entitiesWithout;
566 * At this stage exclude the ones that don't pass & add them as we can troubleshoot them
568 public static function toBeSkipped_getSqlOperators() {
569 $entitiesWithout = array(
570 'Case', //case api has non-std mandatory fields one of (case_id, contact_id, activity_id, contact_id)
571 'Contact', // on the todo list!
572 'EntityTag', // non-standard api - has inappropriate mandatory fields & doesn't implement limit
573 'Extension', // can't handle creating 25
574 'Note', // note has a default get that isn't implemented in createTestObject -meaning you don't 'get' them
575 'Setting', //a bit of a pseudoapi - keys by domain
577 return $entitiesWithout;
586 public function getKnownUnworkablesUpdateSingle($entity, $key) {
587 // can't update values are values for which updates don't result in the value being changed
588 $knownFailures = array(
589 'ActionSchedule' => array(
590 'cant_update' => array(
594 'ActivityContact' => array(
595 'cant_update' => array(
597 //we have an FK on activity_id + contact_id + record id so if we don't leave this one distinct we get an FK constraint error
601 'cant_update' => array(
602 'state_province_id', //issues with country id - need to ensure same country
604 'master_id', //creates relationship
606 'cant_return' => ['street_parsing', 'skip_geocode', 'fix_address'],
609 'cant_update' => array(
610 'entity_table', // believe this field is defined in error
612 'cant_return' => array(
617 'cant_update' => array(
621 'Domain' => ['cant_update' => ['domain_version']],
622 'MembershipBlock' => array(
623 'cant_update' => array(
624 // The fake/auto-generated values leave us unable to properly cleanup fake data
629 'MailingJob' => ['cant_update' => ['parent_id']],
630 'ContributionSoft' => array(
631 'cant_update' => array(
632 // can't be changed through api
637 'cant_update' => array(
638 // This is being legitimately manipulated to always have a valid primary - skip.
642 'Navigation' => array(
643 'cant_update' => array(
644 // Weight is deliberately altered when this is changed - skip.
648 'LocationType' => array(
649 'cant_update' => array(
650 // I'm on the fence about whether the test should skip or the behaviour is wrong.
651 // display_name is set to match name if display_name is not provided. It would be more 'normal'
652 // to only calculate a default IF id is not set - but perhaps the current behaviour is kind
653 // of what someone updating the name expects..
658 'cant_update' => array(
659 'pledge_original_installment_amount',
661 'original_installment_amount',
663 'amount', // can't be changed through API,
665 'break_return' => array(// if these are passed in they are retrieved from the wrong table
668 'contribution_page_id',
669 'financial_account_id',
673 'cant_return' => array(// can't be retrieved from api
674 'honor_type_id', //due to uniquename missing
682 'initial_reminder_day',
683 'additional_reminder_day',
685 'pledge_contribution_page_id',
687 'pledge_campaign_id',
688 'pledge_financial_type_id',
691 'PaymentProcessorType' => array(
692 'cant_update' => array(
695 'break_return' => array(),
696 'cant_return' => array(),
698 'PriceFieldValue' => array(
699 'cant_update' => array(
700 'weight', //won't update as there is no 1 in the same price set
703 'ReportInstance' => array(
704 // View mode is part of the navigation which is not retrieved by the api.
705 'cant_return' => array('view_mode'),
707 'SavedSearch' => array(
708 // I think the fields below are generated based on form_values.
709 'cant_update' => array(
716 'StatusPreference' => array(
717 'break_return' => array(
722 // For better or worse triggers override.
723 'break_return' => ['run_time'],
724 'cant_update' => ['run_time'],
727 if (empty($knownFailures[$entity]) ||
empty($knownFailures[$entity][$key])) {
730 return $knownFailures[$entity][$key];
733 /* ----- testing the _get ----- */
736 * @dataProvider toBeSkipped_get
737 * Entities that don't need a get action
740 public function testNotImplemented_get($Entity) {
741 $result = civicrm_api($Entity, 'Get', array('version' => 3));
742 $this->assertEquals(1, $result['is_error']);
743 // $this->assertContains("API ($Entity, Get) does not exist", $result['error_message']);
744 $this->assertRegExp('/API (.*) does not exist/', $result['error_message']);
748 * @dataProvider entities
751 public function testWithoutParam_get($Entity) {
752 // should get php complaining that a param is missing
754 $result = civicrm_api($Entity, 'Get');
755 $this->fail('Expected an exception. No exception was thrown.');
757 // As of php7.1 a new Exception is thrown by PHP ArgumentCountError when not enough params are passed.
758 catch (ArgumentCountError
$e) {
761 catch (PHPUnit_Framework_Error
$e) {
767 * @dataProvider entities
770 public function testGetFields($Entity) {
771 if (in_array($Entity, $this->deprecatedAPI
) ||
$Entity == 'Entity' ||
$Entity == 'CustomValue') {
775 $result = civicrm_api($Entity, 'getfields', array('version' => 3));
776 $this->assertTrue(is_array($result['values']), "$Entity ::get fields doesn't return values array in line " . __LINE__
);
777 foreach ($result['values'] as $key => $value) {
778 $this->assertTrue(is_array($value), $Entity . "::" . $key . " is not an array in line " . __LINE__
);
783 * @dataProvider entities_get
786 public function testEmptyParam_get($Entity) {
788 if (in_array($Entity, $this->toBeImplemented
['get'])) {
789 // $this->markTestIncomplete("civicrm_api3_{$Entity}_get to be implemented");
792 $result = civicrm_api($Entity, 'Get', array());
793 $this->assertEquals(1, $result['is_error']);
794 $this->assertContains("Unknown api version", $result['error_message']);
798 * @dataProvider entities_get
801 public function testEmptyParam_getString($Entity) {
803 if (in_array($Entity, $this->toBeImplemented
['get'])) {
804 // $this->markTestIncomplete("civicrm_api3_{$Entity}_get to be implemented");
807 $result = $this->callAPIFailure($Entity, 'Get', 'string');
808 $this->assertEquals(2000, $result['error_code']);
809 $this->assertEquals('Input variable `params` is not an array', $result['error_message']);
813 * @dataProvider entities_get
814 * @Xdepends testEmptyParam_get // no need to test the simple if the empty doesn't work/is skipped. doesn't seem to work
817 public function testSimple_get($Entity) {
818 // $this->markTestSkipped("test gives core error on test server (but not on our locals). Skip until we can get server to pass");
819 if (in_array($Entity, $this->toBeImplemented
['get'])) {
822 $result = civicrm_api($Entity, 'Get', array('version' => 3));
823 // @TODO: list the get that have mandatory params
824 if ($result['is_error']) {
825 $this->assertContains("Mandatory key(s) missing from params array", $result['error_message']);
826 // either id or contact_id or entity_id is one of the field missing
827 $this->assertContains("id", $result['error_message']);
830 $this->assertEquals(3, $result['version']);
831 $this->assertArrayHasKey('count', $result);
832 $this->assertArrayHasKey('values', $result);
837 * @dataProvider custom_data_incl_non_std_entities_get
840 public function testCustomDataGet($entityName) {
841 if ($entityName === 'Note') {
842 $this->markTestIncomplete('Note can not be processed here because of a vagary in the note api, it adds entity_table=contact to the get params when id is not present - which makes sense almost always but kills this test');
844 $this->quickCleanup(array('civicrm_uf_match'));
845 $this->createLoggedInUser();// so subsidiary activities are created
847 $entitiesWithNamingIssues = [
848 'SmsProvider' => 'Provider',
849 'AclRole' => 'EntityRole',
850 'MailingEventQueue' => 'Queue',
853 $usableName = !empty($entitiesWithNamingIssues[$entityName]) ?
$entitiesWithNamingIssues[$entityName] : $entityName;
854 $optionName = CRM_Core_DAO_AllCoreTables
::getTableForClass(CRM_Core_DAO_AllCoreTables
::getFullName($usableName));
856 if (!isset(CRM_Core_BAO_CustomQuery
::$extendsMap[$entityName])) {
857 $createdValue = $this->callAPISuccess('OptionValue', 'create', [
858 'option_group_id' => 'cg_extend_objects',
859 'label' => $usableName,
860 'value' => $usableName,
861 'name' => $optionName,
864 // We are not passing 'check_permissions' so the the more limited permissions *should* be
865 // ignored but per CRM-17700 there is a history of custom data applying permissions when it shouldn't.
866 CRM_Core_Config
::singleton()->userPermissionClass
->permissions
= array('access CiviCRM', 'view my contact');
867 $objects = $this->getMockableBAOObjects($entityName, 1);
869 // simple custom field
870 $ids = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__
, $usableName . 'Test.php');
871 $customFieldName = 'custom_' . $ids['custom_field_id'];
872 $params = array('id' => $objects[0]->id
, 'custom_' . $ids['custom_field_id'] => "custom string");
873 $result = $this->callAPISuccess($entityName, 'create', $params);
874 $this->assertTrue(isset($result['id']), 'no id on ' . $entityName);
875 $getParams = array('id' => $result['id'], 'return' => array($customFieldName));
876 $check = $this->callAPISuccess($entityName, 'get', $getParams);
877 $this->assertTrue(!empty($check['values'][$check['id']][$customFieldName]), 'Custom data not present for ' . $entityName);
878 $this->assertEquals("custom string", $check['values'][$check['id']][$customFieldName], 'Custom data not present for ' . $entityName);
879 $this->customFieldDelete($ids['custom_field_id']);
880 $this->customGroupDelete($ids['custom_group_id']);
882 $ids2 = $this->entityCustomGroupWithSingleStringMultiSelectFieldCreate(__FUNCTION__
, $usableName . 'Test.php');
883 $customFieldNameMultiSelect = 'custom_' . $ids2['custom_field_id'];
884 // String custom field, Multi-Select html type
885 foreach ($ids2['custom_field_group_options'] as $option_value => $option_label) {
886 $params = ['id' => $objects[0]->id
, 'custom_' . $ids2['custom_field_id'] => $option_value];
887 $result = $this->callAPISuccess($entityName, 'create', $params);
888 $getParams = [$customFieldNameMultiSelect => $option_value, 'return' => [$customFieldNameMultiSelect]];
889 $this->callAPISuccessGetCount($entityName, $getParams, 1);
893 $this->customFieldDelete($ids2['custom_field_id']);
894 $this->customGroupDelete($ids2['custom_group_id']);
896 $this->callAPISuccess($entityName, 'delete', array('id' => $result['id']));
897 $this->quickCleanup(array('civicrm_uf_match'));
898 if (!empty($createdValue)) {
899 $this->callAPISuccess('OptionValue', 'delete', ['id' => $createdValue['id']]);
904 * @dataProvider entities_get
907 public function testAcceptsOnlyID_get($Entity) {
908 // big random number. fun fact: if you multiply it by pi^e, the result is another random number, but bigger ;)
909 $nonExistantID = 30867307034;
910 if (in_array($Entity, $this->toBeImplemented
['get'])
911 ||
in_array($Entity, $this->toBeSkipped_getByID())
917 // the below function returns different values and hence an early return
918 // we'll fix this once beta1 is released
921 $result = civicrm_api($Entity, 'Get', array('version' => 3, 'id' => $nonExistantID));
923 if ($result['is_error']) {
924 // just to get a clearer message in the log
925 $this->assertEquals("only id should be enough", $result['error_message']);
927 if (!in_array($Entity, $this->onlyIDNonZeroCount
['get'])) {
928 $this->assertEquals(0, $result['count']);
933 * Create two entities and make sure we can fetch them individually by ID.
935 * @dataProvider entities_get
937 * limitations include the problem with avoiding loops when creating test objects -
938 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
939 * Currency - only seems to support US
942 public function testByID_get($entityName) {
943 if (in_array($entityName, self
::toBeSkipped_automock(TRUE))) {
944 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
948 $baos = $this->getMockableBAOObjects($entityName);
949 list($baoObj1, $baoObj2) = $baos;
952 $result = $this->callAPISuccess($entityName, 'get', array(
953 'id' => $baoObj1->id
,
956 $this->assertTrue(!empty($result['values'][$baoObj1->id
]), 'Should find first object by id');
957 $this->assertEquals($baoObj1->id
, $result['values'][$baoObj1->id
]['id'], 'Should find id on first object');
958 $this->assertEquals(1, count($result['values']));
960 // fetch second by ID
961 $result = $this->callAPISuccess($entityName, 'get', array(
962 'id' => $baoObj2->id
,
964 $this->assertTrue(!empty($result['values'][$baoObj2->id
]), 'Should find second object by id');
965 $this->assertEquals($baoObj2->id
, $result['values'][$baoObj2->id
]['id'], 'Should find id on second object');
966 $this->assertEquals(1, count($result['values']));
970 * Ensure that the "get" operation accepts limiting the #result records.
972 * TODO Consider making a separate entity list ("entities_getlimit")
973 * For the moment, the "entities_updatesingle" list should give a good
974 * sense for which entities support createTestObject
976 * @dataProvider entities_getlimit
978 * @param string $entityName
980 public function testLimit($entityName) {
981 $cases = array(); // each case is array(0 => $inputtedApiOptions, 1 => $expectedResultCount)
983 array('options' => array('limit' => NULL)),
985 'check that a NULL limit returns unlimited',
988 array('options' => array('limit' => FALSE)),
990 'check that a FALSE limit returns unlimited',
993 array('options' => array('limit' => 0)),
995 'check that a 0 limit returns unlimited',
998 array('options' => array('limit' => 5)),
1000 'check that a 5 limit returns 5',
1005 'check that no limit returns 25',
1008 $baoString = _civicrm_api3_get_BAO($entityName);
1009 if (empty($baoString)) {
1010 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
1014 // make 30 test items -- 30 > 25 (the default limit)
1016 for ($i = 0; $i < 30; $i++
) {
1017 $baoObj = CRM_Core_DAO
::createTestObject($baoString, array('currency' => 'USD'));
1018 $ids[] = $baoObj->id
;
1022 // each case is array(0 => $inputtedApiOptions, 1 => $expectedResultCount)
1023 foreach ($cases as $case) {
1024 $this->checkLimitAgainstExpected($entityName, $case[0], $case[1], $case[2]);
1026 //non preferred / legacy syntax
1027 if (isset($case[0]['options']['limit'])) {
1028 $this->checkLimitAgainstExpected($entityName, array('rowCount' => $case[0]['options']['limit']), $case[1], $case[2]);
1029 $this->checkLimitAgainstExpected($entityName, array('option_limit' => $case[0]['options']['limit']), $case[1], $case[2]);
1030 $this->checkLimitAgainstExpected($entityName, array('option.limit' => $case[0]['options']['limit']), $case[1], $case[2]);
1033 foreach ($ids as $id) {
1034 CRM_Core_DAO
::deleteTestObjects($baoString, array('id' => $id));
1040 * Ensure that the "get" operation accepts limiting the #result records.
1042 * @dataProvider entities_getSqlOperators
1044 * @param string $entityName
1046 public function testSqlOperators($entityName) {
1047 $toBeIgnored = array_merge($this->toBeImplemented
['get'],
1048 $this->deprecatedAPI
,
1049 $this->toBeSkipped_get(TRUE),
1050 $this->toBeSkipped_getByID()
1052 if (in_array($entityName, $toBeIgnored)) {
1056 $baoString = _civicrm_api3_get_BAO($entityName);
1058 $entities = $this->callAPISuccess($entityName, 'get', array('options' => array('limit' => 0), 'return' => 'id'));
1059 $entities = array_keys($entities['values']);
1060 $totalEntities = count($entities);
1061 if ($totalEntities < 3) {
1063 for ($i = 0; $i < 3 - $totalEntities; $i++
) {
1064 $baoObj = CRM_Core_DAO
::createTestObject($baoString, array('currency' => 'USD'));
1065 $ids[] = $baoObj->id
;
1070 $entities = $this->callAPISuccess($entityName, 'get', array('options' => array('limit' => 0)));
1071 $entities = array_keys($entities['values']);
1072 $this->assertGreaterThan(2, $totalEntities);
1073 $this->callAPISuccess($entityName, 'getsingle', array('id' => array('IN' => array($entities[0]))));
1074 $this->callAPISuccessGetCount($entityName, array('id' => array('NOT IN' => array($entities[0]))), $totalEntities - 1);
1075 $this->callAPISuccessGetCount($entityName, array('id' => array('>' => $entities[0])), $totalEntities - 1);
1079 * Check that get fetches an appropriate number of results.
1081 * @param string $entityName
1082 * Name of entity to test.
1083 * @param array $params
1085 * @param string $message
1087 public function checkLimitAgainstExpected($entityName, $params, $limit, $message) {
1088 $result = $this->callAPISuccess($entityName, 'get', $params);
1090 $this->assertGreaterThanOrEqual($limit, $result['count'], $message);
1091 $this->assertGreaterThanOrEqual($limit, $result['count'], $message);
1094 $this->assertEquals($limit, $result['count'], $message);
1095 $this->assertEquals($limit, count($result['values']), $message);
1100 * Create two entities and make sure we can fetch them individually by ID (e.g. using "contact_id=>2"
1103 * @dataProvider entities_get
1105 * limitations include the problem with avoiding loops when creating test objects -
1106 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
1107 * Currency - only seems to support US
1108 * @param $entityName
1109 * @throws \PHPUnit_Framework_IncompleteTestError
1111 public function testByIDAlias_get($entityName) {
1112 if (in_array($entityName, self
::toBeSkipped_automock(TRUE))) {
1113 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1117 $baoString = _civicrm_api3_get_BAO($entityName);
1118 if (empty($baoString)) {
1119 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
1123 $idFieldName = _civicrm_api_get_entity_name_from_camel($entityName) . '_id';
1126 $baoObj1 = CRM_Core_DAO
::createTestObject($baoString, array('currency' => 'USD'));
1127 $this->assertTrue(is_int($baoObj1->id
), 'check first id');
1128 $this->deletableTestObjects
[$baoString][] = $baoObj1->id
;
1129 $baoObj2 = CRM_Core_DAO
::createTestObject($baoString, array('currency' => 'USD'));
1130 $this->assertTrue(is_int($baoObj2->id
), 'check second id');
1131 $this->deletableTestObjects
[$baoString][] = $baoObj2->id
;
1133 // fetch first by ID
1134 $result = civicrm_api($entityName, 'get', array(
1136 $idFieldName => $baoObj1->id
,
1138 $this->assertAPISuccess($result);
1139 $this->assertTrue(!empty($result['values'][$baoObj1->id
]), 'Should find first object by id');
1140 $this->assertEquals($baoObj1->id
, $result['values'][$baoObj1->id
]['id'], 'Should find id on first object');
1141 $this->assertEquals(1, count($result['values']));
1143 // fetch second by ID
1144 $result = civicrm_api($entityName, 'get', array(
1146 $idFieldName => $baoObj2->id
,
1148 $this->assertAPISuccess($result);
1149 $this->assertTrue(!empty($result['values'][$baoObj2->id
]), 'Should find second object by id');
1150 $this->assertEquals($baoObj2->id
, $result['values'][$baoObj2->id
]['id'], 'Should find id on second object');
1151 $this->assertEquals(1, count($result['values']));
1155 * @dataProvider entities_get
1158 public function testNonExistantID_get($Entity) {
1159 // cf testAcceptsOnlyID_get
1160 $nonExistantID = 30867307034;
1161 if (in_array($Entity, $this->toBeImplemented
['get'])) {
1165 $result = civicrm_api($Entity, 'Get', array('version' => 3, 'id' => $nonExistantID));
1167 // redundant with testAcceptsOnlyID_get
1168 if ($result['is_error']) {
1172 $this->assertArrayHasKey('version', $result);
1173 $this->assertEquals(3, $result['version']);
1174 if (!in_array($Entity, $this->onlyIDNonZeroCount
['get'])) {
1175 $this->assertEquals(0, $result['count']);
1179 /* ---- testing the _create ---- */
1182 * @dataProvider toBeSkipped_create
1183 entities that don't need a create action
1186 public function testNotImplemented_create($Entity) {
1187 $result = civicrm_api($Entity, 'Create', array('version' => 3));
1188 $this->assertEquals(1, $result['is_error']);
1189 $this->assertContains(strtolower("API ($Entity, Create) does not exist"), strtolower($result['error_message']));
1193 * @dataProvider entities
1194 * @expectedException CiviCRM_API3_Exception
1197 public function testWithoutParam_create($Entity) {
1198 if ($Entity === 'Setting') {
1199 $this->markTestSkipped('It seems OK for setting to skip here as it silently sips invalid params');
1201 elseif ($Entity === 'Mailing') {
1202 $this->markTestSkipped('It seems OK for "Mailing" to skip here because you can create empty drafts');
1204 // should create php complaining that a param is missing
1205 civicrm_api3($Entity, 'Create');
1209 * @dataProvider entities_create
1211 * Check that create doesn't work with an invalid
1213 * @throws \PHPUnit_Framework_IncompleteTestError
1215 public function testInvalidSort_get($Entity) {
1216 $invalidEntitys = array('ActivityType', 'Setting', 'System');
1217 if (in_array($Entity, $invalidEntitys)) {
1218 $this->markTestSkipped('It seems OK for ' . $Entity . ' to skip here as it silently sips invalid params');
1220 $result = $this->callAPIFailure($Entity, 'get', array('options' => array('sort' => 'sleep(1)')));
1224 * @dataProvider entities_create
1226 * Check that create doesn't work with an invalid
1228 * @throws \PHPUnit_Framework_IncompleteTestError
1230 public function testValidSortSingleArrayById_get($Entity) {
1231 $invalidEntitys = array('ActivityType', 'Setting', 'System');
1234 'id desc' => '_id desc',
1235 'id DESC' => '_id DESC',
1236 'id ASC' => '_id ASC',
1237 'id asc' => '_id asc');
1238 foreach ($tests as $test => $expected) {
1239 if (in_array($Entity, $invalidEntitys)) {
1240 $this->markTestSkipped('It seems OK for ' . $Entity . ' to skip here as it silently ignores passed in params');
1242 $params = array('sort' => array($test));
1243 $result = _civicrm_api3_get_options_from_params($params, FALSE, $Entity, 'get');
1244 $lowercase_entity = _civicrm_api_get_entity_name_from_camel($Entity);
1245 $this->assertEquals($lowercase_entity . $expected, $result['sort']);
1250 * @dataProvider entities_create
1252 * Check that create doesn't work with an invalid
1254 * @throws \PHPUnit_Framework_IncompleteTestError
1256 public function testInvalidID_create($Entity) {
1257 // turn test off for noew
1258 $this->markTestIncomplete("Entity [ $Entity ] cannot be mocked - no known DAO");
1260 if (in_array($Entity, $this->toBeImplemented
['create'])) {
1261 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1264 $result = $this->callAPIFailure($Entity, 'Create', array('id' => 999));
1268 * @dataProvider entities
1270 public function testCreateWrongTypeParamTag_create() {
1271 $result = civicrm_api("Tag", 'Create', 'this is not a string');
1272 $this->assertEquals(1, $result['is_error']);
1273 $this->assertEquals("Input variable `params` is not an array", $result['error_message']);
1277 * @dataProvider entities_updatesingle
1279 * limitations include the problem with avoiding loops when creating test objects -
1280 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
1281 * Currency - only seems to support US
1282 * @param $entityName
1284 public function testCreateSingleValueAlter($entityName) {
1285 if (in_array($entityName, $this->toBeImplemented
['create'])) {
1286 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1290 $baoString = _civicrm_api3_get_BAO($entityName);
1291 $this->assertNotEmpty($baoString, $entityName);
1292 $this->assertNotEmpty($entityName, $entityName);
1293 $fieldsGet = $fields = $this->callAPISuccess($entityName, 'getfields', array('action' => 'get', 'options' => array('get_options' => 'all')));
1294 if ($entityName != 'Pledge') {
1295 $fields = $this->callAPISuccess($entityName, 'getfields', array('action' => 'create', 'options' => array('get_options' => 'all')));
1297 $fields = $fields['values'];
1298 $return = array_keys($fieldsGet['values']);
1299 $valuesNotToReturn = $this->getKnownUnworkablesUpdateSingle($entityName, 'break_return');
1300 // these can't be requested as return values
1301 $entityValuesThatDoNotWork = array_merge(
1302 $this->getKnownUnworkablesUpdateSingle($entityName, 'cant_update'),
1303 $this->getKnownUnworkablesUpdateSingle($entityName, 'cant_return'),
1307 $return = array_diff($return, $valuesNotToReturn);
1308 $baoObj = new CRM_Core_DAO();
1309 $baoObj->createTestObject($baoString, array('currency' => 'USD'), 2, 0);
1311 $getEntities = $this->callAPISuccess($entityName, 'get', array(
1313 'return' => $return,
1315 'sort' => 'id DESC',
1320 // lets use first rather than assume only one exists
1321 $entity = $getEntities['values'][0];
1322 $entity2 = $getEntities['values'][1];
1323 $this->deletableTestObjects
[$baoString][] = $entity['id'];
1324 $this->deletableTestObjects
[$baoString][] = $entity2['id'];
1325 // Skip these fields that we never really expect to update well.
1326 $genericFieldsToSkip = ['currency', 'id', strtolower($entityName) . '_id', 'is_primary'];
1327 foreach ($fields as $field => $specs) {
1329 $fieldName = $field;
1331 if (in_array($field, $genericFieldsToSkip)
1332 ||
in_array($field, $entityValuesThatDoNotWork)
1334 //@todo id & entity_id are correct but we should fix currency & frequency_day
1337 $this->assertArrayHasKey('type', $specs, "the _spec function for $entityName field $field does not specify the type");
1338 switch ($specs['type']) {
1339 case CRM_Utils_Type
::T_DATE
:
1340 $entity[$fieldName] = '2012-05-20';
1343 case CRM_Utils_Type
::T_TIMESTAMP
:
1345 $entity[$fieldName] = '2012-05-20 03:05:20';
1348 case CRM_Utils_Type
::T_STRING
:
1349 case CRM_Utils_Type
::T_BLOB
:
1350 case CRM_Utils_Type
::T_MEDIUMBLOB
:
1351 case CRM_Utils_Type
::T_TEXT
:
1352 case CRM_Utils_Type
::T_LONGTEXT
:
1353 case CRM_Utils_Type
::T_EMAIL
:
1354 if ($fieldName == 'form_values' && $entityName == 'SavedSearch') {
1355 // This is a hack for the SavedSearch API.
1356 // It expects form_values to be an array.
1357 // If you want to fix this, you should definitely read this forum
1359 // http://forum.civicrm.org/index.php/topic,33990.0.html
1360 // See also my question on the CiviCRM Stack Exchange:
1361 // https://civicrm.stackexchange.com/questions/3437
1362 $entity[$fieldName] = array('sort_name' => "SortName2");
1365 $entity[$fieldName] = substr('New String', 0, CRM_Utils_Array
::Value('maxlength', $specs, 100));
1366 if ($fieldName == 'email') {
1367 $entity[$fieldName] = strtolower($entity[$fieldName]);
1369 // typecast with array to satisfy changes made in CRM-13160
1370 if ($entityName == 'MembershipType' && in_array($fieldName, array(
1371 'relationship_type_id',
1372 'relationship_direction',
1375 $entity[$fieldName] = (array) $entity[$fieldName];
1380 case CRM_Utils_Type
::T_INT
:
1381 // probably created with a 1
1382 if ($fieldName == 'weight') {
1383 $entity[$fieldName] = 2;
1385 elseif (!empty($specs['FKClassName'])) {
1386 if ($specs['FKClassName'] == $baoString) {
1387 $entity[$fieldName] = (string) $entity2['id'];
1390 if (!empty($entity[$fieldName])) {
1391 $resetFKTo = array($fieldName => $entity[$fieldName]);
1393 $entity[$fieldName] = (string) empty($entity2[$field]) ?
'' : $entity2[$field];
1394 //todo - there isn't always something set here - & our checking on unset values is limited
1395 if (empty($entity[$field])) {
1396 unset($entity[$field]);
1401 $entity[$fieldName] = '6';
1405 case CRM_Utils_Type
::T_BOOLEAN
:
1406 // probably created with a 1
1407 $entity[$fieldName] = '0';
1410 case CRM_Utils_Type
::T_FLOAT
:
1411 case CRM_Utils_Type
::T_MONEY
:
1412 $entity[$field] = '22.75';
1415 case CRM_Utils_Type
::T_URL
:
1416 $entity[$field] = 'warm.beer.com';
1418 if (empty($specs['FKClassName']) && (!empty($specs['pseudoconstant']) ||
!empty($specs['options']))) {
1419 $options = CRM_Utils_Array
::value('options', $specs, array());
1421 //eg. pdf_format id doesn't ship with any
1422 if (isset($specs['pseudoconstant']['optionGroupName'])) {
1423 $optionValue = $this->callAPISuccess('option_value', 'create', array(
1424 'option_group_id' => $specs['pseudoconstant']['optionGroupName'],
1425 'label' => 'new option value',
1428 $optionValue = $optionValue['values'];
1429 $keyColumn = CRM_Utils_Array
::value('keyColumn', $specs['pseudoconstant'], 'value');
1430 $options[$optionValue[0][$keyColumn]] = 'new option value';
1433 $entity[$field] = array_rand($options);
1435 if (!empty($specs['FKClassName']) && !empty($specs['pseudoconstant'])) {
1436 // in the weird situation where a field has both an fk and pseudoconstant defined,
1437 // e.g. campaign_id field, need to flush caches.
1438 // FIXME: Why doesn't creating a campaign clear caches?
1439 civicrm_api3($entityName, 'getfields', array('cache_clear' => 1));
1441 $updateParams = array(
1442 'id' => $entity['id'],
1443 $field => isset($entity[$field]) ?
$entity[$field] : NULL,
1445 if (!empty($specs['serialize'])) {
1446 $updateParams[$field] = $entity[$field] = (array) $specs['serialize'];
1448 if (isset($updateParams['financial_type_id']) && in_array($entityName, array('Grant'))) {
1449 //api has special handling on these 2 fields for backward compatibility reasons
1450 $entity['contribution_type_id'] = $updateParams['financial_type_id'];
1452 if (isset($updateParams['next_sched_contribution_date']) && in_array($entityName, array('ContributionRecur'))) {
1453 //api has special handling on these 2 fields for backward compatibility reasons
1454 $entity['next_sched_contribution'] = $updateParams['next_sched_contribution_date'];
1456 if (isset($updateParams['image'])) {
1457 // Image field is passed through simplifyURL function so may be different, do the same here for comparison
1458 $entity['image'] = CRM_Utils_String
::simplifyURL($updateParams['image'], TRUE);
1460 if (isset($updateParams['thumbnail'])) {
1461 // Thumbnail field is passed through simplifyURL function so may be different, do the same here for comparison
1462 $entity['thumbnail'] = CRM_Utils_String
::simplifyURL($updateParams['thumbnail'], TRUE);
1465 $update = $this->callAPISuccess($entityName, 'create', $updateParams);
1466 $checkParams = array(
1467 'id' => $entity['id'],
1469 'return' => $return,
1471 'sort' => 'id DESC',
1476 $checkEntity = $this->callAPISuccess($entityName, 'getsingle', $checkParams);
1477 if (!empty($specs['serialize']) && !is_array($checkEntity[$field])) {
1478 // Put into serialized format for comparison if 'get' has not returned serialized.
1479 $entity[$field] = CRM_Core_DAO
::serializeField($checkEntity[$field], $specs['serialize']);
1482 $this->assertAPIArrayComparison($entity, $checkEntity, array(), "checking if $fieldName was correctly updated\n" . print_r(array(
1483 'update-params' => $updateParams,
1484 'update-result' => $update,
1485 'getsingle-params' => $checkParams,
1486 'getsingle-result' => $checkEntity,
1487 'expected entity' => $entity,
1490 //reset the foreign key fields because otherwise our cleanup routine fails & some other unexpected stuff can kick in
1491 $entity = array_merge($entity, $resetFKTo);
1492 $updateParams = array_merge($updateParams, $resetFKTo);
1493 $this->callAPISuccess($entityName, 'create', $updateParams);
1494 if (isset($updateParams['financial_type_id']) && in_array($entityName, array('Grant'))) {
1495 //api has special handling on these 2 fields for backward compatibility reasons
1496 $entity['contribution_type_id'] = $updateParams['financial_type_id'];
1498 if (isset($updateParams['next_sched_contribution_date']) && in_array($entityName, array('ContributionRecur'))) {
1499 //api has special handling on these 2 fields for backward compatibility reasons
1500 $entity['next_sched_contribution'] = $updateParams['next_sched_contribution_date'];
1507 /* ---- testing the _getFields ---- */
1509 /* ---- testing the _delete ---- */
1512 * @dataProvider toBeSkipped_delete
1513 entities that don't need a delete action
1516 public function testNotImplemented_delete($Entity) {
1517 $nonExistantID = 151416349;
1518 $result = civicrm_api($Entity, 'Delete', array('version' => 3, 'id' => $nonExistantID));
1519 $this->assertEquals(1, $result['is_error']);
1520 $this->assertContains(strtolower("API ($Entity, Delete) does not exist"), strtolower($result['error_message']));
1524 * @dataProvider entities
1527 public function testWithoutParam_delete($Entity) {
1528 // should delete php complaining that a param is missing
1530 $result = civicrm_api($Entity, 'Delete');
1531 $this->fail('Expected an exception. No exception was thrown.');
1533 // As of php7.1 a new Exception is thrown by PHP ArgumentCountError when not enough params are passed.
1534 catch (ArgumentCountError
$e) {
1537 catch (PHPUnit_Framework_Error
$e) {
1543 * @dataProvider entities_delete
1546 public function testEmptyParam_delete($Entity) {
1547 if (in_array($Entity, $this->toBeImplemented
['delete'])) {
1548 // $this->markTestIncomplete("civicrm_api3_{$Entity}_delete to be implemented");
1551 $result = civicrm_api($Entity, 'Delete', array());
1552 $this->assertEquals(1, $result['is_error']);
1553 $this->assertContains("Unknown api version", $result['error_message']);
1557 * @dataProvider entities_delete
1559 * @throws \PHPUnit_Framework_IncompleteTestError
1561 public function testInvalidID_delete($Entity) {
1562 $result = $this->callAPIFailure($Entity, 'Delete', array('id' => 999999));
1566 * @dataProvider entities
1568 public function testDeleteWrongTypeParamTag_delete() {
1569 $result = civicrm_api("Tag", 'Delete', 'this is not a string');
1570 $this->assertEquals(1, $result['is_error']);
1571 $this->assertEquals("Input variable `params` is not an array", $result['error_message']);
1575 * Create two entities and make sure delete action only deletes one!
1577 * @dataProvider entities_delete
1579 * limitations include the problem with avoiding loops when creating test objects -
1580 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
1581 * Currency - only seems to support US
1582 * @param $entityName
1583 * @throws \PHPUnit_Framework_IncompleteTestError
1585 public function testByID_delete($entityName) {
1586 // turn test off for noew
1587 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
1590 if (in_array($entityName, self
::toBeSkipped_automock(TRUE))) {
1591 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1594 $startCount = $this->callAPISuccess($entityName, 'getcount', array());
1596 $baos = $this->getMockableBAOObjects($entityName, $createcount);
1597 list($baoObj1, $baoObj2) = $baos;
1599 // make sure exactly 2 exist
1600 $result = $this->callAPISuccess($entityName, 'getcount', array(),
1601 $createcount +
$startCount
1604 $this->callAPISuccess($entityName, 'delete', array('id' => $baoObj2->id
));
1605 //make sure 1 less exists now
1606 $result = $this->callAPISuccess($entityName, 'getcount', array(),
1607 ($createcount +
$startCount) - 1
1610 //make sure id #1 exists
1611 $result = $this->callAPISuccess($entityName, 'getcount', array('id' => $baoObj1->id
),
1614 //make sure id #2 desn't exist
1615 $result = $this->callAPISuccess($entityName, 'getcount', array('id' => $baoObj2->id
),
1621 * Create two entities and make sure delete action only deletes one!
1623 * @dataProvider entities_getfields
1626 public function testGetfieldsHasTitle($entity) {
1627 $entities = $this->getEntitiesSupportingCustomFields();
1628 if (in_array($entity, $entities)) {
1629 $ids = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__
, $entity . 'Test.php');
1631 $actions = $this->callAPISuccess($entity, 'getactions', array());
1632 foreach ($actions['values'] as $action) {
1633 if (substr($action, -7) == '_create' ||
substr($action, -4) == '_get' ||
substr($action, -7) == '_delete') {
1634 //getactions can't distinguish between contribution_page.create & contribution_page.create
1637 $fields = $this->callAPISuccess($entity, 'getfields', array('action' => $action));
1638 if (!empty($ids) && in_array($action, array('create', 'get'))) {
1639 $this->assertArrayHasKey('custom_' . $ids['custom_field_id'], $fields['values']);
1642 foreach ($fields['values'] as $fieldName => $fieldSpec) {
1643 $this->assertArrayHasKey('title', $fieldSpec, "no title for $entity - $fieldName on action $action");
1644 $this->assertNotEmpty($fieldSpec['title'], "empty title for $entity - $fieldName");
1648 $this->customFieldDelete($ids['custom_field_id']);
1649 $this->customGroupDelete($ids['custom_group_id']);
1656 public function getEntitiesSupportingCustomFields() {
1657 $entities = self
::custom_data_entities_get();
1658 $returnEntities = array();
1659 foreach ($entities as $entityArray) {
1660 $returnEntities[] = $entityArray[0];
1662 return $returnEntities;
1666 * @param string $entityName
1671 private function getMockableBAOObjects($entityName, $count = 2) {
1672 $baoString = _civicrm_api3_get_BAO($entityName);
1673 if (empty($baoString)) {
1674 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
1679 while ($i < $count) {
1681 $baoObj = CRM_Core_DAO
::createTestObject($baoString, array('currency' => 'USD'));
1682 $this->assertTrue(is_int($baoObj->id
), 'check first id');
1683 $this->deletableTestObjects
[$baoString][] = $baoObj->id
;
1691 * Verify that HTML metacharacters provided as inputs appear consistently.
1694 * At time of writing, the encoding scheme requires (for example) that an
1695 * event title be partially-HTML-escaped before writing to DB. To provide
1696 * consistency, the API must perform extra encoding and decoding on some
1699 * In this example, the event 'title' is subject to encoding, but the
1700 * event 'description' is not.
1702 public function testEncodeDecodeConsistency() {
1704 $createResult = civicrm_api('Event', 'Create', array(
1706 'title' => 'CiviCRM <> TheRest',
1707 'description' => 'TheRest <> CiviCRM',
1708 'event_type_id' => 1,
1710 'start_date' => 20081021,
1712 $this->assertAPISuccess($createResult);
1713 $eventId = $createResult['id'];
1714 $this->assertEquals('CiviCRM <> TheRest', $createResult['values'][$eventId]['title']);
1715 $this->assertEquals('TheRest <> CiviCRM', $createResult['values'][$eventId]['description']);
1717 // Verify "get" handles decoding in result value
1718 $getByIdResult = civicrm_api('Event', 'Get', array(
1722 $this->assertAPISuccess($getByIdResult);
1723 $this->assertEquals('CiviCRM <> TheRest', $getByIdResult['values'][$eventId]['title']);
1724 $this->assertEquals('TheRest <> CiviCRM', $getByIdResult['values'][$eventId]['description']);
1726 // Verify "get" handles encoding in search value
1727 $getByTitleResult = civicrm_api('Event', 'Get', array(
1729 'title' => 'CiviCRM <> TheRest',
1731 $this->assertAPISuccess($getByTitleResult);
1732 $this->assertEquals('CiviCRM <> TheRest', $getByTitleResult['values'][$eventId]['title']);
1733 $this->assertEquals('TheRest <> CiviCRM', $getByTitleResult['values'][$eventId]['description']);
1735 // Verify that "getSingle" handles decoding
1736 $getSingleResult = $this->callAPISuccess('Event', 'GetSingle', array(
1740 $this->assertEquals('CiviCRM <> TheRest', $getSingleResult['title']);
1741 $this->assertEquals('TheRest <> CiviCRM', $getSingleResult['description']);
1743 // Verify that chaining handles decoding
1744 $chainResult = $this->callAPISuccess('Event', 'Get', array(
1746 'api.event.get' => array(),
1748 $this->assertEquals('CiviCRM <> TheRest', $chainResult['values'][$eventId]['title']);
1749 $this->assertEquals('TheRest <> CiviCRM', $chainResult['values'][$eventId]['description']);
1750 $this->assertEquals('CiviCRM <> TheRest', $chainResult['values'][$eventId]['api.event.get']['values'][0]['title']);
1751 $this->assertEquals('TheRest <> CiviCRM', $chainResult['values'][$eventId]['api.event.get']['values'][0]['description']);
1753 // Verify that "setvalue" handles encoding for updates
1754 $setValueTitleResult = civicrm_api('Event', 'setvalue', array(
1758 'value' => 'setValueTitle: CiviCRM <> TheRest',
1760 $this->assertAPISuccess($setValueTitleResult);
1761 $this->assertEquals('setValueTitle: CiviCRM <> TheRest', $setValueTitleResult['values']['title']);
1762 $setValueDescriptionResult = civicrm_api('Event', 'setvalue', array(
1765 'field' => 'description',
1766 'value' => 'setValueDescription: TheRest <> CiviCRM',
1768 //$this->assertTrue((bool)$setValueDescriptionResult['is_error']); // not supported by setValue
1769 $this->assertEquals('setValueDescription: TheRest <> CiviCRM', $setValueDescriptionResult['values']['description']);
1773 * Verify that write operations (create/update) use partial HTML-encoding
1775 * In this example, the event 'title' is subject to encoding, but the
1776 * event 'description' is not.
1778 public function testEncodeWrite() {
1780 $createResult = civicrm_api('Event', 'Create', array(
1782 'title' => 'createNew: CiviCRM <> TheRest',
1783 'description' => 'createNew: TheRest <> CiviCRM',
1784 'event_type_id' => 1,
1786 'start_date' => 20081021,
1788 $this->assertAPISuccess($createResult);
1789 $eventId = $createResult['id'];
1790 $this->assertDBQuery('createNew: CiviCRM <> TheRest', 'SELECT title FROM civicrm_event WHERE id = %1', array(
1791 1 => array($eventId, 'Integer'),
1793 $this->assertDBQuery('createNew: TheRest <> CiviCRM', 'SELECT description FROM civicrm_event WHERE id = %1', array(
1794 1 => array($eventId, 'Integer'),
1797 // Verify that "create" handles encoding for updates
1798 $createWithIdResult = civicrm_api('Event', 'Create', array(
1801 'title' => 'createWithId: CiviCRM <> TheRest',
1802 'description' => 'createWithId: TheRest <> CiviCRM',
1804 $this->assertAPISuccess($createWithIdResult);
1805 $this->assertDBQuery('createWithId: CiviCRM <> TheRest', 'SELECT title FROM civicrm_event WHERE id = %1', array(
1806 1 => array($eventId, 'Integer'),
1808 $this->assertDBQuery('createWithId: TheRest <> CiviCRM', 'SELECT description FROM civicrm_event WHERE id = %1', array(
1809 1 => array($eventId, 'Integer'),
1812 // Verify that "setvalue" handles encoding for updates
1813 $setValueTitleResult = civicrm_api('Event', 'setvalue', array(
1817 'value' => 'setValueTitle: CiviCRM <> TheRest',
1819 $this->assertAPISuccess($setValueTitleResult);
1820 $this->assertDBQuery('setValueTitle: CiviCRM <> TheRest', 'SELECT title FROM civicrm_event WHERE id = %1', array(
1821 1 => array($eventId, 'Integer'),
1823 $setValueDescriptionResult = civicrm_api('Event', 'setvalue', array(
1826 'field' => 'description',
1827 'value' => 'setValueDescription: TheRest <> CiviCRM',
1829 //$this->assertTrue((bool)$setValueDescriptionResult['is_error']); // not supported by setValue
1830 $this->assertAPISuccess($setValueDescriptionResult);
1831 $this->assertDBQuery('setValueDescription: TheRest <> CiviCRM', 'SELECT description FROM civicrm_event WHERE id = %1', array(
1832 1 => array($eventId, 'Integer'),