Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unresolvable cycles warning when creating a new alembic migration #145

Closed
martinburchell opened this issue Mar 26, 2021 · 0 comments · Fixed by #154
Closed

Unresolvable cycles warning when creating a new alembic migration #145

martinburchell opened this issue Mar 26, 2021 · 0 comments · Fixed by #154
Assignees
@martinburchell

Comments

@martinburchell
Copy link
Collaborator 

/home/martinb/workspace/camcops/working/.server_ve/lib/python3.6/site-packages/sqlalchemy/sql/ddl.py:1217: SAWarning: Cannot correctly sort tables; there are unresolvable cycles between tables "_security_devices, _security_users, patient", which is usually caused by mutually dependent foreign key constraints.  Foreign key constraints involving these tables will not be considered; this warning may raise an error in a future release.
  % (", ".join(sorted(t.fullname for t in err.cycles)),)
martinburchell added a commit that referenced this issue Apr 9, 2021
@martinburchell
Fix unresolvable cycles warning
a607add 
Device, User and Patient all have foreign keys to each other.
#145
@martinburchell martinburchell self-assigned this Apr 12, 2021
@martinburchell martinburchell mentioned this issue Apr 15, 2021
Merged
@martinburchell martinburchell linked a pull request Apr 15, 2021 that will close this issue
Replace our test runner with pytest #154
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@martinburchell martinburchell

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Replace our test runner with pytest ucam-department-of-psychiatry/camcops
1 participant
@martinburchell