sandman icon indicating copy to clipboard operation
sandman copied to clipboard

could not assemble any primary key columns for mapped table 'sqlite_sequence'

Open ba1dr opened this issue 10 years ago • 0 comments

Ubuntu 15.10, Python 3.5, Sandman 0.9.8

Trying to open my db.sqlite3 file (created with django, no magic, just some tables with users):

sandmanctl sqlite:////opt/projects/somepath/db.sqlite3

And receive an error:

/usr/local/lib/python3.5/dist-packages/flask_sqlalchemy/__init__.py:800: UserWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True to suppress this warning.
  warnings.warn('SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True to suppress this warning.')
/usr/local/lib/python3.5/dist-packages/click/core.py:858: Warning: Invoked legacy parameter callback "<function print_version at 0x7f3f2458dd90>".  The new signature for such callbacks starting with click 2.0 is (ctx, param, value).
  value, args = param.handle_parse_result(ctx, opts, args)
Traceback (most recent call last):
  File "/usr/local/bin/sandmanctl", line 9, in <module>
    load_entry_point('sandman==0.9.8', 'console_scripts', 'sandmanctl')()
  File "/usr/local/lib/python3.5/dist-packages/click/core.py", line 700, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python3.5/dist-packages/click/core.py", line 680, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python3.5/dist-packages/click/core.py", line 873, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python3.5/dist-packages/click/core.py", line 508, in invoke
    return callback(*args, **kwargs)
  File "/usr/local/lib/python3.5/dist-packages/sandman/sandmanctl.py", line 43, in run
    activate(name='sandmanctl')
  File "/usr/local/lib/python3.5/dist-packages/sandman/model/utils.py", line 179, in activate
    generate_endpoint_classes(db, generate_pks)
  File "/usr/local/lib/python3.5/dist-packages/sandman/model/utils.py", line 42, in generate_endpoint_classes
    {'__tablename__': name})
  File "/usr/local/lib/python3.5/dist-packages/flask_sqlalchemy/__init__.py", line 609, in __init__
    DeclarativeMeta.__init__(self, name, bases, d)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/ext/declarative/api.py", line 55, in __init__
    _as_declarative(cls, classname, cls.__dict__)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/ext/declarative/base.py", line 88, in _as_declarative
    _MapperConfig.setup_mapping(cls, classname, dict_)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/ext/declarative/base.py", line 103, in setup_mapping
    cfg_cls(cls_, classname, dict_)
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/ext/declarative/base.py", line 135, in __init__
    self._early_mapping()
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/ext/declarative/base.py", line 138, in _early_mapping
    self.map()
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/ext/declarative/base.py", line 529, in map
    **self.mapper_args
  File "<string>", line 2, in mapper
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/orm/mapper.py", line 629, in __init__
    self._configure_pks()
  File "/usr/local/lib/python3.5/dist-packages/sqlalchemy/orm/mapper.py", line 1223, in _configure_pks
    (self, self.mapped_table.description))
sqlalchemy.exc.ArgumentError: Mapper Mapper|sqlite_sequence|sqlite_sequence could not assemble any primary key columns for mapped table 'sqlite_sequence'

ba1dr avatar Dec 01 '15 22:12 ba1dr