VTHzHTMZ

1CREATE TABLE IF NOT EXISTS today_version (
2region TEXT,
3instance TEXT,
4version TEXT,
5last_update_time TEXT,
6PRIMARY KEY (region, version)
7)     
8
9CREATE TABLE IF NOT EXISTS history_version (
10region TEXT,
11instance TEXT,
12version TEXT,
13last_update_time TEXT
14)
15	
16df = pd.read_csv("data.csv")
17query = '''insert or replace into today_version (region, instance, version, last_update_time) values (?,?,?,?,?)'''
18conn.executemany(query, df.to_records(index=False))
19	
20$ sqlite3
21$ > select * from today_version;
22...... (record)
23	
24CREATE TRIGGER add_history BEFORE DELETE ON today_version
25WHEN new.version != old.version
26BEGIN
27    INSERT INTO history_version (market, instance, version, last_update_time) VALUES (old.market, old.instance, old.version, old.last_update_time);
28END;