balance_check.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
# Nano Telegram bot
# @NanoWalletBot https://t.me/NanoWalletBot
# 
# Source code:
# https://github.com/SergiySW/NanoWalletBot
# 
# Released under the BSD 3-Clause License
# 

import logging
import urllib3, socket, json
import time, math

# Parse config
from six.moves import configparser
config = configparser.ConfigParser()
config.read('bot.cfg')
wallet = config.get('main', 'wallet')


# MySQL requests
from common_mysql import mysql_select_accounts_list, mysql_select_accounts_list_extra


# Request to node
from common_rpc import *


# balances check
def balance_check():
	time_start = int(time.time())
	count = 0
	diff_summ = 0
	# list from MySQL
	accounts_list = mysql_select_accounts_list()
	accounts_list_extra = mysql_select_accounts_list_extra()
	
	for account in accounts_list:
		balance = int(account_balance(account[1]))
		mysql_balance = int(account[3])
		diff = abs(balance - mysql_balance)
		diff_summ = diff_summ + diff
		if (diff > 0):
			count = count + 1
			print(account[1])
			print('{0} {1}'.format(mysql_balance, balance))
			
	accounts_list = mysql_select_accounts_list()
	
	for account in accounts_list_extra:
		balance = int(account_balance(account[1]))
		mysql_balance = int(account[3])
		diff = abs(balance - mysql_balance)
		diff_summ = diff_summ + diff
		if (diff > 0):
			count = count + 1
			print(account[1])
			print('{0} {1}'.format(mysql_balance, balance))
	
	time_end = int(time.time())
	total_time = time_end - time_start
	print (total_time)
	print ("{} inconsistent accounts\n{} inconsistent sum (xrb)".format(count, diff_summ))

balance_check()