django-pyodbc icon indicating copy to clipboard operation
django-pyodbc copied to clipboard

Django 2.0 Alpha inspectdb command fails

Open brianedelman opened this issue 7 years ago • 0 comments

Using the new Alpha support for Django 2.0, inspect db command is failing with django-pyodbc set up.

I am able to make the command work by rolling django-pyodbc back to 1.1.3 and Django to 1.10

Here is the error for 2.0

Traceback (most recent call last):
  File "./manage.py", line 14, in <module>
    execute_from_command_line(sys.argv)
  File "/Users/brianedelman/.virtualenvs/lacma/lib/python3.6/site-packages/django/core/management/__init__.py", line 371, in execute_from_command_line
    utility.execute()
  File "/Users/brianedelman/.virtualenvs/lacma/lib/python3.6/site-packages/django/core/management/__init__.py", line 365, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Users/brianedelman/.virtualenvs/lacma/lib/python3.6/site-packages/django/core/management/base.py", line 288, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/Users/brianedelman/.virtualenvs/lacma/lib/python3.6/site-packages/django/core/management/base.py", line 335, in execute
    output = self.handle(*args, **options)
  File "/Users/brianedelman/.virtualenvs/lacma/lib/python3.6/site-packages/django/core/management/commands/inspectdb.py", line 28, in handle
    for line in self.handle_inspection(options):
  File "/Users/brianedelman/.virtualenvs/lacma/lib/python3.6/site-packages/django/core/management/commands/inspectdb.py", line 44, in handle_inspection
    with connection.cursor() as cursor:
AttributeError: __enter__

My server set up is mssql

DATABASES = {
   'default': {
       'ENGINE': "django_pyodbc",
       'HOST': "HOST",
       'USER': "USER",
       'PASSWORD': "PASSWORD",
       'NAME': "DB",
       'OPTIONS': {
            'host_is_server': True,
            'unicode_results': True,
            'extra_params': 'tds_version=8.0'
       },
   }
}

brianedelman avatar Feb 23 '18 16:02 brianedelman