Changeset 840


Ignore:
Timestamp:
03/26/10 08:38:51 (14 years ago)
Author:
nanardon
Message:
  • use sql view for managedObjects instead a specific query
File:
1 edited

Legend:

Unmodified
Added
Removed
  • LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/User.pm

    r835 r840  
    149149        } 
    150150        return \@res; 
    151     } elsif ($field eq 'managedObjects') { 
    152         my $sth = $self->db->prepare_cached( 
    153             q{ 
    154             select name from "group" join 
    155             group_attributes on group_attributes.okey = "group".ikey 
    156             where value = ? and attr = ? 
    157             } 
    158         ); 
    159         $sth->execute($self->id, 'managedBy'); 
    160         my @res; 
    161         while (my $res = $sth->fetchrow_hashref) { 
    162             push(@res, $res->{name}); 
    163         } 
    164         return \@res; 
    165151    } elsif ($field eq 'accountExpires') { 
    166152        my $sth = $self->db->prepare_cached( 
Note: See TracChangeset for help on using the changeset viewer.