SQLITE:获取每个不同组件的最新组件更新

CREATE TABLE component_updates (
    id INTEGER PRIMARY KEY,
    component_name TEXT NOT NULL,
    update_version TEXT NOT NULL,
    update_date DATETIME NOT NULL
);

SELECT component_name, MAX(update_date) AS latest_update_date
FROM component_updates
GROUP BY component_name;

import sqlite3

# 连接到 SQLite 数据库
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建示例表
cursor.execute('''
CREATE TABLE IF NOT EXISTS component_updates (
    id INTEGER PRIMARY KEY,
    component_name TEXT NOT NULL,
    update_version TEXT NOT NULL,
    update_date DATETIME NOT NULL
);
''')

# 插入示例数据
cursor.execute("INSERT INTO component_updates (component_name, update_version, update_date) VALUES ('ComponentA', '1.0.1', '2023-04-01 10:00:00')")
cursor.execute("INSERT INTO component_updates (component_name, update_version, update_date) VALUES ('ComponentA', '1.0.2', '2023-04-02 11:00:00')")
cursor.execute("INSERT INTO component_updates (component_name, update_version, update_date) VALUES ('ComponentB', '2.0.1', '2023-04-01 12:00:00')")

# 获取每个组件的最新更新
cursor.execute('''
SELECT component_name, MAX(update_date) AS latest_update_date
FROM component_updates
GROUP BY component_name;
''')

# 打印结果
for row in cursor.fetchall():
    print(row)

# 关闭连接
conn.close()