flask 创建mysql_flask + MySQL-python 创建 webapp 应用

0 - python 用自带的 wgsi 也可以创建 web 服务

1)建立 hello.py 内容如下

# hello.py

def application(environ, start_response):

start_response('200 OK', [('Content-Type', 'text/html')])

return '

Hello, web!

'

2)建立 server.py

# -*- coding:utf-8 -*-

# 从wsgiref模块导入:

from wsgiref.simple_server import make_server

# 导入我们自己编写的application函数:

from hello import application

# 创建一个服务器，IP地址为空，端口是8000，处理函数是application:

httpd = make_server('', 8000, application)

print "Serving HTTP on port 8000..."

# 开始监听HTTP请求:

httpd.serve_forever()

缺点：貌似只能创建一个访问地址，不同 url 路由不好控制

1 - flask 建立一个 web server

1、pip install Flask

2、建立一个 test_flask.py 的文件，加入代码如下：

# -*- coding:utf-8 –*-

from flask import Flask, request, make_response, current_app

from functools import wraps

import json

import sys

import datetime

# 一个 app 是一个 Flask 文件

app = Flask(__name__)

def jsonp(func):

"""Wraps JSONified output for JSONP requests."""

@wraps(func)

def decorated_function(*args, **kwargs):

callback = request.args.get('callback', False)

if callback:

data = str(func(*args, **kwargs).data)

content = str(callback) + '(' + data + ')'

mimetype = 'application/javascript'

return current_app.response_class(content, mimetype=mimetype)

else:

return func(*args, **kwargs)

return decorated_function

# 有route

@app.route('/test', methods=['GET'])

def test():

resp = make_response(

(

json.dumps({'key':'value'}),

200,

{'Content-Type': 'application/json'}

)

)

return resp

if __name__ == '__main__':

app.run(host='0.0.0.0', port=8899)

2 - 安装mysql

1、使用 brew 安装 mysql 服务

brew install mysql

2、启动 mysql 服务

mysql.server start

3、使用 root 用户免密登录

mysql -uroot

4、修改 root 密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

5、登录 mysql 数据库 建立测试表格

create table tb_dept(

id int primary key auto_increment,#部门编号 整形 主键 自增长

name varchar(18),#部门名称

description varchar(100)#描述

);

3 - 安装 MySQL-python

pip install MySQL-python

4 - 手写数据库连接代码

# -*- coding:utf-8 –*-

from flask import Flask, request, make_response, current_app

from functools import wraps

import MySQLdb as mysql

import json

import sys

import datetime

app = Flask(__name__)

def MysqlInit():

#connect to mysql

hostaddress = 'localhost'

username = 'root'

password = '*****'

database = 'test'

try:

conn = mysql.connect(

host=hostaddress,

user=username,

passwd=password,

db=database,

charset="utf8")

print 'connect to mysql db success'

return conn

except Exception, e:

print e

sys.exit('init mysql failed!')

def CheckConnect(conn):

try:

conn.ping()

return conn

except:

print 'mysql coonect has been closed now reconnect'

cur_conn = MysqlInit()

return cur_conn

def QueryClusterInfo(conn):

print "\ncoming QueryClusterInfo!!!"

try:

conn = CheckConnect(conn)

cursor = conn.cursor()

except:

conn = CheckConnect(conn)

cursor = conn.cursor()

response_dict = {'ret_code':0,'ret_msg':'ok'}

sql_cmd = 'select * from tb_dept'

try:

cursor.execute(sql_cmd)

cluster_result = cursor.fetchall()

except:

cursor.close()

response_dict['ret_code'] = 1

response_dict['ret_msg'] = 'sql_select_error_in_queryClusterInfo'

return json.dumps(response_dict)

response_dict['res'] = []

if cluster_result is not None:

for items in cluster_result:

res = {}

res['id'] = items[0]

res['name'] = items[1]

res['description'] = items[2]

response_dict['res'].append(res)

cursor.close()

return json.dumps(response_dict)

def jsonp(func):

"""Wraps JSONified output for JSONP requests."""

@wraps(func)

def decorated_function(*args, **kwargs):

callback = request.args.get('callback', False)

if callback:

data = str(func(*args, **kwargs).data)

content = str(callback) + '(' + data + ')'

mimetype = 'application/javascript'

return current_app.response_class(content, mimetype=mimetype)

else:

return func(*args, **kwargs)

return decorated_function

@app.route('/test_mysql', methods=['GET'])

def test():

conn = MysqlInit()

resp = make_response(

(

QueryClusterInfo(conn),

200,

{'Content-Type': 'application/json'}

)

)

return resp

if __name__ == '__main__':

app.run(host='0.0.0.0', port=8989)