pythonapi汇总工具_python的api中lib的tools汇总1

import hashlib, pymysql,redis,time

from config import setting

# md5加密，加盐

def md5(s):

s = (str(s) + setting.SALT).encode()

m = hashlib.md5(s)

return m.hexdigest()

def op_mysql(sql: str):

result = '执行完成'

conn = pymysql.connect(**setting.mysql_info)

cur = conn.cursor(pymysql.cursors.DictCursor) # 建立游标

cur.execute(sql)

if sql.strip().lower().startswith('select'):

result = cur.fetchone()

#result = cur.fetchall()

cur.close()

conn.close()

return result

def saveRedis(data, key):

r = redis.Redis(**setting.redis_info) # 0-15

r.set(key,data,3000) # 200秒的失效时间

# p = r.pipeline()

# for d in data:

# p.hset(key, d.get('uin'), json.dumps(d, ensure_ascii=False))

# p.execute()

print('redis写入完成！')

def getRedis(key):

r = redis.Redis(**setting.redis_info) # 0-15

return r.get(key)

def clear_error_count(table, username):

# username = input('username:').strip()

sql = 'update %s set error_count = 0 where username = "%s";' % (table, username)

return op_mysql(sql)

# 这个函数用来判断表是否存在

def table_exists(table_name):

sql2 = "show tables;"

conn = pymysql.connect(**setting.mysql_info)

cur = conn.cursor(pymysql.cursors.DictCursor) # 建立游标

cur.execute(sql2)

table_list =cur.fetchall()

for js in range(len(table_list)):

if table_name==table_list[js]['Tables_in_jxz']:

return 1 # 存在返回1

return 0 # 不存在返回0

# 把时间戳转换成格式化

def timestamp_to_str(timestamp=None, format='%Y-%m-%d %H:%M:%S'):

if timestamp:

time_tuple = time.localtime(timestamp) # 把时间戳转换成时间元祖

result = time.strftime(format, time_tuple) # 把时间元祖转换成格式化好的时间

return result

else:

return time.strptime(format)

# 把时间字符串转换成时间戳

def str_to_timestamp(str_time=None, format='%Y-%m-%d %H:%M:%S'):

if str_time:

time_tuple = time.strptime(str_time, format) # 把格式化好的时间转换成元祖

result = time.mktime(time_tuple) # 把时间元祖转换成时间戳

return int(result)

return int(time.time())