Thanks, Terry: I think I see how to change My scripts to get them to work again. I should have read the documentation closer! George
On Fri, Nov 17, 2017 at 5:21 PM Terry Brady <[email protected]> wrote: > George, > > See the first section named "Hibernate" for a description of the change to > UUID. https://wiki.duraspace.org/display/DSPACE/DSpace+Release+6.0+Status > > The primary keys for nearly every table in DSpace were switched to UUID's > to support this change. Any SQL that you have will need to be modified to > support the change. > > The old resource_id / resource_type_id fields are still present on many > tables, but the intention is to use the UUIDs for all joins. > > Terry > > On Fri, Nov 17, 2017 at 9:55 AM, George Kozak <[email protected]> wrote: > >> Hi, >> I have some PERL DBI scripts that I run on a daily basis to pull >> information from the DSpace postgres database. After going to DSpace 6.2, >> I am seeing some problems. >> The first one, I encountered was a script that executed: >> select text_value from metadatavalue where metadata_field_id=66 and >> resource_id=$value; >> This line failed and I discovered that resource_id is no longer part of >> the metadatavalue table. Instead there is a uuid type field called >> "dspace_object_id". I am not familiar with "uuid" type fields. I see that >> the just substituting the resource_id value for dspace_object_id won't work. >> Can someone help me in figuring out this change? >> Thanks! >> >> -- >> *************************** >> George Kozak >> Digital Library Specialist >> Cornell University Library - IT >> 218 Olin Library >> Cornell University >> Ithaca, NY 14853 >> 607-255-8924 <(607)%20255-8924> >> [email protected] >> > -- >> You received this message because you are subscribed to the Google Groups >> "DSpace Technical Support" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/dspace-tech. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Terry Brady > Applications Programmer Analyst > Georgetown University Library Information Technology > https://github.com/terrywbrady/info > 425-298-5498 (Seattle, WA) > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. > -- *************************** George Kozak Digital Library Specialist Cornell University Library - IT 218 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 [email protected] -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
