# Zones table: id, Zonename, Comment, Level # Rooms table: id, Name, Comment, Exits, Flags, XYZ, Color, Zoneid connection = sqlite3.connect(dbname) dbcursor = connection.cursor() # ---- init done ---- def loadcomps(): dbcursor.execute('SELECT id, Name, Grade, Sphere FROM Components') return dbcursor.fetchall() def addcomp(id, name, grade, sphere): dbcursor.execute('INSERT INTO Components(id, Name, Grade, Sphere) VALUES (?,?,?,?)', (id, name, grade, sphere)) dbcommit()