Andrew Williamson eviljeff
eviljeff
/ gist:76144fd10994d6e4171ca92a9973a3a1
Created
July 10, 2019 13:48
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Attaching to olympia_addons-frontend_1 | |
| [36maddons-frontend_1 |[0m yarn run v1.16.0 | |
| [36maddons-frontend_1 |[0m $ better-npm-run amo | |
| [36maddons-frontend_1 |[0m running better-npm-run in /srv/code | |
| [36maddons-frontend_1 |[0m Executing script: amo | |
| [36maddons-frontend_1 |[0m | |
| [36maddons-frontend_1 |[0m to be executed: better-npm-run start-dev-proxy | |
| [36maddons-frontend_1 |[0m running better-npm-run in /srv/code | |
| [36maddons-frontend_1 |[0m Executing script: start-dev-proxy | |
| [36maddons-frontend_1 |[0m |
eviljeff
/ bulkaddcerts.py
Last active
January 3, 2017 18:32
snippet to be run in django-admin shell `./manage.py shell` to bulk add certs from 'certs.txt' file in format [issuer: xx serial: yy].
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from olympia.blocklist.models import BlocklistDetail, BlocklistIssuerCert | |
| def addCert(issuer, serial, name, bug): | |
| detail = BlocklistDetail(name=name, why='.', who='.', bug=bug) | |
| detail.save() | |
| cert = BlocklistIssuerCert(issuer=issuer, serial=serial, details=detail) | |
| cert.save() | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE addons SET icontype = 'image/png' WHERE icontype = '' and icon_hash is not null and icon_hash <> 'crushed'; |
eviljeff
/ quick_trusted.sh
Created
March 11, 2015 18:47
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # | |
| # 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 program modifies the prefs.js file on the given device so that | |
| # trusted marketplaces for installing signed privileged apps can be | |
| # added/removed *FOR TESTING PURPOSES ONLY*. |
eviljeff
/ setupcerts.sh
Last active
August 29, 2015 14:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # | |
| # 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 program replaces the certificate database on a device with the contents | |
| # of a local certificate database. Usually it is used in conjunction with the | |
| # other scripts in this directory as described in ./README.txt. |
eviljeff
/ quickpush.sh
Created
March 6, 2015 12:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # | |
| # 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 program replaces the certificate database on a device with the contents | |
| # of a local certificate database. Usually it is used in conjunction with the | |
| # other scripts in this directory as described in ./README.txt. |
eviljeff
/ gist:ba00a916d8603827a6b1
Created
November 14, 2014 16:20
SQL to output which approved & undisabled apps have at least one version that requires flash
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select addons.id from | |
| (SELECT * FROM addons WHERE status IN (2, 4, 13, 16) AND inactive = 0) AS addons | |
| JOIN versions ON (versions.addon_id=addons.id) | |
| JOIN (select * FROM files where uses_flash=1) AS files ON (files.version_id=versions.id) | |
| GROUP BY addons.id; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # | |
| # 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 program replaces the certificate database on a device with the contents | |
| # of a local certificate database. Usually it is used in conjunction with the | |
| # other scripts in this directory as described in ./README.txt. |
eviljeff
/ gist:1641078
Created
January 19, 2012 16:42
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ADDON_EXTENSION = 1 | |
| ADDON_DICT = 3 | |
| ADDON_LPADDON = 6 # maybe - I'm not sure what it is | |
| ADDON_PLUGIN = 7 | |
| ADDON_API = 8 |