How to execute external script in the Django envir

Question

I am trying to execute an external snippet for debugging and terminal-like purposes in the environment the Django console uses so it can connect to the db, etc.

Basically, I am just using it for the same reason one would fiddle with the console but I am using longer snippets to output some formatted information so it is handy to have that code in an actual file manipulated with an IDE.

An answer said you could do that by executing python manage.py shell < snippet.py but I did not see a successfull result. And although no errors are reported, I am not getting the excepted output, but only a series of >>> prompts.

So how can I do this?

By the way, I am using PyCharm, in case this IDE has a shorthand way of doing this or any special tool.

Answer 1

If its just a one off script,

import django
django.setup()

from myapp.models.import MyModel 

You need to have your environmental variable set up, so its easiest to run it from the IDE (make it part of the same project, right click on teh file and there should be a run option).

If you are looking for something to run on a production environment I would create a management command as suggested by DanEEStar.

Answer 2

Many times you need scripts to play with db or more. But you need to the the django way i.e. the ORM and play with every thing that your project has.

You can checkout https://github.com/django-extensions/django-extensions

You create a scripts folder in your project home and write down a method run . the app provide you a way to run those scripts easily. How to do it.

Step 1 - Install the package. Step 2 - Create a scripts folder with init.py in project root, and add 'django_extensions' in your applications Step 3- Create a file send_email_to_users.py in scripts folder. Simple Example.

from project.models import MyModel
from django.contrib.auth.models import User
from project.utils import send_email

def run():
    results = MyModel.objects.all()
    for res in results:
         send_mail(res.email)

Now from command line you can run

python manage.py runscript send_mail_to_users

Answer 3

I would say creating a new Custom management command is the best way to achieve this goal.

But you can run your script in a django environment. I use this sometimes to run a oneoff script or some simple tests.

You have to set the environment variable DJANGO_SETTINGS_MODULE to your settings module and then you have to call django.setup()

I copied these lines from the manage.py script, you have to set the correct settings module!

os.environ.setdefault("DJANGO_SETTINGS_MODULE", "project.settings.local")
django.setup()

Here is a simple template script which I use sometimes:

# -*- coding: utf-8 -*-
import os
import django

#  you have to set the correct path to you settings module
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "project.settings.local")
django.setup()


from project.apps.bla.models import MyModel


def run():
    # do the work
    m = MyModel.objects.get(pk=1)


if __name__ == '__main__':
    run()

It is important to note that all project imports must be placed after calling django.setup().