3 +--------------------------------------------------------------------+
4 | CiviCRM version 4.7 |
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2016 |
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 class for CRM_Contact_BAO_Group BAO
34 class CRM_Contact_BAO_GroupTest
extends CiviUnitTestCase
{
37 * Sets up the fixture, for example, opens a network connection.
39 * This method is called before a test is executed.
41 protected function setUp() {
46 * Tears down the fixture, for example, closes a network connection.
48 * This method is called after a test is executed.
50 protected function tearDown() {
51 $this->quickCleanup(array('civicrm_mapping_field', 'civicrm_mapping', 'civicrm_group', 'civicrm_saved_search'));
55 * Test case for add( ).
57 public function testAddSimple() {
59 $checkParams = $params = array(
60 'title' => 'Group Uno',
61 'description' => 'Group One',
62 'visibility' => 'User and User Admin Only',
66 $group = CRM_Contact_BAO_Group
::create($params);
68 $this->assertDBCompareValues(
69 'CRM_Contact_DAO_Group',
70 array('id' => $group->id
),
76 * Test adding a smart group.
78 public function testAddSmart() {
80 $checkParams = $params = array(
81 'title' => 'Group Dos',
82 'description' => 'Group Two',
83 'visibility' => 'User and User Admin Only',
85 'formValues' => array('sort_name' => 'Adams'),
88 $group = CRM_Contact_BAO_Group
::createSmartGroup($params);
90 unset($checkParams['formValues']);
91 $this->assertDBCompareValues(
92 'CRM_Contact_DAO_Group',
93 array('id' => $group->id
),
99 * Load all sql data sets & return an array of saved searches.
103 public function dataProviderSavedSearch() {
105 $this->loadSavedSearches();
106 $results = CRM_Core_DAO
::singleValueQuery('SELECT GROUP_CONCAT(id) FROM civicrm_group WHERE saved_search_id IS NOT NULL');
107 return array(explode(',', $results));
111 * Load saved search sql files into the DB.
113 public function loadSavedSearches() {
114 $dsn = CRM_Core_Config
::singleton()->dsn
;
115 foreach (glob(dirname(__FILE__
) . "/SavedSearchDataSets/*.sql") as $file) {
116 CRM_Utils_File
::sourceSQLFile($dsn, $file);
121 * Check we can load smart groups based on config from 'real DBs' without fatal errors.
123 * Note that we are only testing lack of errors at this stage
124 * @todo - for some reason the data was getting truncated from the group table using dataprovider - would be preferable to get that working
125 * //@notdataProvider dataProviderSavedSearch
126 * //@notparam integer $groupID
128 * To add to this dataset do
131 * SELECT mapping_id FROM civicrm_group g LEFT JOIN civicrm_saved_search s ON saved_search_id = s.id WHERE g.id = @groupID INTO @mappingID;
132 * SELECT * FROM civicrm_mapping WHERE id = @mappingID;
133 * SELECT * FROM civicrm_mapping_field WHERE mapping_id = @mappingID;
134 * SELECT * FROM civicrm_saved_search WHERE mapping_id = @mappingID;
135 * SELECT g.* FROM civicrm_saved_search s LEFT JOIN civicrm_group g ON g.saved_search_id = s.id WHERE mapping_id = @mappingID;
137 * Copy the output to a single sql file and place in the SavedSearchDataSets folder - use the group number as the prefix.
138 * Try to keep as much of the real world irregular glory as you can! Don't change the table ids to be number 1 as this can hide errors
140 public function testGroupData() {
141 $groups = $this->dataProviderSavedSearch();
142 foreach ($groups[0] as $groupID) {
143 $group = new CRM_Contact_BAO_Group();
144 $group->id
= $groupID;
147 CRM_Contact_BAO_GroupContactCache
::load($group, TRUE);