This is my reference notes<\/p>\n\n\n\n
python -m django –version<\/p>\n\n\n\n
django-admin startproject mysite<\/p>\n\n\n\n
python manage.py runserver<\/p>\n\n\n\n
Project
Apps
-Views – Controller – Model Validation on the server side
-Templates – Views (Models Validation on the Client Side) – Javascript disabled – Submit
-Settings.py add the following connection string as default.
‘default’: {
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘northwind’,
‘USER’: ‘developer’,
‘PASSWORD’: ‘Kingdom’,
‘HOST’: ‘127.0.0.1’,
‘PORT’: ‘3306’,
},
-Run this command to install the mysql client globally using pip.
pip install mysqlclient
Admin App
-Register all models in the Admin app.
-Master data entry should be done via App.
-All master data tables must start with ref_<\/p>\n\n\n\n
Models\n -Foreign key relationships must be maintained\n -Migrations must be used so that db deployment is done in correct steps as per the dependency.\n -Models additional validation must be done via validators https:\/\/docs.djangoproject.com\/en\/3.1\/ref\/validators\/<\/code><\/pre>\n\n\n\nDeployment
\n Production deployment must have a new secret key in the project’s settings.py
\n Project’s url.py should have the url entries for all applications otherwise we will get 404.<\/p>\n\n\n\n
After the project is created run the following command and see the default homepage at this location.
\n python manage.py runserver<\/p>\n\n\n\n
http:\/\/127.0.0.1:8000\/ <\/h2>\n\n\n\n
Step2 : Admin site setup and users management<\/p>\n\n\n\n
Before creating any apps migrate admin models to database using the following command.
\n python manage.py migrate
\nCreate a superuser using the following command.
\n python manage.py createsuperuser
\nRun the following query against the auth_user table to see if the superadmin is created successfully
\n SELECT * FROM djangotutorial.auth_user;
\nNOTE: After deployment to production. Ask the client to change password for the superadmin via admin app. <\/strong><\/em>**
\nLogin to admin portal and enter first name and last name of the super admin if you want.
\nCreate all the roles needed for your applications in the admin portal.
\nGrant required permission to all roles<\/p>\n\n\n\nGive additional permissions to users in addition to roles permissions<\/h2>\n\n\n\n
App Creation and Models Creation and Data Entry for Ref tables.<\/p>\n\n\n\n
Create an app under this project using the following command.
\n python manage.py startapp cruddemo
\nAdd urls.py to the app folder and initialize the app name as shown below
\n from . import views
\n from django.urls import path
\n app_name = ‘cruddemo’
\nCreate a sample table ref_record_status in Mysql and run the following command to generate python model class.
\n python manage.py inspectdb > output.txt
\n Copy only the models that your application needs from the output.txt file to models.py in your app.
\nRegister the model in the admin portal.
\n in admin.py of the app add the following lines. Copy the model name from models.py file.
\n from .models import RefRecordStatus
\n admin.site.register(RefRecordStatus)
\nIn project settings.py add the following entry in INSTALLED_APPS
\n ‘cruddemo.apps.CruddemoConfig’,
\nRun the following command and login to the admin portal.
\nAdd data to the reference tables via GUI.
\nTODO: Generate python code for migrating initial data also. **<\/p>\n\n\n\n
Step 4: Deploying the database objects from admin and app to new database.<\/p>\n\n\n\n
- Create a new database and update the name of the database in default connection string.<\/li>
- Run this command to migrate all the admin objects.
\npython manage.py migrate<\/li> - To migrate the objects of the applications run the following command.
\npython manage.py makemigrations cruddemo
\npython manage.py sqlmigrate cruddemo 0001
\npython manage.py migrate<\/li><\/ol>\n\n\n\nThis did not work. **We need to solve it in the future.<\/p>\n","protected":false},"excerpt":{"rendered":"
This is my reference notes python -m django –version django-admin startproject mysite python manage.py runserver Project Apps -Views – Controller – Model Validation on the server side -Templates – Views (Models Validation on the Client Side) – Javascript disabled – Submit -Settings.py add the following connection string as default. ‘default’: { ‘ENGINE’: ‘django.db.backends.mysql’, ‘NAME’: ‘northwind’, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":""},"categories":[15],"tags":[],"_links":{"self":[{"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/posts\/1980"}],"collection":[{"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/comments?post=1980"}],"version-history":[{"count":1,"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/posts\/1980\/revisions"}],"predecessor-version":[{"id":1981,"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/posts\/1980\/revisions\/1981"}],"wp:attachment":[{"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/media?parent=1980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/categories?post=1980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hthirukkumaran.com\/index.php\/wp-json\/wp\/v2\/tags?post=1980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}