Grouper Developers Forum

[Chris Hyzer <>]

When it says its up to date, it is just looking at what version is in the 
grouper_ddl table, it isn’t actually checking the structure.

If you do a:

gsh.sh -registry -deep

or:

gsh.sh -registry -deep -runscript

That will generate and/or run the script that will check all the tables and 
cols and views and stuff.  It should recreate all your views, though it is a 
probably a good idea in non-dev to run the first one, and look at the script 
that will run (and potentially edit it if there are problems).  :)  Let me 
know if there are issues.

Regards,
Chris

> -----Original Message-----
> From: Dr. Loris Bennett 
> [mailto:]
> Sent: Friday, February 27, 2009 9:28 AM
> To: Chris Hyzer
> Cc: Grouper Dev Mailing List
> Subject: RE: [grouper-dev] Creation of "common views" when DB is
> initialised?
> 
> On Fri, 2009-02-27 at 08:46 -0500, Chris Hyzer wrote:
> > 1. Have you looked at grouper_groups_v?  It might be too heavyweight
> for what you need
> 
> Now, you mention it, I did have a look at that before. However, my
> current DB doesn't contain any views at all. Backups of the DB for
> previous Grouper version do, I now notice.
> 
>         bin/gsh.sh -registry -check
> 
> on the current, view-less DB says
> 
>         database table/object structure (ddl) is up to date
> 
> Did something not get initialised or did I just misclick somewhere and
> delete all the views?
> 
> Cheers
> 
> Loris
> 
> > 2. In grouper 1.5, those cols are moving to the grouper_groups table,
> so the view might not be necessary
> >
> > But yes, we can add this or other views to core grouper if people
> find them useful...  I already would like to see a better lightweight
> membership view:
> >
> > https://bugs.internet2.edu/jira/browse/GRP-231
> >
> > Chris
> >
> > > -----Original Message-----
> > > From: Dr. Loris Bennett 
> > > [mailto:]
> > > Sent: Friday, February 27, 2009 7:20 AM
> > > To: Grouper Dev Mailing List
> > > Subject: [grouper-dev] Creation of "common views" when DB is
> > > initialised?
> > >
> > > Hi,
> > >
> > > I am just trying out some stuff with grouperloader and, following
> one
> > > of
> > > Chris' examples, using a view which provides me with id, name,
> > > displayName, description for groups. Such a view seems to me to be
> so
> > > useful that I feel it would be nice if it were created when the
> grouper
> > > DB is initialised.
> > >
> > > I am sure there may well be other canditates for "common views".
> > >
> > > Thoughts?
> > >
> > > 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
> >
> --
> 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