{"id":39,"date":"2023-01-10T08:11:00","date_gmt":"2023-01-10T08:11:00","guid":{"rendered":"https:\/\/pythonpower.in\/index.php\/2023\/01\/10\/django-models-and-databases\/"},"modified":"2023-01-10T08:11:00","modified_gmt":"2023-01-10T08:11:00","slug":"django-models-and-databases","status":"publish","type":"post","link":"https:\/\/pythonpower.in\/index.php\/2023\/01\/10\/django-models-and-databases\/","title":{"rendered":"Django Models And Databases"},"content":{"rendered":"
<\/a><\/div>\n

<\/p>\n

 <\/p>\n

\n
\n
\n
\n
Working with Models and Databases:
\n<\/span>. <\/b>As the part of web application development, compulsory we required to interact with
\n<\/span><\/span> database to store our data and to retrieve our stored data.
\n<\/span>. <\/b>Django provides a big in-built support for database operations. Django provides one
\n<\/span>  inbuilt database sqlite3.
\n<\/span>. <\/b>For small to medium applications this database is more enough. Django can provide
\n<\/span>  support for other databases also like oracle, mysql , postgresql etc
\n<\/span>
<\/span>Database Configuration:
\n<\/span>. <\/b>Django by default provides sqlite3 database. If we want to use this database,we are
\n<\/span> not required to do any configurations.
\n<\/span><\/span>. <\/span><\/b>The default sqllite3 configurations in settings.py file are declared as follows. <\/span><\/span><\/span><\/span><\/span><\/div>\n

<\/span><\/span><\/span>settings.py <\/u><\/span><\/span><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
   <\/span><\/span><\/div>\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>DATABASES={
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>‘default’<\/span>: {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>‘ENGINE’<\/span>: <\/span>‘django .db. backends .sqlite3’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>‘NAME’<\/span>: os.path.join(BASE_DIR, <\/span>‘db.sqlite3’<\/span>),
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>}
\n<\/span><\/span><\/p>\n<\/p>\n

\n
\n
\n

.<\/b> if we don’t want sqlite3 database then we have to configure our own database <\/span><\/span><\/p>\n

  with <\/span>the following     parameters <\/span><\/span><\/p>\n<\/p>\n

\n
\n
\n

1) ENGINE: Name of Database engine
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

2) NAME: Database Name
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

3) USER: Database Login user name
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

4) PASSWORD: Database Login password
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

5) HOST: The Machine on which database server is running
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

6) PORT: The port number on which database server is running <\/span><\/p>\n<\/p>\n

\n
\n
\n

Note: <\/span>Most of the times HOST and PORT are optional.<\/span><\/span><\/p>\n


<\/span><\/p>\n

\n
\n
\n
\n

How to Check Django Database Connection:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

1) We can check whether django database configurations are properly <\/span><\/p>\n

  configured or not
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

   by using the following commands from the shell
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

2) D:djangoprojectsmodelProject>py manage.py shell
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

>>> from django.db import connection
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

>>> c = connection.cursor()
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

3) If we are not getting any error means our database configurations <\/span><\/span><\/p>\n

    are proper.<\/span> <\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n
\n

Configuration of MySQL Database:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

1) First we have to create our own logical database in the mysql.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

mysql> create database employeedb;
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

2) We have to install mysqlclient by using pip as follows
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

pip install –only-binary :all: mysqlclient <\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

