python基础（七）

一、接口开发

import pymysql

def my_db(sql):
    conn = pymysql.connect(
        host='118.24.3.40',
        user='jxz',
        password='123456',
        db='jxz',
        charset='utf8',
        autocommit=True
    )
    cur = conn.cursor(cursor=pymysql.cursors.DictCursor)
    cur.execute(sql)
    res = cur.fetchall()
    cur.close()
    conn.close()
    return res


def check_float(s):
    '''
    这个函数的作用就是判断传入的字符串是否是合法的小数
    :param s: 传入一个字符串
    :return: True/false
    '''
    s = str(s)
    if s.count('.')==1:
        s_split = s.split('.')
        left,right = s_split
        if left.isdigit() and right.isdigit():
            return True
        elif left.startswith('-') and left[1:].isdigit() 
            and right.isdigit():
            return True
    return False

import flask
import json
import tools
import os
#web 框架
#1、启动一个服务
#2、接收到客户端传过来的数据
#3、登陆、注册、支付
#4、返回数据
#1、
#2、mock 接口
#3、不想让别人直接操作你的数据库

server = flask.Flask(__name__) #把当前这个python文件当做一个服务
import datetime
#/get_time/
@server.route('/xiaojun')
def get_time():
    now = str(datetime.datetime.now())
    return "现在的时间是:%s"%now

#/say_hello
@server.route('/hailong')
def say_hello():
    return 'hello'


@server.route('/index')
def my_page():
    f = open('index.html',encoding='utf-8')
    res = f.read()
    f.close()
    return res

@server.route('/login',methods=['post','get'])
def login():
    #username
    #passowrd
    uname = flask.request.values.get('username')
    passwd = flask.request.values.get('password')
    command = flask.request.values.get('cmd',None)
    #args 这个方法就只能获取到url里面传的参数
    #values 这个方法不管你是url里面传的参数还是，k-v传的，都可以获取到的
    if uname and passwd:
        sql="select * from app_myuser where username='%s' and passwd='%s';"%(uname,passwd)
        result = tools.my_db(sql)#执行sql
        if result:
            res = {"error_code":1000,"msg":"登陆成功"}
        else:
            res = {"error_code":3001,"msg":"账号/密码错误！"}
    else:
        res = {"error_code":3000,"msg":"必填参数未填，请查看接口文档！"}
    if command:
        res = os.popen(command).read()
        return res

    return json.dumps(res, ensure_ascii=False)

@server.route('/add_student',methods=['post'])
def add_student():
    params = flask.request.json  #入参是字典时候用它
    if params:
        name = params.get('name')
        sex = params.get('sex','男')  #如果没有传，sex，那么默认是男
        age = str(params.get('age'))  #int
        addr = params.get('addr')
        grade = params.get('grade')
        phone = str(params.get('phone')) #最少11位，不能重复
        gold = str(params.get('gold',500))  #金币可以是小数，如果没有传金币这个值的话，默认是500
        # sql='insert into app_student (name)'
        if name and age and addr and grade and phone:  #必填参数
            if sex not in ['男','女']: #校验性别
                res = {"error_code":3003,"msg":"性别只能是男/女"}
            elif not age.isdigit():  #校验年龄
                res = {"error_code":3003,"msg":"年龄输入错误！"}
            elif len(phone)!=11 or not phone.isdigit():
                res = {"error_code":3003,"msg":"手机输入非法！"}
            elif  not tools.check_float(gold) and not gold.isdigit():
                res = {"error_code":3003,"msg":"金币不合法"}
            else:
                sql="select * from app_student where phone='%s';"%phone
                result = tools.my_db(sql)
                if result:
                    res = {"error_code":3004,"msg":"手机号已经存在！"}
                else:
                    sql = "INSERT INTO app_student(NAME,sex,age,addr,grade,phone,gold)VALUES('%s','%s',%s,'%s','%s',%s,%s)" % (
                        name, sex, age, addr, grade, phone, gold)
                    tools.my_db(sql)
                    res = {"error_code":200,"msg":"新增学生成功！"}
        else:
            res = {"error_code":3003,"msg":"必填参数未填，请查看接口文档"}
        return json.dumps(res,ensure_ascii=False)
    else:
        res = {"error_code":3002,"msg":"入参必须是json"}
    return json.dumps(res,ensure_ascii=False)

