Merge pull request #5883 from mallezie/addfield-website
[civicrm-core.git] / tests / phpunit / api / v3 / SyntaxConformanceTest.php
CommitLineData
6a488035
TO
1<?php
2/*
3 +--------------------------------------------------------------------+
39de6fd5 4 | CiviCRM version 4.6 |
6a488035 5 +--------------------------------------------------------------------+
e7112fa7 6 | Copyright CiviCRM LLC (c) 2004-2015 |
6a488035
TO
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
9 | |
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. |
13 | |
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. |
18 | |
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 +--------------------------------------------------------------------+
d25dd0ee 26 */
6a488035
TO
27
28require_once 'CiviTest/CiviUnitTestCase.php';
29
30
31/**
e5dd95b2 32 * Test that the core actions for APIv3 entities comply with standard syntax+behavior.
6a488035 33 *
e5dd95b2
TO
34 * By default, this tests all API entities. To only test specific entities, call phpunit with
35 * environment variable SYNTAX_CONFORMANCE_ENTITIES, e.g.
36 *
37 * env SYNTAX_CONFORMANCE_ENTITIES="Contact Event" ./scripts/phpunit api_v3_SyntaxConformanceTest
38 *
39 * @package CiviCRM_APIv3
40 * @subpackage API_Core
6a488035 41 */
8086a0bf 42class api_v3_SyntaxConformanceTest extends CiviUnitTestCase {
18eee50e 43 protected $_apiversion = 3;
6a488035 44
4a97890c
TO
45 /**
46 * @var array e.g. $this->deletes['CRM_Contact_DAO_Contact'][] = $contactID;
47 */
48 protected $deletableTestObjects;
49
be2e0c6a
TO
50 /**
51 * This test case doesn't require DB reset.
52 */
6a488035 53 public $DBResetRequired = FALSE;
6ead217b 54
8efea814
EM
55 protected $_entity;
56
be2e0c6a
TO
57 /**
58 * Map custom group entities to civicrm components.
59 */
82e1689e 60 static $componentMap = array(
82e1689e
N
61 'Contribution' => 'CiviContribute',
62 'Membership' => 'CiviMember',
63 'Participant' => 'CiviEvent',
82e1689e
N
64 'Event' => 'CiviEvent',
65 'Case' => 'CiviCase',
82e1689e
N
66 'Pledge' => 'CiviPledge',
67 'Grant' => 'CiviGrant',
bf38705f 68 'Campaign' => 'CiviCampaign',
69 'Survey' => 'CiviCampaign',
82e1689e
N
70 );
71
63e9c3fd
EM
72 /**
73 * Set up function.
74 *
75 * There are two types of missing APIs:
76 * Those that are to be implemented
77 * (in some future version when someone steps in -hint hint-). List the entities in toBeImplemented[ {$action} ]
78 * Those that don't exist
79 * and that will never exist (eg an obsoleted Entity
80 * 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)
81 */
00be9182 82 public function setUp() {
6a488035 83 parent::setUp();
6ead217b 84 $this->enableCiviCampaign();
92915c55
TO
85 $this->toBeImplemented['get'] = array(
86 'Profile',
87 'CustomValue',
88 'Constant',
89 'CustomSearch',
90 'Extension',
91 'ReportTemplate',
92 'System',
db7de9c1 93 'Setting',
92915c55
TO
94 );
95 $this->toBeImplemented['create'] = array(
96 'SurveyRespondant',
97 'OptionGroup',
98 'MailingRecipients',
99 'UFMatch',
100 'LocationType',
101 'CustomSearch',
102 'Extension',
103 'ReportTemplate',
db7de9c1 104 'System',
92915c55
TO
105 );
106 $this->toBeImplemented['delete'] = array(
107 'MembershipPayment',
108 'OptionGroup',
109 'SurveyRespondant',
110 'UFJoin',
111 'UFMatch',
112 'Extension',
113 'LocationType',
db7de9c1 114 'System',
92915c55 115 );
567b2076
EM
116 $this->onlyIDNonZeroCount['get'] = array(
117 'ActivityType',
118 'Entity',
119 'Domain',
120 'Setting',
121 );
6a488035 122 $this->deprecatedAPI = array('Location', 'ActivityType', 'SurveyRespondant');
4a97890c 123 $this->deletableTestObjects = array();
6a488035
TO
124 }
125
00be9182 126 public function tearDown() {
4a97890c
TO
127 foreach ($this->deletableTestObjects as $entityName => $entities) {
128 foreach ($entities as $entityID) {
129 CRM_Core_DAO::deleteTestObjects($entityName, array('id' => $entityID));
130 }
131 }
132 }
6a488035 133
4cbe18b8 134 /**
db7de9c1
EM
135 * Generate list of all entities.
136 *
137 * @param array $skip
138 * Entities to skip.
4cbe18b8
EM
139 *
140 * @return array
141 */
db7de9c1 142 public static function entities($skip = array()) {
e5dd95b2
TO
143 // The order of operations in here is screwy. In the case where SYNTAX_CONFORMANCE_ENTITIES is
144 // defined, we should be able to parse+return it immediately. However, some weird dependency
145 // crept into the system where civicrm_api('Entity','get') must be called as part of entities()
146 // (even if its return value is ignored).
dcf56200 147
e5dd95b2 148 $tmp = civicrm_api('Entity', 'Get', array('version' => 3));
dcf56200 149 if (getenv('SYNTAX_CONFORMANCE_ENTITIES')) {
e5dd95b2 150 $tmp = array(
21dfd5f5 151 'values' => explode(' ', getenv('SYNTAX_CONFORMANCE_ENTITIES')),
e5dd95b2 152 );
dcf56200
TO
153 }
154
6a488035
TO
155 if (!is_array($skip)) {
156 $skip = array();
157 }
158 $tmp = array_diff($tmp['values'], $skip);
159 $entities = array();
160 foreach ($tmp as $e) {
161 $entities[] = array($e);
162 }
163 return $entities;
164 }
165
4cbe18b8 166 /**
db7de9c1
EM
167 * Get list of entities for get test.
168 *
4cbe18b8
EM
169 * @return array
170 */
6a488035
TO
171 public static function entities_get() {
172 // all the entities, beside the ones flagged
97715495 173 return static::entities(static::toBeSkipped_get(TRUE));
6a488035
TO
174 }
175
4cbe18b8 176 /**
567b2076
EM
177 * Get entities for create tests.
178 *
4cbe18b8
EM
179 * @return array
180 */
6a488035 181 public static function entities_create() {
97715495 182 return static::entities(static::toBeSkipped_create(TRUE));
6a488035
TO
183 }
184
4cbe18b8
EM
185 /**
186 * @return array
187 */
6a488035 188 public static function entities_updatesingle() {
97715495 189 return static::entities(static::toBeSkipped_updatesingle(TRUE));
6a488035
TO
190 }
191
4cbe18b8
EM
192 /**
193 * @return array
194 */
b9af4758
E
195 public static function entities_getlimit() {
196 return static::entities(static::toBeSkipped_getlimit());
197 }
198
ced9bfed
EM
199 /**
200 * Generate list of entities that can be retrieved using SQL operator syntax.
201 *
202 * @return array
203 */
dcf5b21f
EM
204 public static function entities_getSqlOperators() {
205 return static::entities(static::toBeSkipped_getSqlOperators());
206 }
92915c55 207
4cbe18b8
EM
208 /**
209 * @return array
210 */
6a488035 211 public static function entities_delete() {
97715495 212 return static::entities(static::toBeSkipped_delete(TRUE));
6a488035
TO
213 }
214
32dafeec
EM
215 /**
216 * @return array
217 */
218 public static function entities_getfields() {
219 return static::entities(static::toBeSkipped_getfields(TRUE));
220 }
92915c55 221
4cbe18b8
EM
222 /**
223 * @return array
224 */
2fc5f1e7
EM
225 public static function custom_data_entities_get() {
226 return static::custom_data_entities();
227 }
228
4cbe18b8
EM
229 /**
230 * @return array
231 */
2fc5f1e7 232 public static function custom_data_entities() {
82e1689e 233 $entities = CRM_Core_BAO_CustomQuery::$extendsMap;
bf38705f 234 $enabledComponents = CRM_Core_BAO_Setting::getItem(CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME, 'enable_components', NULL, array());
82e1689e 235 $customDataEntities = array();
2fc5f1e7 236 $invalidEntities = array('Individual', 'Organization', 'Household');
2f6264b4 237 $entitiesToFix = array('Case', 'Relationship');
481a74f4 238 foreach ($entities as $entityName => $entity) {
22e263ad 239 if (!in_array($entityName, $invalidEntities)
92915c55
TO
240 && !in_array($entityName, $entitiesToFix)
241 ) {
22e263ad 242 if (!empty(self::$componentMap[$entityName]) && empty($enabledComponents[self::$componentMap[$entityName]])) {
6c6e6187
TO
243 CRM_Core_BAO_ConfigSetting::enableComponent(self::$componentMap[$entityName]);
244 }
245 $customDataEntities[] = array($entityName);
82e1689e
N
246 }
247 }
2fc5f1e7
EM
248 return $customDataEntities;
249 }
250
4cbe18b8 251 /**
567b2076
EM
252 * Get entities to be skipped on get tests.
253 *
4cbe18b8
EM
254 * @param bool $sequential
255 *
256 * @return array
257 */
6a488035 258 public static function toBeSkipped_get($sequential = FALSE) {
92915c55
TO
259 $entitiesWithoutGet = array(
260 'MailingEventSubscribe',
261 'MailingEventConfirm',
262 'MailingEventResubscribe',
263 'MailingEventUnsubscribe',
567b2076 264 'Location',
92915c55 265 );
6a488035
TO
266 if ($sequential === TRUE) {
267 return $entitiesWithoutGet;
268 }
269 $entities = array();
270 foreach ($entitiesWithoutGet as $e) {
271 $entities[] = array($e);
272 }
273 return $entities;
274 }
b7d29345 275
b14ce773 276 /**
fd786d03
EM
277 * Get entities to be skipped for get call.
278 *
b14ce773 279 * Mailing Contact Just doesn't support id. We have always insisted on finding a way to
4a2db77c 280 * support id in API but in this case the underlying tables are crying out for a restructure
e4f46be0 281 * & it just doesn't make sense, on the otherhand Event need id to be existent as pseudo property
f2dff5cc 282 * is been associated with it, so we need to bypass for get api otherwise it will through pseudo_match validation
b7d29345 283 *
4a2db77c 284 * @param bool $sequential
b7d29345 285 *
a6c01b45
CW
286 * @return array
287 * Entities that cannot be retrieved by ID
b14ce773 288 */
289 public static function toBeSkipped_getByID($sequential = FALSE) {
f2dff5cc 290 return array('MailingContact', 'Event');
b14ce773 291 }
6a488035 292
4cbe18b8
EM
293 /**
294 * @param bool $sequential
295 *
296 * @return array
297 */
6a488035 298 public static function toBeSkipped_create($sequential = FALSE) {
21eb0c57 299 $entitiesWithoutCreate = array('Constant', 'Entity', 'Location', 'Profile', 'MailingRecipients');
6a488035
TO
300 if ($sequential === TRUE) {
301 return $entitiesWithoutCreate;
302 }
303 $entities = array();
304 foreach ($entitiesWithoutCreate as $e) {
305 $entities[] = array($e);
306 }
307 return $entities;
308 }
309
4cbe18b8
EM
310 /**
311 * @param bool $sequential
312 *
313 * @return array
314 */
6a488035 315 public static function toBeSkipped_delete($sequential = FALSE) {
92915c55
TO
316 $entitiesWithout = array(
317 'MailingContact',
318 'MailingEventConfirm',
319 'MailingEventResubscribe',
320 'MailingEventSubscribe',
321 'MailingEventUnsubscribe',
322 'MailingRecipients',
323 'Constant',
324 'Entity',
325 'Location',
326 'Domain',
327 'Profile',
328 'CustomValue',
92c99a4a 329 'Setting',
92915c55 330 );
6a488035
TO
331 if ($sequential === TRUE) {
332 return $entitiesWithout;
333 }
334 $entities = array();
335 foreach ($entitiesWithout as $e) {
336 $entities[] = array($e);
337 }
338 return $entities;
339 }
b7d29345 340
32dafeec
EM
341 /**
342 * @param bool $sequential
343 *
344 * @return array
345 * @todo add metadata for ALL these entities
346 */
347 public static function toBeSkipped_getfields($sequential = FALSE) {
17eeaef9 348 $entitiesWithMetadataNotYetFixed = array('ReportTemplate', 'CustomSearch');
32dafeec 349 if ($sequential === TRUE) {
6c6e6187 350 return $entitiesWithMetadataNotYetFixed;
32dafeec
EM
351 }
352 $entities = array();
353 foreach ($entitiesWithMetadataNotYetFixed as $e) {
354 $entities[] = array($e);
355 }
356 return $entities;
357 }
92915c55 358
6c6e6187 359 /**
eceb18cc 360 * Generate list of entities to test for get by id functions.
6c6e6187 361 * @param bool $sequential
a6c01b45
CW
362 * @return array
363 * Entities to be skipped
6c6e6187 364 */
b07a3bf9 365 public static function toBeSkipped_automock($sequential = FALSE) {
92915c55
TO
366 $entitiesWithoutGet = array(
367 'MailingContact',
368 'EntityTag',
369 'Participant',
370 'ParticipantPayment',
371 'Setting',
372 'SurveyRespondant',
373 'MailingRecipients',
374 'CustomSearch',
375 'Extension',
376 'ReportTemplate',
af9b09df 377 'System',
92915c55 378 );
b07a3bf9
TO
379 if ($sequential === TRUE) {
380 return $entitiesWithoutGet;
381 }
382 $entities = array();
383 foreach ($entitiesWithoutGet as $e) {
384 $entities[] = array($e);
385 }
386 return $entities;
387 }
388
389
b7d29345 390 /**
6c6e6187 391 * At this stage exclude the ones that don't pass & add them as we can troubleshoot them
1e1fdcf6
EM
392 * @param bool $sequential
393 * @return array
6c6e6187 394 */
6a488035
TO
395 public static function toBeSkipped_updatesingle($sequential = FALSE) {
396 $entitiesWithout = array(
92915c55
TO
397 'Attachment',
398 // pseudo-entity; testUpdateSingleValueAlter doesn't introspect properly on it. Multiple magic fields
6a488035
TO
399 'Mailing',
400 'MailingGroup',
401 'MailingJob',
402 'Address',
403 'MailingEventUnsubscribe',
404 'MailingEventSubscribe',
405 'Constant',
406 'Entity',
407 'Location',
408 'Domain',
409 'Profile',
410 'CustomValue',
411 'SurveyRespondant',
6a488035
TO
412 'UFMatch',
413 'UFJoin',
414 'UFField',
415 'OptionValue',
416 'Relationship',
417 'RelationshipType',
6a488035
TO
418 'Note',
419 'OptionGroup',
420 'Membership',
6a488035
TO
421 'Group',
422 'GroupOrganization',
423 'GroupNesting',
424 'Job',
425 'File',
426 'EntityTag',
427 'CustomField',
428 'CustomGroup',
429 'Contribution',
6a488035
TO
430 'ActivityType',
431 'MailingEventConfirm',
432 'Case',
433 'Contact',
434 'ContactType',
435 'MailingEventResubscribe',
436 'UFGroup',
437 'Activity',
438 'Email',
439 'Event',
440 'GroupContact',
441 'MembershipPayment',
442 'Participant',
443 'ParticipantPayment',
444 'LineItem',
6a488035
TO
445 'PledgePayment',
446 'ContributionPage',
447 'Phone',
faacb3e4 448 'PaymentProcessor',
6a488035 449 'Setting',
b14ce773 450 'MailingContact',
af9b09df 451 'SystemLog',
92915c55 452 //skip this because it doesn't make sense to update logs,
6a488035
TO
453 );
454 if ($sequential === TRUE) {
455 return $entitiesWithout;
456 }
457 $entities = array();
458 foreach ($entitiesWithout as $e) {
459 $entities[] = array(
460 $e,
461 );
462 }
463 return array('pledge');
464 return $entities;
465 }
466
b7d29345 467 /**
b9af4758 468 * At this stage exclude the ones that don't pass & add them as we can troubleshoot them
b7d29345 469 */
b9af4758
E
470 public static function toBeSkipped_getlimit() {
471 $entitiesWithout = array(
92915c55
TO
472 'Case',
473 //case api has non-std mandatory fields one of (case_id, contact_id, activity_id, contact_id)
474 'EntityTag',
475 // non-standard api - has inappropriate mandatory fields & doesn't implement limit
476 'Event',
477 // failed 'check that a 5 limit returns 5' - probably is_template field is wrong or something, or could be limit doesn't work right
478 'Extension',
479 // can't handle creating 25
480 'Note',
481 // fails on 5 limit - probably a set up problem
482 'Setting',
483 //a bit of a pseudoapi - keys by domain
b9af4758
E
484 );
485 return $entitiesWithout;
486 }
487
dcf5b21f
EM
488 /**
489 * At this stage exclude the ones that don't pass & add them as we can troubleshoot them
490 */
491 public static function toBeSkipped_getSqlOperators() {
492 $entitiesWithout = array(
6c6e6187 493 'Case', //case api has non-std mandatory fields one of (case_id, contact_id, activity_id, contact_id)
0ae1863a 494 'Contact', // on the todo list!
dcf5b21f
EM
495 'EntityTag', // non-standard api - has inappropriate mandatory fields & doesn't implement limit
496 'Extension', // can't handle creating 25
497 'Note', // note has a default get that isn't implemented in createTestObject -meaning you don't 'get' them
dcf5b21f
EM
498 'Setting', //a bit of a pseudoapi - keys by domain
499 );
500 return $entitiesWithout;
501 }
502
0f583c8f
EM
503 /**
504 * @param $entity
505 * @param $key
506 *
507 * @return array
508 */
9b873358 509 public function getKnownUnworkablesUpdateSingle($entity, $key) {
6a488035
TO
510 // can't update values are values for which updates don't result in the value being changed
511 $knownFailures = array(
03fe1a00
TO
512 'ActionSchedule' => array(
513 'cant_update' => array(
514 'group_id',
515 ),
516 ),
0f583c8f
EM
517 'ActivityContact' => array(
518 'cant_update' => array(
92915c55
TO
519 'activity_id',
520 //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
0f583c8f
EM
521 ),
522 ),
6a488035
TO
523 'Address' => array(
524 'cant_update' => array(
525 'state_province_id', //issues with country id - need to ensure same country
6c6e6187 526 'master_id', //creates relationship
6a488035 527 ),
21dfd5f5 528 'cant_return' => array(),
6a488035 529 ),
6ead217b
E
530 'Batch' => array(
531 'cant_update' => array(
532 'entity_table', // believe this field is defined in error
533 ),
534 'cant_return' => array(
535 'entity_table',
21dfd5f5 536 ),
6ead217b 537 ),
1753bd71
TO
538 'CaseType' => array(
539 'cant_update' => array(
540 'definition',
21dfd5f5 541 ),
1753bd71 542 ),
95520636
TO
543 'MembershipBlock' => array(
544 'cant_update' => array(
545 // The fake/auto-generated values leave us unable to properly cleanup fake data
546 'entity_type',
547 'entity_id',
21dfd5f5 548 ),
95520636 549 ),
7d543448 550 'ContributionSoft' => array(
551 'cant_update' => array(
552 // can't be changed through api
553 'pcp_id',
554 ),
555 ),
6a488035
TO
556 'Pledge' => array(
557 'cant_update' => array(
558 'pledge_original_installment_amount',
559 'installments',
560 'original_installment_amount',
561 'next_pay_date',
af9b09df 562 'amount', // can't be changed through API,
6a488035
TO
563 ),
564 'break_return' => array(// if these are passed in they are retrieved from the wrong table
565 'honor_contact_id',
566 'cancel_date',
567 'contribution_page_id',
568 'financial_account_id',
569 'financial_type_id',
21dfd5f5 570 'currency',
6a488035
TO
571 ),
572 'cant_return' => array(// can't be retrieved from api
573 'honor_type_id', //due to uniquename missing
574 'end_date',
575 'modified_date',
576 'acknowledge_date',
577 'start_date',
578 'frequency_day',
579 'currency',
580 'max_reminders',
581 'initial_reminder_day',
582 'additional_reminder_day',
583 'frequency_unit',
584 'pledge_contribution_page_id',
585 'pledge_status_id',
586 'pledge_campaign_id',
b06d9acd 587 'pledge_financial_type_id',
21dfd5f5 588 ),
6a488035
TO
589 ),
590 'PaymentProcessorType' => array(
591 'cant_update' => array(
592 'billing_mode',
593 ),
6c6e6187
TO
594 'break_return' => array(),
595 'cant_return' => array(),
6a488035 596 ),
db232378
EM
597 'PriceFieldValue' => array(
598 'cant_update' => array(
599 'weight', //won't update as there is no 1 in the same price set
600 ),
601 ),
6a488035 602 );
9b873358 603 if (empty($knownFailures[$entity]) || empty($knownFailures[$entity][$key])) {
6a488035
TO
604 return array();
605 }
606 return $knownFailures[$entity][$key];
607 }
608
be2e0c6a 609 /* ----- testing the _get ----- */
6a488035
TO
610
611 /**
612 * @dataProvider toBeSkipped_get
be2e0c6a 613 * Entities that don't need a get action
1e1fdcf6 614 * @param $Entity
6a488035
TO
615 */
616 public function testNotImplemented_get($Entity) {
617 $result = civicrm_api($Entity, 'Get', array('version' => 3));
618 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
311873a0 619 // $this->assertContains("API ($Entity, Get) does not exist", $result['error_message']);
6c6e6187 620 $this->assertRegExp('/API (.*) does not exist/', $result['error_message']);
6a488035
TO
621 }
622
623 /**
624 * @dataProvider entities
625 * @expectedException PHPUnit_Framework_Error
1e1fdcf6 626 * @param $Entity
6a488035
TO
627 */
628 public function testWithoutParam_get($Entity) {
629 // should get php complaining that a param is missing
630 $result = civicrm_api($Entity, 'Get');
631 }
632
633 /**
634 * @dataProvider entities
1e1fdcf6 635 * @param $Entity
6a488035
TO
636 */
637 public function testGetFields($Entity) {
bd6658bd 638 if (in_array($Entity, $this->deprecatedAPI) || $Entity == 'Entity' || $Entity == 'CustomValue') {
6a488035
TO
639 return;
640 }
641
642 $result = civicrm_api($Entity, 'getfields', array('version' => 3));
643 $this->assertTrue(is_array($result['values']), "$Entity ::get fields doesn't return values array in line " . __LINE__);
644 foreach ($result['values'] as $key => $value) {
645 $this->assertTrue(is_array($value), $Entity . "::" . $key . " is not an array in line " . __LINE__);
646 }
647 }
648
649 /**
650 * @dataProvider entities_get
1e1fdcf6 651 * @param $Entity
6a488035
TO
652 */
653 public function testEmptyParam_get($Entity) {
654
655 if (in_array($Entity, $this->toBeImplemented['get'])) {
656 // $this->markTestIncomplete("civicrm_api3_{$Entity}_get to be implemented");
657 return;
658 }
659 $result = civicrm_api($Entity, 'Get', array());
660 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
661 $this->assertContains("Mandatory key(s) missing from params array", $result['error_message']);
662 }
92915c55 663
6a488035
TO
664 /**
665 * @dataProvider entities_get
1e1fdcf6 666 * @param $Entity
6a488035
TO
667 */
668 public function testEmptyParam_getString($Entity) {
669
670 if (in_array($Entity, $this->toBeImplemented['get'])) {
671 // $this->markTestIncomplete("civicrm_api3_{$Entity}_get to be implemented");
672 return;
673 }
d0e1eff2 674 $result = $this->callAPIFailure($Entity, 'Get', 'string');
6a488035
TO
675 $this->assertEquals(2000, $result['error_code']);
676 $this->assertEquals('Input variable `params` is not an array', $result['error_message']);
677 }
92915c55 678
6a488035
TO
679 /**
680 * @dataProvider entities_get
681 * @Xdepends testEmptyParam_get // no need to test the simple if the empty doesn't work/is skipped. doesn't seem to work
1e1fdcf6 682 * @param $Entity
6a488035
TO
683 */
684 public function testSimple_get($Entity) {
685 // $this->markTestSkipped("test gives core error on test server (but not on our locals). Skip until we can get server to pass");
6a488035
TO
686 if (in_array($Entity, $this->toBeImplemented['get'])) {
687 return;
688 }
689 $result = civicrm_api($Entity, 'Get', array('version' => 3));
690 // @TODO: list the get that have mandatory params
691 if ($result['is_error']) {
692 $this->assertContains("Mandatory key(s) missing from params array", $result['error_message']);
693 // either id or contact_id or entity_id is one of the field missing
694 $this->assertContains("id", $result['error_message']);
695 }
696 else {
697 $this->assertEquals(3, $result['version']);
698 $this->assertArrayHasKey('count', $result);
699 $this->assertArrayHasKey('values', $result);
700 }
701 }
702
2fc5f1e7
EM
703 /**
704 * @dataProvider custom_data_entities_get
1e1fdcf6 705 * @param $entityName
2fc5f1e7
EM
706 */
707 public function testCustomDataGet($entityName) {
708 $this->createLoggedInUser();// so subsidiary activities are created
709 $ids = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__, $entityName . 'Test.php');
710 $customFieldName = 'custom_' . $ids['custom_field_id'];
711 $objects = $this->getMockableBAOObjects($entityName, 1);
712 $params = array('id' => $objects[0]->id, 'custom_' . $ids['custom_field_id'] => "custom string");
713 $result = $this->callAPISuccess($entityName, 'create', $params);
714
715 $getParams = array('id' => $result['id'], 'return' => array($customFieldName));
716 $check = $this->callAPISuccess($entityName, 'get', $getParams);
717 $this->assertEquals("custom string", $check['values'][$check['id']][$customFieldName]);
718
719 $this->customFieldDelete($ids['custom_field_id']);
720 $this->customGroupDelete($ids['custom_group_id']);
721 $this->callAPISuccess($entityName, 'delete', array('id' => $result['id']));
722 }
723
6a488035
TO
724 /**
725 * @dataProvider entities_get
1e1fdcf6 726 * @param $Entity
6a488035
TO
727 */
728 public function testAcceptsOnlyID_get($Entity) {
729 // big random number. fun fact: if you multiply it by pi^e, the result is another random number, but bigger ;)
730 $nonExistantID = 30867307034;
b14ce773 731 if (in_array($Entity, $this->toBeImplemented['get'])
92915c55 732 || in_array($Entity, $this->toBeSkipped_getByID())
b14ce773 733 ) {
6a488035
TO
734 return;
735 }
736
737 // FIXME
738 // the below function returns different values and hence an early return
739 // we'll fix this once beta1 is released
740 // return;
741
c679daca 742 $result = civicrm_api($Entity, 'Get', array('version' => 3, 'id' => $nonExistantID));
6a488035
TO
743
744 if ($result['is_error']) {
745 // just to get a clearer message in the log
746 $this->assertEquals("only id should be enough", $result['error_message']);
747 }
748 if (!in_array($Entity, $this->onlyIDNonZeroCount['get'])) {
749 $this->assertEquals(0, $result['count']);
750 }
751 }
752
753 /**
eceb18cc 754 * Create two entities and make sure we can fetch them individually by ID.
4a97890c
TO
755 *
756 * @dataProvider entities_get
757 *
758 * limitations include the problem with avoiding loops when creating test objects -
759 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
760 * Currency - only seems to support US
1e1fdcf6 761 * @param $entityName
4a97890c
TO
762 */
763 public function testByID_get($entityName) {
b07a3bf9 764 if (in_array($entityName, self::toBeSkipped_automock(TRUE))) {
4a97890c
TO
765 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
766 return;
767 }
768
18eee50e 769 $baos = $this->getMockableBAOObjects($entityName);
770 list($baoObj1, $baoObj2) = $baos;
4a97890c
TO
771
772 // fetch first by ID
6ead217b 773 $result = $this->callAPISuccess($entityName, 'get', array(
4a97890c
TO
774 'id' => $baoObj1->id,
775 ));
6ead217b 776
4a97890c
TO
777 $this->assertTrue(!empty($result['values'][$baoObj1->id]), 'Should find first object by id');
778 $this->assertEquals($baoObj1->id, $result['values'][$baoObj1->id]['id'], 'Should find id on first object');
779 $this->assertEquals(1, count($result['values']));
780
781 // fetch second by ID
6ead217b 782 $result = $this->callAPISuccess($entityName, 'get', array(
4a97890c
TO
783 'id' => $baoObj2->id,
784 ));
4a97890c
TO
785 $this->assertTrue(!empty($result['values'][$baoObj2->id]), 'Should find second object by id');
786 $this->assertEquals($baoObj2->id, $result['values'][$baoObj2->id]['id'], 'Should find id on second object');
787 $this->assertEquals(1, count($result['values']));
788 }
789
b9af4758
E
790 /**
791 * Ensure that the "get" operation accepts limiting the #result records.
792 *
793 * TODO Consider making a separate entity list ("entities_getlimit")
794 * For the moment, the "entities_updatesingle" list should give a good
795 * sense for which entities support createTestObject
796 *
797 * @dataProvider entities_getlimit
8efea814 798 *
c490a46a 799 * @param string $entityName
b9af4758 800 */
00be9182 801 public function testLimit($entityName) {
b9af4758
E
802 $cases = array(); // each case is array(0 => $inputtedApiOptions, 1 => $expectedResultCount)
803 $cases[] = array(
804 array('options' => array('limit' => NULL)),
ebddc2d9
EM
805 30,
806 'check that a NULL limit returns unlimited',
b9af4758
E
807 );
808 $cases[] = array(
809 array('options' => array('limit' => FALSE)),
ebddc2d9
EM
810 30,
811 'check that a FALSE limit returns unlimited',
b9af4758
E
812 );
813 $cases[] = array(
814 array('options' => array('limit' => 0)),
ebddc2d9
EM
815 30,
816 'check that a 0 limit returns unlimited',
b9af4758
E
817 );
818 $cases[] = array(
819 array('options' => array('limit' => 5)),
820 5,
821 'check that a 5 limit returns 5',
822 );
823 $cases[] = array(
824 array(),
825 25,
826 'check that no limit returns 25',
827 );
828
6252a38c 829 $baoString = _civicrm_api3_get_BAO($entityName);
b9af4758
E
830 if (empty($baoString)) {
831 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
832 return;
833 }
834
835 // make 30 test items -- 30 > 25 (the default limit)
4038f8ec 836 $ids = array();
b9af4758 837 for ($i = 0; $i < 30; $i++) {
8d5544c5 838 $baoObj = CRM_Core_DAO::createTestObject($baoString, array('currency' => 'USD'));
4038f8ec 839 $ids[] = $baoObj->id;
b9af4758
E
840 }
841
842 // each case is array(0 => $inputtedApiOptions, 1 => $expectedResultCount)
843 foreach ($cases as $case) {
ebddc2d9 844 $this->checkLimitAgainstExpected($entityName, $case[0], $case[1], $case[2]);
a85a667f
EM
845
846 //non preferred / legacy syntax
22e263ad 847 if (isset($case[0]['options']['limit'])) {
ebddc2d9
EM
848 $this->checkLimitAgainstExpected($entityName, array('rowCount' => $case[0]['options']['limit']), $case[1], $case[2]);
849 $this->checkLimitAgainstExpected($entityName, array('option_limit' => $case[0]['options']['limit']), $case[1], $case[2]);
850 $this->checkLimitAgainstExpected($entityName, array('option.limit' => $case[0]['options']['limit']), $case[1], $case[2]);
a85a667f 851 }
b9af4758 852 }
4038f8ec
TO
853 foreach ($ids as $id) {
854 CRM_Core_DAO::deleteTestObjects($baoString, array('id' => $id));
855 }
8d5544c5 856 $baoObj->free();
b9af4758
E
857 }
858
dcf5b21f
EM
859 /**
860 * Ensure that the "get" operation accepts limiting the #result records.
861 *
862 * @dataProvider entities_getSqlOperators
863 *
c490a46a 864 * @param string $entityName
dcf5b21f 865 */
00be9182 866 public function testSqlOperators($entityName) {
dcf5b21f
EM
867 $baoString = _civicrm_api3_get_BAO($entityName);
868 if (empty($baoString)) {
869 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
870 return;
871 }
872 $entities = $this->callAPISuccess($entityName, 'get', array('options' => array('limit' => 0), 'return' => 'id'));
873 $entities = array_keys($entities['values']);
874 $totalEntities = count($entities);
875 if ($totalEntities < 3) {
876 $ids = array();
877 for ($i = 0; $i < 3 - $totalEntities; $i++) {
878 $baoObj = CRM_Core_DAO::createTestObject($baoString, array('currency' => 'USD'));
879 $ids[] = $baoObj->id;
880 }
881 $totalEntities = 3;
882 }
883 $entities = $this->callAPISuccess($entityName, 'get', array('options' => array('limit' => 0)));
884 $entities = array_keys($entities['values']);
885 $this->assertGreaterThan(2, $totalEntities);
886 $this->callAPISuccess($entityName, 'getsingle', array('id' => array('IN' => array($entities[0]))));
887 $this->callAPISuccessGetCount($entityName, array('id' => array('NOT IN' => array($entities[0]))), $totalEntities - 1);
888 $this->callAPISuccessGetCount($entityName, array('id' => array('>' => $entities[0])), $totalEntities - 1);
889 }
890
ebddc2d9 891 /**
eceb18cc 892 * Check that get fetches an appropriate number of results.
ebddc2d9 893 *
e16033b4
TO
894 * @param string $entityName
895 * Name of entity to test.
dcf5b21f 896 * @param array $params
e16033b4 897 * @param int $limit
dcf5b21f 898 * @param string $message
ebddc2d9 899 */
00be9182 900 public function checkLimitAgainstExpected($entityName, $params, $limit, $message) {
ebddc2d9 901 $result = $this->callAPISuccess($entityName, 'get', $params);
22e263ad 902 if ($limit == 30) {
ebddc2d9
EM
903 $this->assertGreaterThanOrEqual($limit, $result['count'], $message);
904 $this->assertGreaterThanOrEqual($limit, $result['count'], $message);
905 }
906 else {
907 $this->assertEquals($limit, $result['count'], $message);
908 $this->assertEquals($limit, count($result['values']), $message);
909 }
910 }
92915c55 911
afb0ff51
TO
912 /**
913 * Create two entities and make sure we can fetch them individually by ID (e.g. using "contact_id=>2"
914 * or "group_id=>4")
915 *
916 * @dataProvider entities_get
917 *
918 * limitations include the problem with avoiding loops when creating test objects -
919 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
920 * Currency - only seems to support US
1e1fdcf6
EM
921 * @param $entityName
922 * @throws \PHPUnit_Framework_IncompleteTestError
afb0ff51
TO
923 */
924 public function testByIDAlias_get($entityName) {
c4de8b59 925 if (in_array($entityName, self::toBeSkipped_automock(TRUE))) {
afb0ff51
TO
926 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
927 return;
928 }
929
6252a38c 930 $baoString = _civicrm_api3_get_BAO($entityName);
afb0ff51
TO
931 if (empty($baoString)) {
932 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
933 return;
934 }
935
c4de8b59
TO
936 $idFieldName = _civicrm_api_get_entity_name_from_camel($entityName) . '_id';
937
afb0ff51
TO
938 // create entities
939 $baoObj1 = CRM_Core_DAO::createTestObject($baoString, array('currency' => 'USD'));
a1a2a83d 940 $this->assertTrue(is_int($baoObj1->id), 'check first id');
afb0ff51
TO
941 $this->deletableTestObjects[$baoString][] = $baoObj1->id;
942 $baoObj2 = CRM_Core_DAO::createTestObject($baoString, array('currency' => 'USD'));
a1a2a83d 943 $this->assertTrue(is_int($baoObj2->id), 'check second id');
afb0ff51
TO
944 $this->deletableTestObjects[$baoString][] = $baoObj2->id;
945
946 // fetch first by ID
947 $result = civicrm_api($entityName, 'get', array(
948 'version' => 3,
c4de8b59 949 $idFieldName => $baoObj1->id,
afb0ff51
TO
950 ));
951 $this->assertAPISuccess($result);
952 $this->assertTrue(!empty($result['values'][$baoObj1->id]), 'Should find first object by id');
953 $this->assertEquals($baoObj1->id, $result['values'][$baoObj1->id]['id'], 'Should find id on first object');
954 $this->assertEquals(1, count($result['values']));
955
956 // fetch second by ID
957 $result = civicrm_api($entityName, 'get', array(
958 'version' => 3,
c4de8b59 959 $idFieldName => $baoObj2->id,
afb0ff51
TO
960 ));
961 $this->assertAPISuccess($result);
962 $this->assertTrue(!empty($result['values'][$baoObj2->id]), 'Should find second object by id');
963 $this->assertEquals($baoObj2->id, $result['values'][$baoObj2->id]['id'], 'Should find id on second object');
964 $this->assertEquals(1, count($result['values']));
965 }
966
967 /**
6a488035 968 * @dataProvider entities_get
1e1fdcf6 969 * @param $Entity
6a488035
TO
970 */
971 public function testNonExistantID_get($Entity) {
972 // cf testAcceptsOnlyID_get
973 $nonExistantID = 30867307034;
974 if (in_array($Entity, $this->toBeImplemented['get'])) {
975 return;
976 }
977
978 $result = civicrm_api($Entity, 'Get', array('version' => 3, 'id' => $nonExistantID));
979
980 // redundant with testAcceptsOnlyID_get
981 if ($result['is_error']) {
982 return;
983 }
984
6a488035
TO
985 $this->assertArrayHasKey('version', $result);
986 $this->assertEquals(3, $result['version']);
987 if (!in_array($Entity, $this->onlyIDNonZeroCount['get'])) {
988 $this->assertEquals(0, $result['count']);
989 }
990 }
991
a1a2a83d 992 /* ---- testing the _create ---- */
6a488035
TO
993
994 /**
995 * @dataProvider toBeSkipped_create
6c6e6187 996 entities that don't need a create action
1e1fdcf6 997 * @param $Entity
6a488035
TO
998 */
999 public function testNotImplemented_create($Entity) {
1000 $result = civicrm_api($Entity, 'Create', array('version' => 3));
1001 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
311873a0 1002 $this->assertContains(strtolower("API ($Entity, Create) does not exist"), strtolower($result['error_message']));
6a488035
TO
1003 }
1004
1005 /**
1006 * @dataProvider entities
1007 * @expectedException PHPUnit_Framework_Error
1e1fdcf6 1008 * @param $Entity
6a488035
TO
1009 */
1010 public function testWithoutParam_create($Entity) {
1011 // should create php complaining that a param is missing
1012 $result = civicrm_api($Entity, 'Create');
1013 }
1014
1015 /**
1016 * @dataProvider entities_create
1e1fdcf6
EM
1017 * @param $Entity
1018 * @throws \PHPUnit_Framework_IncompleteTestError
6a488035
TO
1019 */
1020 public function testEmptyParam_create($Entity) {
e4f46be0 1021 $this->markTestIncomplete("fixing this test to test the api functions fails on numerous tests
f27f2724 1022 which will either create a completely blank entity (batch, participant status) or
18eee50e 1023 have a damn good crack at it (e.g mailing job). Marking this as incomplete beats false success");
18eee50e 1024 return;
6a488035
TO
1025 if (in_array($Entity, $this->toBeImplemented['create'])) {
1026 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1027 return;
1028 }
18eee50e 1029 $result = $this->callAPIFailure($Entity, 'Create', array());
6a488035
TO
1030 $this->assertContains("Mandatory key(s) missing from params array", $result['error_message']);
1031 }
1032
18eee50e 1033 /**
1034 * @dataProvider entities_create
1035 *
1036 * Check that create doesn't work with an invalid
1e1fdcf6
EM
1037 * @param $Entity
1038 * @throws \PHPUnit_Framework_IncompleteTestError
18eee50e 1039 */
1040 public function testInvalidID_create($Entity) {
1041 // turn test off for noew
6ead217b 1042 $this->markTestIncomplete("Entity [ $Entity ] cannot be mocked - no known DAO");
18eee50e 1043 return;
1044 if (in_array($Entity, $this->toBeImplemented['create'])) {
1045 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1046 return;
1047 }
1048 $result = $this->callAPIFailure($Entity, 'Create', array('id' => 999));
1049 }
1050
6a488035
TO
1051 /**
1052 * @dataProvider entities
1053 */
1054 public function testCreateWrongTypeParamTag_create() {
1055 $result = civicrm_api("Tag", 'Create', 'this is not a string');
1056 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
1057 $this->assertEquals("Input variable `params` is not an array", $result['error_message']);
1058 }
1059
1060 /**
1061 * @dataProvider entities_updatesingle
1062 *
1063 * limitations include the problem with avoiding loops when creating test objects -
1064 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
1065 * Currency - only seems to support US
1e1fdcf6 1066 * @param $entityName
6a488035
TO
1067 */
1068 public function testCreateSingleValueAlter($entityName) {
1069 if (in_array($entityName, $this->toBeImplemented['create'])) {
1070 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1071 return;
1072 }
1073
6252a38c 1074 $baoString = _civicrm_api3_get_BAO($entityName);
6a488035
TO
1075 $this->assertNotEmpty($baoString, $entityName);
1076 $this->assertNotEmpty($entityName, $entityName);
905fd0e9 1077 $fieldsGet = $fields = $this->callAPISuccess($entityName, 'getfields', array('action' => 'get', 'options' => array('get_options' => 'all')));
9b873358 1078 if ($entityName != 'Pledge') {
905fd0e9 1079 $fields = $this->callAPISuccess($entityName, 'getfields', array('action' => 'create', 'options' => array('get_options' => 'all')));
6a488035
TO
1080 }
1081 $fields = $fields['values'];
39bc176e 1082 $return = array_keys($fieldsGet['values']);
6a488035 1083 $valuesNotToReturn = $this->getKnownUnworkablesUpdateSingle($entityName, 'break_return');
6c6e6187 1084 // these can't be requested as return values
1fd111c8 1085 $entityValuesThatDoNotWork = array_merge(
92915c55
TO
1086 $this->getKnownUnworkablesUpdateSingle($entityName, 'cant_update'),
1087 $this->getKnownUnworkablesUpdateSingle($entityName, 'cant_return'),
1088 $valuesNotToReturn
1089 );
6a488035 1090
6c6e6187 1091 $return = array_diff($return, $valuesNotToReturn);
6a488035
TO
1092 $baoObj = new CRM_Core_DAO();
1093 $baoObj->createTestObject($baoString, array('currency' => 'USD'), 2, 0);
39bc176e
EM
1094
1095 $getEntities = $this->callAPISuccess($entityName, 'get', array(
6ead217b
E
1096 'sequential' => 1,
1097 'return' => $return,
1098 'options' => array(
1099 'sort' => 'id DESC',
1100 'limit' => 2,
1101 ),
1102 ));
a8699624 1103
6a488035 1104 // lets use first rather than assume only one exists
39bc176e
EM
1105 $entity = $getEntities['values'][0];
1106 $entity2 = $getEntities['values'][1];
1107 $this->deletableTestObjects[$baoString][] = $entity['id'];
1108 $this->deletableTestObjects[$baoString][] = $entity2['id'];
6a488035 1109 foreach ($fields as $field => $specs) {
a8699624 1110 $resetFKTo = NULL;
6a488035
TO
1111 $fieldName = $field;
1112 if (!empty($specs['uniquename'])) {
1113 $fieldName = $specs['uniquename'];
1114 }
1115 if ($field == 'currency' || $field == 'id' || $field == strtolower($entityName) . '_id'
92915c55
TO
1116 || in_array($field, $entityValuesThatDoNotWork)
1117 ) {
6a488035
TO
1118 //@todo id & entity_id are correct but we should fix currency & frequency_day
1119 continue;
1120 }
0ce6d639 1121 $this->assertArrayHasKey('type', $specs, "the _spec function for $entityName field $field does not specify the type");
6a488035
TO
1122 switch ($specs['type']) {
1123 case CRM_Utils_Type::T_DATE:
6a488035
TO
1124 $entity[$fieldName] = '2012-05-20';
1125 break;
6c6e6187 1126
b6afca8f 1127 case CRM_Utils_Type::T_TIMESTAMP:
6a488035
TO
1128 case 12:
1129 $entity[$fieldName] = '2012-05-20 03:05:20';
1130 break;
1131
1132 case CRM_Utils_Type::T_STRING:
1133 case CRM_Utils_Type::T_BLOB:
1134 case CRM_Utils_Type::T_MEDIUMBLOB:
1135 case CRM_Utils_Type::T_TEXT:
1136 case CRM_Utils_Type::T_LONGTEXT:
1137 case CRM_Utils_Type::T_EMAIL:
6c6e6187 1138 $entity[$fieldName] = substr('New String', 0, CRM_Utils_Array::Value('maxlength', $specs, 100));
6a488035
TO
1139 break;
1140
1141 case CRM_Utils_Type::T_INT:
1142 // probably created with a 1
a8699624
EM
1143 if ($fieldName == 'weight') {
1144 $entity[$fieldName] = 2;
1145 }
1146 elseif (!empty($specs['FKClassName'])) {
9b873358 1147 if ($specs['FKClassName'] == $baoString) {
6a488035
TO
1148 $entity[$fieldName] = (string) $entity2['id'];
1149 }
92e4c2a5 1150 else {
6ead217b 1151 $uniqueName = CRM_Utils_Array::value('uniqueName', $specs);
a8699624
EM
1152 if (!empty($entity[$fieldName])) {
1153 $resetFKTo = array($fieldName => $entity[$fieldName]);
1154 }
6ead217b 1155 $entity[$fieldName] = (string) empty($entity2[$field]) ? CRM_Utils_Array::value($uniqueName, $entity2) : $entity2[$field];
6c6e6187 1156 //todo - there isn't always something set here - & our checking on unset values is limited
6a488035
TO
1157 if (empty($entity[$field])) {
1158 unset($entity[$field]);
1159 }
1160 }
1161 }
a8699624
EM
1162 else {
1163 $entity[$fieldName] = '6';
1164 }
6a488035
TO
1165 break;
1166
6a488035
TO
1167 case CRM_Utils_Type::T_BOOLEAN:
1168 // probably created with a 1
1169 $entity[$fieldName] = '0';
1170 break;
1171
1172 case CRM_Utils_Type::T_FLOAT:
1173 case CRM_Utils_Type::T_MONEY:
edd31a24 1174 $entity[$field] = '22.75';
6a488035
TO
1175 break;
1176
1177 case CRM_Utils_Type::T_URL:
1178 $entity[$field] = 'warm.beer.com';
1179 }
905fd0e9
CW
1180 if (empty($specs['FKClassName']) && (!empty($specs['pseudoconstant']) || !empty($specs['options']))) {
1181 $options = CRM_Utils_Array::value('options', $specs, array());
1182 if (!$options) {
edd31a24 1183 //eg. pdf_format id doesn't ship with any
22e263ad 1184 if (isset($specs['pseudoconstant']['optionGroupName'])) {
92915c55 1185 $optionValue = $this->callAPISuccess('option_value', 'create', array(
905fd0e9 1186 'option_group_id' => $specs['pseudoconstant']['optionGroupName'],
af9b09df 1187 'label' => 'new option value',
905fd0e9 1188 'sequential' => 1,
92915c55 1189 ));
905fd0e9
CW
1190 $optionValue = $optionValue['values'];
1191 $options[$optionValue[0]['value']] = 'new option value';
edd31a24 1192 }
3d3ef918 1193 }
905fd0e9
CW
1194 $entity[$field] = array_rand($options);
1195 }
1196 if (!empty($specs['FKClassName']) && !empty($specs['pseudoconstant'])) {
1197 // in the weird situation where a field has both an fk and pseudoconstant defined,
1198 // e.g. campaign_id field, need to flush caches.
1199 // FIXME: Why doesn't creating a campaign clear caches?
1200 civicrm_api3($entityName, 'getfields', array('cache_clear' => 1));
6a488035
TO
1201 }
1202 $updateParams = array(
6a488035 1203 'id' => $entity['id'],
6ead217b 1204 $field => isset($entity[$field]) ? $entity[$field] : NULL,
6a488035 1205 );
22e263ad 1206 if (isset($updateParams['financial_type_id']) && in_array($entityName, array('Grant'))) {
deb562a8
EM
1207 //api has special handling on these 2 fields for backward compatibility reasons
1208 $entity['contribution_type_id'] = $updateParams['financial_type_id'];
1209 }
6a488035 1210
f27f2724 1211 $update = $this->callAPISuccess($entityName, 'create', $updateParams);
6a488035
TO
1212 $checkParams = array(
1213 'id' => $entity['id'],
6a488035
TO
1214 'sequential' => 1,
1215 'return' => $return,
1216 'options' => array(
1217 'sort' => 'id DESC',
1218 'limit' => 2,
1219 ),
1220 );
1221
f27f2724 1222 $checkEntity = $this->callAPISuccess($entityName, 'getsingle', $checkParams);
92915c55
TO
1223 $this->assertAPIArrayComparison($entity, $checkEntity, array(), "checking if $fieldName was correctly updated\n" . print_r(array(
1224 'update-params' => $updateParams,
1225 'update-result' => $update,
1226 'getsingle-params' => $checkParams,
1227 'getsingle-result' => $checkEntity,
af9b09df 1228 'expected entity' => $entity,
92915c55 1229 ), TRUE));
a8699624
EM
1230 if ($resetFKTo) {
1231 //reset the foreign key fields because otherwise our cleanup routine fails & some other unexpected stuff can kick in
1232 $entity = array_merge($entity, $resetFKTo);
1233 $updateParams = array_merge($updateParams, $resetFKTo);
1234 $this->callAPISuccess($entityName, 'create', $updateParams);
22e263ad 1235 if (isset($updateParams['financial_type_id']) && in_array($entityName, array('Grant'))) {
a8699624
EM
1236 //api has special handling on these 2 fields for backward compatibility reasons
1237 $entity['contribution_type_id'] = $updateParams['financial_type_id'];
1238 }
1239 }
6a488035 1240 }
6a488035
TO
1241 $baoObj->free();
1242 }
1243
be2e0c6a 1244 /* ---- testing the _getFields ---- */
6a488035 1245
be2e0c6a 1246 /* ---- testing the _delete ---- */
6a488035
TO
1247
1248 /**
1249 * @dataProvider toBeSkipped_delete
6c6e6187 1250 entities that don't need a delete action
1e1fdcf6 1251 * @param $Entity
6a488035
TO
1252 */
1253 public function testNotImplemented_delete($Entity) {
1254 $nonExistantID = 151416349;
1255 $result = civicrm_api($Entity, 'Delete', array('version' => 3, 'id' => $nonExistantID));
1256 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
311873a0 1257 $this->assertContains(strtolower("API ($Entity, Delete) does not exist"), strtolower($result['error_message']));
6a488035
TO
1258 }
1259
1260 /**
1261 * @dataProvider entities
1262 * @expectedException PHPUnit_Framework_Error
1e1fdcf6 1263 * @param $Entity
6a488035
TO
1264 */
1265 public function testWithoutParam_delete($Entity) {
1266 // should delete php complaining that a param is missing
1267 $result = civicrm_api($Entity, 'Delete');
1268 }
1269
1270 /**
1271 * @dataProvider entities_delete
1e1fdcf6 1272 * @param $Entity
6a488035
TO
1273 */
1274 public function testEmptyParam_delete($Entity) {
1275 if (in_array($Entity, $this->toBeImplemented['delete'])) {
1276 // $this->markTestIncomplete("civicrm_api3_{$Entity}_delete to be implemented");
1277 return;
1278 }
1279 $result = civicrm_api($Entity, 'Delete', array());
1280 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
1281 $this->assertContains("Mandatory key(s) missing from params array", $result['error_message']);
1282 }
92915c55 1283
18eee50e 1284 /**
1285 * @dataProvider entities_delete
1e1fdcf6
EM
1286 * @param $Entity
1287 * @throws \PHPUnit_Framework_IncompleteTestError
18eee50e 1288 */
1289 public function testInvalidID_delete($Entity) {
6ead217b
E
1290 // turn test off for now
1291 $this->markTestIncomplete("Entity [ $Entity ] cannot be mocked - no known DAO");
18eee50e 1292 return;
1293 if (in_array($Entity, $this->toBeImplemented['delete'])) {
1294 // $this->markTestIncomplete("civicrm_api3_{$Entity}_delete to be implemented");
1295 return;
1296 }
1297 $result = $this->callAPIFailure($Entity, 'Delete', array('id' => 999));
1298 }
92915c55 1299
6a488035
TO
1300 /**
1301 * @dataProvider entities
1302 */
1303 public function testDeleteWrongTypeParamTag_delete() {
1304 $result = civicrm_api("Tag", 'Delete', 'this is not a string');
1305 $this->assertEquals(1, $result['is_error'], 'In line ' . __LINE__);
1306 $this->assertEquals("Input variable `params` is not an array", $result['error_message']);
1307 }
1308
18eee50e 1309 /**
1310 * Create two entities and make sure delete action only deletes one!
1311 *
1312 * @dataProvider entities_delete
1313 *
1314 * limitations include the problem with avoiding loops when creating test objects -
1315 * hence FKs only set by createTestObject when required. e.g parent_id on campaign is not being followed through
1316 * Currency - only seems to support US
1e1fdcf6
EM
1317 * @param $entityName
1318 * @throws \PHPUnit_Framework_IncompleteTestError
18eee50e 1319 */
1320 public function testByID_delete($entityName) {
1321 // turn test off for noew
1322 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
1323 return;
1324
1325 if (in_array($entityName, self::toBeSkipped_automock(TRUE))) {
1326 // $this->markTestIncomplete("civicrm_api3_{$Entity}_create to be implemented");
1327 return;
1328 }
1329 $startCount = $this->callAPISuccess($entityName, 'getcount', array());
1330 $createcount = 2;
1331 $baos = $this->getMockableBAOObjects($entityName, $createcount);
1332 list($baoObj1, $baoObj2) = $baos;
1333
1334 // make sure exactly 2 exist
1335 $result = $this->callAPISuccess($entityName, 'getcount', array(),
1336 $createcount + $startCount
1337 );
1338
1339 $this->callAPISuccess($entityName, 'delete', array('id' => $baoObj2->id));
1340 //make sure 1 less exists now
1341 $result = $this->callAPISuccess($entityName, 'getcount', array(),
6c6e6187 1342 ($createcount + $startCount) - 1
18eee50e 1343 );
1344
1345 //make sure id #1 exists
1346 $result = $this->callAPISuccess($entityName, 'getcount', array('id' => $baoObj1->id),
1347 1
1348 );
1349 //make sure id #2 desn't exist
1350 $result = $this->callAPISuccess($entityName, 'getcount', array('id' => $baoObj2->id),
1351 0
1352 );
1353 }
1354
32dafeec
EM
1355 /**
1356 * Create two entities and make sure delete action only deletes one!
1357 *
1358 * @dataProvider entities_getfields
1e1fdcf6 1359 * @param $entity
32dafeec
EM
1360 */
1361 public function testGetfieldsHasTitle($entity) {
1362 $entities = $this->getEntitiesSupportingCustomFields();
1363 if (in_array($entity, $entities)) {
1364 $ids = $this->entityCustomGroupWithSingleFieldCreate(__FUNCTION__, $entity . 'Test.php');
1365 }
6c6e6187 1366 $actions = $this->callAPISuccess($entity, 'getactions', array());
4c41ecb2 1367 foreach ($actions['values'] as $action) {
92915c55 1368 if (substr($action, -7) == '_create' || substr($action, -4) == '_get' || substr($action, -7) == '_delete') {
7385c761
EM
1369 //getactions can't distinguish between contribution_page.create & contribution_page.create
1370 continue;
1371 }
4c41ecb2
EM
1372 $fields = $this->callAPISuccess($entity, 'getfields', array('action' => $action));
1373 if (!empty($ids) && in_array($action, array('create', 'get'))) {
7385c761 1374 $this->assertArrayHasKey('custom_' . $ids['custom_field_id'], $fields['values']);
4c41ecb2 1375 }
32dafeec 1376
4c41ecb2
EM
1377 foreach ($fields['values'] as $fieldName => $fieldSpec) {
1378 $this->assertArrayHasKey('title', $fieldSpec, "no title for $entity - $fieldName on action $action");
1379 $this->assertNotEmpty($fieldSpec['title'], "empty title for $entity - $fieldName");
1380 }
32dafeec 1381 }
32dafeec
EM
1382 if (!empty($ids)) {
1383 $this->customFieldDelete($ids['custom_field_id']);
1384 $this->customGroupDelete($ids['custom_group_id']);
1385 }
1386 }
1387
1388 /**
1389 * @return array
1390 */
1391 public function getEntitiesSupportingCustomFields() {
1392 $entities = self::custom_data_entities_get();
1393 $returnEntities = array();
1394 foreach ($entities as $entityArray) {
1395 $returnEntities[] = $entityArray[0];
1396 }
1397 return $returnEntities;
1398 }
92915c55 1399
8efea814 1400 /**
100fef9d 1401 * @param string $entityName
8efea814
EM
1402 * @param int $count
1403 *
8efea814
EM
1404 * @return array
1405 */
1406 private function getMockableBAOObjects($entityName, $count = 2) {
6252a38c 1407 $baoString = _civicrm_api3_get_BAO($entityName);
18eee50e 1408 if (empty($baoString)) {
1409 $this->markTestIncomplete("Entity [$entityName] cannot be mocked - no known DAO");
fcb93467 1410 return array();
18eee50e 1411 }
1412 $baos = array();
6ead217b 1413 $i = 0;
22e263ad 1414 while ($i < $count) {
6c6e6187 1415 // create entities
18eee50e 1416 $baoObj = CRM_Core_DAO::createTestObject($baoString, array('currency' => 'USD'));
a1a2a83d 1417 $this->assertTrue(is_int($baoObj->id), 'check first id');
18eee50e 1418 $this->deletableTestObjects[$baoString][] = $baoObj->id;
1419 $baos[] = $baoObj;
2241036a 1420 $i++;
18eee50e 1421 }
1422 return $baos;
1423 }
1424
1425
6a488035 1426 /**
fe482240 1427 * Verify that HTML metacharacters provided as inputs appear consistently.
6a488035
TO
1428 * as outputs.
1429 *
1430 * At time of writing, the encoding scheme requires (for example) that an
1431 * event title be partially-HTML-escaped before writing to DB. To provide
1432 * consistency, the API must perform extra encoding and decoding on some
1433 * fields.
1434 *
1435 * In this example, the event 'title' is subject to encoding, but the
1436 * event 'description' is not.
1437 */
1438 public function testEncodeDecodeConsistency() {
1439 // Create example
1440 $createResult = civicrm_api('Event', 'Create', array(
1441 'version' => 3,
1442 'title' => 'CiviCRM <> TheRest',
1443 'description' => 'TheRest <> CiviCRM',
1444 'event_type_id' => 1,
1445 'is_public' => 1,
1446 'start_date' => 20081021,
1447 ));
1448 $this->assertAPISuccess($createResult);
1449 $eventId = $createResult['id'];
1450 $this->assertEquals('CiviCRM <> TheRest', $createResult['values'][$eventId]['title']);
1451 $this->assertEquals('TheRest <> CiviCRM', $createResult['values'][$eventId]['description']);
1452
1453 // Verify "get" handles decoding in result value
1454 $getByIdResult = civicrm_api('Event', 'Get', array(
1455 'version' => 3,
1456 'id' => $eventId,
1457 ));
1458 $this->assertAPISuccess($getByIdResult);
1459 $this->assertEquals('CiviCRM <> TheRest', $getByIdResult['values'][$eventId]['title']);
1460 $this->assertEquals('TheRest <> CiviCRM', $getByIdResult['values'][$eventId]['description']);
1461
1462 // Verify "get" handles encoding in search value
1463 $getByTitleResult = civicrm_api('Event', 'Get', array(
1464 'version' => 3,
1465 'title' => 'CiviCRM <> TheRest',
1466 ));
1467 $this->assertAPISuccess($getByTitleResult);
1468 $this->assertEquals('CiviCRM <> TheRest', $getByTitleResult['values'][$eventId]['title']);
1469 $this->assertEquals('TheRest <> CiviCRM', $getByTitleResult['values'][$eventId]['description']);
1470
1471 // Verify that "getSingle" handles decoding
6ead217b 1472 $getSingleResult = $this->callAPISuccess('Event', 'GetSingle', array(
6a488035
TO
1473 'id' => $eventId,
1474 ));
1475
6a488035
TO
1476 $this->assertEquals('CiviCRM <> TheRest', $getSingleResult['title']);
1477 $this->assertEquals('TheRest <> CiviCRM', $getSingleResult['description']);
1478
1479 // Verify that chaining handles decoding
6ead217b 1480 $chainResult = $this->callAPISuccess('Event', 'Get', array(
6a488035 1481 'id' => $eventId,
6c6e6187 1482 'api.event.get' => array(),
6a488035
TO
1483 ));
1484 $this->assertEquals('CiviCRM <> TheRest', $chainResult['values'][$eventId]['title']);
1485 $this->assertEquals('TheRest <> CiviCRM', $chainResult['values'][$eventId]['description']);
1486 $this->assertEquals('CiviCRM <> TheRest', $chainResult['values'][$eventId]['api.event.get']['values'][0]['title']);
1487 $this->assertEquals('TheRest <> CiviCRM', $chainResult['values'][$eventId]['api.event.get']['values'][0]['description']);
1488
1489 // Verify that "setvalue" handles encoding for updates
1490 $setValueTitleResult = civicrm_api('Event', 'setvalue', array(
1491 'version' => 3,
1492 'id' => $eventId,
1493 'field' => 'title',
1494 'value' => 'setValueTitle: CiviCRM <> TheRest',
1495 ));
1496 $this->assertAPISuccess($setValueTitleResult);
1497 $this->assertEquals('setValueTitle: CiviCRM <> TheRest', $setValueTitleResult['values']['title']);
1498 $setValueDescriptionResult = civicrm_api('Event', 'setvalue', array(
1499 'version' => 3,
1500 'id' => $eventId,
1501 'field' => 'description',
1502 'value' => 'setValueDescription: TheRest <> CiviCRM',
1503 ));
bc2bc079 1504 //$this->assertTrue((bool)$setValueDescriptionResult['is_error']); // not supported by setValue
1505 $this->assertEquals('setValueDescription: TheRest <> CiviCRM', $setValueDescriptionResult['values']['description']);
6c6e6187 1506 }
6a488035
TO
1507
1508 /**
1509 * Verify that write operations (create/update) use partial HTML-encoding
1510 *
1511 * In this example, the event 'title' is subject to encoding, but the
1512 * event 'description' is not.
1513 */
1514 public function testEncodeWrite() {
1515 // Create example
1516 $createResult = civicrm_api('Event', 'Create', array(
1517 'version' => 3,
1518 'title' => 'createNew: CiviCRM <> TheRest',
1519 'description' => 'createNew: TheRest <> CiviCRM',
1520 'event_type_id' => 1,
1521 'is_public' => 1,
1522 'start_date' => 20081021,
1523 ));
1524 $this->assertAPISuccess($createResult);
1525 $eventId = $createResult['id'];
1526 $this->assertDBQuery('createNew: CiviCRM &lt;&gt; TheRest', 'SELECT title FROM civicrm_event WHERE id = %1', array(
21dfd5f5 1527 1 => array($eventId, 'Integer'),
6a488035
TO
1528 ));
1529 $this->assertDBQuery('createNew: TheRest <> CiviCRM', 'SELECT description FROM civicrm_event WHERE id = %1', array(
21dfd5f5 1530 1 => array($eventId, 'Integer'),
6a488035
TO
1531 ));
1532
1533 // Verify that "create" handles encoding for updates
1534 $createWithIdResult = civicrm_api('Event', 'Create', array(
1535 'version' => 3,
1536 'id' => $eventId,
1537 'title' => 'createWithId: CiviCRM <> TheRest',
1538 'description' => 'createWithId: TheRest <> CiviCRM',
1539 ));
1540 $this->assertAPISuccess($createWithIdResult);
1541 $this->assertDBQuery('createWithId: CiviCRM &lt;&gt; TheRest', 'SELECT title FROM civicrm_event WHERE id = %1', array(
21dfd5f5 1542 1 => array($eventId, 'Integer'),
6a488035
TO
1543 ));
1544 $this->assertDBQuery('createWithId: TheRest <> CiviCRM', 'SELECT description FROM civicrm_event WHERE id = %1', array(
21dfd5f5 1545 1 => array($eventId, 'Integer'),
6a488035
TO
1546 ));
1547
1548 // Verify that "setvalue" handles encoding for updates
1549 $setValueTitleResult = civicrm_api('Event', 'setvalue', array(
1550 'version' => 3,
1551 'id' => $eventId,
1552 'field' => 'title',
1553 'value' => 'setValueTitle: CiviCRM <> TheRest',
1554 ));
1555 $this->assertAPISuccess($setValueTitleResult);
1556 $this->assertDBQuery('setValueTitle: CiviCRM &lt;&gt; TheRest', 'SELECT title FROM civicrm_event WHERE id = %1', array(
21dfd5f5 1557 1 => array($eventId, 'Integer'),
6a488035
TO
1558 ));
1559 $setValueDescriptionResult = civicrm_api('Event', 'setvalue', array(
1560 'version' => 3,
1561 'id' => $eventId,
1562 'field' => 'description',
1563 'value' => 'setValueDescription: TheRest <> CiviCRM',
1564 ));
bc2bc079 1565 //$this->assertTrue((bool)$setValueDescriptionResult['is_error']); // not supported by setValue
1566 $this->assertAPISuccess($setValueDescriptionResult);
1567 $this->assertDBQuery('setValueDescription: TheRest <> CiviCRM', 'SELECT description FROM civicrm_event WHERE id = %1', array(
21dfd5f5 1568 1 => array($eventId, 'Integer'),
bc2bc079 1569 ));
6a488035 1570 }
96025800 1571
6a488035 1572}