import sqlite3
import mariadb

sconn = sqlite3.connect("bandj.db")
mconn = mariadb.connect(user="someone", password="supersecret",
    host="cpsc.umw.edu", port=3306, database="something")

scur = sconn.cursor()
mcur = mconn.cursor()
 
scur.execute("select max(id) from container")
duncan = scur.fetchone()
next_container_id = duncan[0] + 1


mcur.execute("select * from containers")
results = mcur.fetchall()
for result in results:
    num_rows = result[3]
    print(f"There were {num_rows} containers on this row.")
    scur.execute("select needs_ref from mixin where mixin=?",
        (result[2],) )
    lexie = scur.fetchall()
    for boxes in range(num_rows):
        scur.execute("insert into container "
            "values (?,?,?,?,?)", (next_container_id, lexie[0][0],
            result[1], result[1], result[2]) )
        next_container_id += 1 

sconn.commit()