cur = conn.cursor()
cur.execute("INSERT INTO p2sh (input_id, full_script) VALUES (%s,%s)", (input_id, full_script))
conn.commit()
def writetooutput_script(output_id, full_script):
print('OUTPUT_SCRIPT: ', output_id, full_script)
cur = conn.cursor()
cur.execute("INSERT INTO output_script (output_id, full_script) VALUES (%s,%s)", (output_id, full_script))
conn.commit()
def fetch_single_data(table, column, id):
cur.execute("SELECT %s FROM %s WHERE id = %s", (column, table, id))
return cur.fetchone()
# Instanciate the Blockchain by giving the path to the directory
blockchain = Blockchain(sys.argv[1])
print(blockchain.get_main_chain())
#ordere blocks according to height starting with genesis block
#orderedblockchain= blockchain.get_main_chain()
#print(type(orderedblockchain))
#print(orderedblockchain[0])
#get relevant data from relevant blocks and save to db
def saveblockinfo(block):
height = block.height
id = block.hash
header = block.header
timestamp = time.mktime(header.timestamp.timetuple())
#writetoblock(id, height, timestamp)
writetoblock(id, height, timestamp)
#returns type of transaction
#types are: coinbase, paytopubkey, paytopubkeyhash, p2sh, op_return
