def test_fresh_install(db):
    """ Test table creation if the uses never had encryption_state table
        installed (i.e. user skiped gajim-omemo plugin version 0.3)
    """
    assert user_version(db) == 0
    assert not table_exists(db, 'encryption_state')
    encryption.migrate(db)
    assert db is not None
    assert table_exists(db, 'encryption_state')
    assert user_version(db) == 1
def test_downgrade(db):
    """ This test asserts a smooth downgrade of sqlite to pre-3.8.2 version.

        Gajim on Windows and TravisCi use an old sqlite version which does not
        support `WITHOUT ROW ID` which was added in *6bf2187*. This test make sure
        that we can gracefully backup data from the `encryption_state` before
        droping the table and reacreating it with an ID column with
        `AUTO_INCREMENT`.
    """
    q = """ CREATE TABLE encryption_state (
                jid TEXT PRIMARY KEY,
                encryption INTEGER,
                timestamp NUMBER DEFAULT CURRENT_TIMESTAMP
                );
        """
    db.execute(q)
    q = """ SELECT name FROM sqlite_master
            WHERE type='table' AND name='encryption_state';
        """

    encryption.migrate(db)
    assert db is not None
    assert table_exists(db, 'encryption_state')
    assert user_version(db) == 1