category::change_parent (public)

 category::change_parent -category_id category_id -tree_id tree_id \
    [ -parent_id parent_id ]

Defined in packages/categories/tcl/categories-procs.tcl

Changes parent category of a category.

Switches:
-category_id
(required)
-tree_id
(required)
-parent_id
(optional)
Options:
-category_id
category_id whose parent should change.
-tree_id
tree_id of the category tree.
-parent_id
new parent category_id.
Author:
Timo Hentschel <timo@timohentschel.de>

Partial Call Graph (max 5 caller/called nodes):
%3 test_category_tree_procs category_tree_procs (test categories) category::change_parent category::change_parent test_category_tree_procs->category::change_parent category_tree::flush_cache category_tree::flush_cache (public) category::change_parent->category_tree::flush_cache db_exec_plsql db_exec_plsql (public) category::change_parent->db_exec_plsql packages/categories/www/cadmin/category-parent-change-2.tcl packages/categories/ www/cadmin/category-parent-change-2.tcl packages/categories/www/cadmin/category-parent-change-2.tcl->category::change_parent

Testcases:
category_tree_procs
Source code:
    db_exec_plsql change_parent_category ""
    category_tree::flush_cache $tree_id
XQL Not present:
Generic
PostgreSQL XQL file:
<fullquery name="category::change_parent.change_parent_category">
    <querytext>
	    select category__change_parent (
				    :category_id,
				    :tree_id,
				    :parent_id
				    )
      </querytext>
</fullquery>
packages/categories/tcl/categories-procs-postgresql.xql

Oracle XQL file:
<fullquery name="category::change_parent.change_parent_category">
    <querytext>
      
	    begin
	    category.change_parent (
				    category_id  => :category_id,
				    tree_id      => :tree_id,
				    parent_id    => :parent_id
				    );
	    end;
	
      </querytext>
</fullquery>
packages/categories/tcl/categories-procs-oracle.xql

[ hide source ] | [ make this the default ]
Show another procedure: