Execute custom SQL before tests run (uses the Nose testrunner)

__init__.py

import os

from django.db import connection


def setUp():
    """
    Create custom database tables before test suite runs
    """
    execute_from_file('stores_table.sql')
    execute_from_file('category_table.sql')


def execute_from_file(filename):
    """
    Execute an SQL file
    """
    filepath = os.path.realpath(os.path.join(
        os.path.dirname(__file__), 'sql/', filename))
    assert os.path.exists(filepath), "%s does not exist!" % filepath
    cursor = connection.cursor()
    cursor.execute(open(filepath, 'r').read())