settings.py
\n<\/b><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>DATABASES={
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>‘default’<\/span>: {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>‘ENGINE’<\/span>: <\/span>‘django.db.backends.mysql’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>‘NAME’<\/span>: <\/span>’employeedb’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>‘USER’<\/span>:<\/span>‘root’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>‘PASSWORD’<\/span>:<\/span>‘root’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>}
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

Checking Configurations:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

D:djangoprojectsmodelProject>py manage.py shell
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

>>> from django.db import connection
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

>>> c = connection.cursor()
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Configuration of Oracle Database:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>DATABASES={
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>‘default’<\/span>: {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>‘ENGINE’<\/span>: <\/span>‘django.db.backends.oracle’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>‘NAME’<\/span>: <\/span>‘XE’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>‘USER’<\/span>:<\/span>‘scott’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>‘PASSWORD’<\/span>:<\/span>‘tiger’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

Note: <\/span>We can find oracle database name by using the <\/span><\/span><\/p>\n

                 following command.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

                      SQL> select * from global_name;<\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

Model Class:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

.<\/span> <\/span><\/b>A Model is a Python class which contains database information.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>A Model is a single, definitive source of information about our data. <\/span><\/span><\/p>\n

   It contains fields. <\/span><\/span>and behavior of the data what we are storing. <\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n
\n
\n

.  <\/b>Each model maps to one database table.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

. <\/b>Every model is a Python class which is the child class of (django.db.models.Model)<\/span><\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

. <\/b>Each attribute of the model represents a database field.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

. <\/b>We have to write all model classes inside \u2018models.py\u2019 file.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

1.<\/span> Create a project and application and link them.<\/span><\/p>\n

After creating a project and application, in the models.py file, <\/span><\/p>\n

write the following code: <\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n


<\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n\t\t\t\t<\/div>\n<\/p><\/div>\n
\n
\n

        django-admin startproject modelProject
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

      cd modelProject\/
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

     python manage.py startapp testApp
\n<\/span><\/p>\n

models.py<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django. db <\/span>impor t<\/span>models
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>#Createyourmodelshere.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>class <\/span>Employee(models.Model):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>eno=models.IntegerField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>ename=models.CharField(max_length=30)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>esal=models.FloatField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>eaddr=models.CharField(max_length=30)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

Note: <\/span>This model class will be converted into Database table. <\/span><\/span><\/p>\n

Django is responsible for <\/span><\/span>this.<\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

table_name: appName_Employee
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

fields: eno, ename, esal and eaddr. And one extra field: id
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

behaviors: eno is of type Integer, ename is of type Char and <\/span><\/p>\n

max_length is 30 characters.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n<\/col>\n<\/col>\n<\/colgroup>\n\n\n
\n
\n
\n

Hence,
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n

\n
\n
\n

Model Class = Database Table Name + Field Names + Field Behaviors
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\n\t\t\t<\/span><\/p>\n

\n
\n
\n

Converting Model Class into <\/span>Database specific SQL Code:<\/span><\/span><\/p>\n


<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Once we write Model class, we have to generate the corresponding SQL Code.<\/span><\/p>\n

 For this, we <\/span>have to use \u201cmakemigrations\u201d command.<\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

                      Python manage.py make migrations<\/span><\/p>\n<\/div>\n<\/div><\/div>\n

\n
\n

                     It results the following:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

                   Migrations for ‘testApp’:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

                   testApp\/migrations\/0001_initial.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

                 – Create model Employee
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

How to see corresponding SQL Code of Migrations:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

To see the generated SQL Code, we have to use the following command <\/span>\u201csqlmigrate\u201d<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

python manage.py sqlmigrate testApp 0001
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>BEGIN<\/span>;
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>—
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>–Create model Employee
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>—
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>CREATETABLE<\/span>“testApp_employee”<\/span>(<\/span>“id”<\/span>integer<\/span>NOTNULL<\/span><\/span>PRIMARYKEY<\/span>AUTOIN<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

CREMENT, <\/span>“eno” <\/span>integer <\/span>NOT NULL<\/span>, <\/span>“ename” <\/span>varchar<\/span>(30) <\/span>NOT NULL<\/span>, <\/span>“esal” <\/span>real <\/span>N
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

OT NULL<\/span>, <\/span>“eaddr” <\/span>varchar<\/span>(30) <\/span>NOT NULL<\/span>);
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>COMMIT<\/span>;
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

Note: <\/span>Here 0001 is the file passed as an argument
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n

\u201cid\u201d field:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

1) For every table(model), Django will generate a special column named with \u201cid\u201d.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

2) ID is a Primary Key. (Unique Identifier for every row inside table is considered as a
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

primary key).
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

3) This field(id) is auto increment field and hence while inserting data, we are not
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

 required to provide data for this field.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

4) This id field is of type \u201cAutoField\u201d
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

