Grouper Users - Open Discussion List

[Chris Hyzer <>]

Fyi, I think generating a GSH script from SQL is convenient...  e.g. (mysql) 
[did I reply this way last time?  :) ]

select concat(concat('delGroup(', name), ')') from grouper_groups_v where 
name like 'loader:group%'

will generate:

delGroup("loader:group1");
delGroup("loader:group1_excludes");
delGroup("loader:group1_includes");
delGroup("loader:group1_systemOfRecord");
delGroup("loader:group1_systemOfRecordAndIncludes");
delGroup("loader:group2");
delGroup("loader:group2_excludes");
delGroup("loader:group2_includes");
delGroup("loader:group2_systemOfRecord");
delGroup("loader:group2_systemOfRecordAndIncludes");
delGroup("loader:group3");
delGroup("loader:group3_excludes");
delGroup("loader:group3_includes");
delGroup("loader:group3_systemOfRecord");
delGroup("loader:group3_systemOfRecordAndIncludes");
delGroup("loader:group4");
delGroup("loader:group4_excludes");
delGroup("loader:group4_includes");
delGroup("loader:group4_systemOfRecord");
delGroup("loader:group4_systemOfRecordAndIncludes");
delGroup("loader:group6");
delGroup("loader:group6_excludes");
delGroup("loader:group6_includes");
delGroup("loader:group6_systemOfRecord");
delGroup("loader:group6_systemOfRecordAndIncludes");

> -----Original Message-----
> From: Loris Bennett 
> [mailto:]
> Sent: Thursday, May 07, 2009 9:35 AM
> To: Grouper Users Mailing List
> Subject: Re: [grouper-users] Mass deletion?
> 
> OK, I have just added some stuff to my WS client to delete the groups
> and stems. This was simple as I knew exactly what had been mistakenly
> created.
> 
> Looking at the list I see that I have asked this question before. Sorry
> for that.
> 
> Loris
> 
> On Thu, 2009-05-07 at 14:27 +0200, Loris Bennett wrote:
> > Hi,
> >
> > Using the web service I have inadvertently created a whole bunch of
> > folders below root. Grouperloader has now created a single group in
> > each. While normalising the stem I had accidentally removed the ':'
> stem
> > separator. :-(
> >
> > I can uniquely identify all the groups and folders I want to remove,
> but
> > what is the best way of doing mass removal? Can it be done easily by
> > deleting stuff directly from the database, or can either gsh or
> > grouperClient deal with wildcards?
> >
> > Cheers
> >
> > Loris
> >
> --
> Dr. Loris Bennett (Mr.)
> Freie Universität Berlin
> ZEDAT - Zentraleinrichtung für Datenverarbeitung / Computer Center
> Compute & Media Service
> Fabeckstr. 32, Room 221
> D-14195 Berlin
> Tel ++49 30 838 51024
> Fax ++49 30 838 56721
> Email 
> 
> Web www.zedat.fu-berlin.de