Skip to content
This repository was archived by the owner on Mar 8, 2023. It is now read-only.
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

@bluec0re

Description

@bluec0re
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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions