| 80 | |
| 81 | @unittest.skipIf(os.getenv('TEST_DB_PROVIDER', 'sqlite3') != 'sqlite3', "This migration is based on a sqlite3 snapshot") |
| 82 | def test_db_upgrade(node_factory): |
| 83 | l1 = node_factory.get_node(options={'database-upgrade': True}) |
| 84 | l1.stop() |
| 85 | |
| 86 | version = subprocess.check_output(['lightningd/lightningd', |
| 87 | '--version']).decode('utf-8').splitlines()[0] |
| 88 | |
| 89 | upgrades = l1.db_query("SELECT * from db_upgrades;") |
| 90 | assert len(upgrades) == 1 |
| 91 | assert(upgrades[0]['upgrade_from'] == -1) |
| 92 | assert(upgrades[0]['lightning_version'] == version) |
| 93 | |
| 94 | # Try resetting to earlier db state. |
| 95 | os.unlink(os.path.join(l1.daemon.lightning_dir, TEST_NETWORK, "lightningd.sqlite3")) |
| 96 | l1.db_manip("CREATE TABLE version (version INTEGER);") |
| 97 | l1.db_manip("INSERT INTO version VALUES (1);") |
| 98 | |
| 99 | l1.start() |
| 100 | upgrades = l1.db_query("SELECT * from db_upgrades;") |
| 101 | assert len(upgrades) == 1 |
| 102 | assert(upgrades[0]['upgrade_from'] == 1) |
| 103 | assert(upgrades[0]['lightning_version'] == version) |
| 104 | |
| 105 | |
| 106 | def test_bitcoin_failure(node_factory, bitcoind): |