Continuous Deployment

1.create-or-alter materialized-view with (backfill=true) ArgMax on table T
2{
3    T | summarize arg_max(Timestamp, *) by User
4}
5Unsupported propery in materialized view alter command. Supported properties: DimensionTables,Lookback,Folder,DocString,AutoUpdateSchema.
6.create ifnotexists materialized-view with (backfill=true) ArgMax on table T
7{
8    T | summarize arg_max(Timestamp, *) by User
9}
10

1# Use the official lightweight Node.js 10 image.
2# https://hub.docker.com/_/node
3FROM node:17-slim
4
5RUN set -ex; \
6  apt-get -y update; \
7  apt-get -y install ghostscript; \
8  apt-get -y install pngquant; \
9  rm -rf /var/lib/apt/lists/*
10
11# Create and change to the app directory.
12WORKDIR /usr/src/app
13
14# Copy application dependency manifests to the container image.
15# A wildcard is used to ensure both package.json AND package-lock.json are copied.
16# Copying this separately prevents re-running npm install on every code change.
17COPY package*.json ./
18
19# Install dependencies.
20# If you add a package-lock.json speed your build by switching to 'npm ci'.
21RUN npm ci --only=production
22# RUN npm install --production
23
24
25# Copy local code to the container image.
26COPY . ./
27
28# Run the web service on container startup.
29CMD [ "npm", "start" ]
30Oops, something went wrong…
31Continuous deployment has been set up, but your repository has failed to build and deploy.
32This revision is a placeholder until your code successfully builds and deploys to the Cloud Run service myapi in asia-east1 of the GCP project myproject.
33
34What's next?
35From the Cloud Run service page, click "Build History".
36Examine your build logs to understand why it failed.
37Fix the issue in your code or Dockerfile (if any).
38Commit and push the change to your repository.
39steps:
40    # Build the container image
41    - name: "gcr.io/cloud-builders/docker"
42      args: ["build", "-t", "gcr.io/$PROJECT_ID/myapi:$COMMIT_SHA", "."]
43    # Push the container image to Container Registry
44    - name: "gcr.io/cloud-builders/docker"
45      args: ["push", "gcr.io/$PROJECT_ID/myapi:$COMMIT_SHA"]
46    # Deploy container image to Cloud Run
47    - name: "gcr.io/google.com/cloudsdktool/cloud-sdk"
48      entrypoint: gcloud
49      args:
50          - "run"
51          - "deploy"
52          - "myapi"
53          - "--image"
54          - "gcr.io/$PROJECT_ID/myapi:$COMMIT_SHA"
55          - "--region"
56          - "asia-east1"
57images:
58    - "gcr.io/$PROJECT_ID/myapi:$COMMIT_SHA"
59

1on: [push, pull_request]
2name: CI-CD
3jobs:
4  CI-CD:
5    runs-on: ${{ matrix.config.os }}
6
7    name: ${{ matrix.config.os }} (${{ matrix.config.r }})
8
9    strategy:
10      # we keep a matrix for convenience, but we would typically just run on one
11      # single OS and R version, aligned with the target deployment environment
12      matrix:
13        config:
14          - {os: ubuntu-20.04, r: 'release', rspm: "https://packagemanager.rstudio.com/cran/__linux__/focal/latest"}
15
16    env:
17      # Enable RStudio Package Manager to speed up package installation
18      RSPM: ${{ matrix.config.rspm }}
19      # Access token for GitHub
20      GITHUB_PAT: ${{ secrets.GITHUB_TOKEN }}
21
22    steps:
23
24      - name: Checkout repo
25        uses: actions/checkout@v2
26
27      - name: Setup R
28        uses: r-lib/actions/setup-r@v1
29        with:
30          r-version: ${{ matrix.config.r }}
31
32      - name: Install system dependencies
33        run: |
34          while read -r cmd
35          do
36            eval sudo $cmd
37          done < <(Rscript -e 'writeLines(remotes::system_requirements("ubuntu", "20.04"))')
38      - name: Install R dependencies
39        run: |
40          remotes::install_deps(dependencies = TRUE)
41          remotes::install_cran("rcmdcheck")
42        shell: Rscript {0}
43
44      - name: Create and populate .Renviron file
45        env:
46          AWS_HOST: ${{ secrets.AWS_HOST }}
47          AWS_PORT: ${{ secrets.AWS_PORT }}
48          AWS_PW: ${{ secrets.AWS_PW }}
49          AWS_USER: ${{ secrets.AWS_USER }}
50          DBNAME: ${{ secrets.DBNAME }}
51        run: |
52          touch .Renviron
53          echo aws_host="$AWS_HOST" >> .Renviron
54          echo aws_port="$AWS_PORT" >> .Renviron
55          echo aws_pw="$AWS_PW" >> .Renviron
56          echo aws_user="$AWS_USER" >> .Renviron
57          echo dbname="$DBNAME" >> .Renviron
58          ls ${{ github.workspace }}
59        shell: bash
60
61      - name: Deploy to shinyapps.io
62        # continuous deployment only for pushes to the main / master branch
63        if: github.ref == 'refs/heads/main' || github.ref == 'refs/heads/master'
64        env:
65          SHINYAPPS_ACCOUNT: ${{ secrets.SHINYAPPS_ACCOUNT }}
66          SHINYAPPS_TOKEN: ${{ secrets.SHINYAPPS_TOKEN }}
67          SHINYAPPS_SECRET: ${{ secrets.SHINYAPPS_SECRET }}
68        run: Rscript deploy/deploy-shinyapps.R
69
70      - name: Create and populate .Renviron file
71        env:
72          AWS_HOST: ${{ secrets.AWS_HOST }}
73          AWS_PORT: ${{ secrets.AWS_PORT }}
74          AWS_PW: ${{ secrets.AWS_PW }}
75          AWS_USER: ${{ secrets.AWS_USER }}
76          DBNAME: ${{ secrets.DBNAME }}
77        run: |
78          touch .Renviron
79          echo aws_host="$AWS_HOST" >> .Renviron
80          echo aws_port="$AWS_PORT" >> .Renviron
81          echo aws_pw="$AWS_PW" >> .Renviron
82          echo aws_user="$AWS_USER" >> .Renviron
83          echo dbname="$DBNAME" >> .Renviron
84
85          echo "cat .Renviron"
86          cat .Renviron
87
88          echo "ls -a ."
89          ls -a .
90
91          echo "ls -a ${{ github.workspace }}"
92          ls -a ${{ github.workspace }}
93        shell: bash
94

1on: [push, pull_request]
2name: CI-CD
3jobs:
4  CI-CD:
5    runs-on: ${{ matrix.config.os }}
6
7    name: ${{ matrix.config.os }} (${{ matrix.config.r }})
8
9    strategy:
10      # we keep a matrix for convenience, but we would typically just run on one
11      # single OS and R version, aligned with the target deployment environment
12      matrix:
13        config:
14          - {os: ubuntu-20.04, r: 'release', rspm: "https://packagemanager.rstudio.com/cran/__linux__/focal/latest"}
15
16    env:
17      # Enable RStudio Package Manager to speed up package installation
18      RSPM: ${{ matrix.config.rspm }}
19      # Access token for GitHub
20      GITHUB_PAT: ${{ secrets.GITHUB_TOKEN }}
21
22    steps:
23
24      - name: Checkout repo
25        uses: actions/checkout@v2
26
27      - name: Setup R
28        uses: r-lib/actions/setup-r@v1
29        with:
30          r-version: ${{ matrix.config.r }}
31
32      - name: Install system dependencies
33        run: |
34          while read -r cmd
35          do
36            eval sudo $cmd
37          done < <(Rscript -e 'writeLines(remotes::system_requirements("ubuntu", "20.04"))')
38      - name: Install R dependencies
39        run: |
40          remotes::install_deps(dependencies = TRUE)
41          remotes::install_cran("rcmdcheck")
42        shell: Rscript {0}
43
44      - name: Create and populate .Renviron file
45        env:
46          AWS_HOST: ${{ secrets.AWS_HOST }}
47          AWS_PORT: ${{ secrets.AWS_PORT }}
48          AWS_PW: ${{ secrets.AWS_PW }}
49          AWS_USER: ${{ secrets.AWS_USER }}
50          DBNAME: ${{ secrets.DBNAME }}
51        run: |
52          touch .Renviron
53          echo aws_host="$AWS_HOST" >> .Renviron
54          echo aws_port="$AWS_PORT" >> .Renviron
55          echo aws_pw="$AWS_PW" >> .Renviron
56          echo aws_user="$AWS_USER" >> .Renviron
57          echo dbname="$DBNAME" >> .Renviron
58          ls ${{ github.workspace }}
59        shell: bash
60
61      - name: Deploy to shinyapps.io
62        # continuous deployment only for pushes to the main / master branch
63        if: github.ref == 'refs/heads/main' || github.ref == 'refs/heads/master'
64        env:
65          SHINYAPPS_ACCOUNT: ${{ secrets.SHINYAPPS_ACCOUNT }}
66          SHINYAPPS_TOKEN: ${{ secrets.SHINYAPPS_TOKEN }}
67          SHINYAPPS_SECRET: ${{ secrets.SHINYAPPS_SECRET }}
68        run: Rscript deploy/deploy-shinyapps.R
69
70      - name: Create and populate .Renviron file
71        env:
72          AWS_HOST: ${{ secrets.AWS_HOST }}
73          AWS_PORT: ${{ secrets.AWS_PORT }}
74          AWS_PW: ${{ secrets.AWS_PW }}
75          AWS_USER: ${{ secrets.AWS_USER }}
76          DBNAME: ${{ secrets.DBNAME }}
77        run: |
78          touch .Renviron
79          echo aws_host="$AWS_HOST" >> .Renviron
80          echo aws_port="$AWS_PORT" >> .Renviron
81          echo aws_pw="$AWS_PW" >> .Renviron
82          echo aws_user="$AWS_USER" >> .Renviron
83          echo dbname="$DBNAME" >> .Renviron
84
85          echo "cat .Renviron"
86          cat .Renviron
87
88          echo "ls -a ."
89          ls -a .
90
91          echo "ls -a ${{ github.workspace }}"
92          ls -a ${{ github.workspace }}
93        shell: bash
94Run touch .Renviron
95  touch .Renviron
96  echo aws_host="$AWS_HOST" >> .Renviron
97  echo aws_port="$AWS_PORT" >> .Renviron
98  echo aws_pw="$AWS_PW" >> .Renviron
99  echo aws_user="$AWS_USER" >> .Renviron
100  echo dbname="$DBNAME" >> .Renviron
101  
102  echo "cat .Renviron"
103  cat .Renviron
104  
105  echo "ls -a ."
106  ls -a .
107  
108  echo "ls -a /home/runner/work/github-actions-manual/github-actions-manual"
109  ls -a /home/runner/work/github-actions-manual/github-actions-manual
110  shell: /usr/bin/bash --noprofile --norc -e -o pipefail {0}
111  env:
112    AWS_HOST: 
113    AWS_PORT: 
114    AWS_PW: 
115    AWS_USER: 
116    DBNAME: 
117cat .Renviron
118aws_host=
119aws_port=
120aws_pw=
121aws_user=
122dbname=
123ls -a .
124.
125..
126.Renviron
127.git
128.github
129.gitignore
130LICENSE
131README.md
132change-workflow.ps1
133commit-new-workflow.ps1
134dist
135public
136test.ps1
137test2.ps1
138ls -a /home/runner/work/github-actions-manual/github-actions-manual
139.
140..
141.Renviron
142.git
143.github
144.gitignore
145LICENSE
146README.md
147change-workflow.ps1
148commit-new-workflow.ps1
149dist
150public
151test.ps1
152test2.ps1
153

1<img src="taxi-715.png" /> 
2

1FAILURE: Build failed with an exception.
2* What went wrong:
3Execution failed for task ':app:stripDebugDebugSymbols'.
4> 1 exception was raised by workers:
5  org.gradle.process.internal.ExecException: A problem occurred starting process 'command '/usr/local/share/android-sdk/ndk/23.1.7779620/toolchains/llvm/prebuilt/darwin-x86_64/bin/arm-linux-androideabi-strip''
6== Building for Android ==
7
8> flutter build appbundle --debug
9Running "flutter pub get" in My_Project...                     1,655ms
10
11💪 Building with sound null safety 💪
12
13Running Gradle task 'bundleDebug'...                            
14[flutter_background_geolocation] Purging debug resources in release build
15Note: Some input files use or override a deprecated API.
16Note: Recompile with -Xlint:deprecation for details.
17Note: /Users/builder/programs/flutter_2_5_3/.pub-cache/hosted/pub.dartlang.org/geocoding-2.0.1/android/src/main/java/com/baseflow/geocoding/GeocodingPlugin.java uses or overrides a deprecated API.
18Note: Recompile with -Xlint:deprecation for details.
19Note: Some input files use or override a deprecated API.
20Note: Recompile with -Xlint:deprecation for details.
21Note: Some input files use or override a deprecated API.
22Note: Recompile with -Xlint:deprecation for details.
23
24FAILURE: Build failed with an exception.
25
26* What went wrong:
27Execution failed for task ':app:stripDebugDebugSymbols'.
28> 1 exception was raised by workers:
29  org.gradle.process.internal.ExecException: A problem occurred starting process 'command '/usr/local/share/android-sdk/ndk/23.1.7779620/toolchains/llvm/prebuilt/darwin-x86_64/bin/arm-linux-androideabi-strip''
30
31
32* Try:
33Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.
34
35* Get more help at https://help.gradle.org
36
37BUILD FAILED in 2m 19s
38Running Gradle task 'bundleDebug'...                              141.1s
39Gradle task bundleDebug failed with exit code 1
40
41
42Build failed :|
43Failed to build for Android
44Flutter channel: stable 
45Mode: debug 
46Build for: Android
47- classpath 'com.android.tools.build:gradle:3.5.4'
48+ classpath 'com.android.tools.build:gradle:4.2.0'
49

1FAILURE: Build failed with an exception.
2* What went wrong:
3Execution failed for task ':app:stripDebugDebugSymbols'.
4> 1 exception was raised by workers:
5  org.gradle.process.internal.ExecException: A problem occurred starting process 'command '/usr/local/share/android-sdk/ndk/23.1.7779620/toolchains/llvm/prebuilt/darwin-x86_64/bin/arm-linux-androideabi-strip''
6== Building for Android ==
7
8> flutter build appbundle --debug
9Running "flutter pub get" in My_Project...                     1,655ms
10
11💪 Building with sound null safety 💪
12
13Running Gradle task 'bundleDebug'...                            
14[flutter_background_geolocation] Purging debug resources in release build
15Note: Some input files use or override a deprecated API.
16Note: Recompile with -Xlint:deprecation for details.
17Note: /Users/builder/programs/flutter_2_5_3/.pub-cache/hosted/pub.dartlang.org/geocoding-2.0.1/android/src/main/java/com/baseflow/geocoding/GeocodingPlugin.java uses or overrides a deprecated API.
18Note: Recompile with -Xlint:deprecation for details.
19Note: Some input files use or override a deprecated API.
20Note: Recompile with -Xlint:deprecation for details.
21Note: Some input files use or override a deprecated API.
22Note: Recompile with -Xlint:deprecation for details.
23
24FAILURE: Build failed with an exception.
25
26* What went wrong:
27Execution failed for task ':app:stripDebugDebugSymbols'.
28> 1 exception was raised by workers:
29  org.gradle.process.internal.ExecException: A problem occurred starting process 'command '/usr/local/share/android-sdk/ndk/23.1.7779620/toolchains/llvm/prebuilt/darwin-x86_64/bin/arm-linux-androideabi-strip''
30
31
32* Try:
33Run with --stacktrace option to get the stack trace. Run with --info or --debug option to get more log output. Run with --scan to get full insights.
34
35* Get more help at https://help.gradle.org
36
37BUILD FAILED in 2m 19s
38Running Gradle task 'bundleDebug'...                              141.1s
39Gradle task bundleDebug failed with exit code 1
40
41
42Build failed :|
43Failed to build for Android
44Flutter channel: stable 
45Mode: debug 
46Build for: Android
47- classpath 'com.android.tools.build:gradle:3.5.4'
48+ classpath 'com.android.tools.build:gradle:4.2.0'
49workflows:
50  workflow-name:
51    environment:
52      ndk: r22b
53      java: 1.8
54

1#!/usr/bin/env bash
2set -euxo pipefail
3
4AZURE_ACCOUNT_NAME="xxxxx@xx.xx"
5AZURE_ACCOUNT_PASSWORD="yyyyyyy"
6AZURE_SUBSCRIPTION_ID="zzzzzz"
7AZURE_TENANT_ID="aaaaaa"
8M365_ACCOUNT_NAME="xxxxx@xx.xx"
9M365_ACCOUNT_PASSWORD="yyyyyyy"
10
11
12#npx teamsfx deploy
13npx teamsfx account login azure
14[TeamsfxCLI] Log in to your Azure account - opening default web browser at https://login.microsoftonline.com/organizations/oauth2/v2.0/authorize?client_id=7ea7c24c-b1f6-4a20-9d11-9ae12e9e7ac0&scope=https%3A%2F%2Fmanagement.core.windows.net%2Fuser_impersonation%20openid%20profile%20offline_access&redirect_uri=http%3A%2F%2Flocalhost%3A45315&client-request-id=c4a5a5a6-45d5-40da-a5a9-8acedac8df52&response_mode=query&response_type=code&x-client-SKU=msal.js.node&x-client-VER=1.0.0-beta.6&x-client-OS=linux&x-client-CPU=x64&client_info=1&code_challenge=MdFhzm7OTWFzSYgxwsgj6A4X9A5cricL-N03nY-qTUo&code_challenge_method=S256&prompt=select_account
15Error: spawn xdg-open ENOENT
16    at Process.ChildProcess._handle.onexit (internal/child_process.js:269:19)
17    at onErrorNT (internal/child_process.js:467:16)
18    at processTicksAndRejections (internal/process/task_queues.js:82:21) {
19  errno: -2,
20  code: 'ENOENT',
21  syscall: 'spawn xdg-open',
22  path: 'xdg-open',
23  spawnargs: [
24    'https://login.microsoftonline.com/organizations/oauth2/v2.0/authorize?client_id=7ea7c24c-b1f6-4a20-9d11-9ae12e9e7ac0&scope=https%3A%2F%2Fmanagement.core.windows.net%2Fuser_impersonation%20openid%20profile%20offline_access&redirect_uri=http%3A%2F%2Flocalhost%3A45315&client-request-id=c4a5a5a6-45d5-40da-a5a9-8acedac8df52&response_mode=query&response_type=code&x-client-SKU=msal.js.node&x-client-VER=1.0.0-beta.6&x-client-OS=linux&x-client-CPU=x64&client_info=1&code_challenge=MdFhzm7OTWFzSYgxwsgj6A4X9A5cricL-N03nY-qTUo&code_challenge_method=S256&prompt=select_account'
25  ]
26}
27export AZURE_ACCOUNT_NAME=xxx
28export AZURE_ACCOUNT_PASSWORD=xxx
29...
30