Attachment downloading for DM chats

[dentropy]

Alright how do we want to go about this? Do we want to loop through all attachments or by speam specifically. Definately team / chat specific. Do we want to pull these from the table itself? Yes. Alright let's do this.

[dentropy]

Do we want to add in the file metadata into the database? Yes In a separate table? Yes What data? Wait no We want there to be as little transformations as possible We can find the data after, right now we just need file type and hash If we need a attachments table later we will get the requirements from an ETL pipline we are actually developing

[dentropy]

We need a filename for the files, the hash is base 64 me no like, I am going to use the ms timestamp and origional file name

[dentropy]

I should throw the sender UUID in there as well for good measure, makes it easy to sort by from Or should I use username? Usernames are file compatible But UUID's make life easier Are the files going to be easy to search if we save the files as such? Sender UUID, MS_Timestamp, ya a sql query can be used to search for that How do we want the final file to look like? sender_uuid_timestamp_filename.ending Or do we want the timestamp first? Bunch of numbers at the beggining verse hex? Hex will look prettier Why not just use the actual username No group chats are weird we use sender UUID Wait we can use sender username UUID's are easier to parse Alright UUID it is How easy do we want the files to be cross referencable? We don't care we want things simple UUID it is