rel-types-procs-postgresql.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="rel_types::additional_rel_types_group_p.group_rel_type_exists">      
<querytext>
    select case when exists (select 1
                             from acs_object_types t1, acs_object_types t2, group_type_rels g
                             where g.group_id = :group_id
                             and t2.object_type <> g.rel_type
                             and t1.object_type in ('membership_rel','composition_rel')
			     and t2.tree_sortkey between t1.tree_sortkey and tree_right(t1.tree_sortkey)
			     )
     then 1 else 0 end
</querytext>
</fullquery>

<fullquery name="rel_types::additional_rel_types_group_type_p.group_rel_type_exists">      
<querytext>
    select case when exists (select 1
                             from acs_object_types t1, acs_object_types t2, group_type_rels g
                             where g.group_type = :group_type
                             and t2.object_type <> g.rel_type
                             and t1.object_type in ('membership_rel','composition_rel')
			     and t2.tree_sortkey between t1.tree_sortkey and tree_right(t1.tree_sortkey)
			     )
     then 1 else 0 end
</querytext>
</fullquery>


<fullquery name="rel_types::new.drop_type">
<querytext>
	select acs_rel_type__drop_type(:rel_type, 'f')
</querytext>
</fullquery>

<fullquery name="rel_types::new.create_type">
<querytext>
select acs_rel_type__create_type (	
	:rel_type,
	:pretty_name,
	:pretty_plural,
	:supertype,
	:table_name,
	'rel_id',
	:package_name,
	:object_type_one,
	:role_one,
	:min_n_rels_one,
	:max_n_rels_one,
	:object_type_two,
	:role_two,
	:min_n_rels_two,
	:max_n_rels_two,
    :composable_p
);
</querytext>
</fullquery>

<fullquery name="rel_types::create_role.create_role">
<querytext>
      select acs_rel_type__create_role(:role, :pretty_name, :pretty_plural)
</querytext>
</fullquery>

<fullquery name="rel_types::delete_role.drop_role">
<querytext>
      select acs_rel_type__drop_role(:role)
</querytext>
</fullquery>

</queryset>