Skip to content
This repository has been archived by the owner on Mar 8, 2023. It is now read-only.

Lots of warnings with SQLAlchemy 1.4.1 and sqlakeyset >= 1.0 #100

Open
bluec0re opened this issue Mar 19, 2021 · 0 comments
Open

Lots of warnings with SQLAlchemy 1.4.1 and sqlakeyset >= 1.0 #100

bluec0re opened this issue Mar 19, 2021 · 0 comments

Comments

@bluec0re
Copy link
Contributor

vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'RepositoryFileComments.commit' will copy column repository_files.id to column repository_file_comments.repository_file_id, which conflicts with relationship(s): 'RepositoryFileComments.repository_file' (copies repository_files.id to repository_file_comments.repository_file_id), 'RepositoryFiles.comments' (copies repository_files.id to repository_file_comments.repository_file_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'RepositoryFileComments.commit' will copy column vulnerability_git_commits.id to column repository_files.commit_id, which conflicts with relationship(s): 'RepositoryFiles.commit' (copies vulnerability_git_commits.id to repository_files.commit_id), 'VulnerabilityGitCommits.repository_files' (copies vulnerability_git_commits.id to repository_files.commit_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'VulnerabilityGitCommits.comments' will copy column vulnerability_git_commits.id to column repository_files.commit_id, which conflicts with relationship(s): 'RepositoryFiles.commit' (copies vulnerability_git_commits.id to repository_files.commit_id), 'VulnerabilityGitCommits.repository_files' (copies vulnerability_git_commits.id to repository_files.commit_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'VulnerabilityGitCommits.comments' will copy column repository_files.id to column repository_file_comments.repository_file_id, which conflicts with relationship(s): 'RepositoryFileComments.repository_file' (copies repository_files.id to repository_file_comments.repository_file_id), 'RepositoryFiles.comments' (copies repository_files.id to repository_file_comments.repository_file_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'RepositoryFileMarkers.commit' will copy column repository_files.id to column repository_file_markers.repository_file_id, which conflicts with relationship(s): 'RepositoryFileMarkers.repository_file' (copies repository_files.id to repository_file_markers.repository_file_id), 'RepositoryFiles.markers' (copies repository_files.id to repository_file_markers.repository_file_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'RepositoryFileMarkers.commit' will copy column vulnerability_git_commits.id to column repository_files.commit_id, which conflicts with relationship(s): 'RepositoryFiles.commit' (copies vulnerability_git_commits.id to repository_files.commit_id), 'VulnerabilityGitCommits.repository_files' (copies vulnerability_git_commits.id to repository_files.commit_id), 'RepositoryFileComments.commit' (copies vulnerability_git_commits.id to repository_files.commit_id), 'VulnerabilityGitCommits.comments' (copies vulnerability_git_commits.id to repository_files.commit_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
/vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'VulnerabilityGitCommits.markers' will copy column vulnerability_git_commits.id to column repository_files.commit_id, which conflicts with relationship(s): 'RepositoryFiles.commit' (copies vulnerability_git_commits.id to repository_files.commit_id), 'VulnerabilityGitCommits.repository_files' (copies vulnerability_git_commits.id to repository_files.commit_id), 'RepositoryFileComments.commit' (copies vulnerability_git_commits.id to repository_files.commit_id), 'VulnerabilityGitCommits.comments' (copies vulnerability_git_commits.id to repository_files.commit_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'VulnerabilityGitCommits.markers' will copy column repository_files.id to column repository_file_markers.repository_file_id, which conflicts with relationship(s): 'RepositoryFileMarkers.repository_file' (copies repository_files.id to repository_file_markers.repository_file_id), 'RepositoryFiles.markers' (copies repository_files.id to repository_file_markers.repository_file_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'Vulnerability.resources' will copy column vulnerability.id to column vulnerability_resources.vulnerability_details_id, which conflicts with relationship(s): 'VulnerabilityResources.vulnerability' (copies vulnerability.id to vulnerability_resources.vulnerability_details_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlalchemy/orm/relationships.py:3435: SAWarning: relationship 'Vulnerability.commits' will copy column vulnerability.id to column vulnerability_git_commits.vulnerability_details_id, which conflicts with relationship(s): 'VulnerabilityGitCommits.vulnerability' (copies vulnerability.id to vulnerability_git_commits.vulnerability_details_id). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   The 'overlaps' parameter may be used to remove this warning.
  util.warn(
vulncode-db/venv/lib/python3.8/site-packages/sqlakeyset/paging.py:275: UserWarning: Ordering by nullable column vulnerability.date_created can cause rows to be incorrectly omitted from the results. See the sqlakeyset README for more details.
  return orm_get_page(query, per_page, place, backwards)
vulncode-db/venv/lib/python3.8/site-packages/sqlakeyset/paging.py:275: UserWarning: Ordering by nullable column nvd_jsons.published_date can cause rows to be incorrectly omitted from the results. See the sqlakeyset README for more details.
  return orm_get_page(query, per_page, place, backwards)
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant