bm_clean_up_session_data (public)

 bm_clean_up_session_data

Defined in packages/bookmarks/tcl/bookmarks-init.tcl

The table bm_in_closed_p holds session data that needs to be removed to avoid the table growing to large (maximum size of the table would be number_of_bookmarks times number_of_users)

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

Testcases:

No testcase defined.

Source code:

    set max_days 31
    db_dml delete_old_in_closed_p "delete from bm_in_closed_p where creation_date < (sysdate - :max_days)"

Generic XQL file:

packages/bookmarks/tcl/bookmarks-init.xql

PostgreSQL XQL file:

<fullquery name="bm_clean_up_session_data.delete_old_in_closed_p">
    <querytext>
      delete from bm_in_closed_p where creation_date < (current_timestamp - interval '$max_days day')
      </querytext>
</fullquery>

packages/bookmarks/tcl/bookmarks-init-postgresql.xql

Oracle XQL file:

<fullquery name="bm_clean_up_session_data.delete_old_in_closed_p">
    <querytext>
      delete from bm_in_closed_p where creation_date < (sysdate - :max_days)
      </querytext>
</fullquery>

packages/bookmarks/tcl/bookmarks-init-oracle.xql