Fake data generated inside tests is not accessible inside the consumer

[Amohammadi2]

Hello everyone. I want to write unittests for my consumers but I'm having problem with "Generating Fake Data". I'm using factory_boy and faker packages to provide fake data to my unit tests (you can find pip freeze output at the end of the issue)

Senario

Please consider the consumer below:

# ...
please consider this consumer:
class PersonalChatConsumer(
        ChatRoomManagementMixin,
        MessageManagementMixin,
        JsonWebsocketConsumer
    ):
    message_serializer_class = PersonalMessageSerializer
    chat_room_class = PersonalChatRoom

    def connect(self):
        print("consumer (user): ", User.objects.all()) # HERE
        print("consumer (personal chat room): ", PersonalChatRoom.objects.all()) # HERE
        return super().connect() # some sort of magic here but it is not important
   # ...

And here is the unit test code I've written:

from chat.models import PersonalChatRoom
from users.models import User
from django.test import TestCase
from channels.testing import WebsocketCommunicator
from asgiref.sync import sync_to_async
from users.tests.test_setup import TestUtilsMixin
from astra_backend.asgi import application
from chat.tests.model_factory import PersonalChatRoomFactory


class TestPersonalChatRoomConsumer(TestCase, TestUtilsMixin):
    def setUp(self) -> None:
        super().setUp()
        self.chat_room = PersonalChatRoomFactory()
        self.u1 = self.chat_room.user_1
        self.u2 = self.chat_room.user_2
        print("setup: (user): ", User.objects.all()) # HERE
        print("setup: (personal chat room): ", PersonalChatRoom.objects.all()) # HERE

    async def test_personal_chat_room_connection(self):
        await sync_to_async(print)("test (user): ", User.objects.all()) # HERE
        await sync_to_async(print)("test (personal chat room): ", PersonalChatRoom.objects.all()) # HERE

        com = WebsocketCommunicator(application, f'chat/personal/{self.chat_room.pk}/')
        connected, _ = await com.connect()
        self.assertTrue(connected)

As you can see, I'm printing out the contents of database in 3 different sections of code:

• inside the setUp method in the TestPersonalChatRoomConsumer class
• inside the test_personal_chat_room_connection method in the TestPersonalChatRoomConsumer class
• inside the connect method of the consumer

What I expected.

I expected all the print statements to print out identical results but ...

What actually happened

setup: (user):  <QuerySet [<User: [email protected]>, <User: [email protected]>]>
setup: (personal chat room):  <QuerySet [<PersonalChatRoom: PV [email protected] and [email protected]>]>
test (user):  <QuerySet [<User: [email protected]>, <User: [email protected]>]>
test (personal chat room):  <QuerySet [<PersonalChatRoom: PV [email protected] and [email protected]>]>
...
consumer (user):  <QuerySet []> # There are no users in the database
consumer (personal chat room):  <QuerySet []> # There are no chat rooms in the database

As you can see, the queryset inside the consumer is empty even though It's supposed to contain the same data as the unit tests.

How to reproduce

It is really simple:
2. create a simple model
3. create a consumer
4. create a test case
5. create a model instance inside the test case
6. try to access it inside the consumer and you will be surprised with an empty queryset

Extra info

• OS: windows 10 64 bits
• I'm running the unit tests using python manage.py test command
• python interpreter version: 3.8.10

pip freeze output

aioredis==1.3.1
asgiref==3.3.4
async-timeout==3.0.1
attrs==21.2.0
autobahn==21.3.1
Automat==20.2.0
autopep8==1.5.7
certifi==2021.5.30
cffi==1.14.6
channels==3.0.4
channels-redis==3.3.0
charset-normalizer==2.0.4
constantly==15.1.0
cryptography==3.4.7
daphne==3.0.2
Django==3.2
django-cors-headers==3.7.0
django-crum==0.7.9
django-extensions==3.1.3
django-filter==2.4.0
django-random-queryset==0.1.3
django-schema-graph==1.2.0
django-spaghetti-and-meatballs==0.4.2
djangorestframework==3.12.4
djangorestframework-recursive==0.1.2
djangorestframework-simplejwt==4.6.0
drf-spectacular==0.15.1
factory-boy==3.2.0
Faker==8.10.2
gunicorn==20.1.0
hiredis==2.0.0
hyperlink==21.0.0
idna==3.2
incremental==21.3.0
inflection==0.5.1
jsondiff==1.3.0
jsonschema==3.2.0
Markdown==3.3.4
msgpack==1.0.2
Pillow==8.2.0
psycopg2-binary==2.8.6
pyasn1==0.4.8
pyasn1-modules==0.2.8
pycodestyle==2.7.0
pycparser==2.20
PyJWT==2.1.0
pyOpenSSL==20.0.1
pyrsistent==0.18.0
python-dateutil==2.8.2
python-dotenv==0.15.0
pytz==2021.1
PyYAML==5.4.1
requests==2.26.0
service-identity==21.1.0
six==1.16.0
sqlparse==0.4.1
text-unidecode==1.3
toml==0.10.2
Twisted==21.7.0
txaio==21.2.1
typing-extensions==3.10.0.0
uritemplate==3.0.1
urllib3==1.26.6
zope.interface==5.4.0