category_synonym::search_sweeper (private)

 category_synonym::search_sweeper

Defined in packages/categories/tcl/category-synonyms-procs.tcl

Deletes results of old searches

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

Testcases:

No testcase defined.

Source code:

    db_dml delete_old_searches ""

Generic XQL file:

<fullquery name="category_synonym::search_sweeper.delete_old_searches">
    <querytext>
      delete from category_search
      where last_queried < current_timestamp - interval '1' day
    </querytext>
</fullquery>

packages/categories/tcl/category-synonyms-procs.xql

PostgreSQL XQL file:

packages/categories/tcl/category-synonyms-procs-postgresql.xql

Oracle XQL file:

packages/categories/tcl/category-synonyms-procs-oracle.xql