Advertisement
Astranome

Websocket data receiver for CryptoTicker

May 30th, 2020
306
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.72 KB | None | 0 0
  1. import websocket
  2. import json
  3. import time
  4. import sqlite3
  5.  
  6. #conn = sqlite3.connect("mydatabase.db")
  7. #cursor = conn.cursor()
  8. '''t = Turtle()
  9. t.screen.setup(800,550)
  10. t.screen.bgcolor("#002137")
  11. t.color('yellow')
  12. '''
  13. b=1
  14. def on_message(ws, message):
  15.     #print(message)
  16.     obj = json.loads(message)
  17.     db=(obj["s"], obj["p"])
  18.     print(db)
  19.     price=float(obj["p"])
  20.     p=price
  21.     print(price)
  22.     conn = sqlite3.connect("mydatabase.db")
  23.     cursor = conn.cursor()
  24.  
  25.  
  26.  
  27.  
  28.     cursor.execute('UPDATE albums SET lastprice = ? WHERE pair = ?',(p,'BTCUSDT'))
  29.     conn.commit()
  30.  
  31. '''    albums = [db]
  32.  
  33.    cursor.executemany("INSERT INTO albums VALUES (?,?)", albums)
  34.    conn.commit()
  35.  
  36.  
  37.  
  38.    t.clear()
  39.    t.color('yellow')
  40.    t.goto(-400,130)
  41.    t.write((price),font=("Arial", 100, "bold"))
  42.    t.color('yellow')
  43.    t.goto(-400,20)
  44.    t.write(('BINANCE BTC USDT'),font=("Arial", 50, "bold"))
  45.    time.sleep(1)
  46. '''
  47. def on_error(ws, error):
  48.     print(error)
  49.  
  50. def on_close(ws):
  51.     print("### closed ###")
  52.  
  53. def on_open(ws):
  54.     print("### connected ###")
  55.  
  56. if __name__ == "__main__":
  57.     #ws = websocket.WebSocketApp("wss://stream.binance.com:9443/stream?streams=ltcbtc@aggTrade/ethbtc@aggTrade",
  58.     ws = websocket.WebSocketApp("wss://stream.binance.com:9443/ws/btcusdt@aggTrade",
  59.                               on_message = on_message,
  60.                               on_error = on_error,
  61.                               on_close = on_close)
  62. """
  63.    t.clear()
  64.    t.color('yellow')
  65.    t.goto(-400,130)
  66.    t.write((price),font=("Arial", 100, "bold"))
  67.    t.color('yellow')
  68.    t.goto(-400,20)
  69.    t.write(('BINANCE SPOT Account'),font=("Arial", 50, "bold"))
  70. """
  71. ws.on_open = on_open
  72. ws.run_forever()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement