def getHeaderAndRows(head,sql,db): arr = dbutils.getDbRows(sql, db) return head, arr
def getFields(tableName,db): sql1 = "SELECT id, tname, tper FROM tbl WHERE tname='%s'" % tableName tname = dbutils.getDbOneRow(sql1,db) sql2 = "SELECT fname, fper, ftyp, frequired, fsql, ftitles, sqlUpdate FROM tbl_d WHERE tbl_id='%s'" % tname[0] ar = dbutils.getDbRows(sql2, db) return tname, ar