starred/sandman2-jeffknupp
1
0
Fork 0
mirror of https://github.com/jeffknupp/sandman2.git synced 2026-04-25 00:25:49 +03:00
Code Issues 45 Projects Releases Packages Wiki Activity

[GH-ISSUE #116] sqlalchemy.exc.ArgumentError #63

New issue
Closed
opened 2026-02-26 01:33:01 +03:00 by kerem · 1 comment
kerem commented 2026-02-26 01:33:01 +03:00
Owner
Copy link

Originally created by @rustanacexd on GitHub (Jul 23, 2019).
Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/116

I am getting an error from the get go, thoughts? This is for mssql 2012

sandman2ctl mssql+pymssql://USERNAMEHERE:PASSWORDHERE@HOSTHERE/DBNAMEHERE
Traceback (most recent call last):
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/bin/sandman2ctl", line 10, in <module>
    sys.exit(main())
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/scripts/sandman2ctl.py", line 51, in main
    app = get_app(args.URI, read_only=args.read_only, schema=args.schema)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/app.py", line 60, in get_app
    _reflect_all(exclude_tables, admin, read_only, schema=schema)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/app.py", line 139, in _reflect_all
    register_model(cls, admin)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/app.py", line 156, in register_model
    cols = list(cls().__table__.primary_key.columns)
  File "<string>", line 2, in __init__
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/instrumentation.py", line 373, in _new_state_if_none
    state = self._state_constructor(instance, self)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 855, in __get__
    obj.__dict__[self.__name__] = result = self.fget(obj)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/instrumentation.py", line 199, in _state_constructor
    self.dispatch.first_init(self, self.class_)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/event/attr.py", line 297, in __call__
    fn(*args, **kw)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 3341, in _event_on_first_init
    configure_mappers()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 3229, in configure_mappers
    mapper._post_configure_properties()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 1947, in _post_configure_properties
    prop.init()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/interfaces.py", line 196, in init
    self.do_init()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 1864, in do_init
    self._generate_backref()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 2121, in _generate_backref
    mapper._configure_property(backref_key, relationship)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 1840, in _configure_property
    prop.init()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/interfaces.py", line 196, in init
    self.do_init()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 1864, in do_init
    self._generate_backref()
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 2124, in _generate_backref
    self._add_reverse_property(self.back_populates)
  File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 1815, in _add_reverse_property
    % (other, self, self.direction)
sqlalchemy.exc.ArgumentError: incident_request_type.incident_request_type and back-reference incident_request_type.incident_request_type_collection are both of the same direction symbol('ONETOMANY').  Did you mean to set remote_side on the many-to-one side ?
Originally created by @rustanacexd on GitHub (Jul 23, 2019). Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/116 I am getting an error from the get go, thoughts? This is for mssql 2012 ``` sandman2ctl mssql+pymssql://USERNAMEHERE:PASSWORDHERE@HOSTHERE/DBNAMEHERE Traceback (most recent call last): File "/Users/rustanacecorpuz/.virtualenvs/sandman2/bin/sandman2ctl", line 10, in <module> sys.exit(main()) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/scripts/sandman2ctl.py", line 51, in main app = get_app(args.URI, read_only=args.read_only, schema=args.schema) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/app.py", line 60, in get_app _reflect_all(exclude_tables, admin, read_only, schema=schema) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/app.py", line 139, in _reflect_all register_model(cls, admin) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sandman2/app.py", line 156, in register_model cols = list(cls().__table__.primary_key.columns) File "<string>", line 2, in __init__ File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/instrumentation.py", line 373, in _new_state_if_none state = self._state_constructor(instance, self) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 855, in __get__ obj.__dict__[self.__name__] = result = self.fget(obj) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/instrumentation.py", line 199, in _state_constructor self.dispatch.first_init(self, self.class_) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/event/attr.py", line 297, in __call__ fn(*args, **kw) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 3341, in _event_on_first_init configure_mappers() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 3229, in configure_mappers mapper._post_configure_properties() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 1947, in _post_configure_properties prop.init() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/interfaces.py", line 196, in init self.do_init() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 1864, in do_init self._generate_backref() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 2121, in _generate_backref mapper._configure_property(backref_key, relationship) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/mapper.py", line 1840, in _configure_property prop.init() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/interfaces.py", line 196, in init self.do_init() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 1864, in do_init self._generate_backref() File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 2124, in _generate_backref self._add_reverse_property(self.back_populates) File "/Users/rustanacecorpuz/.virtualenvs/sandman2/lib/python3.7/site-packages/sqlalchemy/orm/relationships.py", line 1815, in _add_reverse_property % (other, self, self.direction) sqlalchemy.exc.ArgumentError: incident_request_type.incident_request_type and back-reference incident_request_type.incident_request_type_collection are both of the same direction symbol('ONETOMANY'). Did you mean to set remote_side on the many-to-one side ? ```
kerem 2026-02-26 01:33:01 +03:00
kerem commented 2026-02-26 01:33:02 +03:00
Author
Owner
Copy link

@jeffknupp commented on GitHub (Jul 29, 2019):

Is it possible to post a dump of the schema for the tables in question?

<!-- gh-comment-id:516190187 --> @jeffknupp commented on GitHub (Jul 29, 2019): Is it possible to post a dump of the schema for the tables in question?
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
master
pyup-scheduled-update-2026-04-20
pyup-scheduled-update-2024-09-16
pyup-scheduled-update-2023-07-24
pyup-scheduled-update-2023-06-19
pyup-scheduled-update-2023-05-22
pyup-scheduled-update-2023-05-15
pyup-scheduled-update-2023-05-08
dependabot/pip/flask-2.3.2
pyup-scheduled-update-2023-05-01
pyup-scheduled-update-2023-04-03
dependabot/pip/werkzeug-2.2.3
pyup-scheduled-update-2022-11-14
pyup-scheduled-update-2022-10-03
pyup-scheduled-update-2022-08-01
pyup-scheduled-update-2022-06-13
pyup-scheduled-update-2022-05-30
pyup-scheduled-update-2022-03-07
pyup-scheduled-update-2022-01-10
pyup-scheduled-update-2021-11-01
pyup-scheduled-update-2020-10-05
pyup-scheduled-update-2019-09-30
pyup-scheduled-update-2019-07-29
pyup-scheduled-update-2019-07-22
pyup-scheduled-update-2019-05-27
pyup-scheduled-update-2019-03-11
marshmallow
pyup-scheduled-update-2019-02-25
pyup-scheduled-update-2019-02-18
pyup-scheduled-update-2019-01-28
pyup-scheduled-update-2019-01-14
docker
name-map-stupid
swagger
fix-pagination
doc-expansion
specify-schema
No results found.
Labels
Clear labels   
bug

   
duplicate

   
enhancement

   
help wanted

   
invalid

   
pull-request

Mirrored from GitHub Pull Request

  
question

   
refactoring

   
research

   
wontfix
No labels
bug
duplicate
enhancement
help wanted
invalid
pull-request
question
refactoring
research
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/sandman2-jeffknupp#63
No description provided.