PolarDB产品使用合集之polardb支持透明数据加密TDE吗

import datetime
import pymysql
from redis import StrictRedis
# 连接在线库和历史库
online_db = pymysql.connect(host='online_db_host', user='user', password='password', db='db')
history_db = pymysql.connect(host='history_db_host', user='user', password='password', db='db')
# 连接Redis缓存
redis_client = StrictRedis(host='redis_host', port=6379, db=0)
def get_order_data(order_id):
    # 尝试从缓存中获取订单数据
    order_data = redis_client.get(f'order_{order_id}')
    if order_data:
        return order_data
    # 如果缓存中没有数据，从在线库中查询
    with online_db.cursor() as cursor:
        sql = f"SELECT * FROM orders WHERE id = {order_id}"
        cursor.execute(sql)
        order_data = cursor.fetchone()
    # 如果在线库中也没有数据，从历史库中查询
    if not order_data:
        with history_db.cursor() as cursor:
            sql = f"SELECT * FROM orders WHERE id = {order_id}"
            cursor.execute(sql)
            order_data = cursor.fetchone()
    # 将查询到的订单数据存入缓存，设置过期时间为90天
    if order_data:
        redis_client.setex(f'order_{order_id}', 90 * 24 * 60 * 60, order_data)
    return order_data
def update_order_data(order_id, new_data):
    # 更新在线库中的订单数据
    with online_db.cursor() as cursor:
        sql = f"UPDATE orders SET data = '{new_data}' WHERE id = {order_id}"
        cursor.execute(sql)
    online_db.commit()
    # 更新历史库中的订单数据（如果需要）
    with history_db.cursor() as cursor:
        sql = f"UPDATE orders SET data = '{new_data}' WHERE id = {order_id}"
        cursor.execute(sql)
    history_db.commit()
    # 更新Redis缓存中的订单数据
    redis_client.setex(f'order_{order_id}', 90 * 24 * 60 * 60, new_data)