application_group::delete (public)

 application_group::delete -group_id group_id

Defined in packages/acs-subsite/tcl/application-group-procs.tcl

Delete the given application group and all relational segments and constraints dependent on it (handled by the PL/[pg]SQL API

Switches:

-group_id (required)

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

Testcases:

acs_subsite_application_group_new

Source code:

    # LARS HACK:
    # Delete permissions on:
    # - the application group
    # - any relational segment of this group
    # - any relation with this group
    # We really ought to have cascading deletes on acs_permissions.grantee_id (and object_id)
    db_dml delete_perms {
        delete from acs_permissions
        where  grantee_id = :group_id
        or     grantee_id in (select segment_id from rel_segments where group_id = :group_id)
        or     grantee_id in (select rel_id from acs_rels where object_id_one = :group_id or object_id_two = :group_id)
    }

    db_exec_plsql delete {}

    db_flush_cache -cache_key_pattern application_group_*

XQL Not present:

Generic

PostgreSQL XQL file:

<fullquery name="application_group::delete.delete">
    <querytext>

		select application_group__delete (
	            :group_id
		)
	    
      </querytext>
</fullquery>

packages/acs-subsite/tcl/application-group-procs-postgresql.xql

Oracle XQL file:

<fullquery name="application_group::delete.delete">
    <querytext>
      
		begin
		application_group.del (
	                group_id      => :group_id
		);
		end;
	    
      </querytext>
</fullquery>

packages/acs-subsite/tcl/application-group-procs-oracle.xql