Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] roll ups using the loader?

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] roll ups using the loader?


Chronological Thread 
  • From: Chris Hyzer <>
  • To: Scott Koranda <>, grouper-users <>
  • Subject: RE: [grouper-users] roll ups using the loader?
  • Date: Fri, 21 Mar 2014 16:36:29 +0000
  • Accept-language: en-US

Yes, that is what the classlist at penn and the joins to the grouper_groups table does...  obviously I need to revist that doc, its hard to understand.

 

I wrote this up earlier this year with a long discussion on the list:

 

https://spaces.internet2.edu/display/Grouper/Grouper+loader+example+include+exclude+and+privileges

 

 

Now you need to flex your SQL muscles and make a query that will create all the other groups for you (use UNION?). Or this could be multiple loader jobs.   This is in a separate loader job that runs after (?) the first one. You can join to the grouper groups table so that it only does groups that exist and wont have unresolvable subject errors. Note if you join to the grouper_groups table, the you will get better performance too.  However you might want to run this 3 times in a row (or however many times it needs) so that all can be managed in one day.

grouperLoaderQuery:   select group_name, subject_identifier, subject_source_id from course_group_structure_v

GROUP_NAME

SUBJECT_IDENTIFIER

SUBJECT_SOURCE_ID

courses:math101:math101

courses:math101:math101_students

g:gsa

courses:math101:math101

courses:math101:math101_instructors

g:gsa

courses:math101:math101_students

courses:math101:math101_students_includes

g:gsa

courses:math101:math101_students

courses:math101:math101_students_systemOfRecord

g:gsa

courses:math101:math101_instructors

courses:math101:math101_instructors_includes

g:gsa

courses:math101:math101_instructors

courses:math101:math101_instructors_systemOfRecord

g:gsa

courses:english101:english101

courses:english101:english101_students

g:gsa

courses:english101:english101

courses:english101:engilsh101_instructors

g:gsa

Now we can have privileges on these groups... again, you can do this with views, and unions, etc  Note, if you can join to the grouper_groups table and use the group UUIDs, it would be faster.

grouperLoaderGroupQuery: select group_name, readers, updaters from course_group_query_v

GROUP_NAME

READERS

UPDATERS

courses:math101:math101

courses:etc:courseReaders,courses:math101:math101_instructors

 

courses:math101:math101_students

courses:etc:courseReaders,courses:math101:math101_instructors

 

courses:math101:math101_students_includes

courses:etc:courseReaders,courses:math101:math101_instructors

courses:etc:courseUpdaters,courses:math101:math101_instructors

courses:math101:math101_instructors

courses:etc:courseReaders,courses:math101:math101_instructors

 

courses:math101:math101_instructors_includes

courses:etc:courseReaders,courses:math101:math101_instructors

courses:etc:courseUpdaters,courses:math101:math101_instructors

courses:english101:english101

courses:etc:courseReaders,courses:english101:english101_instructors

 

sdf

 

 

 

 

-----Original Message-----
From: [mailto:] On Behalf Of Scott Koranda
Sent: Friday, March 21, 2014 12:32 PM
To: grouper-users
Subject: [grouper-users] roll ups using the loader?

 

Hi,

 

Outside of the addIncludeExclude functionality is it possible for a

loader job to manage arbitrary "roll ups" of groups like 'students',

'instructors', and 'guests' into an 'all' group?

 

Thanks,

 

Scott K




Archive powered by MHonArc 2.6.16.

Top of Page