The spreadsheet is in Google Drive, and looks like this:
The tests are run from the Test Runner menu, and the spreadsheet updated with the results.
To run the web app:
bundle exec rackup config.ru
See the homepage:
http://localhost:9292
Google Drive uses OAuth 2.0 for access permissions - you'll need to configure credentials in the config/config.yml file (use config.yml.example as a template).
The google_client_email is the email address for a service account (a server-side only account associated with your usual Google account).
The google_p12_file is a private key file that is generated when you set up the service account.
More details on setting up the service account are at https://console.developers.google.com/
Run a Resque worker process to process background jobs:
QUEUE=test_jobs bundle exec rake resque:work
By default, the app will use the local Redis client.
To use a RedisCloud instance, set this environment variable:
REDISCLOUD_URL=url for redis cloud instance, e.g. redis://rediscloud:1234567890@pub-redis-15001.us-east-1-1.2.ec2.garantiadata.com:15001
There's a library of Google App Script helper functions published by the Sprat Google account.
The Project Key for the published library is : MNMuL6AHdxrq9UX44qx2DMKxz0Q3oDASm
To add the library to your spreadsheet, use Tools->Script Editor to open the script editor, then Resources->Libraries to show the libraries dialog. Then search for the Sprat Library by Project Key (as above) and add the latest version to your scripts. (You may also need to enable the "Development Mode" flag).
Then, add this code to a new script, after which a "Test Runner" menu option will appear when you re-open the spreadsheet:
function onOpen() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var menuEntries = [ {name: "Run tests", functionName: "runThisSheet"} , {name: "Schedule tests", functionName: "scheduleThisSheet"} ];
ss.addMenu("Test Runner", menuEntries);
setTestRunnerProperties();
}
function setTestRunnerProperties() {
ScriptProperties.setProperty("TestRunnerURL", "http://serene-shore-1334.herokuapp.com/jobs");
ScriptProperties.setProperty("TestRunnerAuth", "");
}
function runThisSheet() {
testRunnerURL = ScriptProperties.getProperty("TestRunnerURL");
testRunnerAuth = ScriptProperties.getProperty("TestRunnerAuth");
runTestJob(testRunnerURL, testRunnerAuth);
}
function scheduleThisSheet() {
testRunnerURL = ScriptProperties.getProperty("TestRunnerURL");
testRunnerAuth = ScriptProperties.getProperty("TestRunnerAuth");
scheduleTestJob(testRunnerURL, testRunnerAuth);
}
Julian Higman
Matt Law