import sqlite3
conn = sqlite3.connect('/home/ubuntu/vinted_tracker/tracker.db')
try:
    conn.execute('INSERT INTO searches (chat_id, query, min_price, max_price, enabled, url_params, exclude_keywords, must_keywords, use_ai) SELECT chat_id, query, min_price, max_price, enabled, url_params, exclude_keywords, must_keywords, use_ai FROM searches_v2')
    conn.execute('DROP TABLE searches_v2')
    conn.commit()
    print('Merged searches_v2 into searches')
except Exception as e:
    print('Searches merge error:', e)

try:
    conn.execute('INSERT OR IGNORE INTO sent_items (item_id, search_id, title, price, url, sent_at) SELECT item_id, search_id, title, price, url, sent_at FROM sent_items_v2')
    conn.execute('DROP TABLE sent_items_v2')
    conn.commit()
    print('Merged sent_items_v2 into sent_items')
except Exception as e:
    print('Sent items merge error:', e)

try:
    conn.execute('INSERT OR IGNORE INTO settings (chat_id, key, value) SELECT chat_id, key, value FROM settings_v2')
    conn.execute('DROP TABLE settings_v2')
    conn.commit()
    print('Merged settings_v2 into settings')
except Exception as e:
    print('Settings merge error:', e)