Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix some minor problems with email notification support |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | email-alerts |
| Files: | files | file ages | folders |
| SHA3-256: | c2566260268c436328ea3b5bd2cd8779 |
| User & Date: | drh 2018-06-23 00:49:58 |
Context
|
2018-06-23
| ||
| 00:53 | Merge in support for email notifications. Munch more work is needed, but it seems ready to begin functional testing. check-in: b77f1aae user: drh tags: trunk | |
| 00:49 | Fix some minor problems with email notification support Closed-Leaf check-in: c2566260 user: drh tags: email-alerts | |
|
2018-06-22
| ||
| 19:48 | Improvements to on-line subscription management. check-in: e649820b user: drh tags: email-alerts | |
Changes
Changes to src/email.c.
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 .... 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 .... 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 |
@ -- The first character of the eventid determines the event type. @ -- Remaining characters determine the specific event. For example, @ -- 'c4413' means check-in with rid=4413. @ -- @ CREATE TABLE repository.pending_alert( @ eventid TEXT PRIMARY KEY, -- Object that changed @ sentSep BOOLEAN DEFAULT false, -- individual emails sent @ sendDigest BOOLEAN DEFAULT false, -- digest emails sent @ ) WITHOUT ROWID; @ @ -- Record bounced emails. If too many bounces are received within @ -- some defined time range, then cancel the subscription. Older @ -- entries are periodically purged. @ -- @ CREATE TABLE repository.email_bounce( ................................................................................ blob_appendf(&p->txt,"== %s %s ==\n%s\n%s/info/%.20s\n", db_column_text(&q,1), zType, db_column_text(&q,2), zUrl, db_column_text(&q,0) ); *pnEvent++; } db_finalize(&q); return anchor.pNext; } /* ** Put a header on an alert email ................................................................................ ** ** This command is intended for testing and debugging the logic ** that generates email alert text. */ void test_generate_alert_cmd(void){ int bActual = find_option("actual",0,0)!=0; Blob out; int i; int nEvent; EmailEvent *pEvent, *p; db_find_and_open_repository(0, 0); verify_all_options(); db_begin_transaction(); email_schema(); |
| | < |
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 .... 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 .... 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 |
@ -- The first character of the eventid determines the event type. @ -- Remaining characters determine the specific event. For example, @ -- 'c4413' means check-in with rid=4413. @ -- @ CREATE TABLE repository.pending_alert( @ eventid TEXT PRIMARY KEY, -- Object that changed @ sentSep BOOLEAN DEFAULT false, -- individual emails sent @ sendDigest BOOLEAN DEFAULT false -- digest emails sent @ ) WITHOUT ROWID; @ @ -- Record bounced emails. If too many bounces are received within @ -- some defined time range, then cancel the subscription. Older @ -- entries are periodically purged. @ -- @ CREATE TABLE repository.email_bounce( ................................................................................ blob_appendf(&p->txt,"== %s %s ==\n%s\n%s/info/%.20s\n", db_column_text(&q,1), zType, db_column_text(&q,2), zUrl, db_column_text(&q,0) ); (*pnEvent)++; } db_finalize(&q); return anchor.pNext; } /* ** Put a header on an alert email ................................................................................ ** ** This command is intended for testing and debugging the logic ** that generates email alert text. */ void test_generate_alert_cmd(void){ int bActual = find_option("actual",0,0)!=0; Blob out; int nEvent; EmailEvent *pEvent, *p; db_find_and_open_repository(0, 0); verify_all_options(); db_begin_transaction(); email_schema(); |