1 |
85ad3d82
|
Assos Assos
|
<?php
|
2 |
|
|
|
3 |
|
|
/**
|
4 |
|
|
* @file
|
5 |
|
|
* Definition of ViewsNodeRevisionRelationsTestCase.
|
6 |
|
|
*/
|
7 |
|
|
|
8 |
|
|
/**
|
9 |
|
|
* Tests basic node_revision table integration into views.
|
10 |
|
|
*/
|
11 |
|
|
class ViewsNodeRevisionRelationsTestCase extends ViewsSqlTest {
|
12 |
|
|
|
13 |
|
|
public static function getInfo() {
|
14 |
|
|
return array(
|
15 |
|
|
'name' => 'Tests basic node_revision integration',
|
16 |
|
|
'description' => 'Tests the integration of node_revision table of node module',
|
17 |
|
|
'group' => 'Views Modules',
|
18 |
|
|
);
|
19 |
|
|
}
|
20 |
|
|
|
21 |
|
|
/**
|
22 |
|
|
* Create a node with revision and rest result count for both views.
|
23 |
|
|
*/
|
24 |
|
|
public function testNodeRevisionRelationship() {
|
25 |
|
|
$node = $this->drupalCreateNode();
|
26 |
|
|
// Create revision of the node.
|
27 |
|
|
$node_revision = clone $node;
|
28 |
|
|
$node_revision->revision = 1;
|
29 |
|
|
node_save($node_revision);
|
30 |
|
|
$column_map = array(
|
31 |
|
|
'vid' => 'vid',
|
32 |
|
|
'node_revision_nid' => 'node_revision_nid',
|
33 |
|
|
'node_node_revision_nid' => 'node_node_revision_nid',
|
34 |
|
|
);
|
35 |
|
|
|
36 |
|
|
// Here should be two rows.
|
37 |
|
|
$view_nid = $this->test_view_node_revision_nid();
|
38 |
|
|
$this->executeView($view_nid, array($node->nid));
|
39 |
|
|
$resultset_nid = array(
|
40 |
|
|
array(
|
41 |
|
|
'vid' => '1',
|
42 |
|
|
'node_revision_nid' => '1',
|
43 |
|
|
'node_node_revision_nid' => '1',
|
44 |
|
|
),
|
45 |
|
|
array(
|
46 |
|
|
'vid' => '2',
|
47 |
|
|
'node_revision_nid' => '1',
|
48 |
|
|
'node_node_revision_nid' => '1',
|
49 |
|
|
),
|
50 |
|
|
);
|
51 |
|
|
$this->assertIdenticalResultset($view_nid, $resultset_nid, $column_map);
|
52 |
|
|
|
53 |
|
|
// There should be only one row with active revision 2.
|
54 |
|
|
$view_vid = $this->test_view_node_revision_vid();
|
55 |
|
|
$this->executeView($view_vid, array($node->nid));
|
56 |
|
|
$resultset_vid = array(
|
57 |
|
|
array(
|
58 |
|
|
'vid' => '2',
|
59 |
|
|
'node_revision_nid' => '1',
|
60 |
|
|
'node_node_revision_nid' => '1',
|
61 |
|
|
),
|
62 |
|
|
);
|
63 |
|
|
$this->assertIdenticalResultset($view_vid, $resultset_vid, $column_map);
|
64 |
|
|
}
|
65 |
|
|
|
66 |
|
|
/**
|
67 |
|
|
* Test view with default join on node.nid.
|
68 |
|
|
*/
|
69 |
|
|
function test_view_node_revision_nid() {
|
70 |
|
|
$view = new view();
|
71 |
|
|
$view->name = 'test_node_revision_nid';
|
72 |
|
|
$view->description = '';
|
73 |
|
|
$view->tag = '';
|
74 |
|
|
$view->base_table = 'node_revision';
|
75 |
|
|
$view->human_name = 'Test node revision nid';
|
76 |
|
|
$view->core = 7;
|
77 |
|
|
$view->api_version = '3.0';
|
78 |
|
|
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
|
79 |
|
|
|
80 |
|
|
/* Display: Master */
|
81 |
|
|
$handler = $view->new_display('default', 'Master', 'default');
|
82 |
|
|
$handler->display->display_options['use_more_always'] = FALSE;
|
83 |
|
|
$handler->display->display_options['access']['type'] = 'perm';
|
84 |
|
|
$handler->display->display_options['access']['perm'] = 'view revisions';
|
85 |
|
|
$handler->display->display_options['cache']['type'] = 'none';
|
86 |
|
|
$handler->display->display_options['query']['type'] = 'views_query';
|
87 |
|
|
$handler->display->display_options['exposed_form']['type'] = 'basic';
|
88 |
|
|
$handler->display->display_options['pager']['type'] = 'full';
|
89 |
|
|
$handler->display->display_options['style_plugin'] = 'default';
|
90 |
|
|
$handler->display->display_options['row_plugin'] = 'fields';
|
91 |
|
|
/* Relationship: Content revision: Content */
|
92 |
|
|
$handler->display->display_options['relationships']['nid']['id'] = 'nid';
|
93 |
|
|
$handler->display->display_options['relationships']['nid']['table'] = 'node_revision';
|
94 |
|
|
$handler->display->display_options['relationships']['nid']['field'] = 'nid';
|
95 |
|
|
$handler->display->display_options['relationships']['nid']['label'] = 'NID';
|
96 |
|
|
$handler->display->display_options['relationships']['nid']['required'] = TRUE;
|
97 |
|
|
/* Field: Content revision: Vid */
|
98 |
|
|
$handler->display->display_options['fields']['vid']['id'] = 'vid';
|
99 |
|
|
$handler->display->display_options['fields']['vid']['table'] = 'node_revision';
|
100 |
|
|
$handler->display->display_options['fields']['vid']['field'] = 'vid';
|
101 |
|
|
/* Field: Content revision: Nid */
|
102 |
|
|
$handler->display->display_options['fields']['nid_1']['id'] = 'nid_1';
|
103 |
|
|
$handler->display->display_options['fields']['nid_1']['table'] = 'node_revision';
|
104 |
|
|
$handler->display->display_options['fields']['nid_1']['field'] = 'nid';
|
105 |
|
|
/* Field: Content: Nid */
|
106 |
|
|
$handler->display->display_options['fields']['nid']['id'] = 'nid';
|
107 |
|
|
$handler->display->display_options['fields']['nid']['table'] = 'node';
|
108 |
|
|
$handler->display->display_options['fields']['nid']['field'] = 'nid';
|
109 |
|
|
$handler->display->display_options['fields']['nid']['relationship'] = 'nid';
|
110 |
|
|
/* Contextual filter: Content revision: Nid */
|
111 |
|
|
$handler->display->display_options['arguments']['nid']['id'] = 'nid';
|
112 |
|
|
$handler->display->display_options['arguments']['nid']['table'] = 'node_revision';
|
113 |
|
|
$handler->display->display_options['arguments']['nid']['field'] = 'nid';
|
114 |
|
|
$handler->display->display_options['arguments']['nid']['default_argument_type'] = 'fixed';
|
115 |
|
|
$handler->display->display_options['arguments']['nid']['summary']['number_of_records'] = '0';
|
116 |
|
|
$handler->display->display_options['arguments']['nid']['summary']['format'] = 'default_summary';
|
117 |
|
|
$handler->display->display_options['arguments']['nid']['summary_options']['items_per_page'] = '25';
|
118 |
|
|
|
119 |
|
|
return $view;
|
120 |
|
|
}
|
121 |
|
|
|
122 |
|
|
/**
|
123 |
|
|
* Test view with default join on node.vid.
|
124 |
|
|
*/
|
125 |
|
|
function test_view_node_revision_vid() {
|
126 |
|
|
$view = new view();
|
127 |
|
|
$view->name = 'test_node_revision_vid';
|
128 |
|
|
$view->description = '';
|
129 |
|
|
$view->tag = '';
|
130 |
|
|
$view->base_table = 'node_revision';
|
131 |
|
|
$view->human_name = 'Test node revision vid';
|
132 |
|
|
$view->core = 7;
|
133 |
|
|
$view->api_version = '3.0';
|
134 |
|
|
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
|
135 |
|
|
|
136 |
|
|
/* Display: Master */
|
137 |
|
|
$handler = $view->new_display('default', 'Master', 'default');
|
138 |
|
|
$handler->display->display_options['use_more_always'] = FALSE;
|
139 |
|
|
$handler->display->display_options['access']['type'] = 'perm';
|
140 |
|
|
$handler->display->display_options['access']['perm'] = 'view revisions';
|
141 |
|
|
$handler->display->display_options['cache']['type'] = 'none';
|
142 |
|
|
$handler->display->display_options['query']['type'] = 'views_query';
|
143 |
|
|
$handler->display->display_options['exposed_form']['type'] = 'basic';
|
144 |
|
|
$handler->display->display_options['pager']['type'] = 'full';
|
145 |
|
|
$handler->display->display_options['style_plugin'] = 'default';
|
146 |
|
|
$handler->display->display_options['row_plugin'] = 'fields';
|
147 |
|
|
/* Relationship: Content revision: Content */
|
148 |
|
|
$handler->display->display_options['relationships']['vid']['id'] = 'vid';
|
149 |
|
|
$handler->display->display_options['relationships']['vid']['table'] = 'node_revision';
|
150 |
|
|
$handler->display->display_options['relationships']['vid']['field'] = 'vid';
|
151 |
|
|
$handler->display->display_options['relationships']['vid']['label'] = 'VID';
|
152 |
|
|
$handler->display->display_options['relationships']['vid']['required'] = TRUE;
|
153 |
|
|
/* Field: Content revision: Vid */
|
154 |
|
|
$handler->display->display_options['fields']['vid']['id'] = 'vid';
|
155 |
|
|
$handler->display->display_options['fields']['vid']['table'] = 'node_revision';
|
156 |
|
|
$handler->display->display_options['fields']['vid']['field'] = 'vid';
|
157 |
|
|
/* Field: Content revision: Nid */
|
158 |
|
|
$handler->display->display_options['fields']['nid_1']['id'] = 'nid_1';
|
159 |
|
|
$handler->display->display_options['fields']['nid_1']['table'] = 'node_revision';
|
160 |
|
|
$handler->display->display_options['fields']['nid_1']['field'] = 'nid';
|
161 |
|
|
/* Field: Content: Nid */
|
162 |
|
|
$handler->display->display_options['fields']['nid']['id'] = 'nid';
|
163 |
|
|
$handler->display->display_options['fields']['nid']['table'] = 'node';
|
164 |
|
|
$handler->display->display_options['fields']['nid']['field'] = 'nid';
|
165 |
|
|
$handler->display->display_options['fields']['nid']['relationship'] = 'vid';
|
166 |
|
|
/* Contextual filter: Content revision: Nid */
|
167 |
|
|
$handler->display->display_options['arguments']['nid']['id'] = 'nid';
|
168 |
|
|
$handler->display->display_options['arguments']['nid']['table'] = 'node_revision';
|
169 |
|
|
$handler->display->display_options['arguments']['nid']['field'] = 'nid';
|
170 |
|
|
$handler->display->display_options['arguments']['nid']['default_argument_type'] = 'fixed';
|
171 |
|
|
$handler->display->display_options['arguments']['nid']['summary']['number_of_records'] = '0';
|
172 |
|
|
$handler->display->display_options['arguments']['nid']['summary']['format'] = 'default_summary';
|
173 |
|
|
$handler->display->display_options['arguments']['nid']['summary_options']['items_per_page'] = '25';
|
174 |
|
|
|
175 |
|
|
return $view;
|
176 |
|
|
}
|
177 |
|
|
} |