CODEWITHSUNDEEP
pythondjangodjango-models
Corey
Corey

Reputation: 14367

Django: How can I use my model classes to interact with my database from outside Django?

I'd like to write a script that interacts with my DB using a Django app's model. However, I would like to be able to run this script from the command line or via cron. What all do I need to import to allow this?

Upvotes: 14

Views: 9870

Answers (3)

muhuk
muhuk

Reputation: 16085

The preferred way should be to add a custom command and then run it as any other django-admin (not to be confused with django.contrib.admin) command:

./manage.py mycustomcommand --customarg

Setting DJANGO_SETTINGS_MODULE should only be used when a custom command is not feasible.

Upvotes: 13

2snacc
2snacc

Reputation: 6353

Depending on your specific needs, django-command-extensions might save you a bit of time. To run any script as-is without messing around with environment variables just type:

./manage.py runscript path/to/my/script.py

django-command-extensions also has commands for automating scripts as cron jobs, which is something you mentioned that you'd like to do.

If you are a more nuts and bolts type of person, you might check out this very detailed post outlining how to make "standalone" django scripts to be run from cron jobs and whatnot.

Upvotes: 5

Soviut
Soviut

Reputation: 91535

You need to set up the Django environment variables. These tell Python where your project is, and what the name of the settings module is (the project name in the settings module is optional):

import os

os.environ['PYTHONPATH'] = '/path/to/myproject'
os.environ['DJANGO_SETTINGS_MODULE'] = 'myproject.settings'

Now you should be able to access the models:

from myproject.models import MyModel

all_my_models = MyModel.objects.all()

Upvotes: 15

Related Questions