VbzCart/docs/procs/Upd Titles fr TitleIttyps: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (changed source to eliminate recursive loop) |
imported>Woozle (corrected input documentation) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Updates some fields in {{vbzcart|table|_titles}} | * '''Purpose''': Updates some fields in {{vbzcart|table|_titles}} | ||
* '''Input''': {{vbzcart| | * '''Input''': {{vbzcart/query|qryCat_Titles_Item_stats}}, grouped by ID_Title | ||
* '''Output''': {{vbzcart|table|_titles}} (update) | * '''Output''': {{vbzcart|table|_titles}} (update) | ||
* '''History''': | * '''History''': | ||
Revision as of 21:51, 24 December 2011
About
- Purpose: Updates some fields in Template:Vbzcart
- Input: Template:Vbzcart/query, grouped by ID_Title
- Output: Template:Vbzcart (update)
- History:
- 2010-11-10
- Added DROP PROCEDURE for easier maintenance.
- Created in database (procs were not ported from L48 to Rizzo).
- 2011-12-24 this was in a recursive loop: this→Template:Vbzcart→Template:Vbzcart→Template:Vbzcart→this, so changed source from Template:Vbzcart to Template:Vbzcart/query.
- 2010-11-10
SQL
<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps; CREATE PROCEDURE Upd_Titles_fr_TitleIttyps()
UPDATE _titles AS t LEFT JOIN (
SELECT
ID_Title,
SUM(ti.cntForSale) AS cntForSale,
SUM(ti.cntInPrint) AS cntInPrint,
SUM(ti.qtyForSale) AS qtyInStock
FROM qryCat_Titles_Item_stats AS ti GROUP BY ID_Title
) AS ti ON ti.ID_Title=t.ID
SET
t.cntForSale = ti.cntForSale,
t.cntInPrint = ti.cntInPrint,
t.qtyInStock = ti.qtyInStock;</mysql>
<section end=sql />