import sqlite3
import mariadb

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

mcur = mconn.cursor()
mcur.execute("select * from containers")
results = mcur.fetchall()
scur.execute("select count(*) from container")
result = scur.fetchone()
num_containers = result[0]
for result in results:

    scur.execute("select needs_ref from mixin where mixin=?", (result[2],) )
    nyah = scur.fetchone()
    refrigerationness = nyah[0] 

    print(f"There are {result[3]} containers in this order.")
    print(f"Do these require refrigeration? {refrigerationness}")
    for i in range(result[3]):
        num_containers += 1
        scur.execute(
            "insert into container ('id','ref','capacity','load','mixin') "
            "values (?,?,?,?,?)",
            (num_containers,refrigerationness,result[1],result[1],result[2]))
sconn.commit()