python连接数据库

1. 用装饰器来验证令牌

   import jwt
   from functools import wraps
   from flask import request
   
   def check_token(*arrgs)
       def decorated(func)
           @wraps(func)
           def wrapper():
               decoded=None
               try:
                   token=request.headers['token']
                   decoded=jwt.decode(token,'123456',audience='webkit',algorithms=['HS256']
                   print(decoded['user_id']
                   return func()
               except jwt.ExpiredSignatureError:
                   print('error....')
                   return decoded
               except Exception:
                   print('error2...')
           return wrapper
       return decorated

2. 连接数据库，首先安装pymysql

   • 查询操作

   import pymysql
   
   #连接数据库
   
   connect=pymysql.connect(host='localhost',user='root',
   password='123456',port='3306',db='user')
   cursor=connect.cursor()#游标
   sql='select * from user'#sql语句
   cursor.execute(sql)#执行语句
   res=cursor.fetchall#查看所有结果
   res=cursor.fetchone #查看一条结果
   res=cursor.fetchmany(3) #查看3条结果
   print(res)

   • 修改数据库

   connect=pymysql.connect(host='localhost',user='root',password='123456',port=3306,db='students')
   user={
       "id":"001",
       "name":"tom",
       "age":"20"
   }
   sql="insert into sc(sno,cno,grade) values ('{0}','{1}','{2}')"\
   .format(user['id'],user['name'],user['age'])
   cursor=connect.cursor()
   cursor.execute(sql)
   connect.commit()#更新操作
   cursor.close()
   connect.close()

3. 语法

   resume_id=connect.insert_id() 最后一个插入的id
   cursor=connect.cursor(cursor=pymysql.cursors.DictCursor)返回字典
   cursor.scroll(2,mode='relative')游标向下移动两位
   cursor.scroll(2,mode='absolute')绝对位置