postgresql7.1
select ca__get_folder_id (:package_id)
select content_item__get_content_type (:item_id)
select content_folder__register_content_type (:folder_id,
:content_type,
:include_subtypes)
select content_folder__new (:name,
:label,
:description,
:root_folder_id)
select ca__set_package_folder (:new_folder_id,
:package_id)
select content_item__new (:name::varchar,
:parent_id::int4,
:item_id::int4,
null,
now(),
:creation_user,
null,
:creation_ip,
:content_item,
:content_type,
null,
null,
'text/plain',
null,
null,
'text'::varchar)
select content_revision__new (:title,
:description,
now(),
null,
null,
:data,
:item_id,
null,
now(),
:creation_user,
:creation_ip)
$plsql_query
select content_keyword__item_assign (:cr_item_id,
:category_id,
null,
null,
null)
select content_revision__new (:title,
:description,
now(),
null,
null,
:data,
:item_id,
null,
now(),
:creation_user,
:creation_ip)
update cr_revisions
set title = :title,
description = :description,
content = :data
where revision_id = :object_id
$plsql_query
select content_item__is_subclass (:content_type,
:parent_type)
select ca_attributes__add_generic_value (:object_id,
:attribute_id,
:attr_value)
select ca_attributes__edit_generic_value (:object_id,
:attribute_id,
:attr_value)
select content_item__get_latest_revision (:item_id)
select content_revision__get_content (:revision_id)
select site_node__url(n2.node_id) as url,
n2.object_id,
acs_object__name(n2.object_id) as object_name,
tree_level(n2.tree_sortkey) as level
from (select tree_ancestor_keys(site_node_get_tree_sortkey(:node_id)) as tree_sortkey) parents,
site_nodes n2
where n2.tree_sortkey = parents.tree_sortkey
and tree_level(n2.tree_sortkey) > 1
order by level asc