61 def sql(conn, stmts):  argument
62     st = conn.createStatement()
70     conn = ds.getConnection("", "")
71     st = conn.createStatement()
80     return conn
132 def open_def(container, name, conn):  argument
133 …ner.loadComponentFromURL(name, "", 0, (pv("OpenMode", "openDesign"), pv("ActiveConnection", conn)))
201 def populate(ds, conn, command="CUSTOMERS", folder=True):  argument
205     f = open_def(fd, "Form1", conn)
212         f = open_def(grp, "Form2", conn)
217     r = open_def(rd, "Report1", conn)
239 def finish(ds, name, conn=None):  argument
242     if conn is not None:
243         conn.close()
259     conn = hsql_connect(ds)
260 …sql(conn, ['CREATE MEMORY TABLE "CUSTOMERS" ("ID" INTEGER NOT NULL PRIMARY KEY, "NAME" VARCHAR(50)…
281     populate(ds, conn)
282     finish(ds, "base-hsqldb.odb", conn)
285 def make_dbf(conn):  argument
286     tbls = conn.Tables
296     ps = conn.prepareStatement('INSERT INTO "CUSTOMERS" VALUES (?,?,?,?,?,?,?)')
315     conn = ds.getConnection("", "")
316     make_dbf(conn)
320     populate(ds, conn)
321     finish(ds, "base-dbase.odb", conn)