Displaying 1 result from an estimated 1 matches for "quota_insert".
2013 Jul 12
0
A sqlite-based quota dict
...ubject TEXT PRIMARY KEY NOT NULL,
-- The entity's size, expressed as a storage space use and as a message
-- count.
-- Note the NULL defaults: they allow to simplify the trigger's logics.
byte_count INTEGER DEFAULT NULL,
message_count INTEGER DEFAULT NULL
);
CREATE TRIGGER quota_insert
BEFORE INSERT ON quota
FOR EACH ROW
BEGIN
-- If there's a row to update, that's because the first INSERT of the "row
-- creation" has been performed.
-- (this UPDATE could probably be simplified if the insertion order,
-- byte_count then message_count, was guaranteed;...