XCResult script CSV upload portion

[AaronMT]

Currently https://github.com/AaronMT/xcresult_extract/blob/main/xcresult_extract.py can be ran on command line with a supplied project xcodeproj and scheme and will output formatted in comma separated values. The script uses the newest XCResult file so should be ran often. By piping the output into a CSV we can save a temporary file (*.csv) and upload to a public-read only bucket on Google Storage Cloud. This public read-only CSV can be consumed by Google Sheets with an IMPORTDATA function for our viewing.

% python3 xcresult_extract.py -project ~/Mozilla/firefox-ios/Client.xcodeproj -scheme "Fennec_Enterprise_XCUITests" | tee ~/Desktop/test1.csv | gsutil -h "Cache-Control:max-age=0,no-cache" cp -a public-read ~/Desktop/test1.csv gs://test-eng-perf

Requirements an authenticated GC account and access to the bucket.

• Where/When can a Python environment use this?
• Where/When can we use GSUtil and have authentication and access to the buckets we use?
• How do we want to unique name the CSV output? (e.g, $(date +%Y-%m-%d_%H-%M-%S.csv)"
• How can we get Google Sheets to target the unique or static import if so?

[AaronMT]

• Pre-req
  • Run tests on Bitrise in a Workflow and a TestPlan (real devices)
  • Generate data output
  • (Action) - Case ticket open with Bitrise on exposing public artifact data
  • https://github.com/ChargePoint/bitrise-step-xcparse - enhance data parsing with Bitrise step
• Pull data artifacts
  • Use Python script and Bitrise tool to pull data artifacts
  • Convert data to desired format (CSV)
  • (Action) - Setup local Python script to pull data using Bitrise tool
• Publish data artifacts
  • Publish data via SimpleHTTP web server
  • (Action) - Create GCP instance and setup a simple web server
• Pull data into Redash
  • (Action) - Query data from SimpleHTTP web server

[AaronMT]

Bitrise Env:

$BITRISE_PROJECT_PATH "Fennec_Enterprise_XCUITests"

Script that clones https://github.com/AaronMT/xcresult_extract.git