Index: openacs-4/packages/acs-kernel/acs-kernel.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v diff -u -r1.150.2.54 -r1.150.2.55 --- openacs-4/packages/acs-kernel/acs-kernel.info 28 Mar 2023 11:20:36 -0000 1.150.2.54 +++ openacs-4/packages/acs-kernel/acs-kernel.info 10 Jul 2023 09:29:25 -0000 1.150.2.55 @@ -9,15 +9,15 @@ f t - + OpenACS Core Team Routines and data models providing the foundation for OpenACS-based Web services. 2021-09-15 OpenACS The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures. 3 - + Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v diff -u -r1.58.2.3 -r1.58.2.4 --- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 15 Aug 2019 10:20:04 -0000 1.58.2.3 +++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 10 Jul 2023 09:29:25 -0000 1.58.2.4 @@ -1019,6 +1019,11 @@ parameter_name in apm_parameters.parameter_name%TYPE ) return apm_parameter_values.attr_value%TYPE; + function get_global_value ( + package_key in apm_packages.package_key%TYPE, + parameter_name in apm_parameters.parameter_name%TYPE + ) return apm_parameter_values.attr_value%TYPE; + procedure set_value ( package_id in apm_packages.package_id%TYPE, parameter_name in apm_parameters.parameter_name%TYPE, @@ -1734,7 +1739,7 @@ return value; end get_value; - procedure set_value ( + procedure set_global_value ( package_key in apm_packages.package_key%TYPE, parameter_name in apm_parameters.parameter_name%TYPE, attr_value in apm_parameter_values.attr_value%TYPE @@ -1766,7 +1771,18 @@ end set_value; + -- legacy function for backwards compatibility procedure set_value ( + package_key in apm_packages.package_key%TYPE, + parameter_name in apm_parameters.parameter_name%TYPE, + attr_value in apm_parameter_values.attr_value%TYPE + ) + is + begin + apm.set_global_value(package_key, parameter_name, attr_value); + end set_value; + + procedure set_value ( package_id in apm_packages.package_id%TYPE, parameter_name in apm_parameters.parameter_name%TYPE, attr_value in apm_parameter_values.attr_value%TYPE Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.10.1d10-5.18.1d19.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v diff -u -r1.79.2.3 -r1.79.2.4 --- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 19 Aug 2019 07:00:18 -0000 1.79.2.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql 10 Jul 2023 09:29:26 -0000 1.79.2.4 @@ -1800,13 +1800,12 @@ --- added -select define_function_args('apm__set_value','package_key,parameter_name,attr_value'); +select define_function_args('apm__set_global_value','package_key,parameter_name,attr_value'); -- --- procedure apm__set_value/3 +-- procedure apm__set_global_value/3 -- -CREATE OR REPLACE FUNCTION apm__set_value( +CREATE OR REPLACE FUNCTION apm__set_global_value( set_value__package_key varchar, set_value__parameter_name varchar, set_value__attr_value varchar @@ -1840,6 +1839,19 @@ END; $$ LANGUAGE plpgsql; +-- +-- legacy procedure apm__set_value/3 +-- Replaced now by apm__set_global_value +--- +CREATE OR REPLACE FUNCTION apm__set_value( + set_value__package_key varchar, + set_value__parameter_name varchar, + set_value__attr_value varchar +) RETURNS integer AS $$ +BEGIN + return apm__set_global_value(set_value__package_key, set_value__parameter_name, set_value__attr_value); +END; +$$ LANGUAGE plpgsql; -- added Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1d18-5.10.1d19.sql'. Fisheye: No comparison available. Pass `N' to diff?