from app import create_app
from app.extensions import db


def test_default_sqlite_database_resolves_to_instance_path(monkeypatch):
    monkeypatch.delenv('DATABASE_URL', raising=False)

    app = create_app()

    with app.app_context():
        assert db.engine.url.database == f'{app.instance_path}/financials.db'


def test_legacy_instance_database_url_is_normalized(monkeypatch):
    monkeypatch.setenv('DATABASE_URL', 'sqlite:///instance/financials.db')

    app = create_app()

    with app.app_context():
        assert db.engine.url.database == f'{app.instance_path}/financials.db'