ci: Configure Packit propose_downstream job

[spetrosi]

When there is a new release of this repo, Packit will fetch linux-system-roles.spec from the Rawhide branch in Fedora dist-git, update it (Source lines and %setup will be regenerated) and open a PR in Fedora Pagure. It will also upload new tarballs to lookaside and update sources.

The PR will be opened only against Rawhide for now, can be changed in dist_git_branches.

documentation: https://packit.dev/docs/configuration/#propose_downstream https://packit.dev/docs/fedora-releases-guide/

Taking inspiration from https://github.com/linux-system-roles/auto-maintenance/pull/233

[spetrosi]

Follow up fedora rpm PR: https://src.fedoraproject.org/rpms/ansible-collection-microsoft-sql/pull-request/40

[spetrosi]

@pcahyna I am trying to replicate packit release automation for mssql and need your help reviewing this. Packit-as-a-Service is added to linux-system-roles repo and is configured to work on all repos. This repo has a workflow that does a release once the repo has updates to changelog https://github.com/linux-system-roles/mssql/blob/main/.github/workflows/changelog_to_tag.yml.

So I guess having .packit.yml file is sufficient to pick up updates? I am adding .packit.yaml in Fedora too: https://src.fedoraproject.org/rpms/ansible-collection-microsoft-sql/pull-request/40#