1 | # -*- indent-tabs-mode: nil; tab-width: 4; -*- |
---|
2 | # vim:ft=perl:et:sw=4 |
---|
3 | # $Id$ |
---|
4 | |
---|
5 | use strict; |
---|
6 | use warnings; |
---|
7 | use Test::More; |
---|
8 | use FindBin qw($Bin); |
---|
9 | |
---|
10 | use DateTime; |
---|
11 | |
---|
12 | require "$Bin/common.pl"; |
---|
13 | eval "require '$Bin/config.pl'"; |
---|
14 | |
---|
15 | if ($@) { |
---|
16 | plan skip_all => 'no config found' if ($@); |
---|
17 | } elsif (!$LA::T::SQLBASE) { |
---|
18 | plan skip_all => 'No SQL base defined'; |
---|
19 | } else { |
---|
20 | plan tests => 111; # Number of test |
---|
21 | } |
---|
22 | |
---|
23 | use_ok('LATMOS::Accounts'); |
---|
24 | use_ok('LATMOS::Accounts::Bases::Sql'); |
---|
25 | |
---|
26 | ok(my $la = LATMOS::Accounts->new(undef, noacl => 1), "Can get LATMOS::Accounts"); |
---|
27 | ok(my $base = $la->base($LA::T::SQLBASE), "can get SQL base $LA::T::SQLBASE"); |
---|
28 | |
---|
29 | { # test: user |
---|
30 | my $oid = genid(); |
---|
31 | |
---|
32 | use_ok('LATMOS::Accounts::Bases::Sql::User'); |
---|
33 | ok($base->create_c_object('user', $oid, |
---|
34 | sn => "snUser", |
---|
35 | givenName => "givenNameUser", |
---|
36 | expire => undef, |
---|
37 | ), "Can create user $oid"); |
---|
38 | ok(my $obj = $base->get_object('user', $oid), "user $oid is actually deleted"); |
---|
39 | is($obj->get_attributes('sn'), "snUser"); |
---|
40 | |
---|
41 | my $passwd = genid(); |
---|
42 | ok($obj->set_password($passwd), "Can set password"); |
---|
43 | ok($base->authenticate_user($oid, $passwd), "can authenticate user"); |
---|
44 | ok(!$base->authenticate_user($oid, '----'), |
---|
45 | "don't authenticate with invalid password"); |
---|
46 | |
---|
47 | ok($base->delete_object('user', $oid), "Can delete user $oid"); |
---|
48 | ok(!$base->get_object('user', $oid), "user $oid is actually deleted"); |
---|
49 | } |
---|
50 | |
---|
51 | $base->rollback; |
---|
52 | |
---|
53 | |
---|
54 | { # test: query |
---|
55 | my $oid = genid(); |
---|
56 | |
---|
57 | use_ok('LATMOS::Accounts::Bases::Sql::User'); |
---|
58 | ok($base->create_c_object('user', $oid, |
---|
59 | sn => "snUser", |
---|
60 | givenName => "givenNameUser", |
---|
61 | expire => undef, |
---|
62 | ), "Can create user $oid"); |
---|
63 | ok(my $obj = $base->get_object('user', $oid), "user $oid is actually deleted"); |
---|
64 | |
---|
65 | is($obj->queryformat('%{name}'), $oid, 'queryformat %{name}'); |
---|
66 | is($obj->queryformat('%{_gecos}'), 'givenNameUser snUser,-,,', 'queryformat %{_gecos}'); |
---|
67 | } |
---|
68 | |
---|
69 | $base->rollback; |
---|
70 | |
---|
71 | { # test alias |
---|
72 | |
---|
73 | my $oid = genid(); |
---|
74 | |
---|
75 | ok($base->create_c_object('user', $oid, |
---|
76 | sn => "snUser", |
---|
77 | givenName => "givenNameUser", |
---|
78 | expire => undef, |
---|
79 | ), "Can create user $oid"); |
---|
80 | ok(my $realobj = $base->get_object('user', $oid), "user $oid is actually created"); |
---|
81 | |
---|
82 | my $aliasoid = genid(); |
---|
83 | |
---|
84 | ok($base->CreateAlias('user', $aliasoid, $oid), "Can create alias object"); |
---|
85 | |
---|
86 | ok(my $obj = $base->get_object('user', $aliasoid), "Can get object trought alias"); |
---|
87 | is($obj->get_attributes('sn'), 'snUser'); |
---|
88 | |
---|
89 | ok(my $aobj = $base->GetAlias('user', $aliasoid), "Can get alias object"); |
---|
90 | |
---|
91 | is($aobj->get_attributes('oalias'), $oid); |
---|
92 | is($aobj->get_attributes('oaliascache'), $oid); |
---|
93 | |
---|
94 | my $oidsub = genid(); |
---|
95 | ok($base->create_c_object('user', $oidsub, |
---|
96 | sn => "snUserSub", |
---|
97 | givenName => "givenNameSub", |
---|
98 | expire => undef, |
---|
99 | ), "Can create user $oid"); |
---|
100 | ok(my $subobj = $base->get_object('user', $oidsub), "user $oidsub is actually created"); |
---|
101 | |
---|
102 | $subobj->set_c_fields( |
---|
103 | managerContact => $aliasoid, |
---|
104 | ); |
---|
105 | |
---|
106 | is($subobj->get_c_field('manager'), $aliasoid, "Can get ref manager"); |
---|
107 | is($subobj->GetAttributeValue('manager'), $oid, "Can get ref manager via GetAttributeValue"); |
---|
108 | |
---|
109 | ok(eq_set( |
---|
110 | [ $base->search_objects('user', 'sn=snUser') ], |
---|
111 | [ $oid, $aliasoid ] |
---|
112 | ), 'Search retrieve alias'); |
---|
113 | |
---|
114 | ok(eq_set( |
---|
115 | [ $base->search_objects('user', 'sn=snUser', 'oalias=NULL') ], |
---|
116 | [ $oid ] |
---|
117 | ), 'Search with oalias=NULL don\'t retrieve alias'); |
---|
118 | |
---|
119 | ok(eq_set( |
---|
120 | [ $base->search_objects('user', 'sn=XXXXXXXXX') ], |
---|
121 | [ ] |
---|
122 | ), 'Search with no result don\'t retrieve alias'); |
---|
123 | |
---|
124 | ok($base->RemoveAlias('user', $aliasoid), "Removing Alias"); |
---|
125 | ok(!$base->GetAlias('user', $aliasoid), "Cannot get removed alias object"); |
---|
126 | |
---|
127 | $subobj->set_c_fields( |
---|
128 | managerContact => $oid, |
---|
129 | ); |
---|
130 | |
---|
131 | ok($base->CreateAlias('user', $aliasoid, "user.$oidsub.managerContact"), "Can create alias object"); |
---|
132 | ok($aobj = $base->GetAlias('user', $aliasoid), "Can get alias object"); |
---|
133 | is($aobj->get_attributes('oalias'), "user.$oidsub.managerContact"); |
---|
134 | is($aobj->get_attributes('oaliascache'), $oid); |
---|
135 | |
---|
136 | ok($aobj->set_c_fields(oalias => $oidsub)); |
---|
137 | is($aobj->get_attributes('oalias'), $oidsub); |
---|
138 | is($aobj->get_attributes('oaliascache'), $oidsub); |
---|
139 | |
---|
140 | ok($aobj->set_c_fields(oalias => "user.$oidsub.managerContact")); |
---|
141 | is($aobj->get_attributes('oalias'), "user.$oidsub.managerContact"); |
---|
142 | is($aobj->get_attributes('oaliascache'), $oid); |
---|
143 | |
---|
144 | } |
---|
145 | |
---|
146 | $base->rollback; |
---|
147 | |
---|
148 | { # test: group |
---|
149 | my $oid = genid(); |
---|
150 | |
---|
151 | use_ok('LATMOS::Accounts::Bases::Sql::Group'); |
---|
152 | ok($base->create_c_object('group', $oid, |
---|
153 | description => 'Group Test' |
---|
154 | ), "Can create group $oid"); |
---|
155 | ok(my $obj = $base->get_object('group', $oid), "group $oid is actually deleted"); |
---|
156 | is($obj->get_attributes('description'), "Group Test"); |
---|
157 | |
---|
158 | ok($base->delete_object('group', $oid), "Can delete group $oid"); |
---|
159 | ok(!$base->get_object('group', $oid), "group $oid is actually deleted"); |
---|
160 | } |
---|
161 | |
---|
162 | $base->rollback; |
---|
163 | |
---|
164 | { # test: nethost |
---|
165 | my $oid = genid(); |
---|
166 | |
---|
167 | use_ok('LATMOS::Accounts::Bases::Sql::Nethost'); |
---|
168 | ok($base->create_c_object('nethost', $oid, |
---|
169 | description => 'Nethost Test', |
---|
170 | ip => '255.255.255.255', # widely improbable to conflict with existing one |
---|
171 | ), "Can create nethost $oid"); |
---|
172 | ok(my $obj = $base->get_object('nethost', $oid), "nethost $oid is actually deleted"); |
---|
173 | is($obj->get_attributes('description'), "Nethost Test"); |
---|
174 | my ($ip) = $obj->get_attributes('ip'); |
---|
175 | is($ip, '255.255.255.255'); |
---|
176 | |
---|
177 | ok($base->delete_object('nethost', $oid), "Can delete nethost $oid"); |
---|
178 | ok(!$base->get_object('nethost', $oid), "nethost $oid is actually deleted"); |
---|
179 | } |
---|
180 | |
---|
181 | $base->rollback; |
---|
182 | |
---|
183 | { # test: netzone |
---|
184 | my $oid = genid(); |
---|
185 | |
---|
186 | use_ok('LATMOS::Accounts::Bases::Sql::Netzone'); |
---|
187 | ok($base->create_c_object('netzone', $oid, |
---|
188 | description => 'Netzone Test', |
---|
189 | type => 'dhcp', |
---|
190 | ), "Can create netzone $oid"); |
---|
191 | ok(my $obj = $base->get_object('netzone', $oid), "netzone $oid is actually deleted"); |
---|
192 | is($obj->get_attributes('description'), "Netzone Test"); |
---|
193 | |
---|
194 | ok($base->delete_object('netzone', $oid), "Can delete netzone $oid"); |
---|
195 | ok(!$base->get_object('netzone', $oid), "netzone $oid is actually deleted"); |
---|
196 | } |
---|
197 | |
---|
198 | $base->rollback; |
---|
199 | |
---|
200 | { # test employment |
---|
201 | use_ok('LATMOS::Accounts::Bases::Sql::Employment'); |
---|
202 | my $baseEmp = genid(); |
---|
203 | my $empUser = genid(); |
---|
204 | |
---|
205 | my $baseEmpStart = DateTime->now->subtract(days => 60); |
---|
206 | my $baseEmpEnd = DateTime->now->add(days => 60); |
---|
207 | |
---|
208 | ok($base->create_c_object('user', $empUser, |
---|
209 | sn => "snUser", |
---|
210 | givenName => "givenNameUser", |
---|
211 | ), "Can create user $empUser"); |
---|
212 | |
---|
213 | ok($base->create_c_object('employment', $baseEmp, |
---|
214 | user => $empUser, |
---|
215 | firstday => $baseEmpStart->ymd, |
---|
216 | lastday => $baseEmpEnd->ymd, |
---|
217 | ), "Can create current employment"); |
---|
218 | |
---|
219 | { |
---|
220 | my $Emp = genid(); |
---|
221 | my $EmpStart = DateTime->now->add(days => 61); |
---|
222 | my $EmpEnd = DateTime->now->add(days => 120); |
---|
223 | ok($base->create_c_object('employment', $Emp, |
---|
224 | user => $empUser, |
---|
225 | firstday => $EmpStart->ymd, |
---|
226 | lastday => $EmpEnd->ymd, |
---|
227 | ), "Can create employment after"); |
---|
228 | ok($base->delete_object('employment', $Emp), "Deleting Emp $Emp"); |
---|
229 | } |
---|
230 | { |
---|
231 | my $Emp = genid(); |
---|
232 | my $EmpStart = DateTime->now->subtract(days => 40); |
---|
233 | my $EmpEnd = DateTime->now->subtract(days => 20); |
---|
234 | ok(!$base->create_c_object('employment', $Emp, |
---|
235 | user => $empUser, |
---|
236 | firstday => $EmpStart->ymd, |
---|
237 | lastday => $EmpEnd->ymd, |
---|
238 | ), "Cannot create employment overlaping start"); |
---|
239 | ok(!$base->delete_object('employment', $Emp), "Deleting Emp $Emp"); |
---|
240 | } |
---|
241 | { |
---|
242 | my $Emp = genid(); |
---|
243 | my $EmpStart = DateTime->now->add(days => 30); |
---|
244 | my $EmpEnd = DateTime->now->add(days => 90); |
---|
245 | ok(!$base->create_c_object('employment', $Emp, |
---|
246 | user => $empUser, |
---|
247 | firstday => $EmpStart->ymd, |
---|
248 | lastday => $EmpEnd->ymd, |
---|
249 | ), "Cannot create employment overlapping end"); |
---|
250 | ok(!$base->delete_object('employment', $Emp), "Deleting Emp $Emp"); |
---|
251 | } |
---|
252 | { |
---|
253 | my $Emp = genid(); |
---|
254 | my $EmpStart = DateTime->now->subtract(days => 90); |
---|
255 | my $EmpEnd = DateTime->now->add(days => 90); |
---|
256 | ok(!$base->create_c_object('employment', $Emp, |
---|
257 | user => $empUser, |
---|
258 | firstday => $EmpStart->ymd, |
---|
259 | lastday => $EmpEnd->ymd, |
---|
260 | ), "Cannot create employment overlapping another"); |
---|
261 | ok(!$base->delete_object('employment', $Emp), "Deleting Emp $Emp"); |
---|
262 | } |
---|
263 | ok($base->delete_object('employment', $baseEmp), "Deleting Emp BaseEmp $baseEmp"); |
---|
264 | |
---|
265 | { |
---|
266 | |
---|
267 | $base->{_options}{allow_pasted_employment} = 1; |
---|
268 | my $Emp = genid(); |
---|
269 | my $EmpStart = DateTime->now->subtract(days => 90); |
---|
270 | ok($base->create_c_object('employment', $Emp, |
---|
271 | user => $empUser, |
---|
272 | firstday => $EmpStart->ymd, |
---|
273 | lastday => undef, |
---|
274 | ), "Can create unlimited employment"); |
---|
275 | ok(my $ouser = $base->get_object('user', $empUser), "Getting user object"); |
---|
276 | ok(!$ouser->get_attributes('expire'), 'User don t expire'); |
---|
277 | |
---|
278 | my $EmpOld = genid(); |
---|
279 | ok($base->create_c_object('employment', $EmpOld, |
---|
280 | user => $empUser, |
---|
281 | firstday => '2012-01-01', |
---|
282 | lastday => '2012-12-31', |
---|
283 | ), "Cannot create pasted employement"); |
---|
284 | |
---|
285 | ok($ouser = $base->get_object('user', $empUser), "Getting user object"); |
---|
286 | ok(!$ouser->get_attributes('expire'), 'User still don t expire'); |
---|
287 | |
---|
288 | ok($base->delete_object('employment', $Emp), "Deleting Emp $Emp"); |
---|
289 | ok($base->delete_object('employment', $EmpOld), "Deleting Emp $EmpOld"); |
---|
290 | $base->{_options}{allow_pasted_employment} = undef; |
---|
291 | } |
---|
292 | |
---|
293 | ok($base->delete_object('user', $empUser), "Deleting user $empUser"); |
---|
294 | } |
---|
295 | |
---|
296 | $base->rollback; |
---|
297 | |
---|
298 | { |
---|
299 | diag('Testing search'); |
---|
300 | |
---|
301 | ok($base->create_c_object('user', 'searchuaa', |
---|
302 | sn => "Lastnamea", |
---|
303 | givenName => "Firstnamea", |
---|
304 | ), "Can create user searchuaa"); |
---|
305 | ok($base->create_c_object('user', 'searchuna', |
---|
306 | sn => "Lastnamea", |
---|
307 | ), "Can create user searchuna"); |
---|
308 | ok($base->create_c_object('user', 'searchuab', |
---|
309 | sn => "Lastnamea", |
---|
310 | givenName => "Firstnameb", |
---|
311 | ), "Can create user searchuab"); |
---|
312 | ok($base->create_c_object('user', 'searchuba', |
---|
313 | sn => "Lastnameb", |
---|
314 | givenName => "Firstnamea", |
---|
315 | ), "Can create user searchuba"); |
---|
316 | ok($base->create_c_object('user', 'searchubb', |
---|
317 | sn => "Lastnameb", |
---|
318 | givenName => "Firstnameb", |
---|
319 | ), "Can create user searchubb"); |
---|
320 | ok($base->create_c_object('group', 'searchga', |
---|
321 | member => [ 'searchuaa', 'searchuba' ], |
---|
322 | ), "Can create group searchga"); |
---|
323 | ok($base->create_c_object('group', 'searchgb', |
---|
324 | member => [ 'searchuab', 'searchuba' ], |
---|
325 | ), "Can create group searchgb"); |
---|
326 | |
---|
327 | ok(eq_set( |
---|
328 | [ $base->search_objects('user', 'givenName=Firstnamea') ], |
---|
329 | [ 'searchuaa', 'searchuba' ] |
---|
330 | ), 'Can search on single attribute'); |
---|
331 | ok(eq_set( |
---|
332 | [ $base->search_objects('user', 'givenName=Firstnamea', 'givenName=Firstnameb') ], |
---|
333 | [ 'searchuaa', 'searchuab', 'searchuba', 'searchubb' ] |
---|
334 | ), 'Can search on single attribute with 2 values'); |
---|
335 | ok(eq_set( |
---|
336 | [ $base->search_objects('user', 'givenName=Firstnamea||Firstnameb') ], |
---|
337 | [ 'searchuaa', 'searchuba', 'searchuab', 'searchubb' ] |
---|
338 | ), 'Can search on single attribute with 2 values using ||'); |
---|
339 | ok(eq_set( |
---|
340 | [ $base->search_objects('user', 'givenName=Firstnamea', 'sn=Lastnamea') ], |
---|
341 | [ 'searchuaa' ] |
---|
342 | ), 'Can search on 2 attributes'); |
---|
343 | ok(! $base->search_objects('user', 'givenName=Firstnamea', 'sn=NoName'), 'Can search on 2 attributes, one return nothing'); |
---|
344 | ok($base->search_objects('user'), 'No filter return something'); |
---|
345 | ok(eq_set( |
---|
346 | [ $base->search_objects('user', 'givenName=NULL', 'sn=Lastnamea') ], |
---|
347 | [ 'searchuna' ] |
---|
348 | ), 'Can search on NULL attributes'); |
---|
349 | ok(eq_set( |
---|
350 | [ $base->search_objects('user', 'memberOf=searchga&&searchgb') ], |
---|
351 | [ 'searchuba' ], |
---|
352 | ), "Search using && with two values"); |
---|
353 | ok(eq_set( |
---|
354 | [ $base->search_objects('group', 'member.givenName=Firstnameb') ], |
---|
355 | [ 'searchgb' ], |
---|
356 | ), "Search using recursive search"); |
---|
357 | ok(eq_set( |
---|
358 | [ $base->search_objects('user', 'givenName~nameb') ], |
---|
359 | [ 'searchuab', 'searchubb' ] |
---|
360 | ), 'Can search using ~ operator'); |
---|
361 | |
---|
362 | diag('Testing filter operator'); |
---|
363 | |
---|
364 | ok(eq_set( |
---|
365 | [ $base->search_objects('user', 'givenName=Firstnameb', '+memberOf=searchga') ], |
---|
366 | [ qw(searchuaa searchuab searchuba searchubb) ] |
---|
367 | ), 'Can search using filter operator +'); |
---|
368 | ok(eq_set( |
---|
369 | [ $base->search_objects('user', 'givenName=Firstnameb', '-memberOf=searchgb') ], |
---|
370 | [ qw(searchubb) ] |
---|
371 | ), 'Can search using filter operator -'); |
---|
372 | ok(eq_set( |
---|
373 | [ $base->search_objects('user', 'memberOf=searchga', '!memberOf=searchgb') ], |
---|
374 | [ qw(searchuba) ] |
---|
375 | ), 'Can search using filter operator !'); |
---|
376 | ok(eq_set( |
---|
377 | [ $base->search_objects('user', 'givenName=Firstnameb', '-memberOf=searchgb') ], |
---|
378 | [ qw(searchubb) ] |
---|
379 | ), 'Can search using filter operator !'); |
---|
380 | |
---|
381 | ok($base->delete_object('user', 'searchuaa'), "deleting user searchuaa"); |
---|
382 | ok($base->delete_object('user', 'searchuna'), "deleting user searchuna"); |
---|
383 | ok($base->delete_object('user', 'searchuba'), "deleting user searchuba"); |
---|
384 | ok($base->delete_object('user', 'searchuab'), "deleting user searchuab"); |
---|
385 | ok($base->delete_object('user', 'searchubb'), "deleting user searchubb"); |
---|
386 | } |
---|
387 | |
---|
388 | $base->rollback; |
---|