Example #1
0
#!/usr/bin/env python
# -*- coding: utf-8 -*-

from models import Disk, Log

list = Disk.select().where(Disk.id >= 1559, Disk.avail_type != "Draft")

print "<Table>"
print "<tr>\
        <th>#</th>\
        <th>Call Number</th>\
        <th>Title</th>\
        <th>Price(HKD)</th>\
        <th>Purchase Date</th>\
        </tr>"
counter = 1

for disk in list:
    print "<tr>\
           <td>%d</td>\
           <td>%s</td>\
           <td>%s/%s<\td>\
           <td></td>\
           <td>%s</td>\
           <tr>"%(
           counter,
           disk.get_callnumber(),
           disk.title_en,
           disk.title_ch,
           Log.select().where(
             Log.log_type == 'create',