category_tree::copy (public)

 category_tree::copy -source_tree source_tree -dest_tree dest_tree

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

Copies a category tree into another category tree.

Switches:

-source_tree (required)

-dest_tree (required)

Options:

-source_tree

tree_id of the category tree to copy.

-dest_tree

tree_id of the category tree to copy into.

Author:

Timo Hentschel <timo@timohentschel.de>

Testcases:

category_tree_procs

Source code:

        set creation_user [ad_conn user_id]
        set creation_ip [ad_conn peeraddr]
        db_exec_plsql copy_tree ""
        category_tree::flush_cache $dest_tree
        category_tree::flush_translation_cache $dest_tree
        category::reset_translation_cache

XQL Not present:

Generic

PostgreSQL XQL file:

<fullquery name="category_tree::copy.copy_tree">
    <querytext>
	    select category_tree__copy(:source_tree, :dest_tree, :creation_user, :creation_ip)
      </querytext>
</fullquery>

packages/categories/tcl/category-trees-procs-postgresql.xql

Oracle XQL file:

<fullquery name="category_tree::copy.copy_tree">
    <querytext>
      
	    begin
	    category_tree.copy(
			       source_tree         => :source_tree,
			       dest_tree           => :dest_tree
			       );
	    end;
	
      </querytext>
</fullquery>

packages/categories/tcl/category-trees-procs-oracle.xql