VbzCart/tables/cache log - Revision history

Woozle: changed ID_Query back to ID_Proc

2010-11-10T23:03:31Z

changed ID_Query back to ID_Proc

← Older revision		Revision as of 23:03, 10 November 2010
Line 10:		Line 10:
	** '''2010-11-09''' Updating SQL before renaming page		** '''2010-11-09''' Updating SQL before renaming page
	*** (table) "data_log" -> "cache_log"		*** (table) "data_log" -> "cache_log"
	*** (field) "ID_Proc" -> "ID_Query" (now using VIEWs instead of PROCs)		*** (field) <s>"ID_Proc" -> "ID_Query" (now using VIEWs instead of PROCs)</s>
	*** (field) "Username" -> "WhoAdmin" (consistency with {{vbzcart\|table\|event_log}})		*** (field) "Username" -> "WhoAdmin" (consistency with {{vbzcart\|table\|event_log}})
	*** (field) Machine -> WhoNetwork" (consistency with {{vbzcart\|table\|event_log}})		*** (field) Machine -> WhoNetwork" (consistency with {{vbzcart\|table\|event_log}})
Line 20:		Line 20:
	WhenStarted DATETIME NOT NULL COMMENT "when this update was started",		WhenStarted DATETIME NOT NULL COMMENT "when this update was started",
	WhenFinished DATETIME COMMENT "when it was completed (NULL = it wasn't)",		WhenFinished DATETIME COMMENT "when it was completed (NULL = it wasn't)",
	~~ID_Query~~ INT NOT NULL COMMENT "cache_queries.ID of stored procedure used",		ID_Proc INT NOT NULL COMMENT "cache_queries.ID of stored procedure used",
	Caller VARCHAR(63) COMMENT "identifying string from code which caused the update",		Caller VARCHAR(63) COMMENT "identifying string from code which caused the update",
	WhoAdmin VARCHAR(127) COMMENT "VbzCart username",		WhoAdmin VARCHAR(127) COMMENT "VbzCart username",

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

2010-11-09T14:29:22Z

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

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

Woozle: major updates for caching rewrite

2010-11-09T14:29:05Z

major updates for caching rewrite

@@ Line 1: / Line 1: @@
 ==About==
 * '''Purpose''': Log of all cache updates performed
 * '''Notes''':
 ** The stored procedures don't automatically update this log; that is handled by the DataMgr classes.
@@ Line 7: / Line 8: @@
 *** Also added VbzUser, SysUser, and Machine, while I'm here (to be consistent with {{vbzcart/table|event_log}}). Sure, some updates are automatic, but some aren't.
 ** '''2009-03-25''' "VbzUser" makes this subsystem too interdependent with [[VbzCart]], so reducing to just one user field (Username). The system initiating the cache update may prefix the username with a qualifier (e.g. "vbz:", "wiki:", "sys:", or whatever seems appropriate; it's for human consumption and doesn't need to match a key anywhere else).
 ==SQL==
