Index: openacs-4/packages/acs-content-repository/acs-content-repository.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/acs-content-repository.info,v
diff -u -r1.30 -r1.31
--- openacs-4/packages/acs-content-repository/acs-content-repository.info 26 Jan 2004 15:39:42 -0000 1.30
+++ openacs-4/packages/acs-content-repository/acs-content-repository.info 6 Feb 2004 20:02:03 -0000 1.31
@@ -7,7 +7,7 @@
t
t
-
+
Dan Wickstrom
The canonical repository for OpenACS content.
2004-01-21
@@ -17,7 +17,7 @@
other CMS backing functionality. Utilized by Bug Tracker, File Storage, and other packages.
-
+
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql 23 Jan 2004 05:45:45 -0000 1.11
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-extlink.sql 6 Feb 2004 20:02:03 -0000 1.12
@@ -10,6 +10,8 @@
-- License. Full text of the license is available from the GNU Project:
-- http://www.fsf.org/copyleft/gpl.html
+select define_function_args('content_extlink__new','name;null,url,label;null,description;null,parent_id,extlink_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null');
+
create or replace function content_extlink__new (varchar,varchar,varchar,varchar,integer,integer,timestamptz,integer,varchar)
returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql,v
diff -u -r1.25 -r1.26
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 23 Jan 2004 05:45:45 -0000 1.25
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-folder.sql 6 Feb 2004 20:02:03 -0000 1.26
@@ -33,8 +33,6 @@
end;' language 'plpgsql';
-- function new
-select define_function_args('content_folder__new','name,label,description,parent_id,context_id,folder_id,creation_date,creation_user,creation_ip');
-
create or replace function content_folder__new (varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar)
returns integer as '
declare
@@ -117,6 +115,8 @@
-- function new -- accepts security_inherit_p DaveB
+select define_function_args('content_folder__new','name,label,description;null,parent_id;null,context_id;null,folder_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null,security_inherit_p;null');
+
create or replace function content_folder__new (varchar,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar, boolean)
returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 9 Nov 2003 03:33:00 -0000 1.11
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-image.sql 6 Feb 2004 20:02:03 -0000 1.12
@@ -104,6 +104,11 @@
-- The Oracle version does allow a non-image type to be specified, as does my
-- alternative down below. This needs a little more straightening out.
+-- DRB: BLOB issues make it impractical to use package_instantiate_object to create
+-- new revisions that contain binary data so a higher-level Tcl API is required rather
+-- than the standard package_instantiate_object. So we don't bother calling define_function_args
+-- here.
+
create function image__new (varchar,integer,integer,integer,varchar,integer,varchar,varchar,varchar,varchar,boolean,timestamptz,varchar,integer,integer,integer
) returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.44 -r1.45
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 22 Jan 2004 03:38:11 -0000 1.44
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql 6 Feb 2004 20:02:03 -0000 1.45
@@ -42,6 +42,9 @@
end;' language 'plpgsql' stable;
-- new 19 param version of content_item__new
+
+select define_function_args('content_item__new','name,parent_id;null,item_id;null,locale;null,creation_date;current_timestamp,creation_user;null,context_id;null,creation_ip;null,item_subtype;content_item,content_type;content_revision,title;null,description;null,mime_type;text/plain,nls_language;null,text;null,data;null,relation_tag;null,is_live;f,storage_type;lob');
+
create or replace function content_item__new (
cr_items.name%TYPE,
cr_items.parent_id%TYPE,
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql,v
diff -u -r1.16 -r1.17
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql 26 Jan 2004 15:39:43 -0000 1.16
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-keyword.sql 6 Feb 2004 20:02:03 -0000 1.17
@@ -91,6 +91,9 @@
-- function new
+
+select define_function_args('content_keyword__new','heading,description;null,parent_id;null,keyword_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null,object_type;content_keyword');
+
create or replace function content_keyword__new (varchar,varchar,integer,integer,timestamptz,integer,varchar,varchar)
returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql,v
diff -u -r1.32 -r1.33
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql 11 Dec 2003 21:39:47 -0000 1.32
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql 6 Feb 2004 20:02:03 -0000 1.33
@@ -13,6 +13,12 @@
-- create or replace package body content_revision
-- function new
+
+-- DRB: BLOB issues make it impractical to use package_instantiate_object to create
+-- new revisions that contain binary data so a higher-level Tcl API is required rather
+-- than the standard package_instantiate_object. So we don't bother calling define_function_args
+-- here.
+
create or replace function content_revision__new (varchar,varchar,timestamptz,varchar,varchar,integer,integer,integer,timestamptz,integer,varchar)
returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql 23 Jan 2004 05:45:45 -0000 1.13
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-symlink.sql 6 Feb 2004 20:02:03 -0000 1.14
@@ -11,6 +11,9 @@
-- create or replace package body content_symlink
-- function new
+
+select define_function_args('content_symlink__new','name;null,label;null,target_id,parent_id,symlink_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null');
+
create or replace function content_symlink__new (varchar,varchar,integer,integer,integer,timestamptz,integer,varchar)
returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql 11 Dec 2003 21:39:47 -0000 1.10
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-template.sql 6 Feb 2004 20:02:03 -0000 1.11
@@ -36,6 +36,8 @@
-- function new
+select define_function_args('content_template__new','name,parent_id;null,template_id;null,creation_date;null,creation_user;null,creation_ip;null');
+
create or replace function content_template__new (varchar,integer,integer,timestamptz,integer,varchar)
returns integer as '
declare
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v
diff -u -r1.29 -r1.30
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 11 Dec 2003 21:39:47 -0000 1.29
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 6 Feb 2004 20:02:03 -0000 1.30
@@ -45,6 +45,9 @@
-- create or replace package body content_type is
-- procedure create_type
+
+select define_function_args('content_type__create_type','content_type,super_type;content_revision,pretty_name,pretty_plural,table_name;null,id_colum;XXX,name_method;null');
+
create or replace function content_type__create_type (varchar,varchar,varchar,varchar,varchar,varchar,varchar)
returns integer as '
declare
@@ -195,6 +198,7 @@
return 0;
end;' language 'plpgsql';
+select define_function_args('content_type__create_attribute','content_type,attribute_name,datatype,pretty_name,pretty_plural;null,sort_order;null,default_value;null,column_spec;text');
-- function create_attribute
create or replace function content_type__create_attribute (varchar,varchar,varchar,varchar,varchar,integer,varchar,varchar)
Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.0.0b4-5.1.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/Attic/upgrade-5.0.0b4-5.1.0d1.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.0.0b4-5.1.0d1.sql 6 Feb 2004 20:02:03 -0000 1.1
@@ -0,0 +1,15 @@
+select define_function_args('content_extlink__new','name;null,url,label;null,description;null,parent_id,extlink_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null');
+
+select define_function_args('content_folder__new','name,label,description;null,parent_id;null,context_id;null,folder_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null,security_inherit_p;null');
+
+select define_function_args('content_item__new','name,parent_id;null,item_id;null,locale;null,creation_date;current_timestamp,creation_user;null,context_id;null,creation_ip;null,item_subtype;content_item,content_type;content_revision,title;null,description;null,mime_type;text/plain,nls_language;null,text;null,data;null,relation_tag;null,is_live;f,storage_type;lob');
+
+select define_function_args('content_keyword__new','heading,description;null,parent_id;null,keyword_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null,object_type;content_keyword');
+
+select define_function_args('content_symlink__new','name;null,label;null,target_id,parent_id,symlink_id;null,creation_date;current_timestamp,creation_user;null,creation_ip;null');
+
+select define_function_args('content_template__new','name,parent_id;null,template_id;null,creation_date;null,creation_user;null,creation_ip;null');
+
+select define_function_args('content_type__create_type','content_type,super_type;content_revision,pretty_name,pretty_plural,table_name;null,id_colum;XXX,name_method;null');
+
+select define_function_args('content_type__create_attribute','content_type,attribute_name,datatype,pretty_name,pretty_plural;null,sort_order;null,default_value;null,column_spec;text');