How to view database and schema of django sqlite3 db

Question

I'm new to django framework.

I tried to create a simple blog by following djangogirls tutorials.

Here by default, we get sqlite3 as default database Engine:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
    }
}

I tried some ORM queries also, Even performed some row sql queries

At my django project, I have this db.sqlite3 file:

blog  db.sqlite3  env  manage.py  mysite

My Question: How to know the schema that django created in this db.sqlite3(I know mysql where I can see details about each database and tables, so here I just want to know more things in sqlite)

I have sqlite3 in my system and I tried .database command, but it just shows me:

seq  name             file                                                      
---  ---------------  ----------------------------------------------------------
0    main 

                                                                  

Casing

Did you try .schema? – Immutable

Yes it shows blank. tried .help and all commands also – Casing

Answer 1

Goto the folder where the database is and then

sqlite3  db.sqlite3

Then

.tables

or .schema

depending on what you want. Instead of invoking sqlite3 directly you could do

 python manage.py dbshell 

and then type the sqlite commands.

If you are working with a legacy database you can generate Django models for that using the

 python manage.py inspectdb

please see https://docs.djangoproject.com/en/3.0/ref/django-admin/#django-admin-inspectdb for additional info.

But please do yourself a favour and get a GUI database client. Life is much easier when you have one.

Allseed

Well yes all this assumes that sqlite3 is available on your system – Allseed

sqlite3 installs with django installation. – Journeyman

+1 for "please do yourself a favour and get a GUI database client. Life is much easier when you have one." Preach. – Vitia

Answer 2

I have been stumbling around for an hour aiming to replicate DESCRIBE table inside the Django shell, and think I've cracked it. I hope this is of use to others.

In the Terminal - enter the following commands.

python3 manage.py dbshell
.tables

Find the name of the table you are looking for, then run the following commands:

.header on
.mode column
pragma table_info('table you are looking for');

Do not forget the semicolon in the last instruction.

Ashling

and yes, forgot the semicolon at the end of the last instruction ;) Why is this line not blinking? – Fisc

Answer 3

First, run the command below:

python manage.py dbshell

To access sqlite3 command-line client as shown below:

Then, run the command below:

.table

Or run the command below:

.tables

To show all the tables in SQLite as shown below:

Then, run the command below:

.schema --indent store_product

To show the schema of "store_product" table as shown below:

Hirschfeld

Answer 4

You can use the following command to get the sql script for the database created.

python manage.py sqlmigrate app_label migration_name

Virchow

Answer 5

You can view your db.sqlite file online.
sqlite Online

Just upload your file there and you can see your tables which are in your db.sqlite file.

Androgynous

My file not opening – Berberidaceous

Answer 6

Just wanted to add that someone can find the migrations under my_project_name>my_app_name>migrations and usually you pick the one with the biggest number.

Then the command should be like: python manage.py sqlmigrate my_app_name number

Rinse