Forum OpenACS Development: Figuring out the package_id in upgrade scripts?

Collapse
1: Figuring out the package_id in upgrade scripts?
Posted by Alex Kroman on 08/18/05 05:19 PM
I'm currently making organizations and project-manager subsite aware. In each of the upgrade scripts I am going to need to add pacakge_id columns. How do I populate these columns with the correct package_id?
Collapse
2: Re: Figuring out the package_id in upgrade scripts? (response to 1)
Posted by Rocael Hernández Rizzardini on 08/18/05 05:38 PM
using the context_id of your objects?
Collapse
3: Re: Figuring out the package_id in upgrade scripts? (response to 1)
Posted by Dave Bauer on 08/18/05 05:46 PM
THis really depends on how the package is setup.

Somewhere you'd need a "parent" object that tells you the hierarchy of objects in your package.

Like Rocael said, if the context_id is set to the package_id, that might help out.

Collapse
4: Re: Figuring out the package_id in upgrade scripts? (response to 1)
Posted by Alex Kroman on 08/18/05 06:23 PM
select context_id from acs_objects where object_type = 'organization' gives the right package_id for organizations.

for project-manager (thanks to daveb):

SELECT
package_id
FROM
cr_folders
WHERE
description = 'Project Repository'
LIMIT 1

Gets the right ID.

select context_id from acs_objects where object_type = 'logger_project' limit 1 also seems to work.

Any preference on how to get the package_id for project manager?

Collapse
5: Re: Figuring out the package_id in upgrade scripts? (response to 1)
Posted by Malte Sussdorff on 08/18/05 06:39 PM
No answer to your questions, but with the HEAD version we made PM and organizations subsite aware using the acs_object's package_id paramter. Maybe, if you have a chance, you could switch to 5.2 before making your changes?