5) We can override the behavior of \u201cid\u201d field and we can make our own field as \u201cid\u201d.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

6) Every Field is <\/span>by default \u201cNOT NULL\u201d.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

How to execute generated SQL Code (migrate Command):
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

After generating sql code, we have to execute that sql code to create table in database.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

For this, we have to use \u2018migrate\u2019 command.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

python manage.py migrate
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n

Operations to perform:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Apply all migrations: admin, auth, contenttypes, sessions, testApp
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Running migrations:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying contenttypes.0001_initial… OK
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying auth.0001_initial… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying admin.0001_initial… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying admin.0002_logentry_remove_auto_add… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying contenttypes.0002_remove_content_type_name… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying auth.0002_alter_permission_name_max_length… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying auth.0003_alter_user_email_max_length… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying auth.0004_alter_user_username_opts… OK
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>Applying auth.0005_alter_user_last_login_null… OK
\n<\/span><\/span><\/p>\n<\/p>\n

\n
\n
\n

. <\/b>Applying auth.0006_require_contenttypes_0002… OK<\/span><\/span><\/p>\n

. <\/b>Applying auth.0007_alter_validators_add_error_messages… OK<\/span><\/span><\/p>\n

. <\/b>Applying auth.0008_alter_user_username_max_length… OK<\/span><\/span><\/p>\n

. <\/b>Applying sessions.0001_initial… OK<\/span> <\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n
\n

What is the Advantage of creating T<\/span>ables with \u2018migrate\u2019 Command
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

If we use \u2018migrate\u2019 command, then all Django required tables will be created in addition to
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

our application specific tables. If we create table manually with sql code, then only our
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

application specific table will be created and django my not work properly. Hence it is
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

highly recommended to create tables with \u2018migrate\u2019 command.
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

How to Check created Table in Django admin Interface:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

We have <\/span>to register model class in \u2018admin.py\u2019 file.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

admin.py
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .contrib <\/span>import <\/span>admin
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>testApp .models <\/span>import <\/span>Employee
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>#Registery our models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>admin.site.register(Employee)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

Creation of Super User to login to admin Interface:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

We can create super user with the following command by providing username, mailid,
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

password.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

                <\/span>python manage.py createsuperuser
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

. <\/b>We can login to admin interface \u2192 Start the server and login to admin interface using <\/span>the created credentials.<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

.  <\/b>python manage.py runserver
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

.  <\/b>Open the following in browser: http:\/\/127.0.0.1:8000\/admin\/
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n

Difference between makemigrations and migrate:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

\u201cmakemigrations\u201d is responsible to generate SQL code for Python model class whereas
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

\u201cmigrate\u201d is responsible to execute that SQL code so that tables will be created in the
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

database. <\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n
\n
\n

To Display Data in admin Interface in Browser: <\/span><\/p>\n

models.py
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .db <\/span>import <\/span>models
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>#Create your models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>class <\/span>Employee(models.Model):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>eno=models.IntegerField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>ename=models.CharField(max_length=30)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>esal=models.FloatField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>eaddr=models.CharField(max_length=30)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span>def<\/span>__str__(self):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span>return <\/span>‘Employee Object with eno: +str(self.no)’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

admin.py
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .contrib <\/span>import <\/span>admin
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>testApp .models <\/span>import <\/span>Employee
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>#Register your models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>class <\/span>EmployeeAdmin(admin.ModelAdmin):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>list_display=[<\/span>‘eno’<\/span>,<\/span>‘ename’<\/span>,<\/span>‘esal’<\/span>,<\/span>‘eaddr’<\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>admin.site.register(Employee,EmployeeAdmin)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

Note:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

We should do this registration in a single line otherwise we are getting error.<\/span><\/p>\n

admin.site.register(Employee)<\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

admin.site.register(EmployeeAdmin)
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Practice Activity:
\n<\/span><\/p>\n

Create the following tables and populate with some sample data<\/span><\/p>\n<\/div>\n<\/div>\n

\n
\n

         1)Job(posting date,location,offeredsalary,qualification)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

          2) Book(number,title,author,publisheddate)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

         3) Customer(name,ano,mailid,phonenumber,age)
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Now we can write views to get data from the database and send to template.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Bef<\/span>ore writing views.py file, create \u201ctemplates\u201d and \u201cstatic\u201d folder with respective
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

