Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Django setup with sqlite3?

Tags:

django

I am trying to follow the walkthrough on the django website and I downloaded sqlite and saved it in C:\Windows\System32 folder. When I edit the settings.py file what do I put for the Name field? Do I have to set up a database? The django literature say's that the API should take care of that for sqlite. When I run python manage.py syncdb I just get a bunch of errors. What am I doing wrong?

    Jason & Casey@SUPERBEAST ~/Desktop/mysite
$ python manage.py syncdb
Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "c:\Python27\lib\site-packages\django\core\management\__init__.py", line
443, in execute_from_command_line
    utility.execute()
  File "c:\Python27\lib\site-packages\django\core\management\__init__.py", line
382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "c:\Python27\lib\site-packages\django\core\management\__init__.py", line
252, in fetch_command
    app_name = get_commands()[subcommand]
  File "c:\Python27\lib\site-packages\django\core\management\__init__.py", line
101, in get_commands
    apps = settings.INSTALLED_APPS
  File "c:\Python27\lib\site-packages\django\utils\functional.py", line 184, in
inner
    self._setup()
  File "c:\Python27\lib\site-packages\django\conf\__init__.py", line 42, in _set
up
    self._wrapped = Settings(settings_module)
  File "c:\Python27\lib\site-packages\django\conf\__init__.py", line 93, in __in
it__
    mod = importlib.import_module(self.SETTINGS_MODULE)
  File "c:\Python27\lib\site-packages\django\utils\importlib.py", line 35, in im
port_module
    __import__(name)
  File "c:\Users\Jason & Casey\Desktop\mysite\mysite\settings.py", line 21
    }
    ^
SyntaxError: invalid syntax
like image 693
spitfiredd Avatar asked Nov 09 '12 02:11

spitfiredd


People also ask

Can you use SQLite with Django?

By default, the configuration uses SQLite. If you're new to databases, or you're just interested in trying Django, this is the easiest choice. SQLite is included in Python, so you won't need to install anything else to support your database.

Do I need to install SQLite for Django?

Django Settings & CommandsNewer versions of Django (v2. 1+) require a newer version of SQLite (3.8. 3+) than is available on AWS Lambda instances (3.7.


2 Answers

I haven't tried django under windows but python 2.7 surely comes with sqlite out of the box.

How to setup the database?

on the top of the file:

import os

then:

PROJECT_DIR = os.path.abspath(os.path.dirname(__file__))
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(PROJECT_DIR, 'yourdatabasename.db'),
    }
}

and finally a syncdb should do the trick.

If it doesn't work, mind to paste the traceback?

like image 160
Nuance Jones Avatar answered Sep 26 '22 08:09

Nuance Jones


The problem is:

  File "c:\Users\Jason & Casey\Desktop\mysite\mysite\settings.py", line 21
    }
    ^
SyntaxError: invalid syntax

Check the syntax a paren or brace hasn't been closed properly around DATABASES.

like image 20
Williams Avatar answered Sep 24 '22 08:09

Williams