use Test::More qw(no_plan);
use strict;
use warnings;
use lib '/opt/openslx/lib';
# basic init
use OpenSLX::ConfigDB;
my $configDB = OpenSLX::ConfigDB->new;
$configDB->connect();
is(
my $group = $configDB->fetchGroupByFilter, undef,
'no group should exist (scalar context)'
);
foreach my $requiredCol (qw(name)) {
my $wrongGroup = {
'name' => 'name',
'priority' => 41,
'comment' => 'has column missing',
};
delete $wrongGroup->{$requiredCol};
ok(
! eval { my $groupID = $configDB->addGroup($wrongGroup); },
"inserting a group without '$requiredCol' column should fail"
);
}
is(
my @groups = $configDB->fetchGroupByFilter, 0,
'still no group should exist (array context)'
);
my $inGroup1 = {
'name' => 'grp-1',
'comment' => '',
'attrs' => {
'slxgrp' => 'slxgrp',
'start_snmp' => 'no',
'start_sshd' => 'yes',
},
};
is(
my $group1ID = $configDB->addGroup($inGroup1), 1,
'first group has ID 1'
);
my $inGroup2 = {
'name' => 'grp-2.0',
'priority' => 30,
'comment' => undef,
};
my $fullGroup = {
'name' => 'grp-nr-3',
'priority' => 50,
'comment' => 'nuff said',
'attrs' => {
'automnt_dir' => 'a',
'automnt_src' => 'b',
'country' => 'c',
'dm_allow_shutdown' => 'd',
'hw_graphic' => 'e',
'hw_monitor' => 'f',
'hw_mouse' => 'g',
'late_dm' => 'h',
'netbios_workgroup' => 'i',
'nis_domain' => 'j',
'nis_servers' => 'k',
'sane_scanner' => 'p',
'scratch' => 'q',
'slxgrp' => 'r',
'start_alsasound' => 's',
'start_atd' => 't',
'start_cron' => 'u',
'start_dreshal' => 'v',
'start_ntp' => 'w',
'start_nfsv4' => 'x',
'start_printer' => 'y',
'start_samba' => 'z',
'start_snmp' => 'A',
'start_sshd' => 'B',
'start_syslog' => 'C',
'start_x' => 'D',
'start_xdmcp' => 'E',
'tex_enable' => 'F',
'timezone' => 'G',
'tvout' => 'H',
'vmware' => 'I',
},
};
ok(
my ($group2ID, $group3ID) = $configDB->addGroup([
$inGroup2, $fullGroup
]),
'add two more groups'
);
is($group2ID, 2, 'group 2 should have ID=2');
is($group3ID, 3, 'group 3 should have ID=3');
# fetch group 3 by id and check all values
ok(my $group3 = $configDB->fetchGroupByID(3), 'fetch group 3');
is($group3->{id}, '3', 'group 3 - id');
is($group3->{name}, 'grp-nr-3', 'group 3 - name');
is($group3->{priority}, 50, 'group 3 - priority');
is($group3->{comment}, 'nuff said', 'group 3 - comment');
is($group3->{attrs}->{automnt_dir}, 'a', 'group 3 - attr automnt_dir');
is($group3->{attrs}->{automnt_src}, 'b', 'group 3 - attr automnt_src');
is($group3->{attrs}->{country}, 'c', 'group 3 - attr country');
is($group3->{attrs}->{dm_allow_shutdown}, 'd', 'group 3 - attr dm_allow_shutdown');
is($group3->{attrs}->{hw_graphic}, 'e', 'group 3 - attr hw_graphic');
is($group3->{attrs}->{hw_monitor}, 'f', 'group 3 - attr hw_monitor');
is($group3->{attrs}->{hw_mouse}, 'g', 'group 3 - attr hw_mouse');
is($group3->{attrs}->{late_dm}, 'h', 'group 3 - attr late_dm');
is($group3->{attrs}->{netbios_workgroup}, 'i', 'group 3 - attr netbios_workgroup');
is($group3->{attrs}->{nis_domain}, 'j', 'group 3 - attr nis_domain');
is($group3->{attrs}->{nis_servers}, 'k', 'group 3 - attr nis_servers');
is($group3->{attrs}->{sane_scanner}, 'p', 'group 3 - attr sane_scanner');
is($group3->{attrs}->{scratch}, 'q', 'group 3 - attr scratch');
is($group3->{attrs}->{slxgrp}, 'r', 'group 3 - attr slxgrp');
is($group3->{attrs}->{start_alsasound}, 's', 'group 3 - attr start_alsasound');
is($group3->{attrs}->{start_atd}, 't', 'group 3 - attr start_atd');
is($group3->{attrs}->{start_cron}, 'u', 'group 3 - attr start_cron');
is($group3->{attrs}->{start_dreshal}, 'v', 'group 3 - attr start_dreshal');
is($group3->{attrs}->{start_ntp}, 'w', 'group 3 - attr start_ftp');
is($group3->{attrs}->{start_nfsv4}, 'x', 'group 3 - attr start_nfsv4');
is($group3->{attrs}->{start_printer}, 'y', 'group 3 - attr start_printer');
is($group3->{attrs}->{start_samba}, 'z', 'group 3 - attr start_samba');
is($group3->{attrs}->{start_snmp}, 'A', 'group 3 - attr start_snmp');
is($group3->{attrs}->{start_sshd}, 'B', 'group 3 - attr start_sshd');
is($group3->{attrs}->{start_syslog}, 'C', 'group 3 - attr start_syslog');
is($group3->{attrs}->{start_x}, 'D', 'group 3 - attr start_x');
is($group3->{attrs}->{start_xdmcp}, 'E', 'group 3 - attr start_xdmcp');
is($group3->{attrs}->{tex_enable}, 'F', 'group 3 - attr tex_enable');
is($group3->{attrs}->{timezone}, 'G', 'group 3 - attr timezone');
is($group3->{attrs}->{tvout}, 'H', 'group 3 - attr tvout');
is($group3->{attrs}->{vmware}, 'I', 'group 3 - attr vmware');
is(keys %{$group3->{attrs}}, 31, 'group 3 - attribute count');
# fetch group 2 by a filter on id and check all values
ok(
my $group2 = $configDB->fetchGroupByFilter({ id => 2 }),
'fetch group 2 by filter on id'
);
is($group2->{id}, 2, 'group 2 - id');
is($group2->{name}, 'grp-2.0', 'group 2 - name');
is($group2->{priority}, 30, 'group 2 - priority');
is($group2->{comment}, undef, 'group 2 - comment');
is(keys %{$group2->{attrs}}, 0, 'group 2 - attribute count');
# fetch group 1 by filter on name and check all values
ok(
my $group1 = $configDB->fetchGroupByFilter({ name => 'grp-1' }),
'fetch group 1 by filter on name'
);
is($group1->{id}, 1, 'group 1 - id');
is($group1->{name}, 'grp-1', 'group 1 - name');
is($group1->{priority}, 50, 'group 1 - priority');
is($group1->{comment}, '', 'group 1 - comment');
is(keys %{$group1->{attrs}}, 3, 'group 1 - attribute count');
is($group1->{attrs}->{slxgrp}, 'slxgrp', 'group 1 - attr slxgrp');
is($group1->{attrs}->{start_snmp}, 'no', 'group 1 - attr start_snmp');
is($group1->{attrs}->{start_sshd}, 'yes', 'group 1 - attr start_sshd');
# fetch groups 3 & 1 by id
ok(
my @groups3And1 = $configDB->fetchGroupByID([3, 1]),
'fetch groups 3 & 1 by id'
);
is(@groups3And1, 2, 'should have got 2 groups');
# now sort by ID and check if we have really got 3 and 1
@groups3And1 = sort { $a->{id} cmp $b->{id} } @groups3And1;
is($groups3And1[0]->{id}, 1, 'first id should be 1');
is($groups3And1[1]->{id}, 3, 'second id should be 3');
# fetching groups by id without giving any should yield undef
is(
$configDB->fetchGroupByID(), undef,
'fetch groups by id without giving any'
);
# fetching groups by filter without giving any should yield all of them
ok(
@groups = $configDB->fetchGroupByFilter(),
'fetch groups by filter without giving any'
);
is(@groups, 3, 'should have got all three groups');
# fetch groups 1 & 2 by filter on priority
ok(
my @groups1And3 = $configDB->fetchGroupByFilter({ priority => 50 }),
'fetch groups 1 & 3 by filter on priority'
);
is(@groups1And3, 2, 'should have got 2 groups');
# now sort by ID and check if we have really got 1 and 3
@groups1And3 = sort { $a->{id} cmp $b->{id} } @groups1And3;
is($groups1And3[0]->{id}, 1, 'first id should be 1');
is($groups1And3[1]->{id}, 3, 'second id should be 3');
# fetch group 2 by filter on comment being undef'd
ok(
my @group2Only = $configDB->fetchGroupByFilter({ comment => undef }),
'fetch group 2 by filter on comment being undefined'
);
is(@group2Only, 1, 'should have got 1 group');
is($group2Only[0]->{id}, 2, 'first id should be 2');
# try to fetch with multi-column filter
ok(
($group1, $group3)
= $configDB->fetchGroupByFilter({ priority => '50', id => 1 }),
'fetching group with priority=50 and id=1 should work'
);
is($group1->{name}, 'grp-1', 'should have got grp-1');
is($group3, undef, 'should not get grp-nr-3');
# try to fetch multiple occurrences of the same group, combined with
# some unknown IDs
ok(
@groups1And3 = $configDB->fetchGroupByID([ 1, 21, 4-1, 1, 4, 1, 1 ]),
'fetch a complex set of groups by ID'
);
is(@groups1And3, 2, 'should have got 2 groups');
# now sort by ID and check if we have really got 1 and 3
@groups1And3 = sort { $a->{id} cmp $b->{id} } @groups1And3;
is($groups1And3[0]->{id}, 1, 'first id should be 1');
is($groups1And3[1]->{id}, 3, 'second id should be 3');
# filter groups by different attributes & values in combination
ok(
my @group1Only = $configDB->fetchGroupByFilter( {}, undef, {
start_snmp => 'no',
} ),
'fetch group 1 by filter on attribute start_snmp'
);
is(@group1Only, 1, 'should have got 1 group');
is($group1Only[0]->{id}, 1, 'first id should be 1');
ok(
@group1Only = $configDB->fetchGroupByFilter( undef, 'id', {
start_snmp => 'no',
tex_enable => undef,
} ),
'fetch group 1 by filter on attribute start_snmp + non-existing attr'
);
is(@group1Only, 1, 'should have got 1 group');
is($group1Only[0]->{id}, 1, 'first id should be 1');
ok(
@group1Only = $configDB->fetchGroupByFilter( {
name => 'grp-1',
priority => 50,
}, 'id', {
start_snmp => 'no',
tex_enable => undef,
} ),
'fetch group 1 by multiple filter on values and attributes'
);
is(@group1Only, 1, 'should have got 1 group');
is($group1Only[0]->{id}, 1, 'first id should be 1');
is(
$configDB->fetchGroupByFilter( {
comment => 'xxx',
}, 'id', {
start_snmp => 'no',
tex_enable => undef,
} ),
undef,
'mismatch group 1 by filter with incorrect value'
);
is(
$configDB->fetchGroupByFilter( {
name => 'grp-1',
}, 'id', {
start_snmp => 'yes',
tex_enable => undef,
} ),
undef,
'mismatch group 1 by filter with incorrect attribute value'
);
is(
$configDB->fetchGroupByFilter( {
name => 'grp-1',
}, 'id', {
start_sshd => undef,
} ),
undef,
'mismatch group 1 by filter with attribute not being empty'
);
# fetch groups 1 & 2 by filter on attribute start_samba not existing
ok(
my @groups1And2 = $configDB->fetchGroupByFilter( {}, undef, {
start_samba => undef,
} ),
'fetch groups 1 & 2 by filter on attribute start_samba not existing'
);
is(@groups1And2, 2, 'should have got 2 groups');
# now sort by ID and check if we have really got 1 and 2
@groups1And2 = sort { $a->{id} cmp $b->{id} } @groups1And2;
is($groups1And2[0]->{id}, 1, 'first id should be 1');
is($groups1And2[1]->{id}, 2, 'second id should be 2');
# try to fetch a couple of non-existing groups by id
is($configDB->fetchGroupByID(-1), undef, 'group with id -1 should not exist');
is($configDB->fetchGroupByID(0), undef, 'group with id 0 should not exist');
is(
$configDB->fetchGroupByID(1 << 31 + 1000), undef,
'trying to fetch another unknown group'
);
# try to fetch a couple of non-existing groups by filter
is(
$configDB->fetchGroupByFilter({ id => 4 }), undef,
'fetching group with id=4 by filter should fail'
);
is(
$configDB->fetchGroupByFilter({ name => 'grp-1.x' }), undef,
'fetching group with name="grp-1.x" should fail'
);
is(
$configDB->fetchGroupByFilter({ priority => '22', id => 1 }), undef,
'fetching group with priority=22 and id=1 should fail'
);
# rename group 1 and then fetch it by its new name
ok($configDB->changeGroup(1, { name => q{GRP-'1'} }), 'changing group 1');
ok(
$group1 = $configDB->fetchGroupByFilter({ name => q{GRP-'1'} }),
'fetching renamed group 1'
);
is($group1->{id}, 1, 'really got group number 1');
is($group1->{name}, q{GRP-'1'}, q{really got group named "GRP-'1'"});
# changing nothing at all should succeed
ok($configDB->changeGroup(1), 'changing nothing at all in group 1');
# adding attributes should work
$inGroup1->{attrs}->{slxgrp} = 'slxgrp1';
$inGroup1->{attrs}->{vmware} = 'yes';
ok($configDB->changeGroup(1, $inGroup1), 'adding attrs to group 1');
$group1 = $configDB->fetchGroupByID(1);
is($group1->{attrs}->{slxgrp}, 'slxgrp1', 'attr slxgrp has correct value');
is($group1->{attrs}->{vmware}, 'yes', 'attr vmware has correct value');
# changing an attribute should work
$inGroup1->{attrs}->{vmware} = 'no';
ok($configDB->changeGroup(1, $inGroup1), 'changing vmware in group 1');
$group1 = $configDB->fetchGroupByID(1);
is($group1->{attrs}->{slxgrp}, 'slxgrp1', 'attr slxgrp has correct value');
is($group1->{attrs}->{vmware}, 'no', 'attr vmware has correct value');
# deleting an attribute should remove it
delete $inGroup1->{attrs}->{slxgrp};
ok($configDB->changeGroup(1, $inGroup1), 'changing slxgrp in group 1');
$group1 = $configDB->fetchGroupByID(1);
ok(!exists $group1->{attrs}->{slxgrp}, 'attr slxgrp should be gone');
# undef'ing an attribute should remove it, too
$inGroup1->{attrs}->{vmware} = undef;
ok($configDB->changeGroup(1, $inGroup1), 'undefining vmware in group 1');
$group1 = $configDB->fetchGroupByID(1);
ok(!exists $group1->{attrs}->{vmware}, 'attr vmware should be gone');
# changing a non-existing column should fail
ok(
! eval { $configDB->changeGroup(1, { xname => "xx" }) },
'changing unknown colum should fail'
);
ok(! $configDB->changeGroup(1, { id => 23 }), 'changing id should fail');
# now remove an group and check if that worked
ok($configDB->removeGroup(2), 'removing group 2 should be ok');
is($configDB->fetchGroupByID(2, 'id'), undef, 'group 2 should be gone');
is($configDB->fetchGroupByID(1)->{id}, 1, 'group 1 should still exist');
is($configDB->fetchGroupByID(3)->{id}, 3, 'group 3 should still exist');
$configDB->disconnect();