Grouper Developers Forum

["Dr. Loris Bennett" <>]

On Fri, 2009-02-27 at 09:37 -0500, Chris Hyzer wrote:
> 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

This gives me the error

        Grouper ddl object type 'Grouper' has dbVersion: 0 and java
        version: 13
        org.apache.ddlutils.model.ModelException: There are multiple
        column with the name id in the table grouper_attributes

Didn't we have something like that before, due to some issue with
postgres?

> 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
> 
-- 
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