VbzCart/tables/cache flow - Revision history

Woozle: used by

2010-11-13T22:26:54Z

used by

← Older revision		Revision as of 22:26, 13 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources		* '''Purpose''': Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources
			* '''Used by ''': {{vbzcart/query\|qryCache_Flow_Procs}}
	* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}		* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}
	* '''Fields''':		* '''Fields''':

Woozle: changing "query" back to "proc"

2010-11-13T22:17:17Z

changing "query" back to "proc"

← Older revision		Revision as of 22:17, 13 November 2010
Line 11:		Line 11:
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `cache_flow` (		<section begin=sql /><mysql>CREATE TABLE `cache_flow` (
	~~ID_Query~~ INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",		ID_Proc INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
	ID_Table INT NOT NULL COMMENT "cache_tables.ID of a table",		ID_Table INT NOT NULL COMMENT "cache_tables.ID of a table",
	doWrite BOOL COMMENT "TRUE = writes to this table",		doWrite BOOL COMMENT "TRUE = writes to this table",

Woozle: /* SQL */ syntax goof

2010-11-13T21:52:09Z

SQL: syntax goof

← Older revision		Revision as of 21:52, 13 November 2010
Line 15:		Line 15:
	doWrite BOOL COMMENT "TRUE = writes to this table",		doWrite BOOL COMMENT "TRUE = writes to this table",
	Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes",		Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
	PRIMARY KEY (`ID_Query`,`ID_Table`,)		PRIMARY KEY (`ID_Query`,`ID_Table`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: changed key structure

2010-11-13T21:36:39Z

changed key structure

← Older revision		Revision as of 21:36, 13 November 2010
Line 2:		Line 2:
	* '''Purpose''': Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources		* '''Purpose''': Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources
	* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}		* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}
			* '''Fields''':
			** '''doWrite''': TRUE = ID_Table is ''written'' to (i.e. TARGET table); otherwise it is only ''read'' from (SOURCE).
			* '''Notes''':
			** If it turns out that some tables are both read and written, then we might want a doRead field as well.
	* '''History''':		* '''History''':
	** '''2010-11-09''' Renamed data_flow -> cache_flow; ID_Proc -> ID_Query		** '''2010-11-09''' Renamed data_flow -> cache_flow; ID_Proc -> ID_Query
			** '''2010-11-13''' Significant revision: ID_Srce/ID_Dest replaced by ID_Table/doWrite
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `cache_flow` (		<section begin=sql /><mysql>CREATE TABLE `cache_flow` (
			ID_Query INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
			ID_Table INT NOT NULL COMMENT "cache_tables.ID of a table",
			doWrite BOOL COMMENT "TRUE = writes to this table",
			Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
			PRIMARY KEY (`ID_Query`,`ID_Table`,)
			) ENGINE = MYISAM;</mysql>
			<section end=sql />
			===previous version===
			<mysql>CREATE TABLE `cache_flow` (
	ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table",		ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table",
	ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table",		ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table",
Line 12:		Line 26:
	PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`)		PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: updated purpose

2010-11-09T14:19:13Z

updated purpose

← Older revision		Revision as of 14:19, 9 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Keeps track of data dependencies between tables – which ~~procs~~ update which ~~caches~~ from which sources		* '''Purpose''': Keeps track of data dependencies between tables – which queries update cached data in which tables from which sources
	* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}		* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}
	* '''History''':		* '''History''':

Woozle: moved VbzCart/tables/data flow to VbzCart/tables/cache flow: rewriting caching processes

2010-11-09T14:18:18Z

moved VbzCart/tables/data flow to VbzCart/tables/cache flow: rewriting caching processes

← Older revision	Revision as of 14:18, 9 November 2010
(No difference)

Woozle: updating history and SQL before renaming page

2010-11-09T14:18:00Z

updating history and SQL before renaming page

← Older revision		Revision as of 14:18, 9 November 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources		* '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources
			* '''Refers to''': {{vbzcart\|table\|cache_tables}}, {{vbzcart\|table\|cache_queries}}
			* '''History''':
			** '''2010-11-09''' Renamed data_flow -> cache_flow; ID_Proc -> ID_Query
	==SQL==		==SQL==
	<section begin=sql /><mysql>~~DROP TABLE IF EXISTS `data_flow`;~~		<section begin=sql /><mysql>CREATE TABLE `cache_flow` (
			ID_Srce INT NOT NULL COMMENT "cache_tables.ID of SOURCE table",
	CREATE TABLE `~~data_flow~~` (		ID_Dest INT NOT NULL COMMENT "cache_tables.ID of DESTINATION table",
	ID_Srce INT NOT NULL COMMENT "~~data_tables~~.ID of SOURCE table",		ID_Query INT NOT NULL COMMENT "cache_queries.ID of stored procedure which calculates Dest data from Srce data",
	ID_Dest INT NOT NULL COMMENT "~~data_tables~~.ID of DESTINATION table",		Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
	~~ID_Proc~~ INT NOT NULL COMMENT "~~data_procs~~.ID of stored procedure which calculates Dest data from Srce data",		PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Query`)
	Notes ~~varchar~~(255) COMMENT "loose explanatory or descriptive notes",
	PRIMARY KEY (`ID_Srce`,`ID_Dest`,`~~ID_Proc~~`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: New page: ==About== * '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources ==SQL==
DROP TABLE IF EXIS...

2009-03-08T21:00:10Z

New page: ==About== * '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXIS...

New page

==About==
* '''Purpose''': Keeps track of data dependencies between tables – which procs update which caches from which sources
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_flow`;

CREATE TABLE `data_flow` (
ID_Srce INT NOT NULL COMMENT "data_tables.ID of SOURCE table",
ID_Dest INT NOT NULL COMMENT "data_tables.ID of DESTINATION table",
ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure which calculates Dest data from Srce data",
Notes varchar(255) COMMENT "loose explanatory or descriptive notes",
PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Proc`)
) ENGINE = MYISAM;</mysql>
<section end=sql />