Implement tests to validate module index CSVs

[matebarabas]

The following tests should be introduced as part of the PR validation workflow: check all records in all 4 module index CSV files (Bicep/TF, res/ptn modules).

• If a module is marked available, the module owner display name, and module owner GH handle fields must be populated.
• If a module is marked orphaned, the module owner display name, and module owner GH handle fields must NOT be populated.
• If a module is either marked available or orphaned, the first published in field must be populated with the following format: YYYY-MM.

Note: the pattern module CSVs don't have the first 2 columns of the resource module CSVs!

[microsoft-github-policy-service]

Important

The "Needs: Triage 🔍" label must be removed once the triage process is complete!

Tip

For additional guidance on how to triage this issue/PR, see the AVM Issue Triage documentation.

Note

This label was added as per ITA06.

[matebarabas]

Closing this one, as redundant with #382. Its content will be consolidated with #382.