Archives - Rank by donation amount

[joedavison]

In order to rank archives by donation amount, and be able to do many other things in the future, we need to begin keeping records of Transactions outside of LNbits.

We have a few different kind of transactions in our platform currently. For each kind, next to it is indicated the data that we need to save in the transaction table.

Donations to users for specific archive pages:

• User Wallet to User Wallet: sender_username, receiver_username, archive_id, amount, datetime
• External Wallet to User Wallet: sender_identifier, receiver_username, archive_id, amount, datetime

Donations to Bookmark and anonymous donations:

• User Wallet to Bookmark Wallet: sender_username, [archive_id], amount, datetime
• External Wallet to Bookmark Wallet: sender_identifier, [archive_id], amount, datetime

The archive_id will need to be passed through from the archive page to the donation page, and further included in the LN invoice in order to reconcile the transaction.

This task involves

• Creating a new table of Transactions that can hold the data structure indicated above
• Modifying all of the parts of the code base where transactions are made, to ensure the data is aggregated and inserted into the Transactions table at the time of the transaction
• Creating a "Rank by donation amount" function that aggregates transaction data for each archive