未知命令“sql”

Question

$ ./manage.py sql addressbook                                                                                             
Unknown command: 'sql'

当我遇到这个奇怪的错误时，我试图查看应用程序模型生成的SQL。在

我的设置.py在

^{pr2}$

还有我的要求.txt公司名称：

BeautifulSoup==3.2.1
Django==1.4.3
MySQL-python==1.2.4
argparse==1.2.1
boto==2.7.0
distribute==0.6.34
django-dajax==0.9.2
django-dajaxice==0.5.4.1
django-piston==0.2.3
django-registration==0.8
django-ses==0.4.1
django-storages==1.1.6
django-tagging==0.3.1
markup==0.2
python-dateutil==2.1
six==1.2.0
tweepy==1.13
wsgiref==0.1.2

更新：/管理.py--现在帮我一个堆栈跟踪。在

Traceback (most recent call last):
  File "./manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/core/management/__init__.py", line 443, in execute_from_comma
nd_line
    utility.execute()
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/core/management/__init__.py", line 380, in execute
    sys.stdout.write(self.main_help_text() + '\n')
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/core/management/__init__.py", line 231, in main_help_text
    for name, app in get_commands().iteritems():
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/core/management/__init__.py", line 101, in get_commands
    apps = settings.INSTALLED_APPS
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/utils/functional.py", line 184, in inner
    self._setup()
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/conf/__init__.py", line 42, in _setup
    self._wrapped = Settings(settings_module)
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/conf/__init__.py", line 93, in __init__
    mod = importlib.import_module(self.SETTINGS_MODULE)
  File "/Users/levicc00123/DoneBox/env/lib/python2.6/site-packages/django/utils/importlib.py", line 35, in import_module
    __import__(name)
  File "/Users/levicc00123/DoneBox/DoneBox/settings.py", line 16, in <module>
    'NAME': os.environ['RDS_DB_NAME'],
  File "/Users/levicc00123/DoneBox/env/lib64/python2.6/UserDict.py", line 22, in __getitem__
    raise KeyError(key)

有没有人有什么想法可以对这个奇怪的问题有所启示？感谢您的时间和考虑。在

Answer 1

您应该同时拥有sqlall和sql管理命令。两者都是从1.0开始存在的，it appears

$ ./manage.py help sqlall
...
Usage: manage.py sqlall [options] <appname appname ...>

Prints the CREATE TABLE, custom SQL and CREATE INDEX SQL statements
for the given model module name(s).
...

请参见其中包含sql的命令：

^{pr2}$

你在用什么版本的django？这并不重要

$ ./manage.py shell
monitor (pid=16669): Starting change monitor.
Python 2.7.3 (default, Jan 15 2013, 12:25:59) 
[GCC 4.1.2 20080704 (Red Hat 4.1.2-48)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> import django
>>> django.VERSION
(1, 4, 3, 'final', 0)

正如在评论中指出的，您有一个键错误：

  File "/Users/levicc00123/DoneBox/DoneBox/settings.py", line 16, in <module>
    'NAME': os.environ['RDS_DB_NAME'],
  File "/Users/levicc00123/DoneBox/env/lib64/python2.6/UserDict.py", line 22, in __getitem__
    raise KeyError(key)

{{cd5>可以使用这个方法的值。例如：

os.environ.get('RDS_DB_NAME', "default value if not in environment")