change-join-policy-2.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

<fullquery name="select_pretty_name">      
      <querytext>

    select t.dynamic_p,
           case when gt.group_type = null then 0 else 1 end as group_type_exists_p
      from acs_object_types t left outer join group_types gt on (t.object_type = gt.group_type)
     where t.object_type = :group_type

      </querytext>
</fullquery>

 
<fullquery name="set_default_join_policy">      
      <querytext>
      
	insert into group_types
	(group_type, default_join_policy)
	values
	(:group_type, :default_join_policy)
    
      </querytext>
</fullquery>

 
<fullquery name="update_join_policy">      
      <querytext>
      
	update group_types
	set default_join_policy = :default_join_policy
	where group_type = :group_type
    
      </querytext>
</fullquery>

 
</queryset>