o ]j@sddlZddlZejddddlmZmZeZedZ e e\Z Z Z e rGede r3ee ede r>ednedede r\ed edeed ed ddlZddlZddlZddlZddlZddlZdd lmZmZejddejejejedd lmZmZmZdd lmZdZ dZ!dZ"dZ#de$edfde$edfde$ededfde$edfgZ%ddZ&d2ddZ'd d!Z(d"d#Z)d$d%Z*d&d'Z+d(d)Z,d3d+d,Z-d-d.Z.d/d0Z/e0d1kre/dSdS)4Nz/opt/ngon/apps) AuthManagergenerate_login_page_htmldead_m60zContent-Type: application/jsonz6{"success": false, "error": "Authentication required"}z{"success": true}zContent-Type: text/htmlzDead M60 Report)datetime timedelta)generate_dropdown_cssgenerate_dropdown_jsgenerate_dropdown_html)ERROR_CATEGORIESz/opt/ngon/data/miner_history.dbz$/opt/ngon/data/live/miner_status.csvz'/opt/ngon/data/live/miner_inventory.csvz#/opt/ngon/config/master_config.json hashboardhashboard_errorsfan fan_errorsthermaltemp_sensor_errorsovertemp_protectionpower power_errorsc Cs|sdSg}|dD]"}|}|sq z |t|Wq ty-||Yq w|s2dStD]\}}|D] }||vrF|Sq:q4dS)z8Return the first matching hardware bucket name, or None.N,)splitstripappendint ValueErrorupperHW_BUCKET_SETS)error_codes_strcodesrawcnamecode_setr#/var/www/html/ngon/dead_m60.pyclassify_error_bucketCs*   r%Tc Csg}zStt }t|}Wdn1swY|diD].\}}|diD]!\}}|diD]\}} |rK| dddkrKq<||q|dd|kr>||q'WdW|S1sKwYW|Sty\Y|Sw) z"Load inventory for a specific pod. rSiterPodN) rsplitlenr+MINER_INVENTORY_CSVcsv DictReaderr/rr1)r:r0parts target_site target_podr4readerrowr#r#r$get_inventory_for_podis*        rLcCsz>tjdtddd}|}|d|f|}|s&|dgfWS|d}|d||f|}|||fWStyKdgfYSw)Nfile: ?immutable=1TurizSSELECT timestamp FROM miner_snapshots WHERE pod = ? ORDER BY timestamp DESC LIMIT 1rzSELECT position, ip, serial, miner_type, hs_rt, power, error_codes, mining_state, mac FROM miner_snapshots WHERE pod = ? AND timestamp = ? ORDER BY position) sqlite3connectMINER_HISTORY_DBcursorexecutefetchoneclosefetchallr1)r:connr rKtsrowsr#r#r$get_snapshot_data}s$    r\cCsxg}z/tt }t|}|D]}|d|kr||qWdW|S1s*wYW|Sty;Y|Sw)Npod)r+MINER_STATUS_CSVrErFr/rr1)r:minersr4rJrKr#r#r$ get_live_datas"     r`c Csgggggd}t}d}|D]}t|trO|dd}|dd}|dd}|dd}|dd} t|d dpsleepingz.1f)rcrdrerftypehashrateerrors0rmrb) set isinstancedictr/floatrCaddrrr%)r[buckets online_macs online_countrKposrdrerfmtypehsrnstatergrentrybucketr#r#r$categorize_minerssL         r~cCstdt|}|rd}td}t|\}}}n#t|\}}|r-d}t|\}}}nd}d}gggggd}t}d}i}z)tj d t d d d } | } | d | D] \} } | || <qY| Wn tyrYnw|D],} | D]'}|dpd}||d}|r|ddddnd|d<|ddq{qwt|}g}|D]3}|dd}|dd}|s|sq|r||vrq||dd||dddq|jddddd}||t||t|d|dt|d|dt|d|dt|d|dt|d |d|t|dt|dt|dt|dt|d t|d!d" }tt|dS)#z"Return JSON data for a single pod.Content-Type: application/json livez%Y-%m-%d %H:%MsnapshotnoneNrarrMrNTrOz+SELECT mac, first_seen FROM miner_lifecyclerfrTr= first_onlineMACSerialPosition)rcrerfcS|dSNrcr#xr#r#r$z serve_pod_data..keycSrrr#rr#r#r$rrrbr rrr)rbr rrroffline) source timestamp inv_countrw zero_hashr rrrrcounts)printr`rnowstrftimer~r\rprQrRrSrTrUrXrrWr1valuesr/replacepoprLrrsortrCsortedr-dumps)r:rrrZrurvrw snap_rows lifecyclerYr mac_val first_seenlstr|mfsinvrinv_mac inv_serialsort_posresultr#r#r$serve_pod_datas               rc Cstdt}|sttddidStt|dd}ddt |}zt j d t d d d }| }|d |d||gi}|D] \}}} | |||f<qLi} |D]]\\}}} |d|| fdddddd} |D]/\} } }|dkrqx| rt| nd}|dkr| dd7<qxt| pd}|r| |d7<qx|| vrg| |<| |d|i| q^|| D] }| |jdddqtt| |dWdSty}zttdt|iWYd}~dSd}~ww)zYReturn N-day trend data: at each pod's daily peak hashrate, count zero/missing1/missing2.rerrorzno podsN)daysz%Y-%m-%dr?rMrNTrOaM WITH snapshot_totals AS ( SELECT pod, DATE(timestamp) as day, timestamp, SUM(CASE WHEN mining_state != 'sleeping' OR mining_state IS NULL THEN CAST(hs_rt AS REAL) ELSE 0 END) as total_hr FROM miner_snapshots WHERE pod IN (as) AND timestamp >= ? GROUP BY pod, timestamp ), ranked AS ( SELECT pod, day, timestamp, total_hr, ROW_NUMBER() OVER (PARTITION BY pod, day ORDER BY total_hr DESC) as rn FROM snapshot_totals ) SELECT pod, day, timestamp FROM ranked WHERE rn = 1 zuSELECT hs_rt, error_codes, mining_state FROM miner_snapshots WHERE pod = ? AND timestamp = ?rrarkrbr>rdaycSr)Nrr#rr#r#r$r_rz"serve_chart_data..r)r(r3)rr<r-rrrrrjoinrCrQrRrSrTrUrXr0rsr%rrWrr1str)rr3since placeholdersrYr peak_timesr]rrZrrrgrnr{rzr}er#r#r$serve_chart_data s\ $rc CsVtdt}t|}t}t}tt}td|d|d|d|d dS)zServe the HTML page.zContent-Type: text/html z Dead M60 Report

NGON Mining - Dead M60 Report

aj
Field work issue lists by pod - zero hash and hardware errors (hashboard, fan, thermal, power), plus offline
Select a pod above to view issues
N) rr<r-rrr r rget_user_access)r3pod_order_json dropdown_css dropdown_js dropdown_htmlr#r#r$ serve_pagegs:  &rcCs^t}|d}|dr"t|dd}|dvrd}t|dS|r*t|dStdS)Nr] chart_allrr)r)cgi FieldStoragegetfirstrrrr)paramsr]rr#r#r$main s     r__main__)T)r)1rsyspathinsertmanagers.auth_managerrrr_form_auth require_auth_auth_required _should_exit_headersrexitrEr-osrQrrrdirnameabspath__file__linksrr r miners.error_categoriesr rSr^rDr, frozensetrr%r<rLr\r`r~rrrr__name__r#r#r#r$sv        0 RG'