import sqlite3
from sqlite3 import Error

dbase = r"j:\\Spotty\secrets_and_database\NEW_Enormous Feed.db"
rowdb = 1
conn = None
dburi = 0000
rduri = "None"
rdtrack_name = "None"
rdartist_name = "None"
rdalbum_name = "None"

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

with conn:
    cur = conn.cursor()
    cur.execute("SELECT * FROM Release_Date")
    rows = cur.fetchall()
    trw = len(rows)
    rw = 1
    for row in rows:
        print("Working on Item " + str(rw) + " of " + str(trw), end='\r')
        rduri = row[0]
        rdtrack_name = row[2]
        if "'" in rdtrack_name:
                rdtrack_name = rdtrack_name.replace("'", "''")
        rdartist_name = row[4]
        if "'" in rdartist_name:
                rdartist_name = rdartist_name.replace("'", "''")
        rdalbum_name = row[7]
        if "'" in rdalbum_name:
                rdalbum_name = rdalbum_name.replace("'", "''")
        cur.execute("UPDATE Track_List SET TRACK_NAME = '" + rdtrack_name + "', ARTIST_NAME = '" + rdartist_name + "', ALBUM_NAME = '" + rdalbum_name + "' WHERE URI = '" + rduri + "'")
        conn.commit()
        rw+=1