🔒 How to Test in Memory SQLite?

[sacred depot]

@brave lichen

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[median sierra]

pytest captures stdout by default

You could run with -s

You went to do an assert instead of printing

[brave lichen]

when you run this code you get - tests/test_true.py:16 (test_create_mig)
None != ('mario',)

Expected :('mario',)
Actual :None

I wrote it so you can easly copy paste

it is 2 part mre

[brave lichen]

@median sierra in Django you can test db, it is new clear instance for every test. I want the same for my test. And keep it in memory.

test returns:

mre.py:130 (test_create_mig)
None != ('mario',)

Expected :('mario',)
Actual   :None
<Click to see difference>

db = <mre.SQLiteBackend object at 0x73837ceff7a0>

    def test_create_mig(db):
        db.create_mario()
        with db._connect() as c:
            res = c.execute("""
                SELECT name
                FROM sqlite_master
                WHERE type='table' AND name='mario';
            """).fetchone()
>       assert res == ("mario",)
E       AssertionError: assert None == ('mario',)

mre.py:139: AssertionError

[sacred depot]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.

🔒 How to Test in Memory SQLite?