category_link::add (public)

 category_link::add -from_category_id from_category_id \
    -to_category_id to_category_id

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

Insert a new category link.

Switches:

-from_category_id (required)

-to_category_id (required)

Options:

-from_category_id

category_id the links comes from.

-to_category_id

category_id the link goes to.

Returns:

link_id

Author:

Timo Hentschel <timo@timohentschel.de>

Testcases:

category_link

Source code:

    db_transaction {
    set link_id [db_exec_plsql insert_category_link ""]
    }
    return $link_id

XQL Not present:

Generic

PostgreSQL XQL file:

<fullquery name="category_link::add.insert_category_link">
    <querytext>
        	select category_link__new (
					 :from_category_id,
					 :to_category_id
					 )
      </querytext>
</fullquery>

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

Oracle XQL file:

<fullquery name="category_link::add.insert_category_link">
    <querytext>
      
		begin
		:1 := category_link.new (
					 from_category_id => :from_category_id,
					 to_category_id   => :to_category_id
					);
		end;
	    
      </querytext>
</fullquery>

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