application folders and HTML and CSS files and link them in settings.py file.
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

Views.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .shortcuts <\/span>import <\/span>render
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>testApp .models <\/span>import <\/span>Employee
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>#Create your views here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>def <\/span>empdata(request):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6)   <\/span>emp_list=Employee.objects.all()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7)   <\/span>my_dict={<\/span>’emp_list’<\/span>:emp_list}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8)   <\/span>return <\/span>render(request, <\/span>‘testApp\/emp.html’<\/span>, context=my_dict)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\n\t\t<\/span><\/div>\n


<\/span><\/div>\n
\n
\n
\n
\n

emp.html
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span><!DOCTYPEhtml<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>{%load static files %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span><html<\/span>lang<\/span>=<\/span>“en”<\/span>dir<\/span>=<\/span>“ltr”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span><head>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span><meta <\/span>charset<\/span>=<\/span>“utf-8”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span><title><\/title>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span><link <\/span>rel<\/span>=<\/span>“stylesheet” <\/span>href<\/span>=<\/span>“{% static ‘\/css\/demo.css’%}”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span><\/head>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span><body>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span><h1> <\/span>The employees list is : <\/span><\/h1>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

13) <\/span>{% if emp_list %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span><table>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span><thead>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span><th> <\/span>eno <\/span><\/th>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span><th> <\/span>ename <\/span><\/th>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span><th> <\/span>esal <\/span><\/th>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

19) <\/span><th> <\/span>eaddr <\/span><\/th>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

20) <\/span><\/thead>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

21)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

22) <\/span>{% for emp in emp_list %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

23) <\/span><tr>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

24) <\/span><td> <\/span>{{emp.eno}}<\/span><\/td>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

25) <\/span><td><\/span>{{emp.ename}}<\/span><\/td>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

26) <\/span><td><\/span>{{emp.esal}}<\/span><\/td>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

27) <\/span><td> <\/span>{{emp.eaddr}}<\/span><\/td>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

28) <\/span><\/tr>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

29) <\/span>{% endfor %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

30)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

31) <\/span><\/table>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

32) <\/span>{%else%}
\n<\/span><\/span><\/p>\n<\/p>\n

\n\n\n\n\n\n\n\n
\n
\n
\n

33) <\/span><p> <\/span>No records found <\/span><\/p>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

34) <\/span>{% endif %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

35)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

36) <\/span><\/body>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

37) <\/span><\/html>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\n\t\t<\/span><\/div>\n


<\/span><\/div>\n
                                                  <\/span><\/p>\n
<\/span><\/a><\/div>\n


<\/span><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n


\n\t\t<\/span><\/div>\n

\n
\n
\n
\n

Important FAQs Related to Model and database
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

configurations:
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n
\n

1) How to configure database inside settings.py?
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

2) How to check connections?
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

3) How to define Model class inside models.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

4) How we can perform makemigrations?
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

5) How we can perform migrate?
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

6) How to add our model to admin interface inside admin.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

7) To display total data how to write ModelAdmin class inside admin.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

8) How to createsuperuser?
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

9) How to login to admin interface and add data to our tables?
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

10) How to see generated sqlcode b’z of makemigrations
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

Faker Module:
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

We can use Faker Module to generate fake data for our database models.
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>faker <\/span>import <\/span>Faker
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>random <\/span>import <\/span>*
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>fakegen=Faker()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>name=fakegen.name()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>print<\/span>(name)
\n<\/span><\/span><\/p>\n<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

6) <\/span>first_name= fakegen.first_name()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>last_name= fakegen.last_name()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>print<\/span>(first_name)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>print<\/span>(last_name)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span>date=fakegen.date()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span>print<\/span>(date)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12) <\/span>number=fakegen.random_number(5)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

13) <\/span>print<\/span>(number)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span>email=fakegen.email()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span>print<\/span>(email)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span>print<\/span>(fakegen.city())
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span>print<\/span>(fakegen.random_int(min=0, max=9999))
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span>print<\/span>(fakegen.random_element(elements=(<\/span>‘Project Manager’<\/span>, <\/span>‘TeamLead’<\/span>, <\/span>‘Softwa
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

re Engineer’<\/span>)))
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

