基于flask框架的接口开发
post接口 实例
#!/usr/bin/env python
# -*- coding:utf-8 -*-
import flask, json, logging
import ConenctDB #引用ConnectMysql文件
from flask import request
logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(name)s - %(levelname)s - %(message)s')
logger = logging.getLogger(__name__)
server = flask.Flask(__name__)
@server.route('/v1/brd/task', methods=['post'])
def task():
json_req = request.json
logger.info("接受到参数:%s",json_req)
task_name = json_req.get('taskName')
category = json_req.get('Category')
description = json_req.get('Description')
database=json_req.get('Database')
status = json_req.get('status')
sql_type = json_req.get('sqlType')
sql_statement = json_req.get('sqlStatement')
has_execs = json_req.get('hasExecs')
in_user = json_req.get('inUser')
result = {'taskName': task_name,
'Category': category,
'description': description,
'database': database,
'sqlType': sql_type,
'status': status,
'sqlStatement': sql_statement,
'hasExecs': has_execs,
'inUser': in_user
}
logger.info('接受到的参数:%s', result)
successed = True
message=''
code = 200
try:
data = ConenctDB.INsertDB("insert into POForTest.dbo.brd_task ([TaskName],[Category],[Description],[DataBase],[status],[SqlStatement],[SqlType],[InUser],[InDate],[LastEditUser],[LastEditDate]) "
"values ('%s','%s','%s','%s','%s','%s','%s','%s',getdate(),%s,getdate())"%(task_name,category,description,database,status,sql_statement,sql_type,in_user,in_user))
# data = ConenctDB.INsertDB("execute dbo.UP_create_brdtask (%s,%s,%s,%s,%s,%s,%s,%s,%s)"%(task_name,category,description,database,status,sql_statement,sql_type,in_user,in_user))
logger.info(data)
except:
message = 'this is a exception message!'
successed = False
code = 500
res = {'successed': successed,
'message': message,
'code': code
}
return json.dumps(res, ensure_ascii=False)
server.run(port=7777, debug=True, host='127.0.0.1')
get 接口
import flask
from flask import request
from app.main import restful_api
from app.business import userbus
from app.utilities.base import AdminResource
import json
@restful_api.resource("/get/UserName")
class GetFullName(AdminResource):
def get(self):
user = userbus.getin_data(request.args)
userid=user.get('userid')
if userid is not None:
userinfo=userbus.get_username(userid)
return UserFullName.successful(userinfo)
else:
Message = "Userid can't be None"
return UserFullName.fail(Message)