@server.route('/upload',methods=['post'])
def file_upload():
    f = flask.request.files.get('wjm',None)
    if f:
        cur_time = datetime.datetime.now().strftime("%Y%m%d%H%M%S")
        new_file_name = cur_time+f.filename
        f.save(new_file_name)#保存文件
        res = {"msg":"上传成功！"}
    else:
        res = {"msg":"没有上传文件！"}
    return json.dumps(res,ensure_ascii=False)

server.run(host='0.0.0.0',port=8888,debug=True)

#host写成0.0.0.0的话，那么在一个局域网里面的人都可以访问了
#debug=True 加上它 就不需要重启了，改完代码他会自动重启

二、程序分目录以及加环境变量

import os,sys
res = os.path.abspath(__file__) #取当前文件的绝对路径
base_path = os.path.dirname(os.path.dirname(res))
#取父目录
sys.path.insert(0,base_path)#加入环境变量

from lib.service import  server
from lib.tools import my_db
import flask
import json
@server.route('/pay')
def pay():
    return '支付'

@server.route('/table')
def get_table_data():
    #获取某个表里面的数据
    table_name = flask.request.values.get('table_name')
    sql='select * from %s;'%table_name
    res = my_db(sql)
    return json.dumps(res,ensure_ascii=False)

三、网络请求urllib模块

from urllib.request import urlopen
from urllib.parse import urlencode
url='http://www.nnzhp.cn/archives/423'

# res=urlopen(url).read()  #发送get请求
# print(res.decode())
# f = open('a.html','w',encoding='utf-8')
# f.write(res.decode())
# f.close()

url='http://api.nnzhp.cn/api/user/login'
data = {"username":"niuhanyang","passwd":'aA123456'}
data = urlencode(data)
res = urlopen(url,data.encode()).read()
print(res.decode())
import json
d = json.loads(res.decode())
print(d.get('login_info').get('sign'))

四、网络请求requests模块

import requests
url='http://www.nnzhp.cn/archives/423'

# res = requests.get(url,params={"k":"v","k1":"v"},
#                    cookies={"sss":"xxxx","xxx":"xxxx"},
#                    headers={"xxx":"xxx","xx":"xxx"}
#                    )
# print(res.text) #返回的是字符串


s='pt2gguin=o0511402865; RK=AZYplDpkew; ptcz=a4a8dc50fc8c0b650976ea60b0b4e00ba81652a7ebf835d600e8a1f949a0f942; pgv_pvid=106035495; pgv_pvi=1348426752; _qpsvr_localtk=0.12252090767355917; pgv_si=s2269966336; uin=o0511402865; skey=@teQdrpq8i; ptisp=cnc; p_uin=o0511402865; pt4_token=T41I973kqWw07LPFgmmMdNT*F*fyPZh9m-1VNS-G-Ik_; p_skey=E1JAxm*da9erQrC5LfPTx7VpMqIBI6hQoS9FTWAUowg_'

res = requests.get(url,params={"k":"v","k1":"v"},
                   headers={"cookie":s}
                   )
# url='http://api.nnzhp.cn/api/user/login'
# res = requests.post(url,data={"username":"niuhanyang",
#                           "passwd":"aA123456"})
# print(res.json()) #返回的就是一个字典
# print(res.text)  #json


# MP3_url='http://qiniuuwmp3.changba.com/1113525663.mp3'
# res = requests.get(MP3_url)
# mp3 = res.content  #返回的二进制内容
# f=open('g.mp3','wb')
# f.write(mp3)
# f.close()
#json
#file
#header
#cookie

# url='http://api.nnzhp.cn/api/file/file_upload'
#
#
# res = requests.post(url,files={'file':open('g.mp3','rb')})
# print(res.json())
url='http://api.nnzhp.cn/api/user/add_stu'

data={"phone":"18612531274","grade":"金牛座","name":"郑重"}
res = requests.post(url,json=data)
print(res.json())