Working with MYSQL Database (studentinfo project): <\/span><\/p>\n

settings.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>TEMPLATE_DIR=os.path.join(BASE_DIR,<\/span>‘templates’<\/span>)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>INSTALLED_APPS=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>….,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>‘testapp’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>TEMPLATES=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>{
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>‘BACKEND’<\/span>: <\/span>‘django.template.backends.django.DjangoTemplates’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>‘DIRS’<\/span>: [TEMPLATE_DIR],
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span>….
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12) <\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

13) <\/span>DATABASES = {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span>‘default’<\/span>: {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span>‘ENGINE’<\/span>: <\/span>‘django.db.backends.mysql’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span>‘NAME’<\/span>: <\/span>‘studentdb’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span>‘USER’<\/span>:<\/span>‘root’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span>‘PASSWORD’<\/span>:<\/span>‘root’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

19) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

20) <\/span>}
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

models.py
\n<\/span><\/p>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .db <\/span>import <\/span>models
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>#Create your models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>class <\/span>Student(models.Model):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>name=models.CharField(max_length=30)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>marks=models.IntegerField()
\n<\/span><\/span><\/p>\n

admin.py<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .contrib <\/span>import <\/span>admin
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>#Register your models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>from <\/span>testapp .models <\/span>import <\/span>Student
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>class <\/span>StudentAdmin(admin.ModelAdmin):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>list_display=[<\/span>‘name’<\/span>,<\/span>‘marks’<\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>admin.site.register(Student,StudentAdmin)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

views.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .shortcuts <\/span>import <\/span>render
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>testapp .models <\/span>import <\/span>Student
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>#Create your views here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>def <\/span>studentview(request):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>student_list=Student.objects.order_by(<\/span>‘marks’<\/span>)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>my_dict={<\/span>‘student_list’<\/span>:student_list}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>return <\/span>render(request,<\/span>‘testapp\/students.html’<\/span>,context=my_dict)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

students.html
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span><!DOCTYPEhtml<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span><html<\/span>lang<\/span>=<\/span>“en”<\/span>dir<\/span>=<\/span>“ltr”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span><head>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span><meta <\/span>charset<\/span>=<\/span>“utf-8”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span><title><\/title>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span><\/head>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span><body>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>{%if student_list %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span><table <\/span>border<\/span>=<\/span>“1” <\/span>margin<\/span>=<\/span>‘auto’<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span><thead>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span><th><\/span>Name<\/span><\/th>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12) <\/span><th><\/span>Marks<\/span><\/th>
\n<\/span><\/span><\/p>\n<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

13) <\/span><\/thead>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span>{% for student in student_list %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span><tr>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span><td><\/span>{{student.name}}<\/span><\/td>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span><td><\/span>{{student.marks}}<\/span><\/td>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span><\/tr>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

19) <\/span>{% endfor %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

20) <\/span><\/table>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

21) <\/span>{% else %}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

22) <\/span><p><\/span>No Studetns found<\/span><\/p>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

23) <\/span>{%endif%}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

24) <\/span><\/body>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

25) <\/span><\/html>
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

urls.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .conf .urls <\/span>import <\/span>url
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>django .contrib <\/span>import <\/span>admin
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>from <\/span>testapp <\/span>import <\/span>views
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>urlpatterns=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>url(r<\/span>‘^admin\/’<\/span>, admin.site.urls),
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>url(r<\/span>‘^$’<\/span>, views.studentview),
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>]
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n
\n

Working with MYSQL Database and Faker Module
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n

\n
\n

(studentinfo Project)<\/span><\/p>\n

                               <\/span><\/p>\n

<\/span><\/a><\/div>\n

<\/span><\/div>\n<\/p>\n
\n
\n
\n

