python flask test

#!/usr/bin/python

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

from os import sys

reload(sys)

sys.setdefaultencoding('utf-8')

import logging

logging.basicConfig(level=logging.INFO)

from flask import Flask

from flask import request

import json

from sqlwemedia import mysqltest

# https://www.cnblogs.com/he12345/p/7486309.html

# https://www.cnblogs.com/vovlie/p/4182814.html

app = Flask(__name__)

 

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

def home():

return '<h1>Home</h1>'

 

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

def signin_form():

return '''<form action="/signin" method="post">

<p><input name="username"></p>

<p><input name="password" type="password"></p>

<p><button type="submit">Sign In</button></p>

</form>'''

 

@app.route('/signin', methods=['POST'])

def signin():

 

if request.form['username']=='admin' and request.form['password']=='password':

return '<h3>Hello, admin!</h3>'

return '<h3>Bad username or password.</h3>'

 

@app.route('/wemedia/<id>', methods=['GET'])

def getMediaId(id):

id = str(id)

 

sql = '''select id AS id from user_info where user_info.id ='%s' ''' %(id)

w = mysqltest()

user_id = w.selectmysql(sql)

if user_id == None:

return '查询结果为空'

w.conn.commit()

w.cursor.close

w.conn.close

jsonData = []

data={}

user_id = ','.join(str(i) for i in user_id)

data ["wm_id"] = wm_id

jsonData.append(data)

logging.info(jsonData)

return json.dumps(jsonData)

 

if __name__ == '__main__':

app.run(host='ip', port=8081, debug=True)

 

import mysql.connector

class mysqltest(object):

def __init__(self):

pass

def selectmysql(self,sql):

 

self.conn = mysql.connector.connect(host='ip',port=23306,user='wemedia',passwd='user@test',db='user', use_unicode=True)

try:

self.cursor = self.conn.cursor()

# 插入一行记录，注意MySQL的占位符是%s:

data = self.cursor.execute(sql)

# 查询单数据时用

#"%s" '% index

wmid = self.cursor.fetchone()

# wmid = cursor.fetchall() 查询多数据时使用

except mysql.connector.Error as e:

print ('Error : {}'.format(e))

finally:

print 'Connect wemedia closed in finally'

 

return wmid