[1028] | 1 | # -*- indent-tabs-mode: nil; tab-width: 4; -*- |
---|
| 2 | # vim:ft=perl:et:sw=4 |
---|
| 3 | # $Id$ |
---|
| 4 | |
---|
[1027] | 5 | use strict; |
---|
| 6 | use warnings; |
---|
[1028] | 7 | use Test::More; |
---|
[1027] | 8 | use FindBin qw($Bin); |
---|
| 9 | |
---|
[1792] | 10 | use DateTime; |
---|
| 11 | |
---|
[1028] | 12 | require "$Bin/common.pl"; |
---|
| 13 | eval "require '$Bin/config.pl'"; |
---|
[1027] | 14 | |
---|
[1028] | 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 { |
---|
[2434] | 20 | plan tests => 111; # Number of test |
---|
[1028] | 21 | } |
---|
[1027] | 22 | |
---|
| 23 | use_ok('LATMOS::Accounts'); |
---|
| 24 | use_ok('LATMOS::Accounts::Bases::Sql'); |
---|
| 25 | |
---|
[1028] | 26 | ok(my $la = LATMOS::Accounts->new(undef, noacl => 1), "Can get LATMOS::Accounts"); |
---|
[1027] | 27 | ok(my $base = $la->base($LA::T::SQLBASE), "can get SQL base $LA::T::SQLBASE"); |
---|
| 28 | |
---|
[1028] | 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", |
---|
[1795] | 36 | expire => undef, |
---|
[1028] | 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 | |
---|
[1031] | 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 | |
---|
[1028] | 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 | |
---|
[1793] | 51 | $base->rollback; |
---|
[1028] | 52 | |
---|
[2327] | 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 | |
---|
[1865] | 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); |
---|
[1910] | 92 | is($aobj->get_attributes('oaliascache'), $oid); |
---|
[1865] | 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"); |
---|
[1910] | 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 | |
---|
[1865] | 144 | } |
---|
| 145 | |
---|
| 146 | $base->rollback; |
---|
| 147 | |
---|
[1031] | 148 | { # test: group |
---|
[1028] | 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 | } |
---|
[1031] | 161 | |
---|
[1793] | 162 | $base->rollback; |
---|
| 163 | |
---|
[1031] | 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"); |
---|
[1567] | 174 | my ($ip) = $obj->get_attributes('ip'); |
---|
| 175 | is($ip, '255.255.255.255'); |
---|
[1031] | 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 | |
---|
[1793] | 181 | $base->rollback; |
---|
| 182 | |
---|
[1031] | 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 | } |
---|
[1792] | 197 | |
---|
[1793] | 198 | $base->rollback; |
---|
| 199 | |
---|
[1792] | 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, |
---|
[2251] | 215 | firstday => $baseEmpStart->ymd, |
---|
| 216 | lastday => $baseEmpEnd->ymd, |
---|
[1792] | 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, |
---|
[2251] | 225 | firstday => $EmpStart->ymd, |
---|
| 226 | lastday => $EmpEnd->ymd, |
---|
[1792] | 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, |
---|
[2251] | 236 | firstday => $EmpStart->ymd, |
---|
| 237 | lastday => $EmpEnd->ymd, |
---|
[1792] | 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, |
---|
[2251] | 247 | firstday => $EmpStart->ymd, |
---|
| 248 | lastday => $EmpEnd->ymd, |
---|
[1792] | 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, |
---|
[2251] | 258 | firstday => $EmpStart->ymd, |
---|
| 259 | lastday => $EmpEnd->ymd, |
---|
[1792] | 260 | ), "Cannot create employment overlapping another"); |
---|
| 261 | ok(!$base->delete_object('employment', $Emp), "Deleting Emp $Emp"); |
---|
| 262 | } |
---|
[1836] | 263 | ok($base->delete_object('employment', $baseEmp), "Deleting Emp BaseEmp $baseEmp"); |
---|
[1792] | 264 | |
---|
[1836] | 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, |
---|
[2251] | 272 | firstday => $EmpStart->ymd, |
---|
[1836] | 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, |
---|
[2252] | 281 | firstday => '2012-01-01', |
---|
| 282 | lastday => '2012-12-31', |
---|
[1836] | 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 | |
---|
[1792] | 293 | ok($base->delete_object('user', $empUser), "Deleting user $empUser"); |
---|
| 294 | } |
---|
[1793] | 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( |
---|
[1803] | 332 | [ $base->search_objects('user', 'givenName=Firstnamea', 'givenName=Firstnameb') ], |
---|
| 333 | [ 'searchuaa', 'searchuab', 'searchuba', 'searchubb' ] |
---|
[1793] | 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'); |
---|
[1803] | 343 | ok(! $base->search_objects('user', 'givenName=Firstnamea', 'sn=NoName'), 'Can search on 2 attributes, one return nothing'); |
---|
[1806] | 344 | ok($base->search_objects('user'), 'No filter return something'); |
---|
[1793] | 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 | |
---|
[2433] | 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') ], |
---|
[2435] | 370 | [ qw(searchubb) ] |
---|
[2433] | 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 !'); |
---|
[2434] | 376 | ok(eq_set( |
---|
| 377 | [ $base->search_objects('user', 'givenName=Firstnameb', '-memberOf=searchgb') ], |
---|
[2435] | 378 | [ qw(searchubb) ] |
---|
[2434] | 379 | ), 'Can search using filter operator !'); |
---|
[2433] | 380 | |
---|
[1793] | 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; |
---|