Using python sqlite in django terminal

Question

How can I see my databases in SQlite for Django.

I am following the django tutorial on ubuntu.

Now it works fine except. After launch

python manage.py sql polls 

then

 python manage.py syncdb 

So, I thought I'd look at daabase and tables, but this is the problem:

 sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main 1 temp 

There is no mysite database. How can I see the database?

Answer 1

your mysite database will be located in the file system itself at the root of your project (the largest folder of your django project), if it looks like settings.py : -

 DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'. 'NAME': 'mysite', # Or path to database file if using sqlite3. 'USER': '', # Not used with sqlite3. 'PASSWORD': '', # Not used with sqlite3. 'HOST': '', # Set to empty string for localhost. Not used with sqlite3. 'PORT': '', # Set to empty string for default. Not used with sqlite3. } } 

If you enabled the django administrator and write the appropriate admin.py files for your survey, you can add, edit, delete, or view the survey data in the django administrator.

Of course, you can upload your mysite database to your django project root (top folder) and view the data in it using something like http://sqlitebrowser.sourceforge.net/

On the command line of your ubuntu terminal, if you executed your syncdb correctly, you should see something similar to this: -

 calvin$ ./manage.py syncdb Creating tables ... Creating table auth_permission Creating table auth_group_permissions Creating table auth_group Creating table auth_user_user_permissions Creating table auth_user_groups Creating table auth_user Creating table django_content_type Creating table django_session Creating table django_site You just installed Django auth system, which means you don't have any superusers defined. Would you like to create one now? (yes/no): yes Username (leave blank to use 'calvin'): calvin E-mail address: [e-mail] Password: Password (again): Superuser created successfully. Installing custom SQL ... Installing indexes ... Installed 0 object(s) from 0 fixture(s) 

You mentioned that you already use your ./manage.py syncdb correctly, so you should have access to your sqlite database by doing sqlite mysite , for example:

 calvin$ sqlite3 mysite SQLite version 3.7.14.1 2012-10-04 19:37:12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> 

And the .tables command in your sqlite shell will give you: -

 sqlite> .tables auth_group auth_user_user_permissions auth_group_permissions django_content_type auth_permission django_session auth_user django_site auth_user_groups sqlite> 

Answer 2

I used the 'dbshell' option if it is already synchronized:

python manage.py dbshell

SQLite version 3.8.2 2013-12-06 14:53:30 Enter ".help" for instructions Enter SQL statements terminated by the ";"

sqlite> .databases