Woozle: 2008-03-15

2009-05-03T22:22:09Z

2008-03-15

← Older revision		Revision as of 22:22, 3 May 2009
Line 3:		Line 3:
	* '''Requires''': {{vbzcart/query\|qryCtg_src}}		* '''Requires''': {{vbzcart/query\|qryCtg_src}}
	* '''Used by''': [[VbzCart catalog building\|catalog building process]] (details to be documented)		* '''Used by''': [[VbzCart catalog building\|catalog building process]] (details to be documented)
			* '''History''':
			** '''2008-03-15''' Building sequence completely rewritten, so presumably this query was created then
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_src_dups AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_src_dups AS

Woozle: extracted from catalog building page

2009-05-03T22:06:34Z

extracted from catalog building page

New page

==About==
* '''Purpose''': Returns all duplicate records (each IDS_Item must be unique) in the generated source data. This should be performed as a check on data integrity before writing to cat_items; any duplicates may indicate a problem (typically, entering items from a new catalog but forgetting to mark the old one as superceded), and should be inspected. (Not sure if conflicts will prevent the update from completing; to be determined later.)
* '''Requires''': {{vbzcart/query|qryCtg_src}}
* '''Used by''': [[VbzCart catalog building|catalog building process]] (details to be documented)
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_src_dups AS
SELECT
IDS_Item,
COUNT(IDS_Item) AS cntRows
FROM qryCtg_src
GROUP BY IDS_Item
HAVING cntRows>1;</mysql>
<section end=sql />

VbzCart/queries/qryCtg src dups - Revision history

Woozle: 2008-03-15

Woozle: extracted from catalog building page