Frank Geisler #101
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Add a new speaker json | |
| on: | |
| issues: | |
| types: | |
| - "opened" | |
| jobs: | |
| addNewSpeaker: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 0 | |
| ref: main | |
| token: ${{ secrets.REPO_TOKEN }} | |
| - name: Add comment to the issue | |
| uses: peter-evans/create-or-update-comment@v2 | |
| with: | |
| issue-number: ${{ github.event.issue.number }} | |
| body: | | |
| Hi @${{ github.event.issue.user.login }}, | |
| Thank you so much for your Speaker submission. | |
| The Action should be running now and adding it to the webpage. It should should update here. | |
| If it doesnt - get in touch with Rob on Twittter https://twitter.com/sqldbawithbeard | |
| - name: Get Speaker Information to file | |
| run: | | |
| Write-Host "What do we have?" | |
| # gci -recurse = this is for troubleshooting because paths are hard | |
| $IssueBody = "${{ github.event.issue.body }}" | |
| # Write-Host $IssueBody | |
| $IssueBody | Out-File speakers/temp.txt | |
| # get the temp file contents - I do this so I dont lose anything | |
| $file = Get-Content ./speakers/temp.txt -Raw | |
| # parse the issue | |
| $regexResult = [regex]::Matches($file, '(?ms)fullname\n\n(?<fullname>.*)\n\n### topics\n\n(?<topics>.*)\n\n### regions\n\n(?<regions>.*)\n\n### Sessionize\n\n(?<Sessionize>.*)\n\n### language\n\n(?<language>.*)\n') | |
| # create an object | |
| $speakerObject = [PSCustomObject]@{ | |
| name = $regexResult[0].Groups['fullname'].Value | |
| topics = $regexResult[0].Groups['topics'].Value | |
| regions = $regexResult[0].Groups['regions'].Value | |
| sessionize = $regexResult[0].Groups['Sessionize'].Value | |
| language = $regexResult[0].Groups['language'].Value | |
| } | |
| #save it to a file | |
| $speakerFileName = $SpeakerObject.name -replace ' ', '-' -replace '''','-' -replace '/','-' -replace '\\','-' -replace ':','-' -replace '\*','-' -replace '\?','-' -replace '"','-' -replace '\|','-' | |
| $filePath = './speakers/{0}.json' -f $speakerFileName | |
| $SpeakerObject |ConvertTo-Json | Out-FIle -FilePath $filePath | |
| $speakerFileName | OUt-File ./speakers/list.txt -Append | |
| shell: pwsh | |
| - name: Add another comment to the issue | |
| uses: peter-evans/create-or-update-comment@v2 | |
| with: | |
| issue-number: ${{ github.event.issue.number }} | |
| body: | | |
| The Speaker Json has been added https://github.com/dataplat/DataSpeakers/tree/main/speakers | |
| - name: Add & Commit | |
| uses: EndBug/[email protected] | |
| with: | |
| author_name: Beardy McBeardFace | |
| author_email: [email protected] | |
| message: 'The Beard says hooray we have another speaker @${{ github.event.issue.user.login }} - This is an automated message' | |
| # createSpeakerListJson: | |
| # needs: addNewSpeaker | |
| # uses: dataplat/DataSpeakers/.github/workflows/wesbiteFile.yml@main | |
| # secrets: | |
| # REPO_TOKEN: ${{ secrets.REPO_TOKEN }} | |
| # painful | |
| # https://github.community/t/reusable-workflows-secrets-and-environments/203695/18 | |
| closeIssue: | |
| needs: [addNewSpeaker] | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Close Issue | |
| uses: peter-evans/close-issue@v2 | |
| with: | |
| issue-number: ${{ github.event.issue.number }} | |
| comment: | | |
| Hey @${{ github.event.issue.user.login }}, | |
| Closing this issue now that the Action has run successfully. | |
| Thank you so much for adding your information to the list. | |
| It will be active on callfordataspeakers.com shortly. | |
| Please share on social media. | |
| Love and Hugs | |
| Rob and Daniel | |
| @SqlDbaWithABeard @dhmacher |