Versions Compared

Old Version 21

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

compared with

New Version 22

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DDL is the database table and view structure. 

DDL upgrade

MethodHowDescription
Auto

grouper.hibernate.properties

Code Block
registry.auto.ddl.upToVersion = 2.5.*


Just start the Grouper UI or WS or GSH or the daemon, and Grouper will auto-upgrade the DDL
Manual run script


Code Block
docker exec -u tomcat -it grouper-ui /bin/bash
cd /opt/grouper/grouperWebapp/WEB-INF/bin
./gsh.sh -registry -check -runscript


This will generate a script and run it in your database
Manual generate script


Code Block
docker exec -u tomcat -it grouper-ui /bin/bash
cd /opt/grouper/grouperWebapp/WEB-INF/bin
./gsh.sh -registry -check


This will generate a script that you can run against your database

Database upgrades in v2.5

...

Code Block
select * from grouper_ddl where object_name = 'Grouper'


VersionDescriptionDDL versionVerify
v2.5.22Add password and sync tables, adjust some views32

This should not have an error

Code Block
select count(1) from grouper_sync


v2.5.31Add recent membership tables and views, add PIT 
views, add grouper member columns for USDU		33

This should not have an error

Code Block
select distinct subject_resolution_resolvable from grouper_members;

select count(1) from grouper_recent_mships_load_v;


Description

Grouper 2.5+ can handle DDL more efficiently and automatically.  DDL can now also change during Grouper build number (previously we kept DDL largely to minor upgrades).

...