<file python> # 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()

</file python>