notification::type::delete (public)

 notification::type::delete -short_name short_name

Defined in packages/notifications/tcl/notification-type-procs.tcl

Remove a notification type. This is very rare.

Switches:

-short_name (required)

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

Testcases:

No testcase defined.

Source code:

        set type_id [notification::type::get_type_id_not_cached $short_name]

        db_exec_plsql delete_notification_type {}

        #
        # TODO: currently, the util_memoize_flush below does nothing
        # (we need in these rare cases a restart of the server to get
        # rid of the old cache entry - one can get still a
        # notification type id from the cache, although it is removed
        # from the db). The right thing would be a broadcast operation
        # for flushing (similar to xo*) or a blueprint epoch/refetch
        # (as under consideration for better live updates on the
        # OpenACS wish-list).
        #
        util_memoize_flush [list notification::type::get_type_id_not_cached $short_name]

Generic XQL file:

packages/notifications/tcl/notification-type-procs.xql

PostgreSQL XQL file:

<fullquery name="notification::type::delete.delete_notification_type">
    <querytext>
            select notification_type__delete(:type_id)
        </querytext>
</fullquery>

packages/notifications/tcl/notification-type-procs-postgresql.xql

Oracle XQL file:

<fullquery name="notification::type::delete.delete_notification_type">
    <querytext>
          begin
            notification_type.del(:type_id);
          end;
        </querytext>
</fullquery>

packages/notifications/tcl/notification-type-procs-oracle.xql