import requests
import time
import getpass
import os
import json
import arrow

import sqlite3

blockconnect = sqlite3.connect('blockchain.db')

bcon = blockconnect.cursor()

try:
    bcon.execute('''CREATE TABLE blockchain
                    (datetime, ethval, bcval)''')
    bcon.execute('INSERT INTO blockchain VALUES ({}, {}. {})'.format())
except Exception:
        pass

nowtime = arrow.now()

myusr = getpass.getuser()

#confpat = '/home/{}/.config'.format(myusr)

#fulpat = '{}/blockchain.json'.format(confpat)

#if 'blockchain.json' in os.listdir(confpat):
#    pass
#else:
#    bcdic = dict({'oldbtc' : '0', 'oldeth' : '0', 'updated' : '2017-08-19T13:26:29.240023+12:00'})
#    bcjs = json.dumps(bcdic)
#    print(bcjs)
    # Writing our configuration file to 'example.cfg'
#    with open(fulpat, 'w') as configfile:
#        configfile.write(bcjs)
    
#with open(fulpat, 'r') as faljs:
    #print(faljs.read())
#    convjs = json.loads(faljs.read())
    
#print(convjs)
#oldbtc = convjs['oldbtc']
#oldeth = convjs['oldeth']

payload = {'fsyms' : 'ETH,BTC', 'tsyms' : 'AUD'}

reqetc = requests.get('https://min-api.cryptocompare.com/data/pricemulti', params= payload)
nowtime = arrow.now()
etjs = reqetc.json()

#if float(etjs['BTC']['AUD']) == float(oldbtc):
#    btcchange = 'no change'
#elif float(etjs['BTC']['AUD']) > float(oldbtc):
#    btcchange = 'increase'
#elif float(etjs['BTC']['AUD']) < float(oldbtc):
#    btcchange = 'decrease'
    
#if float(etjs['ETH']['AUD']) == float(oldeth):
#    ethchange = 'no change'
#elif float(etjs['ETH']['AUD']) > float(oldeth):
#    ethchange = 'increase'
#elif float(etjs['ETH']['AUD']) < float(oldeth):
#    ethchange = 'decrease'
    
#diffbtc = abs(float(etjs['BTC']['AUD'])-float(oldbtc))
#diffeth = abs(float(etjs['ETH']['AUD'])-float(oldeth))
#print(str(float(diffbtc)) + ' ' + str(float(diffeth)))
#oldtime = convjs['updated']
#print('AUD. BTC: {}. Old price: {}. {}. ETH: {}. Old price: {}. {}'.format(etjs['BTC']['AUD'], oldbtc, btcchange, etjs['ETH']['AUD'], oldeth, ethchange))
#print('old time: ' + oldtime + ' current time: ' + nowtime.for_json())
#print(bt hchange)


#bcdic = dict({'oldbtc' : etjs['BTC']['AUD'], 'oldeth' : etjs['ETH']['AUD'], 'btcdiff' : diffbtc, 'ethdiff' : diffeth, 'updated' : nowtime.for_json()})
#bcjs = json.dumps(bcdic)

#with open(fulpat, 'w') as configfile:
#    configfile.write(bcjs)

#bcdic

bcon.execute('INSERT INTO blockchain VALUES ({}, {}, {})'.format(nowtime.timestamp, etjs['BTC']['AUD'], etjs['ETH']['AUD']))

---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
<ipython-input-109-e4fcb48d2d08> in <module>()
----> 1 bcon.execute('INSERT INTO blockchain VALUES ({}, {}, {})'.format(nowtime.timestamp, etjs['BTC']['AUD'], etjs['ETH']['AUD']))

OperationalError: database is locked

blockconnect.commit()

for row in bcon.execute('SELECT * FROM blockchain'):
    print(row)

#bcon.commit()

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-111-f467ff2d8d78> in <module>()
----> 1 bcon.commit()

AttributeError: 'sqlite3.Cursor' object has no attribute 'commit'

blockconnect.close()