One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Edit File: getprice.py

from binance.um_futures import UMFutures
import time
import argparse
import pymysql

parser = argparse.ArgumentParser()
parser.add_argument("-symbol", help="Sembol Giriniz", required=True)
args = parser.parse_args()
symbol = args.symbol

def create_um_futures_client(ayar):
    return UMFutures(ayar["binanceapikey"], ayar["binancesecretkey"],base_url="https://testnet.binancefuture.com")
try:
    baglanti = pymysql.connect(
        host='127.0.0.1',
        db='newcoin',
        user='root',
        password='Ua04420076*',
        port=3306,
        charset='utf8mb4',
        cursorclass=pymysql.cursors.DictCursor
    )
    with baglanti.cursor() as islem:
        islem.execute("select * from settings where id=1")
        ayar=islem.fetchone()
        baglanti.commit()
        um_futures_client = create_um_futures_client(ayar)
        exchange_info = um_futures_client.exchange_info()
        symbol_info = next(filter(lambda x: x['symbol'] == symbol, exchange_info['symbols']), None)
        islem.execute('update `symbols` set `pp`=%s, `qp`=%s where `symbol`=%s',(symbol_info['pricePrecision'],symbol_info['quantityPrecision'],symbol))
        baglanti.commit()
        while True:
            try:
                response = um_futures_client.ticker_price(symbol)
                price = response['price']
                islem.execute('update `symbols` set `price`=%s where `symbol`=%s',(price,symbol))
                baglanti.commit()
                time.sleep(1)
            except Exception as e:
                print(f"Hata oluştu: {e}")
                um_futures_client = create_um_futures_client(ayar)
            time.sleep(1)
except KeyboardInterrupt:
    print("Ctrl+C'ye basıldı, program kapatılmayacak.")
    while True:
        pass

finally:
    if 'baglanti' in locals():
        baglanti.close()