How to run Django’s test database only in memory?

by

If you set your database engine to sqlite3 when you run your tests, Django will use a in-memory database.

I’m using code like this in my settings.py to set the engine to sqlite when running my tests:

if 'test' in sys.argv:
    DATABASE_ENGINE = 'sqlite3'

Or in Django 1.2:

if 'test' in sys.argv:
    DATABASES['default'] = {'ENGINE': 'sqlite3'}

And finally in Django 1.3 and 1.4:

if 'test' in sys.argv:
    DATABASES['default'] = {'ENGINE': 'django.db.backends.sqlite3'}

(The full path to the backend isn’t strictly necessary with Django 1.3, but makes the setting forward compatible.)

You can also add the following line, in case you are having problems with South migrations:

    SOUTH_TESTS_MIGRATE = False

More Related Contents:

  1. Mac OS X – EnvironmentError: mysql_config not found
  2. Setting Django up to use MySQL
  3. How to replace Django’s primary key with a different integer that is unique for that table
  4. MySQL “incorrect string value” error when save unicode string in Django
  5. Install mysql-python (Windows)
  6. TransactionManagementError “You can’t execute queries until the end of the ‘atomic’ block” while using signals, but only during Unit Testing
  7. How to use MySQLdb with Python and Django in OSX 10.6?
  8. Django : Table doesn’t exist
  9. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  10. Error loading MySQLdb Module ‘Did you install mysqlclient or MySQL-python?’
  11. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  12. MySQL Improperly Configured Reason: unsafe use of relative path
  13. Using Django database layer outside of Django?
  14. How to move a model between two Django apps (Django 1.7)
  15. Can one use the Django database layer outside of Django?
  16. How can I disable logging while running unit tests in Python Django?
  17. InterfaceError (0, ”)
  18. How do i cast char to integer while querying in django ORM?
  19. How to run django unit-tests on production database?
  20. How to make an Inner Join in django?
  21. Simple Subquery with OuterRef
  22. Using .aggregate() on a value introduced using .extra(select={…}) in a Django Query?
  23. Running a specific test case in Django when your app has a tests directory
  24. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  25. Install mysqlclient for Django Python on Mac OS X Sierra
  26. How can I specify a database for Django Tests to use instead of having it build it every time?
  27. Django + MySQL on Mac OS 10.6.2 Snow Leopard
  28. Django: How to create a model dynamically just for testing
  29. Single Django model, multiple tables?
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment