Topic: Solo Pool Miner Race - page 108. (Read 36432 times)

# Python Skript: load_data.py
# Version: 1.0 vom 23.12.2023

import requests
from influxdb import InfluxDBClient
from datetime import datetime
import pytz

# Funktion zum Parsen der Hashrate-Einheiten
def parse_hashrate(hashrate_str):
    if "G" in hashrate_str:
        return float(hashrate_str.replace("G", ""))
    elif "T" in hashrate_str:
        return float(hashrate_str.replace("T", "")) * 1000  # Umrechnung von Tera zu Giga
    elif "M" in hashrate_str:
        return float(hashrate_str.replace("M", "")) / 1000  # Umrechnung von Mega zu Giga
    elif "P" in hashrate_str:
        return float(hashrate_str.replace("P", "")) * 1000000  # Umrechnung von Peta zu Giga
    else:
        return 0.0

# URL und Datenbankinformationen
url = "https://solo.ckpool.org/users/bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c"
database_name = "willipool"
influxdb_host = "localhost"  # Ändere dies entsprechend deiner InfluxDB-Installation

# JSON von der URL abrufen
response = requests.get(url)
data = response.json()

# Zeitzone für die Umrechnung
local_tz = pytz.timezone("Europe/Berlin")  # Ändere dies entsprechend deiner Zeitzone

# InfluxDB-Client initialisieren
client = InfluxDBClient(host=influxdb_host, port=8086, database=database_name)

# InfluxDB-Daten vorbereiten
influx_data = [
    {
        "measurement": "pool_stats",
        "tags": {},
        "time": datetime.utcfromtimestamp(data["lastshare"]).replace(tzinfo=pytz.utc).astimezone(local_tz),
        "fields": {
            "hashrate1m": parse_hashrate(data["hashrate1m"]),
            "hashrate5m": parse_hashrate(data["hashrate5m"]),
            "hashrate1hr": parse_hashrate(data["hashrate1hr"]),
            "hashrate1d": parse_hashrate(data["hashrate1d"]),
            "hashrate7d": parse_hashrate(data["hashrate7d"]),
            "workers": data["workers"],
            "shares": data["shares"],
            "bestshare": data["bestshare"],
            "bestever": data["bestever"],
        },
    }
]

# Worker-Daten hinzufügen
for worker in data["worker"]:
    influx_data.append(
        {
            "measurement": "worker_stats",
            "tags": {"workername": worker["workername"]},
            "time": datetime.utcfromtimestamp(worker["lastshare"]).replace(tzinfo=pytz.utc).astimezone(local_tz),
            "fields": {
                "hashrate1m": parse_hashrate(worker["hashrate1m"]),
                "hashrate5m": parse_hashrate(worker["hashrate5m"]),
                "hashrate1hr": parse_hashrate(worker["hashrate1hr"]),
                "hashrate1d": parse_hashrate(worker["hashrate1d"]),
                "hashrate7d": parse_hashrate(worker["hashrate7d"]),
                "lastshare": worker["lastshare"],
                "shares": worker["shares"],
                "bestshare": worker["bestshare"],
                "bestever": worker["bestever"],
            },
        }
    )


# Debugging-Ausgaben
#print("InfluxDB-Daten:")
#for data_point in influx_data:
#    print(data_point)



# Daten in die InfluxDB schreiben
client.write_points(influx_data)

# Verbindung schließen
client.close()

