web.py简单demo

1.准备工作

安装python/安装web.py/安装sql插件

2.python代码

# coding:utf-8
import sys 
default_encoding = 'utf-8' 
if sys.getdefaultencoding() != default_encoding: 
    reload(sys) 
    sys.setdefaultencoding(default_encoding) 
import web
from web import form
import json

render = web.template.render('templates')

db = web.database(dbn='mysql', db='last2km', 
    host='rds3uiru3je6rmipublic.mysql.rds.aliyuncs.com', user='last2km', pw='c42hn7rLq')

order_form = form.Form(
    form.Textbox("consignee", description="consignee"),
    form.Textbox("address", description="address"),
    form.Textbox("mobile", description="mobile"),
    form.Textbox("receive_amount", description="receive_amount"),
    form.Textbox("remark", description="remark"),
    form.Button("submit", type="submit", description="Register")
)

detail_form = form.Form(
    form.Textbox("name", description="name"),
    form.Textbox("price", description="price"),
    form.Textbox("count", description="count"),
    form.Button("submit", type="submit", description="submit")
)

urls = (
    '/','index',
    '/orderIndex','orderIndex',
    '/addOrder','addOrder',
    '/updateOrder/(.+)','updateOrder',
    '/addOrderDetail/(.+)','addOrderDetail',
    '/OrderService/(.+)/(.+)','OrderService'
)

class index:
    def GET(self):
        return render.index()


class updateOrder:
    def GET(self, id):
        oser = OrderService()
        oser.update(id,1)
        return render.orderIndex(oser.getByStatus('0,1,4,16,64'))


class orderIndex:
    def GET(self):
        oser = OrderService()
        return render.orderIndex(oser.getByStatus('0,1,4,16,64'))
        

class addOrder:
    def GET(self):
        f = order_form()
        return render.addOrder(f)

    def POST(self):
        f = web.input()
        a = db.insert('lk_order',seller_id=1, mobile=f['mobile'], 
            consignee=f['consignee'],address=f['address'],created_time=web.SQLLiteral("NOW()"))
        oser = OrderService()
        order = oser.getById(a)
        return render.addOrderDetail(detail_form(), order, oser.getDetails(order.id))

class addOrderDetail():
    def GET(self,id):
        oser = OrderService()
        return render.addOrderDetail(detail_form(), oser.getById(id), oser.getDetails(id))

    def POST(self,id):
        f = web.input()
        oser = OrderService()
        db.insert('lk_order_detail', order_id=id, name=f['name'], price=f['price'], count=f['count'])
        return render.addOrderDetail(detail_form(), oser.getById(id), oser.getDetails(id))


class OrderService:
    def GET(self, Method, data):
        web.header('Access-Control-Allow-Origin', '*')
        oser = OrderService()

        if Method == 'GET':
            order = oser.getById(data)
            for k in order.keys():
                order[k] = str(order[k])
            oser.generate(order)
            return json.dumps(dict(order),ensure_ascii= False)
        elif Method == 'STATUS':
            orders = []
            for order in oser.getByStatus(data):
                for k in order.keys():
                    order[k] = str(order[k])
                oser.generate(order)
                orders.append(dict(order))
            return json.dumps(orders,ensure_ascii= False)
        elif Method == 'UPDATE':
            print data
            obj = json.loads(data)
            oser.update(obj['id'], obj['status'])
            order = oser.getById(obj['id'])
            for k in order.keys():
                order[k] = str(order[k])
            oser.generate(order)
            return json.dumps(dict(order),ensure_ascii= False)
        elif Method == 'DETAIL':
            orderDetails = []
            for detail in oser.getDetails(data):
                for k in detail.keys():
                    detail[k] = str(detail[k])
                orderDetails.append(dict(detail))
            return json.dumps(orderDetails,ensure_ascii= False)
        elif Method == 'ADD':
            pass

    def getById(self, id):
        return db.select('lk_order', where='id=$id', vars=locals())[0]

    def getByStatus(self, data):
        status = data.split(',')
        return db.select('lk_order', where='status in $status', vars=locals())

    def update(self, id, status):
        db.update('lk_order', where='id=$id', status=status, vars=locals())

    def getDetails(self, id):
        return db.select('lk_order_detail', where='order_id=$id', vars=locals())

    def getSellerId(self, id):
        return db.select('lk_seller', where='id=$id', vars=locals())[0]

    def Add(self, order, details):
        id = db.insert('lk_order', seller_id=order['seller_id'], consignee=order['consignee'], address=order['address']
            , mobile=order['mobile'], remark=order['remark'], order_amount=order['order_amount']
            , receive_amount=order['receive_amount'], status=order['status'],created_time=web.SQLLiteral("NOW()"))

        for detail in details:
            db.insert('lk_order_detail', order_id=id, name=detail['name'], price=detail['price'], count=detail['count'])
        return id

    def generate(self, order):
        if order['status'] == '1':
            order['nextOperation'] = "接单"
            order['stateClass'] = 'ion-information-circled color-danger'
        elif order['status'] == '4':
            order['nextOperation'] = "签收"
            order['stateClass'] = 'ion-jet color-active'
        elif order['status'] == '16':
            order['nextOperation'] = "回单"
            order['stateClass'] = 'ion-checkmark-circled color-success'

        sellerId = order['seller_id']
        sellerTmp = db.select('lk_seller', where='id=$sellerId', vars=locals())[0]
        order['sellerName'] = sellerTmp['name']
        order['sellerLogo'] = sellerTmp['logo']

