游戏数据库存储新购活动

import sqlite3
from datetime import datetime

# 连接到SQLite数据库（如果不存在则创建）
conn = sqlite3.connect('game_database.db')
cursor = conn.cursor()

# 创建新购活动表
cursor.execute('''
CREATE TABLE IF NOT EXISTS purchase_activities (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    player_id TEXT NOT NULL,
    item_name TEXT NOT NULL,
    purchase_amount REAL NOT NULL,
    purchase_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)
''')

# 插入一条新购活动记录
def record_purchase(player_id, item_name, purchase_amount):
    cursor.execute('''
    INSERT INTO purchase_activities (player_id, item_name, purchase_amount)
    VALUES (?, ?, ?)
    ''', (player_id, item_name, purchase_amount))
    conn.commit()

# 示例：记录一次购买
record_purchase('player123', '魔法剑', 99.99)

# 查询并打印所有购买记录
cursor.execute('SELECT * FROM purchase_activities')
rows = cursor.fetchall()
for row in rows:
    print(row)

# 关闭数据库连接
conn.close()