{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Rule': 'TEXT', 'Trashed': 'INT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_gmail_cleanup
(Guid, Package, Rule, Trashed, Module)
VALUES
('{guid}', '{package}', '{rule}',
{trashed}, 'ObjServiceGmail')
SELECT
DATE(CreateTime) AS RunDate,
COUNT(*) AS RuleCount,
SUM(Trashed) AS TotalTrashed
FROM data_gmail_cleanup WHERE Package = '{package}'
AND CreateTime >= '{since}'
GROUP BY DATE(CreateTime) ORDER BY RunDate DESC