KaneAI - World’s First E2E Software Testing Agent.Book a Demo Join TestMu Conference

How to use test_sqlite_in_memory_used method in pytest-django

Best Python code snippet using pytest-django_python

test_db_setup.py

Source:test_db_setup.py

...189            "ENGINE": "django.db.backends.sqlite3",190            "NAME": "/tmp/should-not-be-used",191        }192    }193    def test_sqlite_in_memory_used(self, django_testdir):194        pytest.importorskip("xdist")195        django_testdir.create_test_module(196            """197            import pytest198            from django.db import connections199            @pytest.mark.django_db200            def test_a():201                (conn, ) = connections.all()202                assert conn.vendor == 'sqlite'203                db_name = conn.creation._get_test_db_name()204                assert 'file:memorydb' in db_name or db_name == ':memory:'205        """206        )207        result = django_testdir.runpytest_subprocess("--tb=short", "-vv", "-n1")208        assert result.ret == 0209        result.stdout.fnmatch_lines(["*PASSED*test_a*"])210class TestSqliteWithMultipleDbsAndXdist:211    db_settings = {212        "default": {213            "ENGINE": "django.db.backends.sqlite3",214            "NAME": "/tmp/should-not-be-used",215        },216        "db2": {217            "ENGINE": "django.db.backends.sqlite3",218            "NAME": "db_name",219            "TEST": {"NAME": "test_custom_db_name"},220        }221    }222    def test_sqlite_database_renamed(self, django_testdir):223        pytest.importorskip("xdist")224        django_testdir.create_test_module(225            """226            import pytest227            from django.db import connections228            @pytest.mark.django_db229            def test_a():230                (conn_db2, conn_default) = sorted(231                    connections.all(),232                    key=lambda conn: conn.alias,233                )234                assert conn_default.vendor == 'sqlite'235                db_name = conn_default.creation._get_test_db_name()236                # can_share_in_memory_db was removed in Django 2.1, and237                # used in _get_test_db_name before.238                if getattr(conn_default.features, "can_share_in_memory_db", True):239                    assert 'file:memorydb' in db_name240                else:241                    assert db_name == ":memory:"242                assert conn_db2.vendor == 'sqlite'243                db_name = conn_db2.creation._get_test_db_name()244                assert db_name.startswith('test_custom_db_name_gw')245        """246        )247        result = django_testdir.runpytest_subprocess("--tb=short", "-vv", "-n1")248        assert result.ret == 0249        result.stdout.fnmatch_lines(["*PASSED*test_a*"])250class TestSqliteWithTox:251    db_settings = {252        "default": {253            "ENGINE": "django.db.backends.sqlite3",254            "NAME": "db_name",255            "TEST": {"NAME": "test_custom_db_name"},256        }257    }258    def test_db_with_tox_suffix(self, django_testdir, monkeypatch):259        "A test to check that Tox DB suffix works when running in parallel."260        monkeypatch.setenv("TOX_PARALLEL_ENV", "py37-django22")261        django_testdir.create_test_module(262            """263            import pytest264            from django.db import connections265            @pytest.mark.django_db266            def test_inner():267                (conn, ) = connections.all()268                assert conn.vendor == 'sqlite'269                db_name = conn.creation._get_test_db_name()270                assert db_name == 'test_custom_db_name_py37-django22'271        """272        )273        result = django_testdir.runpytest_subprocess("--tb=short", "-vv")274        assert result.ret == 0275        result.stdout.fnmatch_lines(["*test_inner*PASSED*"])276    def test_db_with_empty_tox_suffix(self, django_testdir, monkeypatch):277        "A test to check that Tox DB suffix is not used when suffix would be empty."278        monkeypatch.setenv("TOX_PARALLEL_ENV", "")279        django_testdir.create_test_module(280            """281            import pytest282            from django.db import connections283            @pytest.mark.django_db284            def test_inner():285                (conn,) = connections.all()286                assert conn.vendor == 'sqlite'287                db_name = conn.creation._get_test_db_name()288                assert db_name == 'test_custom_db_name'289        """290        )291        result = django_testdir.runpytest_subprocess("--tb=short", "-vv")292        assert result.ret == 0293        result.stdout.fnmatch_lines(["*test_inner*PASSED*"])294class TestSqliteWithToxAndXdist:295    db_settings = {296        "default": {297            "ENGINE": "django.db.backends.sqlite3",298            "NAME": "db_name",299            "TEST": {"NAME": "test_custom_db_name"},300        }301    }302    def test_db_with_tox_suffix(self, django_testdir, monkeypatch):303        "A test to check that both Tox and xdist suffixes work together."304        pytest.importorskip("xdist")305        monkeypatch.setenv("TOX_PARALLEL_ENV", "py37-django22")306        django_testdir.create_test_module(307            """308            import pytest309            from django.db import connections310            @pytest.mark.django_db311            def test_inner():312                (conn, ) = connections.all()313                assert conn.vendor == 'sqlite'314                db_name = conn.creation._get_test_db_name()315                assert db_name.startswith('test_custom_db_name_py37-django22_gw')316        """317        )318        result = django_testdir.runpytest_subprocess("--tb=short", "-vv", "-n1")319        assert result.ret == 0320        result.stdout.fnmatch_lines(["*PASSED*test_inner*"])321class TestSqliteInMemoryWithXdist:322    db_settings = {323        "default": {324            "ENGINE": "django.db.backends.sqlite3",325            "NAME": ":memory:",326            "TEST": {"NAME": ":memory:"},327        }328    }329    def test_sqlite_in_memory_used(self, django_testdir):330        pytest.importorskip("xdist")331        django_testdir.create_test_module(332            """333            import pytest334            from django.db import connections335            @pytest.mark.django_db336            def test_a():337                (conn, ) = connections.all()338                assert conn.vendor == 'sqlite'339                db_name = conn.creation._get_test_db_name()340                assert 'file:memorydb' in db_name or db_name == ':memory:'341        """342        )343        result = django_testdir.runpytest_subprocess("--tb=short", "-vv", "-n1")...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.