Step 1:

Install python 3.6.5

Install pycham

Open pycham and create a project with name:djangotest

Step 2:

find out the djangotest project size before installing django (42.6 MB)

open terminal from pycham

run the folllowing command to install django tools

djangotest>pip install django

Step 3:

to create django project run the following command

 
  djangotest>django-admin  startproject uktest .            // create project
  djangotest>django-admin  startapp hong                    // to create different app under project
  djangotest>python manage.py runserver       // run project

Step 4:

browse:http://127.0.0.1:8000/

After creating project some file introduction

• djangotest
  • uktest is the django main project directory
    • __init__.py
    • asgi.py
    • settings.py this file setup root urls,database ,app
    • urls.py this file setup admin url,include all apps url
    • wsgi.py
  • hong -- is the app(application directory whis is setup in uktest.settings.py file)
    • migrations
    • __init__.py
    • admin.py
    • apps.py -- is the app config file
    • models.py -- is contain all model class
    • tests.py
    • views.py --is contail all method or class
    • urls.py -- is setup all method url
  • venv -- contain all downloaded library
  • db.sqlite3 -- default sqlite database
  • manage.py -- by this execute all command
• manage.py is a command-line utility which allows us to interact with Django project in various ways.
• djangotest sub-directory is actually a Python package for our project. We can import this package(a group of modules) and its contents just like we import any general Python package/module and its contents.

Step 5:

To create auth table using mysql

pip install mysqlclient

settings.py =>

DATABASES = {
	'default': {
		'ENGINE': 'django.db.backends.mysql',
		'NAME': 'db_uktest',
		'USER': 'root',
		'PASSWORD':"",
		'HOST': "",
		'PORT': "",
		'OPTIONS': {
		    'init_command': "SET sql_mode='STRICT_TRANS_TABLES'"
		}
	}
}

Open the mysql databse and found to table create

Run the following command to create acl table on the database

  djangotest>python manage.py makemigrations
  djangotest>python manage.py migrate

Open the mysql databse and found 10 acl table created (auth_group,auth_group_permissions,auth_permission,auth_user,auth_user_groups, auth_user_user_permissions,django_admin_log,django_content_type,django_migrations, django_session )

  djangotest>python manage.py createsuperuser

http://127.0.0.1:8000/admin/ and enter: user:uzzal,email:uzzalmodak@yahoo.com,pass:password

Or create auth table using default sqllite database

settings.py =>

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

browse the link and upload db.sqlite file from your porject to see default no. of table and their column https://sqliteonline.com/

Run the following command

  djangotest>python manage.py makemigrations
  djangotest>python manage.py migrate

again browse the link and upload db.sqlite file and found some table has been createdhttps://sqliteonline.com/

  djangotest>python manage.py createsuperuser

http://127.0.0.1:8000/admin/ and enter: user:uzzal,email:uzzalmodak@yahoo.com,pass:password

django documentation linkhttps://docs.djangoproject.com/en/4.0/

Step 6:

After creating the application hong you must setup under main project directory settings.py as follows.

INSTALLED_APPS = [
‘django.contrib.admin’,
‘django.contrib.auth’,
‘django.contrib.contenttypes’,
‘django.contrib.sessions’,
‘django.contrib.messages’,
‘django.contrib.staticfiles’,
‘hong’,
]

Django follow MVT architecture(model->view->template insted model->view->conteoller)

Create a file models.py in hong app which treat like model and add following code

from django.db import models

class Student(models.Model):
	roll_no = models.TextField()
	name = models.TextField(max_length = 40)
	stud_class = models.TextField()
	department = models.TextField()

Now, execute these commands.

djangotest>python manage.py makemigrations
djangotest>python manage.py migrate

Now open the main database that you have created for this Django project. Then, check the table hong_student(namming convention appName_modelName)

Step 7:

Django Views Component

In our hong app directory create a new python file named views.py. and add the following code

from django.shortcuts import render
from django.http import HttpResponse

def student_show(request):
    x = []
    for i in range(10):
        x.append(i)
    return HttpResponse("
Hi UK Modak 
The Digits are {0}".format(x))

Here we have imported HttpResponse from the library django.http because we need to respond in the HTTP format. Also, we are passing the parameter request to the function.

Every view function will have their first parameter as request.

After that, we wrote a simple python program of storing digits 0-9 in a list and we passed on that list as a string to the HttpResponse. It will then covert the same as HTTP and that will be returned to our browser as HTML which then renders it that way.

This Views file is special as you can see, we are passing HTML as a string and that presents on the browser.

In our hong app directory create a new python file named urls.py. and add the following code

from django.urls import path
from . import views
urlpatterns = [
path('student/show', views.student_show, name = 'student_show'),
]

Here, we are creating a urls file for our application rather than the whole project. This urls file will contain all the URLs inside it related to our app. Thus, we get a cleaner main urls_config file.

Now, we will be connecting our project with the application.

Open the urls.py file of the project that is in the root folder.

Now add this hong.urls.py in the main project(uktest) urls.py file as follows

from django.contrib import admin
from django.urls import path,include

urlpatterns = [
    path('admin/', admin.site.urls),
	path('', include('hong.urls')),
]

To run this view simply type in the url bar, http://localhost:8000/student/show

Step 8:(Create another oracle connection and render output)

djangotest>pip install cx_Oracle
djangotest>pip install xlwt
djangotest>pip install json

create a text file db_connection.txt in the the location:D:\\db_connect_info\\uk\\ and the following code

ukuser/ukpass@UZZAL-PC/db11g

add the following code in hong.views.py file

from django.views import View
import cx_Oracle
import json
import datetime
import xlwt
import ast


def get_connection_info_uk():
    with open("D:\\db_connect_info\\uk\\db_connection.txt") as f:
        conn_info = f.readlines()
    conn_info = [x.strip() for x in conn_info]
    return conn_info

def query_db(query, args=(), one=False):
    try:
        list_conn_info = get_connection_info_uk()
        db_connection_info = str(list_conn_info[0])
        con = cx_Oracle.connect(db_connection_info)
        cur_oracle = con.cursor()
        cur_oracle.execute(query, args)
        r = [dict((cur_oracle.description[i][0], value) \
                  for i, value in enumerate(row)) for row in cur_oracle.fetchall()]
        cur_oracle.connection.close()
        return (r[0] if r else None) if one else r
    except:
        pass
		
def myconverter(o):
    if isinstance(o, datetime.datetime):
        return o.__str__()

def item_detail(request):
    if request.method == 'GET':
        print(request.GET)
        l_data = request.GET
        l_dic = l_data.dict()
        oracle_sql = '''SELECT *
                          FROM inv_sales_dtl
                         ORDER BY id asc'''
        my_query = query_db(oracle_sql)
        l_json_output = json.dumps(my_query, default=myconverter)
        return HttpResponse(l_json_output)

Add this following code in hong.urls.py file

path('student/item_detail', views.item_detail, name='item_detail'),

To run this view simply type in the url bar, http://localhost:8000/student/item_detail