rel-types-procs-postgresql.xql
DB Query file
Related Files
- packages/acs-subsite/tcl/rel-types-procs.xql
- packages/acs-subsite/tcl/rel-types-procs.tcl
- packages/acs-subsite/tcl/rel-types-procs-postgresql.xql
- packages/acs-subsite/tcl/rel-types-procs-oracle.xql
[ hide source ]
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>