Calculate the current earnings for v3

You can calculate your current earnings from a local database.

1. You need a python and sqlite3 packages

   sudo apt install sqlite3

   • Windows and MacOS users can use a docker container (here `x:\storagenode` is a path to your storage location for the storagenode)

     docker run -it -v x:\storagenode\storage:/data --name earnings sstc/sqlite3 sh
     apk update
     apk add python
     exit

   • Windows users can enable WSL feature and install the Ubuntu from the Microsoft Store and follow this guide for Linux
2. Save this script with name earnings.py 
3. Stop the container

   docker stop -t 300 storagenode

4. Run the script from the data folder (it's better to make a copy to a different place and run this script from there to avoid the database corruption with a parallel access),

   python earnings.py

   • or specify the path to the data folder as an argument:

     python earnings.py /path/to/data

   • or specify the path to the data folder and month:

     python earnings.py /path/to/storj/data 2019-05

   • For docker-way you can copy the script to the created container, and run it from there

     docker cp earnings.py earnings:/data/
     docker start earnings
     docker exec -it earnings python earnings.py
     docker exec -it earnings python earnings.py . 2019-05

5. Run your storagenode back

   docker start storagenode

Note. Better to stop the container and copy the info.db to a different place then use the script from there to avoid the sharing violation or corruption for the file or stop the container before processing.

Note. On Linux if you usually run your docker commands with sudo, then you should run this script with sudo too.

All credits for script should go to author: https://github.com/ReneSmeekes/storj_earnings