This repository was archived by the owner on Mar 8, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 72
This repository was 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
Copy link
Copy link
Open
Description
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)
Metadata
Metadata
Assignees
Labels
No labels