VbzCart/docs/queries/qryCache Flow Procs: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (one field missing) |
imported>Woozle (more specific purpose) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': | * '''Purpose''': gives a list of procs for a given table, making sure that any proc with a set "doesClear" flag comes before the rest. | ||
* '''Requires''': {{vbzcart|table|cache_flow}}, {{vbzcart|table|cache_queries}} | * '''Requires''': {{vbzcart|table|cache_flow}}, {{vbzcart|table|cache_queries}} | ||
* '''Used by''': cache manager | * '''Used by''': cache manager | ||
Revision as of 03:14, 14 November 2010
About
- Purpose: gives a list of procs for a given table, making sure that any proc with a set "doesClear" flag comes before the rest.
- Requires: Template:Vbzcart, Template:Vbzcart
- Used by: cache manager
- History:
- 2010-11-09 Renamed tables, so had to fix this query; renamed from v_data_flow to qryCache_Flow_Queries
- 2010-11-13 Renamed from qryCache_Flow_Queries to qryCache_Flow_Procs; modified to use new cache_flow structure
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCache_Flow_Procs AS
SELECT cf.ID_Proc, cf.ID_Table, cf.doWrite, cp.doesClear FROM cache_flow AS cf LEFT JOIN cache_queries AS cp ON cf.ID_Proc=cp.ID ORDER BY cp.doesClear;</mysql>
<section end=sql />