Use Django ORM as standalone [duplicate]

by

Ah ok I figured it out and will post the solutions for anyone attempting to do the same thing.

This solution assumes that you want to create new models.

First create a new folder to store your files. We’ll call it “standAlone”. Within “standAlone”, create the following files:

__init__.py
myScript.py
settings.py

Obviously “myScript.py” can be named whatever.

Next, create a directory for your models.

We’ll name our model directory “myApp”, but realize that this is a normal Django application within a project, as such, name it appropriately to the collection of models you are writing.

Within this directory create 2 files: 

__init__.py
models.py

Your going to need a copy of manage.py from an either an existing Django project or you can just grab a copy from your Django install path:

django\conf\project_template\manage.py

Copy the manage.py to your /standAlone directory. Ok so you should now have the following structure:

\standAlone
    __init__.py
    myScript.py
    manage.py
    settings.py
\myApp
    __init__.py
    models.py

Add the following to your myScript.py file:

# settings.py
from django.conf import settings

settings.configure(
    DATABASE_ENGINE    = "postgresql_psycopg2",
    DATABASE_NAME      = "myDatabase",
    DATABASE_USER      = "myUsername",
    DATABASE_PASSWORD  = "myPassword",
    DATABASE_HOST      = "localhost",
    DATABASE_PORT      = "5432",
    INSTALLED_APPS     = ("myApp")
)

from django.db import models
from myApp.models import *

and add this to your settings.py file:

    DATABASE_ENGINE    = "postgresql_psycopg2"
    DATABASE_NAME      = "myDatabase"
    DATABASE_USER      = "myUsername"
    DATABASE_PASSWORD  = "myPassword"
    DATABASE_HOST      = "localhost"
    DATABASE_PORT      = "5432",
    INSTALLED_APPS     = ("myApp")

and finally your myApp/models.py:

# myApp/models.py
from django.db import models

class MyModel(models.Model):
     field = models.CharField(max_length=255)

and that’s it. Now to have Django manage your database, in command prompt navigate to our /standalone directory and run: 

manage.py sql MyApp

More Related Contents:

  1. How do you join two tables on a foreign key field using django ORM?
  2. Filter by property
  3. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  4. Django JSONField inside ArrayField
  5. django.db.utils.OperationalError Could not connect to server
  6. Using only the DB part of Django
  7. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  8. Django connection to postgres by docker-compose
  9. How to set up a PostgreSQL database in Django
  10. Composite primary key in django
  11. What is choice_set in this Django app tutorial?
  12. How do i cast char to integer while querying in django ORM?
  13. Case insensitive unique model fields in Django?
  14. Django JSONField filtering
  15. How to make an Inner Join in django?
  16. Docker- django throws error while connecting to postgres: psycopg2.OperationalError: could not connect to server: Connection refused
  17. How to find pg_config path
  18. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  19. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  20. What is the default order of a list returned from a Django filter call?
  21. Deploying Django to Heroku (Psycopg2 Error)
  22. How to store a dictionary on a Django Model?
  23. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  24. How to perform filtering with a Django JSONField?
  25. What is the difference between static files and media files in Django?
  26. Django 1.9 ImportError for import_module
  27. dynamically loading django apps at runtime
  28. How to redirect from a view to another view In Django
  29. Static media images are not displaying in Django
  30. How does COPY work and why is it so much faster than INSERT?

Leave a Comment