-<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_log`;
+<section begin=sql /><mysql>CREATE TABLE `cache_log` (
 CREATE TABLE `data_log` (
@@ Line 21: / Line 44: @@
      PRIMARY KEY (`ID`)
   ) ENGINE = MYISAM;</mysql>
-<section end=sql />
+===Retired 2009-03-24===
 <mysql>DROP TABLE IF EXISTS `data_log`;

Woozle: consolidating two usernames down to one

2009-03-25T12:18:24Z

consolidating two usernames down to one

← Older revision		Revision as of 12:18, 25 March 2009
Line 6:		Line 6:
	** '''2009-03-24''' Belatedly realized that it makes no sense to log source and destination each time; running the procedure updates a preset destination (a given function always updates the same destination) from ''all'' the function's sources.		** '''2009-03-24''' Belatedly realized that it makes no sense to log source and destination each time; running the procedure updates a preset destination (a given function always updates the same destination) from ''all'' the function's sources.
	*** Also added VbzUser, SysUser, and Machine, while I'm here (to be consistent with {{vbzcart/table\|event_log}}). Sure, some updates are automatic, but some aren't.		*** Also added VbzUser, SysUser, and Machine, while I'm here (to be consistent with {{vbzcart/table\|event_log}}). Sure, some updates are automatic, but some aren't.
			** '''2009-03-25''' "VbzUser" makes this subsystem too interdependent with [[VbzCart]], so reducing to just one user field (Username). The system initiating the cache update may prefix the username with a qualifier (e.g. "vbz:", "wiki:", "sys:", or whatever seems appropriate; it's for human consumption and doesn't need to match a key anywhere else).
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_log`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_log`;
Line 11:		Line 12:
	CREATE TABLE `data_log` (		CREATE TABLE `data_log` (
	ID INT NOT NULL AUTO_INCREMENT COMMENT "log line identifier",		ID INT NOT NULL AUTO_INCREMENT COMMENT "log line identifier",
	WhenStarted DATETIME NOT NULL COMMENT "when this ~~event~~ was started",		WhenStarted DATETIME NOT NULL COMMENT "when this update was started",
	WhenFinished DATETIME COMMENT "when it was completed (NULL = it wasn't)",		WhenFinished DATETIME COMMENT "when it was completed (NULL = it wasn't)",
	ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure used",		ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure used",
	Caller VARCHAR(63) COMMENT "identifying string from code which caused the update",		Caller VARCHAR(63) COMMENT "identifying string from code which caused the update",
	~~VbzUser~~ VARCHAR(255) COMMENT "~~VbzCart~~ user, if ~~any",~~		Username VARCHAR(255) COMMENT "identifier of user who initiated the change, if known",
	~~SysUser VARCHAR(127) COMMENT "Computer username, if any~~",		Machine VARCHAR(64) COMMENT "Network name (or IP address) of computer initiating the update, if any",
	Machine VARCHAR(64) COMMENT "Network name (or IP address) of computer initiating the ~~change~~, if any",
	Notes VARCHAR(255) COMMENT "historical human-created notes",		Notes VARCHAR(255) COMMENT "historical human-created notes",
	PRIMARY KEY (`ID`)		PRIMARY KEY (`ID`)

Woozle: got rid of redundant fields; added more user ID

2009-03-24T23:56:54Z

got rid of redundant fields; added more user ID

@@ Line 3: / Line 3: @@
 * '''Notes''':
 ** The stored procedures don't automatically update this log; that is handled by the DataMgr classes.
 ==SQL==
 <section begin=sql /><mysql>DROP TABLE IF EXISTS `data_log`;
 CREATE TABLE `data_log` (
@@ Line 17: / Line 37: @@
      PRIMARY KEY (`ID`)
   ) ENGINE = MYISAM;</mysql>

Woozle: New page: ==About== * '''Purpose''': Log of all cache updates performed * '''Notes''': ** The stored procedures don't automatically update this log; that is handled by the DataMgr classes. ==SQL== <...

2009-03-08T21:02:32Z

New page: ==About== * '''Purpose''': Log of all cache updates performed * '''Notes''': ** The stored procedures don't automatically update this log; that is handled by the DataMgr classes. ==SQL== <...

New page

==About==
* '''Purpose''': Log of all cache updates performed
* '''Notes''':
** The stored procedures don't automatically update this log; that is handled by the DataMgr classes.
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `data_log`;

CREATE TABLE `data_log` (
ID INT NOT NULL AUTO_INCREMENT COMMENT "log line identifier",
WhenStarted DATETIME NOT NULL COMMENT "when this event was started",
WhenFinished DATETIME COMMENT "when it was completed",
ID_TableDest INT NOT NULL COMMENT "data_tables.ID of table being updated",
ID_TableSrce INT NOT NULL COMMENT "data_tables.ID of triggering/source table",
ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure used",
Caller varchar(63) COMMENT "identifying string from code which caused the update",
Notes varchar(255) COMMENT "historical human-created notes",
PRIMARY KEY (`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />