python API开发

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

from flask import Flask
import json
import MySQLdb

app = Flask(__name__) 
@app.route('/prodcost/<int:prod_id>')   
def hello(prod_id): 
    try:
        conn = MySQLdb.connect(host='192.168.81.28', user='riskinfo', db='riskinfo', passwd='riskinfo')
        cur = conn.cursor() 
        sql = "select * from prod_cost where prod_id = {0}".format(prod_id)  
        cur.execute(sql)
        result = cur.fetchall()
        result = {"value":{"avg_cost":result[0][1], "batch_cost":result[0][2]}, "prod_id":result[0][0]}     
        return '%s' % result
        conn.commit()
        cur.close()
        conn.close()
    except MySQLdb.Error,e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
if __name__ == '__main__': 
    print "服务器运行"
    app.run(host="0.0.0.0",port=8080, debug=True)
    
    
    
   
浏览器中输入：http://localhost:8080/prodcost/1
   
   

#!/usr/bin/env python
#filecoding:utf8

from flask import Flask
import MySQLdb

app = Flask(__name__)
@app.route('/item/<string:item_id>', methods=['GET'])
def hello(item_id):
    try:
        conn = MySQLdb.connect(host='192.168.95.175', user='madfrog', db='blacklist', passwd='madfrog')
        cur = conn.cursor()
        sql = "select * from antifraud_bl_pullblack_tag where item_id = '%s' " % item_id
        num = cur.execute(sql)  # 返回受影响的行数
        if num > 0:
            result = cur.fetchall()  # 接收全部的返回结果行
            result_num = {"item_id": result[0][0], "pullblack_type": result[0][1]}
        else:
            result_num = 'NULL'
        conn.commit()
        cur.close()
        conn.close()
        return '%s' % result_num
    except MySQLdb.Error, e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
if __name__ == '__main__':
    print "start"
    app.run(host='127.0.0.1', port=8080, debug=True)