Hotfix - Personas y Organizaciones - Aviso en acción masiva de envío de correo #258
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: Develop - Create Instance on Opened or Reopened PR | |
| on: | |
| pull_request: | |
| types: [opened, reopened] | |
| branches: # https://docs.github.com/en/actions/reference/workflow-syntax-for-github-actions#onpushpull_requestbranchestags | |
| - '**' # matches every branch | |
| workflow_dispatch: | |
| env: | |
| DEVELOP_HOST: ${{ secrets.DEVELOP_HOST}} | |
| DEVELOP_SSH_USERNAME: ${{ secrets.DEVELOP_SSH_USERNAME}} | |
| DEVELOP_DOMAIN_NAME: ${{ secrets.DEVELOP_DOMAIN_NAME}} | |
| MAIN_HOST: ${{ secrets.MAIN_HOST}} | |
| MAIN_SSH_USERNAME: ${{ secrets.MAIN_SSH_USERNAME}} | |
| jobs: | |
| create_instance: | |
| name: Create Instance on Opened or Reopened PR | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Extract branch name | |
| run: echo ${GITHUB_HEAD_REF:-${GITHUB_REF#refs/heads/}} && echo 'BRANCH='${GITHUB_HEAD_REF:-${GITHUB_REF#refs/heads/}} >> $GITHUB_ENV | |
| - name: Install SSH Key | |
| uses: shimataro/ssh-key-action@v2 | |
| with: | |
| key: ${{ secrets.SSH_PRIVATE_KEY }} | |
| known_hosts: unnecessary | |
| # - name: Adding Known Hosts Develop | |
| # run: ssh-keyscan -H $DEVELOP_HOST >> ~/.ssh/known_hosts | |
| # - name: Adding Known Hosts Main | |
| # run: ssh-keyscan -H $MAIN_HOST >> ~/.ssh/known_hosts | |
| - name: Get Available database name | |
| run: | |
| DATABASE_NAME=$(ssh -o "StrictHostKeyChecking no" $DEVELOP_SSH_USERNAME@$DEVELOP_HOST "mysql -h 127.0.0.1 -u '${{ secrets.DEVELOP_DB_USERNAME }}' --password='${{ secrets.DEVELOP_DB_PASSWORD }}' -N -e 'select schema_name | |
| from information_schema.schemata | |
| where | |
| SCHEMA_NAME not in ( | |
| SELECT | |
| TABLE_SCHEMA | |
| from information_schema.tables | |
| where table_name like \"stic%\" | |
| group by TABLE_SCHEMA | |
| ) | |
| and SCHEMA_NAME like \"mydevelop%\" | |
| order by SCHEMA_NAME LIMIT 1'") && | |
| echo $DATABASE_NAME && | |
| (echo "DATABASE_NAME=$DATABASE_NAME" >> $GITHUB_ENV) | |
| - name: Extract branch clean | |
| run: echo 'BRANCH_CLEAN='`echo ${{ env.BRANCH }} | sed -e 's/[^a-zA-Z0-9_/]//g'` >> $GITHUB_ENV | |
| - name: Set current date as env variable | |
| run: echo 'NOW='$(date +'%Y-%m-%d %H:%M:%S') >> $GITHUB_ENV | |
| - name: echo environment variables | |
| run: echo ${{ env }} | |
| # - name: Delete develop instance | |
| # run: ssh -o "StrictHostKeyChecking no" $DEVELOP_SSH_USERNAME@$DEVELOP_HOST "test -e /web/${{ env.BRANCH_CLEAN }}" && (echo "Directory branch exists" && ssh -o "StrictHostKeyChecking no" $DEVELOP_SSH_USERNAME@$DEVELOP_HOST "rm -rf /web/${{ env.BRANCH_CLEAN }} && mysql -h 127.0.0.1 -u $DEVELOP_DB_USERNAME --password=$DEVELOP_DB_PASSWORD -e 'drop database if exists ${{ env.DATABASE_NAME }}; create database ${{ env.DATABASE_NAME }};'") || echo "Branch doesn't exist in develop" | |
| - name: Create Instance in develop through Main | |
| run: ssh -o "StrictHostKeyChecking no" $MAIN_SSH_USERNAME@$MAIN_HOST "cd scripts/create && bash create.sh -b ${{ env.BRANCH }} -i $DEVELOP_DOMAIN_NAME -p /web/${{ env.BRANCH_CLEAN }} -db ${{ env.DATABASE_NAME }} -d -y" | |
| - name: Set Clean git branch | |
| run: ssh -o "StrictHostKeyChecking no" $DEVELOP_SSH_USERNAME@$DEVELOP_HOST "test -e /web/${{ env.BRANCH_CLEAN }}" && (echo "Directory branch exists" && ssh -o "StrictHostKeyChecking no" $DEVELOP_SSH_USERNAME@$DEVELOP_HOST "cd /web/${{ env.BRANCH_CLEAN }} && git stash && git reset && git pull") | |
| - name: Get project data | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GH_TOKEN }} | |
| ORGANIZATION: SinergiaTIC | |
| PROJECT_NUMBER: 2 | |
| PR_ID: ${{ github.event.pull_request.node_id }} | |
| run: | | |
| gh api graphql -f query=' | |
| query($org: String!, $number: Int!) { | |
| organization(login: $org){ | |
| projectV2(number: $number) { | |
| id | |
| fields(first:20) { | |
| nodes { | |
| ... on ProjectV2Field { | |
| id | |
| name | |
| } | |
| ... on ProjectV2SingleSelectField { | |
| id | |
| name | |
| options { | |
| id | |
| name | |
| } | |
| } | |
| } | |
| } | |
| items(first:100) { | |
| nodes { | |
| ... on ProjectV2Item { | |
| id | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }' -f org=$ORGANIZATION -F number=$PROJECT_NUMBER > project_data.json | |
| echo 'PROJECT_ID='$(jq '.data.organization.projectV2.id' project_data.json) >> $GITHUB_ENV | |
| echo 'URL_FIELD_ID='$(jq '.data.organization.projectV2.fields.nodes[] | select(.name== "URLValidationInstance") | .id' project_data.json) >> $GITHUB_ENV | |
| echo 'DB_FIELD_ID='$(jq '.data.organization.projectV2.fields.nodes[] | select(.name== "DBValidationInstance") | .id' project_data.json) >> $GITHUB_ENV | |
| echo 'DATE_FIELD_ID='$(jq '.data.organization.projectV2.fields.nodes[] | select(.name== "DateValidationInstance") | .id' project_data.json) >> $GITHUB_ENV | |
| echo 'CURRENT_DATE='$(date +'%Y-%m-%d') >> $GITHUB_ENV | |
| - name: Get PR Item ID | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GH_TOKEN }} | |
| PR_ID: ${{ github.event.pull_request.node_id }} | |
| run: | | |
| item_id="$( gh api graphql -f query=' | |
| mutation($project:ID!, $pr:ID!) { | |
| addProjectV2ItemById(input: {projectId: $project, contentId: $pr}) { | |
| item { | |
| id | |
| } | |
| } | |
| }' -f project=$PROJECT_ID -f pr=$PR_ID --jq '.data.addProjectV2ItemById.item.id')" | |
| echo 'ITEM_ID='$item_id >> $GITHUB_ENV | |
| - name: Change Fields | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GH_TOKEN }} | |
| run: | | |
| gh api graphql -f query=' | |
| mutation ( | |
| $project: ID! | |
| $item: ID! | |
| $url_field: ID! | |
| $url_value: String! | |
| ) { | |
| set_status: updateProjectV2ItemFieldValue(input: { | |
| projectId: $project | |
| itemId: $item | |
| fieldId: $url_field | |
| value: { | |
| text: $url_value | |
| } | |
| }) { | |
| projectV2Item { | |
| id | |
| } | |
| } | |
| }' -f project=$PROJECT_ID -f item=$ITEM_ID -f url_field=$URL_FIELD_ID -f url_value=https://${{ env.DEVELOP_DOMAIN_NAME}}/${{ env.BRANCH_CLEAN }} --silent | |
| gh api graphql -f query=' | |
| mutation ( | |
| $project: ID! | |
| $item: ID! | |
| $db_field: ID! | |
| $db_value: String! | |
| ) { | |
| set_status: updateProjectV2ItemFieldValue(input: { | |
| projectId: $project | |
| itemId: $item | |
| fieldId: $db_field | |
| value: { | |
| text: $db_value | |
| } | |
| }) { | |
| projectV2Item { | |
| id | |
| } | |
| } | |
| }' -f project=$PROJECT_ID -f item=$ITEM_ID -f db_field=$DB_FIELD_ID -f db_value=${{ env.DATABASE_NAME }} --silent | |
| gh api graphql -f query=' | |
| mutation ( | |
| $project: ID! | |
| $item: ID! | |
| $date_field: ID! | |
| $date_value: Date! | |
| ) { | |
| set_status: updateProjectV2ItemFieldValue(input: { | |
| projectId: $project | |
| itemId: $item | |
| fieldId: $date_field | |
| value: { | |
| date: $date_value | |
| } | |
| }) { | |
| projectV2Item { | |
| id | |
| } | |
| } | |
| }' -f project=$PROJECT_ID -f item=$ITEM_ID -f date_field=$DATE_FIELD_ID -f date_value=$CURRENT_DATE --silent | |
| - name: Create or Edit PR comment | |
| uses: thollander/actions-comment-pull-request@v1 | |
| with: | |
| message: | | |
| Actions executed at: ${{ env.NOW }}. | |
| comment_includes: 'Actions executed at:' | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} |