notification::mark_sent (public)

 notification::mark_sent -notification_id notification_id \
    -user_id user_id

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

mark that a user has been sent a notification

Switches:

-notification_id (required)

-user_id (required)

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

Testcases:

No testcase defined.

Source code:

        # Do the insert
        db_dml insert_notification_user_map {}

Generic XQL file:

<fullquery name="notification::mark_sent.insert_notification_user_map">
    <querytext>
            insert
            into notification_user_map
            (notification_id, user_id, sent_date)
            select :notification_id, :user_id, current_timestamp
            from dual where exists (select 1 from notifications
                                    where notification_id = :notification_id)
        </querytext>
</fullquery>

packages/notifications/tcl/notification-procs.xql

PostgreSQL XQL file:

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

Oracle XQL file:

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