Skip to main content

How to Connect Database in Django | Django Database operation



To manage database operation in Django  First We create a Database using SQLITE, It will be by default exists under the Django project.



SQLite is a lite weight database software which is the RDBMS (Relational database management system)  light-weight package which is mostly used in mobile applications but now it can be used in the web application, enterprise application, etc.



Django provides ORM (Object Relational Mapping) tools that are used to map the database table of SQLite in an application using objects.






ORM means Object-relational mapping that provides a set of classes to implement a set of tables.



Step's for database Operation using DJANGO


1)  Create an app using python manage.py startapp app-name


2)  Create Classes under models.py file according to a database table  schema for example if we want to create a registration form using four different fields username, password, email, and mobileno then we create Register class and define all fields.


class Register(models.Model):

 emailid= models.CharField(max_length=200)

 password= models.CharField(max_length=200)

 mobile= models.CharField(max_length=200)

 fullname= models.CharField(max_length=200)


3) run command to migrate model class to the table schema

   3.1)  python manage.py migrate  #to enable all predefine app under settings.py INSTALLED_APPS Section.



  3.2)  python manage.py makemigrations appname  #it is used to enable the current app for migration, it will convert the model class to the table schema


  
 4)  python manage.py migrate  #it will create table using SQL Script



5)  If we want to show a table then we should go into the super admin dashboard, which will be by default exist under the Django framework. we should create user id and password only


  6) to login into  the super admin dashboard run the following command


     python manage.py createsuperuser  #it provides a console screen to write username and password to admin


  7) open admin dashboard using 127.0.0.1:8000/admin  server should be started


  8)  login with a valid username and password


  9) add a registration model class  of application to the admin dashboard


 10)  go into admin.py that exists under app and write the following code



     from django.contrib import admin

      from .models import Register

      admin.site.register(Register)



11) refresh the admin dashboard your table will be visible


12) data will be shown on Object pattern in admin dashboard so we can Override __str__ method in the class and convert an object to String.



How to work with another database such as MySQL:-

1)  First, install mysqlclient on your machine.

   open command prompt and type this command

    pip install mysqlclient==2.2.4

or
pip install mysqlclient


download XAMPP Server and install it, start apache and MySQL using XAMPP Control Panel.

IF Mysql is already installed then no need XAMPP Server.

for xampp open browser and type localhost/phpmyadmin
then create database .


2) go into base project settings.py and change the database list.


    


If not work then try this

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'testdb',
'USER': 'root',
'PASSWORD':"",
'HOST':"127.0.0.1",
'PORT':"3306",
'OPTIONS': {
    'ssl_mode': 'DISABLED',
'init_command': "SET sql_mode='STRICT_TRANS_TABLES'"
}
}
remaining command are the same 

python manage.py makemigrations
python manage.py migrate
 python manage.py sqlmigrate appname 0001 
python manage.py migrate






Comments

Popular posts from this blog

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...