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
SELECT ca_attributes__create_attribute (
'ca_ad', -- content_type
:attribute_name, -- attribute_name
:datatype, -- datatype
:pretty_name, -- pretty_name
:pretty_plural, -- pretty_plural
null, -- sort_order
:default_value, -- default_value
'type_specific', -- storage
'cr_ca_ads', -- table_name
:column_spec, -- column_spec
null -- package_id
);
SELECT ca_attributes__register_widget (
:attribute_id, -- attribute_name
:widget , -- widget
:pretty_name, -- label
:main_keyword_id, -- keyword_id
:html_options, -- html_options
:extra_options, -- extra_options
:select_options, -- select_options
:validate, -- validate
:optional_p, -- optional_p
:enabled_p -- enabled_p
);