Список проголосовавших за комментарий "Для теты нет, но есть вот такой:<br/> def InsKline1m(self, sd): # thname = 'kline' """ kl = {'stream': 'btcusdt@kline_1m', 'data': {'e': 'kline', 'E': 1692194018649, 's': 'BTCUSDT', 'k': {'t': 1692193980000, 'T': 1692194039999, 's': 'BTCUSDT', 'i': '1m', 'f': 4009649234, 'L': 4009650704, 'o': '29087.10', 'c': '29094.90', 'h': '29095.20', 'l': '29087.10', 'v': '148.002', 'n': 1471, 'x': False, 'q': '4305614.76410', 'V': '88.941', 'Q': '2587451.86430', 'B': '0'}}} """ ""«if threading.get_ident() != self.threads[thname]['thread_id']: # print('aaaa ',threading.get_ident()) self.threads[thname]['thread_id'] = threading.get_ident() self.OpenDB(thname) „“» dt = self.ConvertToDTime(sd['data']['E']) var = (sd['data']['E'],sd['data']['s'],dt,sd['data']['k']['t'],sd['data']['k']['T'],sd['data']['k']['f'],sd['data']['k']['L'], sd['data']['k']['o'],sd['data']['k']['c'],sd['data']['k']['h'],sd['data']['k']['l'],sd['data']['k']['v'], sd['data']['k']['n'],sd['data']['k']['x'],sd['data']['k']['q'],sd['data']['k']['V'],sd['data']['k']['Q']) #17 sql2 = '(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' sql1 = 'insert into Kline1m (E,Symbol,dtime,tb,tc,f,L,open,close,high,low,vol,n,x,q,V,Qp) values' + sql2 begin = time.monotonic_ns() self.cursor.execute(sql1, var) self.connect.commit() if sd['data']['k']['x']: dt = self.ConvertToDTime(sd['data']['k']['t']) print('dt ', dt) var = (sd['data']['s'],dt,sd['data']['k']['t'],sd['data']['k']['T'],sd['data']['k']['o'], sd['data']['k']['c'],sd['data']['k']['h'],sd['data']['k']['l'],sd['data']['k']['v'], sd['data']['k']['n'],sd['data']['k']['q'],sd['data']['k']['V'],sd['data']['k']['Q']) #13 sql2 = '(?,?,?,?,?,?,?,?,?,?,?,?,?)' sql1 = 'insert into Kline_1mc (Symbol,dtime,tb,tc,open,close,high,low,vol,n,q,V,Qp) values' + sql2 self.cursor.execute(sql1, var) self.connect.commit() Tq = (time.monotonic_ns() — begin)/1000 print('Time of record ', Tq)<br/> Сорри, форматирование слетело.)"