Attaching documents to forum posts

[wmcclin]

The Maldives (Noo Raajje) project will begin consultations in mid-July through August in which they would like gather data from fishers and councils. Some of the information may come in the form of documents. They'd like to be able attach these documents to a forum post.

[underbluewaters]

This could be sort of a big ticket. There are two sides to this work, the upload handling infrastructure and UI pieces.

UI Side

Prosemirror message documents in the forum support Map Bookmarks via attachments, which are designed to support things like File Uploads as well. More details on attachments can be found in the schema. The basic steps to getting uploads working in forum posts would be:

• [x] Extend the schema as necessary to store type-specific attachment data.
• [x] Add an appropriate action in EditorMenuBar which calls the appropriate APIs to create the upload record, upload it, and then add the attachment to messages.
• [x] Create a ForumFileUpload component to represent uploads in the footer of a message
• [x] Update PostContentEditor to render posted attachments
• [ ] Support drag & drop uploads

Server and Database Support

I'd like to take this opportunity to create a more generic FileUpload table that can be repurposed for other use cases, such as surveys. Like with map_bookmarks, there needs to be some fairly complex introspection of the post prosemirror document to assign the correct post_id to these FileUpload records.

• [x] Create a file_uploads table that can be repurposed for surveys and potentially other users
• [ ] add post-insert/update trigger to posts to assign file_uploads.post_id
• [ ] implement posts_file_uploads relation
• [x] Implement RLS policies as needed
• [x] create graphql middleware for embedding access tokens in download links

[underbluewaters]

Other tasks

• [ ] add post-delete trigger and graphile_worker task to delete files from cloud storage