数据库手机促销代码

import sqlite3

# 创建数据库连接
conn = sqlite3.connect('promotions.db')
cursor = conn.cursor()

# 创建促销代码表
cursor.execute('''
CREATE TABLE IF NOT EXISTS promotions (
    code TEXT PRIMARY KEY,
    discount REAL,
    expiration_date TEXT
)
''')

# 插入促销代码
cursor.execute("INSERT INTO promotions (code, discount, expiration_date) VALUES (?, ?, ?)", ('SUMMER20', 0.2, '2023-12-31'))

# 提交更改
conn.commit()

# 应用促销代码
def apply_promotion(code, price):
    cursor.execute("SELECT discount, expiration_date FROM promotions WHERE code = ?", (code,))
    result = cursor.fetchone()
    if result:
        discount, expiration_date = result
        if datetime.datetime.now() < datetime.datetime.strptime(expiration_date, '%Y-%m-%d'):
            return price * (1 - discount)
    return price

# 示例使用
price = 100
discounted_price = apply_promotion('SUMMER20', price)
print(f'Original Price: ${price}, Discounted Price: ${discounted_price}')

# 关闭连接
conn.close()