copy (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__copy(CAST(:item_id AS integer),CAST(:target_folder_id AS integer),CAST(:creation_user AS integer),:creation_ip,:name)}]
return [ns_set value $s 0]
}
copy2 (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__copy2(CAST(:item_id AS integer),CAST(:target_folder_id AS integer),CAST(:creation_user AS integer),:creation_ip)}]
return [ns_set value $s 0]
}
del (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__del(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
delete (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__delete(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
edit_name (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__edit_name(CAST(:item_id AS integer),:name)}]
return [ns_set value $s 0]
}
generic_move (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__generic_move(CAST(:item_id AS integer),CAST(:target_item_id AS integer),:name)}]
return [ns_set value $s 0]
}
get_best_revision (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_best_revision(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_content_type (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_content_type(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_context (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_context(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_id (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_id(:item_path,CAST(:root_folder_id AS integer),:resolve_index)}]
return [ns_set value $s 0]
}
get_latest_revision (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_latest_revision(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_live_revision (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_live_revision(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_parent_folder (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_parent_folder(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_path (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_path(CAST(:item_id AS integer),CAST(:root_folder_id AS integer))}]
return [ns_set value $s 0]
}
get_publish_date (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_publish_date(CAST(:item_id AS integer),:is_live)}]
return [ns_set value $s 0]
}
get_revision_count (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_revision_count(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_root_folder (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_root_folder(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
get_template (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_template(CAST(:item_id AS integer),:use_context)}]
return [ns_set value $s 0]
}
get_title (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_title(CAST(:item_id AS integer),:is_live)}]
return [ns_set value $s 0]
}
get_virtual_path (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__get_virtual_path(CAST(:item_id AS integer),CAST(:root_folder_id AS integer))}]
return [ns_set value $s 0]
}
is_index_page (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__is_index_page(CAST(:item_id AS integer),CAST(:folder_id AS integer))}]
return [ns_set value $s 0]
}
is_publishable (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__is_publishable(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
is_published (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__is_published(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
is_subclass (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__is_subclass(:object_type,:supertype)}]
return [ns_set value $s 0]
}
is_valid_child (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__is_valid_child(CAST(:item_id AS integer),:content_type,:relation_tag)}]
return [ns_set value $s 0]
}
move (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__move(CAST(:item_id AS integer),CAST(:target_folder_id AS integer),:name)}]
return [ns_set value $s 0]
}
new (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__new(:name,CAST(:parent_id AS integer),CAST(:item_id AS integer),:locale,:creation_date,CAST(:creation_user AS integer),CAST(:context_id AS integer),:creation_ip,:item_subtype,:content_type,:title,:description,:mime_type,:nls_language,:text,:data,:relation_tag,:is_live,:storage_type,CAST(:package_id AS integer),:with_child_rels)}]
return [ns_set value $s 0]
}
register_template (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__register_template(CAST(:item_id AS integer),CAST(:template_id AS integer),:use_context)}]
return [ns_set value $s 0]
}
relate (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__relate(CAST(:item_id AS integer),CAST(:object_id AS integer),:relation_tag,CAST(:order_n AS integer),:relation_type)}]
return [ns_set value $s 0]
}
set_live_revision (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__set_live_revision(CAST(:revision_id AS integer),:publish_status,:publish_date,:is_latest)}]
return [ns_set value $s 0]
}
set_release_period (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__set_release_period(CAST(:item_id AS integer),:start_when,:end_when)}]
return [ns_set value $s 0]
}
unregister_template (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__unregister_template(CAST(:item_id AS integer),CAST(:template_id AS integer),:use_context)}]
return [ns_set value $s 0]
}
unrelate (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__unrelate(CAST(:rel_id AS integer))}]
return [ns_set value $s 0]
}
unset_live_revision (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__unset_live_revision(CAST(:item_id AS integer))}]
return [ns_set value $s 0]
}
write_to_file (scripted)
db_with_handle -dbn $dbn __DB {
set s [ns_pg_bind 0or1row $__DB {select content_item__write_to_file(CAST(:item_id AS integer),:root_path)}]
return [ns_set value $s 0]
}