VbzCart/procs/Upd Titles fr TitleIttyps - Revision history

Woozle: removed obsolete tag

2015-09-07T01:23:50Z

removed obsolete tag

← Older revision		Revision as of 01:23, 7 September 2015
Line 9:		Line 9:
	** '''2011-12-24''' this was in a recursive loop: this→{{vbzcart\|table\|_titles}}→{{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}→{{vbzcart\|table\|_title_ittyps}}→this, so changed source from {{vbzcart\|table\|_title_ittyps}} to {{vbzcart/query\|qryCat_Titles_Item_stats}}.		** '''2011-12-24''' this was in a recursive loop: this→{{vbzcart\|table\|_titles}}→{{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}→{{vbzcart\|table\|_title_ittyps}}→this, so changed source from {{vbzcart\|table\|_title_ittyps}} to {{vbzcart/query\|qryCat_Titles_Item_stats}}.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;		<mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;
	CREATE PROCEDURE Upd_Titles_fr_TitleIttyps()		CREATE PROCEDURE Upd_Titles_fr_TitleIttyps()
	UPDATE _titles AS t LEFT JOIN (		UPDATE _titles AS t LEFT JOIN (
Line 23:		Line 23:
	t.cntInPrint = ti.cntInPrint,		t.cntInPrint = ti.cntInPrint,
	t.qtyInStock = ti.qtyInStock;</mysql>		t.qtyInStock = ti.qtyInStock;</mysql>
	~~<section end=sql />~~

Woozle: corrected input documentation

2011-12-24T21:51:44Z

corrected input documentation

← Older revision		Revision as of 21:51, 24 December 2011
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Updates some fields in {{vbzcart\|table\|_titles}}		* '''Purpose''': Updates some fields in {{vbzcart\|table\|_titles}}
	* '''Input''': {{vbzcart\|~~table\|_title_ittyps~~}}, grouped by ID_Title		* '''Input''': {{vbzcart/query\|qryCat_Titles_Item_stats}}, grouped by ID_Title
	* '''Output''': {{vbzcart\|table\|_titles}} (update)		* '''Output''': {{vbzcart\|table\|_titles}} (update)
	* '''History''':		* '''History''':

Woozle: changed source to eliminate recursive loop

2011-12-24T21:14:48Z

changed source to eliminate recursive loop

← Older revision		Revision as of 21:14, 24 December 2011
Line 7:		Line 7:
	*** Added DROP PROCEDURE for easier maintenance.		*** Added DROP PROCEDURE for easier maintenance.
	*** Created in database (procs were not ported from L48 to Rizzo).		*** Created in database (procs were not ported from L48 to Rizzo).
			** '''2011-12-24''' this was in a recursive loop: this→{{vbzcart\|table\|_titles}}→{{vbzcart\|proc\|Upd_TitleIttyps_fr_Titles}}→{{vbzcart\|table\|_title_ittyps}}→this, so changed source from {{vbzcart\|table\|_title_ittyps}} to {{vbzcart/query\|qryCat_Titles_Item_stats}}.
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;
Line 15:		Line 16:
	SUM(ti.cntForSale) AS cntForSale,		SUM(ti.cntForSale) AS cntForSale,
	SUM(ti.cntInPrint) AS cntInPrint,		SUM(ti.cntInPrint) AS cntInPrint,
	SUM(ti.~~qtyInStock~~) AS qtyInStock		SUM(ti.qtyForSale) AS qtyInStock
	FROM ~~_title_ittyps~~ AS ti GROUP BY ID_Title		FROM qryCat_Titles_Item_stats AS ti GROUP BY ID_Title
	) AS ti ON ti.ID_Title=t.ID		) AS ti ON ti.ID_Title=t.ID
	SET		SET

Woozle: created in db

2010-11-10T15:19:00Z

created in db

← Older revision		Revision as of 15:19, 10 November 2010
Line 3:		Line 3:
	* '''Input''': {{vbzcart\|table\|_title_ittyps}}, grouped by ID_Title		* '''Input''': {{vbzcart\|table\|_title_ittyps}}, grouped by ID_Title
	* '''Output''': {{vbzcart\|table\|_titles}} (update)		* '''Output''': {{vbzcart\|table\|_titles}} (update)
			* '''History''':
			** '''2010-11-10'''
			*** Added DROP PROCEDURE for easier maintenance.
			*** Created in database (procs were not ported from L48 to Rizzo).
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE PROCEDURE Upd_Titles_fr_TitleIttyps()		<section begin=sql /><mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_TitleIttyps;
			CREATE PROCEDURE Upd_Titles_fr_TitleIttyps()
	UPDATE _titles AS t LEFT JOIN (		UPDATE _titles AS t LEFT JOIN (
	SELECT		SELECT

Woozle: New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_titles}} * '''Input''': {{vbzcart|table|_title_ittyps}}, grouped by ID_Title * '''Output''': {{vbzcart|table|_titles}} (u...

2009-03-08T19:44:54Z

New page: ==About== * '''Purpose''': Updates some fields in {{vbzcart|table|_titles}} * '''Input''': {{vbzcart|table|_title_ittyps}}, grouped by ID_Title * '''Output''': {{vbzcart|table|_titles}} (u...

New page

==About==
* '''Purpose''': Updates some fields in {{vbzcart|table|_titles}}
* '''Input''': {{vbzcart|table|_title_ittyps}}, grouped by ID_Title
* '''Output''': {{vbzcart|table|_titles}} (update)
==SQL==
<section begin=sql /><mysql>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.qtyInStock) AS qtyInStock
FROM _title_ittyps 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 />