settings.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>TEMPLATE_DIR=os.path.join(BASE_DIR,<\/span>‘templates’<\/span>)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>STATIC_DIR=os.path.join(BASE_DIR,<\/span>‘static’<\/span>)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>INSTALLED_APPS=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>….,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>‘testapp’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>TEMPLATES=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>{
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>‘BACKEND’<\/span>: <\/span>‘django.template.backends.django.DjangoTemplates’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span>‘DIRS’<\/span>: [TEMPLATE_DIR],
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span>….
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

13) <\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span>DATABASES = {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span>‘default’<\/span>: {
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span>‘ENGINE’<\/span>: <\/span>‘django.db.backends.mysql’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span>‘NAME’<\/span>: <\/span>‘studentdb’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span>‘USER’<\/span>:<\/span>‘root’<\/span>,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

19) <\/span>‘PASSWORD’<\/span>:<\/span>‘root’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

20) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

21) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

22) <\/span>STATIC_URL = <\/span>‘\/static\/’
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

23) <\/span>STATICFILES_DIRS=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

24) <\/span>STATIC_DIR,
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

25) <\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

models.py
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .db <\/span>import <\/span>models
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>#Create your models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>class <\/span>Student(models.Model):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5)         <\/span>rollno=models.IntegerField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6).         <\/span>name=models.CharField(max_length=30)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7)         <\/span>dob=models.DateField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8)        <\/span>marks=models.IntegerField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9)       <\/span>email=models.EmailField()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10)     <\/span>phonenumber=models.IntegerField(15)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11)     <\/span>address=models.TextField()
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

admin.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .contrib <\/span>import <\/span>admin
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>testapp .models <\/span>import <\/span>Student
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>#Register your models here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>class <\/span>StudentAdmin(admin.ModelAdmin):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>list_display=[<\/span>‘rollno’<\/span>,<\/span>‘name’<\/span>,<\/span>‘dob’<\/span>,<\/span>‘marks’<\/span>,<\/span>’email’<\/span>,<\/span>‘phonenumber’<\/span>,<\/span>‘address’<\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>admin.site.register(Student,StudentAdmin)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

populate_student_info.py
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>import <\/span>os
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>os.environ.setdefault(<\/span>‘DJANGO_SETTINGS_MODULE’<\/span>,<\/span>‘studentinfoproject.settings’<\/span>)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n\t\t\t\t\t<\/td>\n<\/tr>\n
\n
\n
\n

3) <\/span>import <\/span>django
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>django.setup()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>from <\/span>testapp .models <\/span>import <\/span>Student
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>from <\/span>faker <\/span>import <\/span>Faker
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>from <\/span>random <\/span>import <\/span>*
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>fake=Faker()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span>def <\/span>phonenumbergen():
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span>d1=randint(6,9)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12) <\/span>num=<\/span>”<\/span>+str(d1)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

13) <\/span>for <\/span>i <\/span>in <\/span>range(9):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span>num=num+str(randint(0,9))
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span>return <\/span>int(num)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span>def <\/span>populate(n):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span>for <\/span>i <\/span>in <\/span>range(n):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span>frollno=fake.random_int(min=1,max=999)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

19) <\/span>fname=fake.name()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

20) <\/span>fdob=fake.date()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

21) <\/span>fmarks=fake.random_int(min=1,max=100)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

22) <\/span>femail=fake.email()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

23) <\/span>fphonenumber=phonenumbergen()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

24) <\/span>faddress=fake.address()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

25) <\/span>student_record=Student.objects.get_or_create(rollno=frollno,name=fname,do
\nb=fdob,marks=fmarks,email=femail,phonenumber=fphonenumber,address=faddre
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

ss)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

26) <\/span>populate(30)
\n<\/span><\/span><\/p>\n


<\/span><\/p>\n<\/p>\n

\n
\n
\n

views.py
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .shortcuts <\/span>import <\/span>render
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>testapp .models <\/span>import <\/span>Student
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>#Create your views here.
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>def <\/span>home_page_view(request):
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6)       <\/span>students=Student.objects.all()
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7)       <\/span>#students=Student.objects.filter(marks__lt=35)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8)      <\/span>#students=Student.objects.filter(name__startswith=’A’)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9)      <\/span>#students=Student.objects.all().order_by(‘marks’)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10)    <\/span>#students=Student.objects.all().order_by(‘-marks’)
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11)     <\/span>return <\/span>render(request,<\/span>‘testapp\/index.html’<\/span>,{<\/span>‘students’<\/span>:students})
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

