Re: [PATCH] WC DB verification triggers

2011-05-26 Thread Julian Foad
On Wed, 2011-05-25 at 06:06 -0400, Greg Stein wrote: > On May 25, 2011 5:50 AM, "Stefan Sperling" wrote: > > On Wed, May 25, 2011 at 10:12:42AM +0100, Julian Foad wrote: > > > We can catch some WC DB inconsistencies as soon as they happen by adding > > > SQLite "trigger" functions that fire on add

Re: [PATCH] WC DB verification triggers

2011-05-25 Thread Greg Stein
On May 25, 2011 5:50 AM, "Stefan Sperling" wrote: > > On Wed, May 25, 2011 at 10:12:42AM +0100, Julian Foad wrote: > > We can catch some WC DB inconsistencies as soon as they happen by adding > > SQLite "trigger" functions that fire on adding or modifying rows, and > > throw an error if some condi

Re: [PATCH] WC DB verification triggers

2011-05-25 Thread Stefan Sperling
On Wed, May 25, 2011 at 10:12:42AM +0100, Julian Foad wrote: > We can catch some WC DB inconsistencies as soon as they happen by adding > SQLite "trigger" functions that fire on adding or modifying rows, and > throw an error if some condition is not met. This is especially useful > in the NODES ta

[PATCH] WC DB verification triggers

2011-05-25 Thread Julian Foad
We can catch some WC DB inconsistencies as soon as they happen by adding SQLite "trigger" functions that fire on adding or modifying rows, and throw an error if some condition is not met. This is especially useful in the NODES table because of its complex rules. This patch is presented as a conce