Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

I ran those queries and they updated the PIT tables since I just did exactly what you did 😊.  If you don’t do that then your tables will be corrupt 😊

 

From: <> On Behalf Of Richard Frovarp
Sent: Thursday, October 31, 2019 1:29 PM
To: Mailing List <>
Subject: Re: [grouper-users] Change loader db name?

 

I was able to follow Chris' suggestion. Don't know about point in time data, but it was outside of my concern. Thanks for all of the advice.

 

On 10/31/19 12:20 PM, Shilen Patel wrote:

I think since this is a direct DB update, the point in time data won’t be updated.  So to do that:

 

update grouper_pit_attr_assn_value gaav set value_string = 'pennCommunity'  where gaav.value_string='grouper' and gaav.ATTRIBUTE_ASSIGN_ID in

(select aa.id from grouper_pit_attribute_assign aa where aa.source_id in

(select  gaaagv.attribute_assign_id2 from grouper_aval_asn_asn_group_v gaaagv where gaaagv.value_string = 'pennCommunity'

  and attribute_def_name_name2 = 'penn:etc:legacy:attribute:legacyAttribute_grouperLoaderDbName'));

 

It should update the same number of rows.

 

Thanks!

 

- Shilen

 

From: on behalf of "Hyzer, Chris"
Reply-To: "Hyzer, Chris"
Date: Thursday, October 31, 2019 at 10:17 AM
To: Richard Frovarp ,
Subject: Re: [grouper-users] Change loader db name?

 

I did something like this:

 

Find loader jobs:

select  gaaagv.attribute_assign_id2 from grouper_aval_asn_asn_group_v gaaagv where gaaagv.value_string = 'grouper'
  and attribute_def_name_name2 = 'penn:etc:legacy:attribute:legacyAttribute_grouperLoaderDbName'

 

Update them:

update grouper_attribute_assign_value gaav set value_string = 'pennCommunity'  where gaav.ATTRIBUTE_ASSIGN_ID in

(select  gaaagv.attribute_assign_id2 from grouper_aval_asn_asn_group_v gaaagv where gaaagv.value_string = 'grouper'

  and attribute_def_name_name2 = 'penn:etc:legacy:attribute:legacyAttribute_grouperLoaderDbName');

 

---

From: Hyzer, Chris
Sent: Monday, October 21, 2019 11:30 AM
To: Richard Frovarp ; Mailing List
Subject: RE: Change loader db name?

 

You can add the new database, go to all loaders and change the name to the new one, delete the old, bounce.  should be fine.  right?  😊

-----Original Message-----
From: On Behalf Of Richard Frovarp
Sent: Thursday, October 17, 2019 2:17 PM
To: Mailing List
Subject: [grouper-users] Change loader db name?

Wondering what sort of chaos I will incur if I change the name of the
database that my loaders are using. I named the legacy database the
thing that I would now like the new one to use. If I go into the config,
I can change the name of the DB, but what will that do to the loaders I
already have defined? Do I just delete the loaders and start over? Small
change? Or do I just consider that name lost to time?

Thanks,

Richard