dtex1.py

python web programming 部分

"""DatabaseTuple example 1"""

import dtuple
import mx.ODBC.Windows as odbc
from jetCursor import jetCursor

mwRec = dtuple.TupleDescriptor((
        ("PgName", "Page Name",     1, 25),
        ("PgNum",  "Page Sequence", 0, 5),
        ("PgText", "Page Content",  0, (4, 40))
    ))
cn = odbc.connect("WebData")
cr = jetCursor(cn.cursor(), cn)
sql = cr.SELECT(("PgName", "PgNum", "PgText"), FROM="PgData",
        REST="ORDER BY PgNum")
cr.execute(sql)
dbrows = cr.fetchall()
cr.close()
cn.close()
for row in dbrows:
    row = dtuple.DatabaseTuple(mwRec, row)
    # select attribute vs. mapping below
    #print "%3d: %s" % (row.PgNum, row.PgName)
    print "%3d: %s" % (row["PgNum"], row["PgName"])