Changeset 158 for LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/Group.pm

Timestamp:

05/22/09 04:55:03 (15 years ago)

Author:

nanardon

Message:

• change db schema about group management

File:

• LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/Group.pm (modified) (3 diffs)

LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/Group.pm

@@ -69 +69 @@
             my $sth = $self->db->prepare_cached(
                 q{
-                select "user".uid from users_groups join "user"
-                on users_groups.uid = "user".uidNumber join
-                "group" on "group".gidnumber = users_groups.gid
-                where "group".groupname = ? order by uid
+                select id from user_attributes_groups
+                join user_attributes_list on
+                user_attributes_groups.attr = user_attributes_list.ikey
+                where value = ? and canonical = ?
                 }
             );
-            $sth->execute($self->id);
+            $sth->execute($self->id, 'memberOf');
             my @res;
             while (my $res = $sth->fetchrow_hashref) {
-                push(@res, $res->{uid});
+                push(@res, $res->{id});
             }
             return \@res;
@@ -91 +91 @@
     foreach my $attr (keys %data) {
         $attr =~ /^memberUID$/ and do {
-            my $gid = $self->get_field('gidnumber') or next;
+            my $cl = $self->base->_load_obj_class('user') or next;
+            my $attrid = $cl->_get_field_name_db('memberOf', $self->base) or next;
             my %member;
             foreach (@{ $self->get_field('memberUID') }) {
@@ -103 +104 @@
                 $member{$_}{c} && $member{$_}{n} and next; # no change !
                 my $user = $self->base->get_object('user', $_) or next;
-                my $uid = $user->get_field('uidnumber') or next;
                 if ($member{$_}{n}) {
                     my $sth = $self->db->prepare_cached(
-                        q{insert into users_groups (uid, gid) values (?,?)}
+                        q{insert into user_attributes_groups (id, attr, value) values (?,?,?)}
                     );
-                    $sth->execute($uid, $gid);
+                    $sth->execute($_, $attrid, $self->id);
                 } elsif ($member{$_}{c}) {
                     my $sth = $self->db->prepare_cached(
-                        q{delete from users_groups where uid = ? and gid = ?}
+                        q{delete from user_attributes_groups where id = ? and attr = ? and value = ?}
                     );
-                    $sth->execute($uid, $gid);
+                    $sth->execute($_, $attrid, $self->id);
                 } # else {} # can't happend
             }