index.html
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span><!DOCTYPEhtml<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>{%loadstaticfiles%}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span><html<\/span>lang<\/span>=<\/span>“en”<\/span>dir<\/span>=<\/span>“ltr”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span><head>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span><meta <\/span>charset<\/span>=<\/span>“utf-8”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span><title><\/title>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span><link <\/span>rel<\/span>=<\/span>“stylesheet” <\/span>href<\/span>=<\/span>“https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

\/css\/bootstrap.min.css” <\/span>integrity<\/span>=<\/span>“sha384-
\nBVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz\/K68vbdEjh4u” <\/span>c
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

rossorigin<\/span>=<\/span>“anonymous”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span><link <\/span>rel<\/span>=<\/span>“stylesheet” <\/span>href<\/span>=”{%static “<\/span>css<\/span>\/sinfo.css”%}”<\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span><\/head>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span><body>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

11) <\/span><div <\/span>class<\/span>=<\/span>“container” <\/span>>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

12) <\/span><h1><\/span>Student Information<\/span><\/h1><hr>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

13) <\/span>{% if students%}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

14) <\/span>{%for student in students%}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

15) <\/span><h2><\/span>{{student.name}} Information<\/span><\/h2><hr>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

16) <\/span><ul>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

17) <\/span><li><\/span>Student Rollno:{{student.rollno}}<\/span><\/li>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

18) <\/span><li><\/span>Student DOB:{{student.dob}}<\/span><\/li>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

19) <\/span><li><\/span>Student Marks:{{student.marks}}<\/span><\/li>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

20) <\/span><li><\/span>Student Email:{{student.email}}<\/span><\/li>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

21) <\/span><li><\/span>Student Phone Number:{{student.phonenumber}}<\/span><\/li>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

22) <\/span><li><\/span>Student Address:{{student.address}}<\/span><\/li>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

23) <\/span><\/ul>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

24) <\/span><br>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

25) <\/span>{%endfor%}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

26) <\/span>{%else%}
\n<\/span><\/span><\/p>\n<\/p>\n

\n\n\n\n\n\n\n\n
\n
\n
\n

27) <\/span><p><\/span>Student Records Are Not Available<\/span><\/p>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

28) <\/span>{%endif%}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

29) <\/span><\/div>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

30) <\/span><\/body>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

31) <\/span><\/html>
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

sinfo.css
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>body.container{
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>background<\/span>: red;
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>color<\/span>:white;
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>h1{
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>text-align<\/span>: center;
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>h2{
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

9) <\/span>color<\/span>:yellow;
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

10) <\/span>}
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\n

urls.py
\n<\/u><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n\n\n\n\n\n\n\n\n\n\n
\n
\n
\n

1) <\/span>from <\/span>django .conf .urls <\/span>import <\/span>url
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

2) <\/span>from <\/span>django .contrib <\/span>import <\/span>admin
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

3) <\/span>from <\/span>testapp <\/span>import <\/span>views
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

4)
\n<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

5) <\/span>urlpatterns=[
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

6) <\/span>url(r<\/span>‘^admin\/’<\/span>, admin.site.urls),
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

7) <\/span>url(r<\/span>‘^$’<\/span>, views.home_page_view),
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n

\n
\n
\n

8) <\/span>]
\n<\/span><\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n

<\/div>\n

<\/span><\/p>\n


<\/span><\/div>\n

<\/span><\/div>\n


<\/span><\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n<\/div><\/div>\n<\/p><\/div>\n

\n
\n


<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n\t\t\t\t<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/div><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

  Working with Models and Databases: . As the part of web application development, compulsory we…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":"","_joinchat":[]},"categories":[7],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/posts\/39"}],"collection":[{"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/comments?post=39"}],"version-history":[{"count":0,"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/posts\/39\/revisions"}],"wp:attachment":[{"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/media?parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/categories?post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pythonpower.in\/index.php\/wp-json\/wp\/v2\/tags?post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}