merge-procs.xql

DB Query file

Related Files

• packages/acs-admin/tcl/merge-procs.xql
• packages/acs-admin/tcl/merge-procs.tcl

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>
    <fullquery name="merge::MergeUserInfo.to_user_portrait">
      <querytext>
	select c.item_id
	from acs_rels a, cr_items c
	where a.object_id_two = c.item_id
	and a.object_id_one = :to_user_id
	and a.rel_type = 'user_portrait_rel' 
      </querytext>
    </fullquery>

    <fullquery name="merge::MergeUserInfo.from_user_portrait">
      <querytext>
	select c.item_id
	from acs_rels a, cr_items c
	where a.object_id_two = c.item_id
	and a.object_id_one = :from_user_id
	and a.rel_type = 'user_portrait_rel' 
      </querytext>
    </fullquery>

    <fullquery name="merge::MergeUserInfo.upd_portrait">
      <querytext>
	update acs_rels
	set object_id_one = :to_user_id
	where object_id_one = :from_user_id
	and rel_type = 'user_portrait_rel' 
      </querytext>
    </fullquery>
    
    <fullquery name="merge::MergeUserInfo.getfromobjs">
      <querytext>
	select object_id as from_oid, privilege as from_priv from acs_permissions where grantee_id = :from_user_id
      </querytext>
    </fullquery>
    
    <fullquery name="merge::MergeUserInfo.touserhas">
      <querytext>
	select count(*) from acs_permissions where object_id = :from_oid and grantee_id = :to_user_id	
      </querytext>
    </fullquery>
    
    <fullquery name="merge::MergeUserInfo.acs_objs_upd">
      <querytext>
	update acs_objects
	set creation_user = :to_user_id
	where creation_user = :from_user_id 
      </querytext>
    </fullquery>

</queryset>