arskom / cekirge Goto Github PK

WhatsApp Messages have;

• A body
• Zero or more attachments
• Attachments that are stickers ???

WhatsApp messages may arrive;

• Directly (DM)
• From a group (GM)
• Status updates (SU) ???

Details:

• Header values for the DM type:

  • From: Address value comes from message.from. Name comes from the latest SU
  • To: Address value comes from message.to. Name is empty

• Header values for the GM type:

  • From: Address value comes from message.from. Name comes from the latest SU
  • To: Address value comes from message.to which contains the group id. Name comes from the group name
  • Author (RFC 9057): Address value comes from message.author which contains the group id. Name comes from the latest SU
  • List-Id: Contains the message.to value.

Inserting group name for the first time

insert into folders (name) values('group name');  
insert into folderstate (fid, key,value) values (last_insert_rowid(), 'whatsapp-id', '[email protected]');

Updating it:

update folders set name = 'newname' where
        id=(select fid from folderstate where key='whatsapp-id' and value='[email protected]');

Must contain project requirements, build instructions etc.