数据库凭证管理秒杀

import redis
import pymysql

# 连接Redis
redis_client = redis.StrictRedis(host='localhost', port=6379, db=0)

# 连接MySQL
db = pymysql.connect(host='localhost', user='user', password='password', database='dbname')
cursor = db.cursor()

def get_data(key):
    # 先从Redis缓存中获取数据
    data = redis_client.get(key)
    if data is not None:
        return data.decode('utf-8')
    
    # 如果Redis中没有数据，从MySQL中获取
    sql = "SELECT value FROM table WHERE key = %s"
    cursor.execute(sql, (key,))
    result = cursor.fetchone()
    if result is not None:
        value = result[0]
        # 将数据存入Redis缓存
        redis_client.setex(key, 3600, value)
        return value
    
    return None

# 示例调用
data = get_data('example_key')
print(data)