askrobots / dbbasic-object-server
Public
Runs live, versioned Python application objects on one VM, with a suite of apps: projects, notes, tasks, files and more.
danq9
signup: the person chooses the password and name on the confirm page
83c7aa6
2 weeks, 5 days ago
History
mail_synced_messages.json · 2.5 KB · 29 lines
| 1 | { |
| 2 | "name": "mail_synced_messages", |
| 3 | "title": "Synced Mail", |
| 4 | "version": 1, |
| 5 | "storage": "append", |
| 6 | "description": "The transport facts about one copied message that app-messaging deliberately does not carry: which account, folder and IMAP UID it came from, the key it was deduplicated on, its References chain, and the list headers (List-Unsubscribe, List-Unsubscribe-Post, List-Id, Precedence). Kept here so the messages schema stays a mailbox and not an IMAP client, the scope line app-messaging's own tests hold. The list headers are STORED, never acted on: this server does not open URLs it finds in mail, because a server that fetches links out of messages can be made to issue requests by anyone who can send it an email. dedupe_key is the Message-ID (or, without one, a hash of sender, date, subject and body start); it is only ever compared inside one owner's one account, so the same message in two people's mailboxes is two rows. Append storage because each row is written once. Written only by system_mail_sync; the owner may read it.", |
| 7 | "fields": [ |
| 8 | {"name": "id"}, |
| 9 | {"name": "account_id", "type": "relation", "required": true, |
| 10 | "relation": {"collection": "mail_accounts", "display_field": "email_address"}, "label": "Account"}, |
| 11 | {"name": "folder", "type": "text", "label": "Folder", "validation": {"max_length": 1000}}, |
| 12 | {"name": "uid", "type": "integer", "label": "UID"}, |
| 13 | {"name": "uidvalidity", "type": "text", "label": "UIDVALIDITY", "validation": {"max_length": 20}}, |
| 14 | {"name": "message_id", "type": "relation", "required": true, |
| 15 | "relation": {"collection": "messages", "display_field": "subject"}, "label": "Message"}, |
| 16 | {"name": "dedupe_key", "type": "text", "required": true, "label": "Dedupe key", "validation": {"max_length": 1100}}, |
| 17 | {"name": "references", "type": "textarea", "label": "References", "validation": {"max_length": 8000}}, |
| 18 | {"name": "list_unsubscribe", "type": "text", "label": "List-Unsubscribe", "validation": {"max_length": 2000}}, |
| 19 | {"name": "list_unsubscribe_post", "type": "text", "label": "List-Unsubscribe-Post", "validation": {"max_length": 2000}}, |
| 20 | {"name": "list_id", "type": "text", "label": "List-Id", "validation": {"max_length": 2000}}, |
| 21 | {"name": "precedence", "type": "text", "label": "Precedence", "validation": {"max_length": 100}}, |
| 22 | {"name": "owner_id", "type": "text", "label": "Owner"}, |
| 23 | {"name": "created_at", "type": "datetime", "label": "Created", "read_only": true} |
| 24 | ], |
| 25 | "views": { |
| 26 | "list_mode": "table", |
| 27 | "list_fields": ["account_id", "folder", "uid", "message_id", "list_id"] |
| 28 | } |
| 29 | } |