if __name__ == "__main__":
    app = web.application(urls, globals())
    app.run()

3.新建一个templates目录放html文件

$def with(orders)
<h1>Order List</h1>
<a href="/addOrder">新增订单</a>
<table>
    <thead>
        <tr>
            <td>订单ID</td>
            <td>收件人</td>
            <td>电话</td>
            <td>订单金额</td>
            <td>应收金额</td>
            <td>地址</td>
            <td>备注</td>
            <td>当前状态</td>
            <td>下单</td>
            <td>加货</td>
        </tr>
    </thead>
$for order in orders
    <tr>
        <td>$:order.id</td>
        <td>$:order.consignee</td>
        <td>$:order.mobile</td>
        <td>$:order.order_amount</td>
        <td>$:order.receive_amount</td>
        <td>$:order.address</td>
        <td>$:order.remark</td>
        $if order.status==0:
            <td>初始</td>
        $elif order.status==1:
            <td>下单</td>
        $elif order.status==4:
            <td>配送</td>
        $elif order.status==16:
            <td>签收</td>
        $else:
            <td>回单</td>

        $if order.status==0:
            <td><a href="/updateOrder/$:order.id">下单</a></td>
            <td><a href="/addOrderDetail/$:order.id">加货</a></td>
        $else:
            <td>下单</td>
            <td>加货</td>
    </tr>
</table>

$def with(form)
<h1>Add Order</h1>
<form method="POST">
    $:form.render()
</form>

$def with(form,order,orderDetails)
<h1>Order detail List</h1>
<table>
    <tbody>
        <tr>
            <th><label for="name">收件人</label></th>
            <td>$:order.consignee</td>
        </tr>
        <tr>
            <th><label for="price">电话</label></th>
            <td>$:order.mobile</td>
        </tr>
        <tr>
            <th><label for="count">订单金额</label></th>
            <td>$:order.order_amount</td>
        </tr>
        <tr>
            <th><label for="count">地址</label></th>
            <td>$:order.address</td>
        </tr>
        <tr>
            <th><label for="count">备注</label></th>
            <td>$:order.remark</td>
        </tr>
    </tbody>
</table>
<hr>
<table>
    <thead>
        <tr>
            <td>ID</td>
            <td>货品名称</td>
            <td>货品单价</td>
            <td>货品数量</td>
        </tr>
    </thead>
$for detail in orderDetails
    <tr>
        <td>$:detail.id</td>
        <td>$:detail.name</td>
        <td>$:detail.price</td>
        <td>$:detail.count</td>
    </tr>
</table>
<form method="POST" action="/addOrderDetail/$:order.id">
<table>
    <tbody>
        <tr>
            <th><label for="name">name</label></th>
            <td><input type="text" id="name" name="name"></td>
        </tr>
        <tr>
            <th><label for="price">price</label></th>
            <td><input type="text" id="price" name="price"></td>
        </tr>
        <tr>
            <th><label for="count">count</label></th>
            <td><input type="text" id="count" name="count"></td>
        </tr>
        <tr>
            <th><label for="submit"></label></th>
            <td><button type="submit" id="submit" name="submit">submit</button></td>
        </tr>
    </tbody>
</table>
</form>

4.目录结构如下：

demo
--code.py
--templates
----orderIndex.html
----addOrder.html
----addOrderDetail.html

5.完事

python code.py # 8080