Will Kahn-Greene willkg

I hereby claim:

To claim this, I am signing this object:

	#!/bin/bash

	# This is built to test a problem where if a try symbol is uploaded, it doesn't
	# invalidate the cache and then future download attempts suggest the symbol
	# doesn't exist (404).

	# using a upload try token:
	#
	# head (404), upload (should invalidate cache), head (should be 200)
	#

	!/bin/bash

	# 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/.
	#
	# Run on the host with crashstats-tools installed.
	#
	# https://pypi.org/project/crashstats-tools/
	#

	#!/usr/bin/env python

	"""
	October 8th, 2020. I wrote this to fix a problem where .dll and .exe files were getting
	uploaded to symbols.mozilla.org, but hadn't been run through makecab. That prevented
	them from getting served by symbols.mozilla.org and that broke debugging efforts.

	I ran this script in WSL2 on Windows. It downloads files from the symbols bucket, runs
	makecab on them, batches them up, and periodically uploads a symbols.zip file.

	import logging
	import os

	import markus
	from markus.main import MetricsFilter

	logging.basicConfig(level=logging.DEBUG)

	LOGGER = logging.getLogger(__name__)

	!/usr/bin/env python

	# 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/.

	"""
	Creates a shell that loads all the Django ORM models and puts them
	in locals.
	"""

	!/usr/bin/env python

	"""
	This de-mozlogifies a log line by line to make it readable by humans. To use:

	tail -f /path/to/mozlog.log \| python demozlog.py

	"""

	import datetime

	--
	-- Bug 1503383: drop everything
	--
	-- Drops all the stored procedures and things that we don't need anymore.

	BEGIN WORK;

	-- Drop functions
	DROP FUNCTION IF EXISTS version_sort_digit(text) CASCADE;
	DROP FUNCTION IF EXISTS major_version_sort(text) CASCADE;

	--
	-- Bug 1461321: signatures data migration
	--
	-- Used for a single data migration October 2018. We can delete it after
	-- using it in stage and prod.

	BEGIN WORK;

	-- Crontabber has a job that updates these tables. We lock the tables here
	-- to prevent it from updating the data while we're migrating.