{
 "hashrate1m": "113T",
 "hashrate5m": "96.4T",
 "hashrate1hr": "86.5T",
 "hashrate1d": "37.2T",
 "hashrate7d": "11.7T",
 "lastshare": 1703329796,
 "workers": 20,
 "shares": 2231057207,
 "bestshare": 7124614295.201826,
 "bestever": 7124614295,
 "authorised": 1702450385,
 "worker": [
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.willi9974_2",
   "hashrate1m": "502G",
   "hashrate5m": "454G",
   "hashrate1hr": "415G",
   "hashrate1d": "405G",
   "hashrate7d": "292G",
   "lastshare": 1703329795,
   "shares": 77113124,
   "bestshare": 83853607.77031049,
   "bestever": 83853607
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.willi9974_1",
   "hashrate1m": "570G",
   "hashrate5m": "534G",
   "hashrate1hr": "505G",
   "hashrate1d": "480G",
   "hashrate7d": "338G",
   "lastshare": 1703329795,
   "shares": 88028363,
   "bestshare": 123419668.6750166,
   "bestever": 123419668
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.rent_a_ray",
   "hashrate1m": "371G",
   "hashrate5m": "338G",
   "hashrate1hr": "343G",
   "hashrate1d": "314G",
   "hashrate7d": "239G",
   "lastshare": 1703329790,
   "shares": 63855416,
   "bestshare": 80519141.63811205,
   "bestever": 80519141
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.fishhot_1",
   "hashrate1m": "271G",
   "hashrate5m": "271G",
   "hashrate1hr": "295G",
   "hashrate1d": "301G",
   "hashrate7d": "228G",
   "lastshare": 1703329795,
   "shares": 60307364,
   "bestshare": 255155161.8944594,
   "bestever": 255155161
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.fishhot_2",
   "hashrate1m": "356G",
   "hashrate5m": "355G",
   "hashrate1hr": "296G",
   "hashrate1d": "297G",
   "hashrate7d": "224G",
   "lastshare": 1703329790,
   "shares": 58845504,
   "bestshare": 47739030.35257854,
   "bestever": 47739030
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.orangehash_1",
   "hashrate1m": "459G",
   "hashrate5m": "453G",
   "hashrate1hr": "476G",
   "hashrate1d": "490G",
   "hashrate7d": "338G",
   "lastshare": 1703329793,
   "shares": 85077073,
   "bestshare": 31263035.19910477,
   "bestever": 31263035
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.real_duke",
   "hashrate1m": "379G",
   "hashrate5m": "396G",
   "hashrate1hr": "430G",
   "hashrate1d": "416G",
   "hashrate7d": "151G",
   "lastshare": 1703329795,
   "shares": 26046846,
   "bestshare": 19276807.92891639,
   "bestever": 19276807
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.5tift",
   "hashrate1m": "453G",
   "hashrate5m": "428G",
   "hashrate1hr": "422G",
   "hashrate1d": "417G",
   "hashrate7d": "256G",
   "lastshare": 1703329794,
   "shares": 56821448,
   "bestshare": 268066146.4347796,
   "bestever": 268066146
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.brun0",
   "hashrate1m": "412G",
   "hashrate5m": "397G",
   "hashrate1hr": "404G",
   "hashrate1d": "402G",
   "hashrate7d": "272G",
   "lastshare": 1703329786,
   "shares": 63494457,
   "bestshare": 115043331.5398745,
   "bestever": 115043331
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.tux1975",
   "hashrate1m": "507G",
   "hashrate5m": "494G",
   "hashrate1hr": "701G",
   "hashrate1d": "757G",
   "hashrate7d": "349G",
   "lastshare": 1703329780,
   "shares": 75901719,
   "bestshare": 21378995.3354238,
   "bestever": 21378995
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.merry_christmas_1day",
   "hashrate1m": "0",
   "hashrate5m": "0",
   "hashrate1hr": "0",
   "hashrate1d": "104G",
   "hashrate7d": "1.08T",
   "lastshare": 1702937619,
   "shares": 313135352,
   "bestshare": 912652788.0582809,
   "bestever": 912652788
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.orangehash_1.ultra90",
   "hashrate1m": "0",
   "hashrate5m": "0",
   "hashrate1hr": "0",
   "hashrate1d": "23.5M",
   "hashrate7d": "45.9M",
   "lastshare": 1703066024,
   "shares": 20000,
   "bestshare": 767697.3393878608,
   "bestever": 767697
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.orangehash_2",
   "hashrate1m": "639G",
   "hashrate5m": "574G",
   "hashrate1hr": "512G",
   "hashrate1d": "469G",
   "hashrate7d": "169G",
   "lastshare": 1703329795,
   "shares": 29062755,
   "bestshare": 59190031.04399755,
   "bestever": 59190031
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.nalien2000_apollo1",
   "hashrate1m": "14.5T",
   "hashrate5m": "14.8T",
   "hashrate1hr": "14.8T",
   "hashrate1d": "13.8T",
   "hashrate7d": "4.5T",
   "lastshare": 1703329796,
   "shares": 753024552,
   "bestshare": 7124614295.201826,
   "bestever": 7124614295
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.brun0_2",
   "hashrate1m": "297G",
   "hashrate5m": "323G",
   "hashrate1hr": "369G",
   "hashrate1d": "211G",
   "hashrate7d": "41.9G",
   "lastshare": 1703329780,
   "shares": 6268197,
   "bestshare": 3841108.477058772,
   "bestever": 3841108
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.cygan",
   "hashrate1m": "6.26T",
   "hashrate5m": "6.23T",
   "hashrate1hr": "6.46T",
   "hashrate1d": "3.67T",
   "hashrate7d": "723G",
   "lastshare": 1703329796,
   "shares": 107843711,
   "bestshare": 59552926.93001042,
   "bestever": 59552926
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.merryXmas",
   "hashrate1m": "4.27T",
   "hashrate5m": "5.09T",
   "hashrate1hr": "5.94T",
   "hashrate1d": "10.4T",
   "hashrate7d": "1.88T",
   "lastshare": 1703329796,
   "shares": 276080370,
   "bestshare": 111822385.8236514,
   "bestever": 111822385
  },
  {
   "workername": "bc1qeuupt2tgerfum8jclt8aklu9cdmzzkwml9lg7c.orangehash_S19",
   "hashrate1m": "129T",
   "hashrate5m": "76T",
   "hashrate1hr": "54.3T",
   "hashrate1d": "4.29T",
   "hashrate7d": "629G",
   "lastshare": 1703329753,
   "shares": 90000000,
   "bestshare": 430374223.871946,
   "bestever": 430374223
  }
 ]
}