scqs-sheets-stratpoint

Mainly used during CI/CD, this project integrates Google Sheet API to SCQS, which updates the SCQS sheet for a specific project with the project's unit tests scores, based on Stratpoint's SCQS metrics.

Prerequisites

• Google Service Account Credentials
• Google Spread Sheet with Service Account allowed to edit

Usage

Installation

npm i scqs-sheets-stratpoint

Find the scqs-sheets-stratpoint

node ./node_modules/scqs-sheets-stratpoint

or

npx scqs-sheets-stratpoint

Required Options

--score; // numerical score for scqs
--spreadsheetId; // spread sheet where the score will be inputted
--sheetName; // sheet in a spread sheet where the score will be inputted
--column; // the column where the score will go, (e.g A, B, C, D)
--credsString; // the stringified service account credentials

Sample usage V1

npx scqs-sheet-stratpoint --score 25 --spreadsheetId ABCD123 --sheetName Sheet1 --column D --credString '{"key":"value"}'

Sample usage V2

npx scqs-sheet-stratpoint --scqsVersion 2 --sheetName $SHEETNAME --spreadsheetId $SHEETID --credsString $STRINGIFIED_SERVICE_ACCOUNT_CREDENTIALS --updateValues '[["$SPRINT", "$DATE_NOW", "$SCORE", "$DETAILS"]]'

Reference:

Google Spreadsheet basic writing