id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27444	Django StaticLiveServerTestCase: view cannot query test-database properly	amstart	nobody	"I have the problem that I cannot test my page via Selenium when using LiveServerTestCase (there seems to be a problem with querying the database, I am using PostgreSQL). Please excuse that I did not try other TestCases, but I wouldnt even know how.

The relevant third party apps I am loading: dal and dal_select2. I used https://github.com/pydanny/cookiecutter-django to kickstart django.

The input form for my model
{{{
    from dal import autocomplete
    from django import forms
    from django.core.urlresolvers import reverse_lazy
    from .models import MyModel
    
    class MyModelCreateForm(forms.ModelForm):
        class Meta:
            model = MyModel
            fields = ['my_other_model']
            widgets = {'my_other_model': autocomplete.ModelSelect2(url = reverse_lazy('autocomplete'))}
}}}

The create view:
{{{
    class CreateMyModelView(CreateView):
        template_name = 'create_my_model.html'
        success_url = 'admin/'
        model = MyModel

    def get_form_class(self):
        return MyModelCreateForm
}}}

The view template:
{{{
{% load static %}
<link href=""{% static 'autocomplete_light/select2.css' %}"" rel=""stylesheet"">
<link rel=""stylesheet"" type=""text/css"" href=""{% static 'css/bootstrap.min.css' %}"" />

<h1>New MyModel Object</h1>
<form class=""new_MyModel""
      id=""new_MyModel_form""
      method=""post""
      action=""{{ request.get_full_path }}"">
  {% csrf_token %}
  {{ form }}
  <button class=""btn btn-primary"" type=""submit""> submit MyModel Object</button>
</form>
<script src=""https://ajax.googleapis.com/ajax/libs/jquery/3.0.0/jquery.min.js"" integrity=""sha384-THPy051/pYDQGanwU6poAc/hOdQxjnOEXzbT+OuUAFqNqFjL+4IGLBgCJC3ZOShY"" crossorigin=""anonymous""></script>
<script src=""{% static 'autocomplete_light/select2.js' %}""></script>
{{ form.media }}
}}}

This is the view the select2 widget uses:
{{{
    class AutocompleteView(autocomplete.Select2QuerySetView):
        def get_queryset(self):
            queryset = MyOtherModel.objects.all()
            if self.q:
                queryset = queryset.filter(foo__contains=self.q)
            print('This is what the autocomplete view sees:' + str(queryset)) #this is for debugging
            return queryset
}}}

The test:

{{{
from selenium import webdriver
from selenium.webdriver.firefox.firefox_binary import FirefoxBinary

from django.contrib.staticfiles.testing import StaticLiveServerTestCase

from .models import MyOtherModel

class LiveServerTest(StaticLiveServerTestCase):
    def test_create_my_model(self):
        MyOtherModel.objects.create(foo = ""find me pleease!"")
        self.browser = webdriver.Firefox(firefox_binary=FirefoxBinary(
            firefox_path='C:\\Program Files\\Mozilla FirefoxESR\\firefox.exe'))
        self.browser.get(self.live_server_url + '/create')
        self.browser.implicitly_wait(0.5)
        print(""This is what the test sees:"" + str(MyOtherModel.objects.all()))
        self.browser.find_element_by_css_selector('#id_my_other_model + span').click()
}}}


Running the Test:

> Creating test database for alias 'default'... This is what the test
> sees:<QuerySet [<MyOtherModel: find me pleease!>]> .This is what the
> autocomplete view sees:<QuerySet []>


The select2 list in the browser says ""no results found"", which is of course expected. For some reason this particular view does not seem to have access to the test database.

Note: This is not that bad since I can test my view with this doc test:
{{{
    from selenium import webdriver
    from selenium.webdriver.firefox.firefox_binary import FirefoxBinary
    import os
    import django
    os.environ['DJANGO_SETTINGS_MODULE'] = ""config.settings.local""
    django.setup()
    
    from demoslogic.arguments.models import MyOtherModel
    
    MyOtherModel.objects.create(foo = ""find me pleease!"")
    #...test the page
}}}"	Bug	new	Testing framework	1.10	Normal		selenium, test database, select2		Unreviewed	0	0	0	0	0	0