VbzCart/docs/queries/qryTitles ItTyps ItTyps: Difference between revisions

Revision as of 19:20, 24 January 2011

Returns: list of available titles for each item type
- This query provides some of the same information as Template:Vbzcart, but (a) broken down by Item and (b) using live data.
Requires: Template:Vbzcart/query, Template:Vbzcart/table
Used by: can be used by catalog pages in place of cat_items to provide realtime data (instead of relying on some cached fields in cat_items), but this is very slow; currently no known uses.
History:
- 2009-04-13 had to recreate because qryTitles_ItTyps_grpItems changed
- 2011-01-24 For consistency with Template:Vbzcart:
  - ItTyp_Sort → ItTypSort
  - ItTyp_Sng → ItTypNameSng
  - ItTyp_Plr → ItTypNamePlr

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS SELECT

 i.*,
 it.Sort                       AS ItTypSort,
 it.NameSng                    AS ItTypNameSng,
 IFNULL(it.NamePlr,it.NameSng) AS ItTypNamePlr

FROM qryTitles_ItTyps_grpItems AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID;</mysql> <section end=sql />

@@ Line 1: / Line 1: @@
 ==About==
 * '''Returns''': list of available titles for each item type
-** This query generally provides the same information as {{vbzcart|table|_title_ittyps}}, but uses live (non-cached) data.
+** This query provides some of the same information as {{vbzcart|table|_title_ittyps}}, but (a) broken down by Item and (b) using live data.
-** There is probably some function-overlap between this query and the procedures which build that cached table.
 * '''Requires''': {{vbzcart/query|qryTitles_ItTyps_grpItems}}, {{vbzcart/table|cat_ittyps}}
-* '''Used by''': can be used by catalog title pages, but is very slow; currently no known uses
+* '''Used by''': can be used by catalog pages in place of cat_items to provide realtime data (instead of relying on some cached fields in cat_items), but this is very slow; currently no known uses.
 * '''History''':
 ** '''2009-04-13''' had to recreate because qryTitles_ItTyps_grpItems changed
-** '''2011-01-24''' For consistency with {{vbzcart|table|_title_ittyps}} so that they may be used interchangeably:
+** '''2011-01-24''' For consistency with {{vbzcart|table|_title_ittyps}}:
 *** '''ItTyp_Sort''' &rarr; '''ItTypSort'''
 *** '''ItTyp_Sng''' &rarr; '''ItTypNameSng'''