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');