{"id":938,"date":"2020-11-13T05:32:46","date_gmt":"2020-11-13T05:32:46","guid":{"rendered":"https:\/\/codeinsightacademy.com\/blog\/?p=938"},"modified":"2021-04-25T08:12:40","modified_gmt":"2021-04-25T08:12:40","slug":"django-cheat-sheet","status":"publish","type":"post","link":"https:\/\/codeinsightacademy.com\/blog\/python\/django-cheat-sheet\/","title":{"rendered":"Django Cheat Sheet"},"content":{"rendered":"\n

Install Django<\/p>\n\n\n\n

python -m pip install Django==3.1.3<\/code><\/pre>\n\n\n\n
Verify Django Installation<\/p>\n\n\n\n
python -m django --version<\/code><\/pre>\n\n\n\n
List all installed python modules \/ packages<\/p>\n\n\n\n
python -m pip list<\/code><\/pre>\n\n\n\n
Create new django project<\/p>\n\n\n\n
django-admin startproject projectname<\/code><\/pre>\n\n\n\n
Run Django Project<\/p>\n\n\n\n
python manage.py runserver<\/code><\/pre>\n\n\n\n
Create New App<\/p>\n\n\n\n
python manage.py startapp newappname<\/code><\/pre>\n\n\n\n
manage.py help<\/p>\n\n\n\n
python manage.py help\n<\/code><\/pre>\n\n\n\n
MySql Database connection<\/p>\n\n\n\n
DATABASES = {\n    'default': {\n        'ENGINE': 'django.db.backends.mysql', \n        'NAME': 'DB_NAME',\n        'USER': 'DB_USER',\n        'PASSWORD': 'DB_PASSWORD',\n        'HOST': 'localhost',   # Or an IP Address that your DB is hosted on\n        'PORT': '3306',\n    }\n}<\/code><\/pre>\n\n\n\n
open db shell with default connection<\/p>\n\n\n\n
python manage.py dbshell\n<\/code><\/pre>\n\n\n\n
MySql Database Connection Troubleshoot in Windows OS
Download whl package which is compatible with your python version
https:\/\/www.lfd.uci.edu\/~gohlke\/pythonlibs\/<\/a>
Find: mysqlclient

To check whether python is 32 or 64 bit just run following command <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
python -m pip install mysqlclient-1.4.6-cp37-cp37m-win32.whl<\/code><\/pre>\n\n\n\n
open django project shell in terminal<\/p>\n\n\n\n
python manage.py shell\n<\/code><\/pre>\n\n\n\n
open db shell with specific connection<\/p>\n\n\n\n
python manage.py dbshell --database \"connection_name\"\n<\/code><\/pre>\n\n\n\n
Create  model of legacy(existing) database table using inspectdb<\/p>\n\n\n\n
python manage.py inspectdb --database='connection_name' table_name<\/code><\/pre>\n\n\n\n
Import Models in shell<\/p>\n\n\n\n
from app.models import ModelName<\/code><\/pre>\n\n\n\n
Select data from table using Django ORM<\/p>\n\n\n\n
queryset = ModelName.objects.all()\nprint(queryset.query)\nprint(list(queryset))<\/code><\/pre>\n\n\n\n
Filter data using ORM<\/p>\n\n\n\n
queryset = ModelName.objects.filter(column=value)\nqueryset = ModelName.objects.get(column=value) #this will give you single record\nqueryset = ModelName.objects.filter(column__iexact=value, column2__exact=value2)\nqueryset = ModelName.objects.filter(col__subcol=value) #for relationship<\/code><\/pre>\n\n\n\n
Limit records in ORM<\/p>\n\n\n\n
queryset = ModelName.objects.all()[:10]<\/code><\/pre>\n\n\n\n
Order by in ORM<\/p>\n\n\n\n
queryset = ModelName.objects.all().order_by('columnname')\nqueryset = ModelName.objects.all().order_by('-columnname')\nqueryset = ModelName.objects.all().order_by('columnname').reverse()<\/code><\/pre>\n\n\n\n
Relationship in models.py (this should be in Model which has foreign key)<\/p>\n\n\n\n
foreign_key_col = models.ForeignKey(PrimaryModelName, related_name = 'related_name', on_delete = models.CASCADE, db_column = 'foreign_key_column_name')<\/code><\/pre>\n\n\n\n
install packages from requirements.txt for your project<\/p>\n\n\n\n
python -m pip install -r requirements.txt\"\n<\/code><\/pre>\n\n\n\n
Django restframework Cheat Sheet (codeinsightacademy.com)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Install Django Verify Django Installation List all installed python modules \/ packages Create new django project Run Django Project Create New App manage.py help MySql Database connection open db shell with default connection MySql Database Connection Troubleshoot in Windows OSDownload whl package which is compatible with your python versionhttps:\/\/www.lfd.uci.edu\/~gohlke\/pythonlibs\/Find: mysqlclient To check whether python is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/938"}],"collection":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/comments?post=938"}],"version-history":[{"count":21,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/938\/revisions"}],"predecessor-version":[{"id":1212,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/938\/revisions\/1212"}],"wp:attachment":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/media?parent=938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/categories?post=938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/tags?post=938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}