def test_cannot_connect_to_newer_db():
conn = connect(qc.config["core"]["db_location"],
qc.config["core"]["db_debug"])
current_version = get_user_version(conn)
set_user_version(conn, current_version + 1)
conn.close()
err_msg = f'is version {current_version + 1} but this version of QCoDeS ' \
f'supports up to version {current_version}'
with pytest.raises(RuntimeError, match=err_msg):
conn = connect(qc.config["core"]["db_location"],
qc.config["core"]["db_debug"])
def test_database_upgrade(empty_temp_db):
connection = connect(qc.config["core"]["db_location"],
qc.config["core"]["db_debug"])
userversion = get_user_version(connection)
if userversion != 0:
raise RuntimeError("trying to upgrade from version 0"
" but your database is version"
" {}".format(userversion))
sql = 'ALTER TABLE "runs" ADD COLUMN "quality"'
atomic_transaction(connection, sql)
set_user_version(connection, 1)