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>

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