Skip to content

Instantly share code, notes, and snippets.

View dklawren's full-sized avatar

David Lawrence dklawren

View GitHub Profile
View gist:c63d7aeb112efc32cdc66f5e30ddc530
mysql> select distinct bug_id from bugs_activity where who = 546015 and bug_when > '2023-03-09' and fieldid in (24,120) and removed like '%java%Exception%' LIMIT 1000
bug_id
1536505
1646242
1646248
1646250
1646396
1646397
1648121
View winget_packages.ps1
# Run "Set-ExecutionPolicy -ExecutionPolicy Unrestricted -Scope Process"
# as admin in PowerShell to allow execution
#Install WinGet
$hasPackageManager = Get-AppPackage -name 'Microsoft.DesktopAppInstaller'
if (!$hasPackageManager -or [version]$hasPackageManager.Version -lt [version]"1.10.0.0") {
"Installing winget Dependencies"
Add-AppxPackage -Path 'https://aka.ms/Microsoft.VCLibs.x64.14.00.Desktop.appx'
$releases_url = 'https://api.github.com/repos/microsoft/winget-cli/releases/latest'
View gist:003e0afad00cd10d26b9e61b76f3a481
--- /dev/fd/63 2020-11-20 19:47:06.150000000 +0000
+++ /dev/fd/62 2020-11-20 19:47:06.150000000 +0000
@@ -107,30 +107,16 @@
"mainCommentMessage": null,
"reviewers": [
{
- "isActionable": false,
- "name": "phab-email-qa-reviewer-1",
- "recipients": [
- {
View gist:8b859a58cc5fca4400918eb421964585
A 2020-11-04T16:47:35.869964940Z [04-Nov-2020 16:47:35 UTC] [2020-11-04 16:47:35] EXCEPTION: (PhutilProxyException) Error while updating the "m-c" repository. {>} (CommandException) Command failed with error #255!
A 2020-11-04T16:47:35.869971123Z COMMAND
A 2020-11-04T16:47:35.869972110Z /app/phabricator/bin/repository update -- rMC
A 2020-11-04T16:47:35.869972859Z {"textPayload":"","insertId":"1cumo84fv03tsv","resource":{"type":"aws_ec2_instance","labels":{"instance_id":"i-079af2d04d470005a","project_id":"moz-fx-phabricat-nonprod-9428","region":"aws:us-west-2c","aws_account":"554708791447"}},"timestamp":"2020-11-04T16:47:35.869972859Z","labels":{"ec2.amazonaw…
A 2020-11-04T16:47:35.869974123Z STDOUT
A 2020-11-04T16:47:35.869974999Z (empty)
A 2020-11-04T16:47:35.869975787Z {"textPayload":"","insertId":"1cumo84fv03tsy","resource":{"type":"aws_ec2_instance","labels":{"instance_id":"i-079af2d04d470005a","region":"aws:us-west-2c","project_id":"moz-fx-phabricat-nonprod-9428","aws_account":"554708791447"}},"t
View gist:68534d757f8bfe1b9722de4c6816ad01
--- output.json 2020-08-28 16:11:36.980000000 +0000
+++ expected.json 2020-08-28 16:10:32.300000000 +0000
@@ -978,8 +978,8 @@
"key": "6853096776781630944",
"revision": {
"bug": {
- "bugId": 1629002,
- "link": "https:\\/\\/bugzilla-dev.allizom.org\\/show_bug.cgi?id=1629002"
+ "bugId": 1629039,
+ "link": "https:\\/\\/bugzilla-dev.allizom.org\\/show_bug.cgi?id=1629039"
View gist:47160179898c966724b45dce821efafb
diff --git a/Dockerfile b/Dockerfile
index 2d122bf..936c8e2 100644
--- a/Dockerfile
+++ b/Dockerfile
@@ -109,7 +109,9 @@ RUN composer global require hirak/prestissimo
COPY --chown=app:app . /app
-RUN pip install --user --require-hashes -r requirements.txt
+USER root
@dklawren
dklawren / gist:e67aea0399efbee8b6601c2f992945a8
Created January 28, 2020 15:12
Phabricator - Changing your email address
View gist:e67aea0399efbee8b6601c2f992945a8
Phabricator - Changing your email address
This how-to describes how someone can change their email address using the Settings section of Phabricator.
Step-by-step guide
1. Login to Phabricator with your BMO account.
2. Click on the dropdown at the top right which is your avatar icon or first initial.
3. Click Settings from the menu.
4. Click Email Addresses from the left side menu.
5. Click on Add New Address, enter your new desired email address, and click Save.
View gist:57a4e6d947bd5d03ec0069518ba68d91
package Bugzilla::Test::Selenium;
use 5.10.1;
use Moo;
use Test2::V0;
use Test::Selenium::Remote::Driver;
has 'driver_class' => (is => 'ro', default => 'Test::Selenium::Remote::Driver');
has 'driver_args' => (is => 'ro', required => 1,);
has 'driver' => (
@dklawren
dklawren / Driver.pm
Created February 8, 2019 17:39
Bugzilla::Test::Selenium::Remote::Driver
View Driver.pm
# This Source Code Form is subject to the terms of the Mozilla Public
# License, v. 2.0. If a copy of the MPL was not distributed with this
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
# This Source Code Form is "Incompatible With Secondary Licenses", as
# defined by the Mozilla Public License, v. 2.0.
package Bugzilla::Test::Selenium::Remote::Driver;
use 5.10.1;
@dklawren
dklawren / boxstarter.ps1
Last active January 13, 2019 23:43 — forked from jessfraz/boxstarter.ps1
Boxstarter Commands for a new Windows box.
View boxstarter.ps1
# Description: Boxstarter Script
# Author: Jess Frazelle <jess@linux.com>
# Last Updated: 2017-09-11
#
# Install boxstarter:
# . { iwr -useb http://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force
#
# You might need to set: Set-ExecutionPolicy RemoteSigned
#
# Run this boxstarter by calling the following from an **elevated** command-prompt: