email_image::add_relation (public)

 email_image::add_relation -user_id user_id -item_id item_id

Defined in packages/acs-subsite/tcl/email-image-procs.tcl

Add a new relation between user_id and item_id

Switches:

-user_id

(required)

-item_id

(required)

the item_id of the image in the content repository

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    db_exec_plsql add_relation {}

Generic XQL file:

packages/acs-subsite/tcl/email-image-procs.xql

PostgreSQL XQL file:

<fullquery name="email_image::add_relation.add_relation">
    <querytext>
	select acs_rel__new (
        null,
        'email_image_rel',
        :user_id,
        :item_id,
        null,
        null,
        null
        )
     </querytext>
</fullquery>

packages/acs-subsite/tcl/email-image-procs-postgresql.xql

Oracle XQL file:

<fullquery name="email_image::add_relation.add_relation">
    <querytext>
        begin
          :1 := acs_rel.new (
                 rel_type => 'email_image_rel',
                 object_id_one => :user_id,
                 object_id_two => :item_id);
        end;
     </querytext>
</fullquery>

packages/acs-subsite/tcl/email-image-procs-oracle.xql