def insert_adresses(ins,outs,address,tx_id,tx_time): sql = None id = 0 is_address = False for x in range(0,len(outs)): out = outs[x] if out['addr'] == address: sql = helper.sqlhelper() value = "%.8f"%(out['value']/1.0e8,) if sql.testxtid(tx_id): id = sql.inserttx(tx_id,int(tx_time)) sql.insert(int(tx_time), address, value, True, id) is_address = True break if is_address: for x in range(0,len(ins)): input = ins[x] sql.insert(int(tx_time), input['prev_out']['addr'], 0, False, id)
def deserialize_Transaction(d, block_time, addresses): txIns = [] txOuts = [] ct = False for txIn in d['txIn']: txIns.append(deserialize_TxIn(txIn)) for txOut in d['txOut']: res = deserialize_TxOut(txOut) txOuts.append(res) if res["address"] in addresses: ct = True if ct: tx_id = getTxId(d['__data__']) sql= helper.sqlhelper() if sql.testxtid(tx_id): id = sql.inserttx(tx_id,int(block_time)) for txI in txIns: sql.insert(int(block_time), txI["address"], 0, False, id) for txO in txOuts: sql.insert(int(block_time), txO["address"], txO["value"], True, id)
def deserialize_Transaction(d, block_time, addresses): txIns = [] txOuts = [] ct = False for txIn in d['txIn']: txIns.append(deserialize_TxIn(txIn)) for txOut in d['txOut']: res = deserialize_TxOut(txOut) txOuts.append(res) if res["address"] in addresses: ct = True if ct: tx_id = getTxId(d['__data__']) sql = helper.sqlhelper() if sql.testxtid(tx_id): id = sql.inserttx(tx_id, int(block_time)) for txI in txIns: sql.insert(int(block_time), txI["address"], 0, False, id) for txO in txOuts: sql.insert(int(block_time), txO["address"], txO["value"], True, id)