import sqlite3, sys
sys.path.insert(1, 'j:\\Spotty\secrets_and_database')
from sqlite3 import Error

database = "j:\\Spotty\secrets_and_database\\Endless Feed.db"
nodate = ['999', 'failure', 'failure2']
decs = ['00s', '10s', '20s', '30s', '40s', '50s', '60s', '70s', '80s', '90s']
e = 0

conn = None                        
try:
    conn = sqlite3.connect(database) 
except Error as e1:
    print("Create_Connection")        
    print(e1)
    exit()  

with conn:                                                              
    cur = conn.cursor()
    while e < 3: 
        try:
            cur.execute("SELECT COUNT (*) FROM Release_Date WHERE FMDate = '" + nodate[e] + "' AND DISCOG_DATE <> 9999")
            total_records = int(cur.fetchone()[0])
            cur.execute("SELECT * FROM Release_Date WHERE FMDate = '" + nodate[e] + "' AND DISCOG_DATE <> 9999") 
            nextrec = 0         
        except Error as e4:
            print("main check")
            print(e4)                                                                                                       
        rows = cur.fetchall()                                              
        for row in rows:
            print("Working on Item " + str(nextrec) + " of " + str(total_records), end='\r')
            if len(row[6]) == 4:
                dec = row[6][2:3]
            #print(x)
            #print(decs[int(dec)])
                newdec = decs[int(dec)]
            #print(newdec)
                cur.execute("UPDATE Release_Date SET FMdate = '" + newdec + "' WHERE URI = '" + row[0] + "'")
                conn.commit()
                nextrec +=1                                                           
            #cur.execute("UPDATE Release_Date SET FMdate = DISCOG_DATE WHERE URI = '" + row[0] + "'")
            #conn.commit()
        e+=1

#with conn:                                                              
##    cur = conn.cursor()                                                 
#    try:
#        cur.execute("SELECT * FROM Release_Date")          
#    except Error as e4:
#        print("main check")
#        print(e4)                                                                                                       
#    rows = cur.fetchall()
#    x = 1                                              
#    for row in rows: 
#        if len(row[8]) == 4:
#            dec = row[8][2:3]
#            print(x)
#            #print(decs[int(dec)])
#            newdec = decs[int(dec)]
#            print(newdec)
#            cur.execute("UPDATE Release_Date SET FMdate = '" + newdec + "' WHERE URI = '" + row[0] + "'")
#            conn.commit()
#        x+=1