When update bitcoinlib version, can't use previous database

[b0r1ngx]

Log:

2024-07-19 14:30:48,202 - bitcoinlib.db - WARNING - BitcoinLib database (0.6.15) is from different version then library code (0.7.0b1). Let's try to update database.
2024-07-19 14:30:48,203 - bitcoinlib.db - WARNING - Error when verifying version or updating database: (sqlite3.OperationalError) duplicate column name: witnesses
[SQL: ALTER TABLE transaction_inputs ADD COLUMN witnesses BLOB]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
OperationalError: (sqlite3.OperationalError) no such column: wallets.anti_fee_sniping
[SQL: SELECT count(*) AS count_1 
FROM (SELECT wallets.id AS wallets_id, wallets.name AS wallets_name, wallets.owner AS wallets_owner, wallets.network_name AS wallets_network_name, wallets.purpose AS wallets_purpose, wallets.scheme AS wallets_scheme, wallets.witness_type AS wallets_witness_type, wallets.encoding AS wallets_encoding, wallets.main_key_id AS wallets_main_key_id, wallets.multisig_n_required AS wallets_multisig_n_required, wallets.sort_keys AS wallets_sort_keys, wallets.parent_id AS wallets_parent_id, wallets.multisig AS wallets_multisig, wallets.cosigner_id AS wallets_cosigner_id, wallets.key_path AS wallets_key_path, wallets.anti_fee_sniping AS wallets_anti_fee_sniping, wallets.default_account_id AS wallets_default_account_id 
FROM wallets 
WHERE wallets.name = ?) AS anon_1]
[parameters: ('tbtc-testnet',)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

Also, can you please say, what the default root of database (can't find it in source).

[mccwdev]

When migrating between major version, for example from a 0.6.x version to 0.7.x you cannot use the same database.

You have to create a new database, import master keys from previous database and rescan all wallets.

The database files can be found at ~/.bitcoinlib/database

And an example of a way to import an old database can be found at bitcoinlib/tools/import_database.py