Multithreading sqlite3 INSERT with Lock() example I made at 3am

main.py

import threading
import sqlite3                                                                   
def threadfunc(name, con, lock):
    print(name)
    with lock:
        with con:
            con.execute("INSERT INTO test VALUES (?)", (name,))

if __name__ == "__main__":
    lock = threading.Lock()
    threads = []
    con = sqlite3.connect("test.db", check_same_thread=False)
    cur = con.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS test(a INTEGER)")

    for i in range(0,50):
        threads.append(threading.Thread(target=threadfunc, args=(i,con,lock)))
        threads[-1].start()

    for t in threads:
        t.join()

    con.close()