SilverStats

Note that the database included and shown is not my real stack information. I do not want to show that inforamtion because it's bad op sec.

Menu

This takes a number. Right now it is 1 through 18..

Select Total

This feature will display all the total oz in Bullion, Junk and Bars tables. It will also use duckduck go search to display how much the silver total is in USD.

Price AVG

The image below shows that it will show text in red if there is a error with determining the avg.

Sold Total

Get the total of all Sold items.

Update Sold Value

Update the sold value. This is used when you sell one of your piece of silver.

Forecast Silver

This feature will take the inputed silver amount and use Duck Duck Go API to get how much the amount of silver is worth in USD.

Back Up DB

This will back up the db by saving a copy of it with a new name.

WEBSITE

Change Status

The status can either be sold or own. By entering the row ID it will automatically change the status via the current status. Like for example, if the status is sold it will change to own and if it set to own it will change to sold.

Delete Row

This page will display a nice html table that includes the row id. The user will enter the row id which will delete the row.

Entering Silver

The enter silver page has three buttons, one to change status, delete a certain row and enter silver. They are color coded as your can see below.

Pie Charts

Shows the percentage of different types of silver and cryptocurrency.

Cryptocurrency table

Reads from JSON file. Can be set by using EXPORT=stats2.json

Silver Stats

Running the website

	ruby run.rb

There are two crypto json files, prod.json and dev.json. There will be a text in the crypto tag with the color red if dev.json is being used. If the prod.json is active it will show green text.

Install Gems

Note that sqlite3 can sometimes be a pain to install. I have trouble in the past. Also gruff uses rmagick which in turn uses ImageMagick. Which can be a pain to install correctly.

Install magick: sudo apt-get install libmagickwand-dev.

I had to install this too: sudo apt update && sudo apt install build-essential

sudo apt-get install sqlite3

sudo apt install ruby-dev

gem install gruff
gem install sqlite3
gem install CryptoPriceFinder
gem install sinatra
gem install httparty
gem install rack -v 3.1.12
gem install dotenv
gem install logger -v 1.5.3
gem install terminal-table
gem install colorize
gem install rackup puma

Set password

You will need to export a var named PASS to be able to get to the page. The username's is admin. Use this: export PASS='Y0urPa$sw0rdzz!1989'

Might want to put this in your .bashrc file. Use source .bashrc after making the change to the file.